db.writer

function

Library: Database access (OMDB)
Import : omdb.xmd

Returns: an external output to which data can be written for the parameter currently being streamed in to the database


Declaration
define external string sink function db.writer
  of   value       db.field  insert-handle

Argument definitions

insert-handle
is the db.field passed as the "with" parameter to the previous db.streaming-execute


Purpose

Use db.writer to obtain an external output object for the current parameter of a db.streaming-execute operation.

Requirements

insert-handle must be the db.field passed as the "with" parameter to the previous db.streaming-execute call.

This function can only be called once following each call to db.prepare (else external exception OMDB307).

The streaming execute operation must not have been completed (else external exception OMDB711).

Usage Notes

After db.prepare returns TRUE, this function can be called to get an external output object for the parameter which is currently being requested. Any data written to the external output is then streamed in to the database.

To indicate a NULL value, either do not call this function or do not write any data to the returned external output.

See the usage notes of db.streaming-execute and db.prepare for further details and examples.

Related Topics