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

Purpose

The db.statement OMX component is used to receive the compiled SQL statement from db.compile-statement. Through this OMX component, the same SQL statement may be executed multiple times without the need to compile the statement at every execution. For some programs, this reduction in processing overhead can be significant.

Usage Notes

To create a db.statement, use the db.compile-statement function. The resulting OMX component is a link to the compiled SQL statement. The statement can then be executed either by calling the db.execute function or by calling the db.streaming-execute function. All placeholder values must be specified at this time. If the statement is a query, the query results are retrieved through a db.field shelf. When you have finished using the statement, you can use db.discard to release the resources used by the db.statement OMX component.

Please refer to OMX Components for a general description of OMX components and how they are used.

Related OMDB library functions:

The functions

• db.compile-statement - compile a SQL statement.
• db.discard - discard a compiled SQL statement.

• db.execute - execute a compiled SQL statement, passing in parameters up front.
• db.streaming-execute - execute a compiled SQL statement, streaming in parameters dynamically.

Related Concepts    Using the OMDB library

Other Library Functions    db.advance-recordset    db.close    db.commit    db.compile-statement    db.database    db.delete    db.discard    db.document-writer-sedna    db.execute    db.execute-in    db.field    db.insert    db.is-null    db.move-dynamic-record    db.move-record    db.omdb-version    db.omdb-version-oci10g    db.omdb-version-oci11g    db.omdb-version-oci8i    db.omdb-version-oci9i    db.omdb-version-odbc    db.omdb-version-sedna    db.open-oci10g    db.open-oci11g    db.open-oci8i    db.open-oci9i    db.open-odbc    db.open-procedure    db.open-sedna    db.open-table    db.prepare    db.procedure    db.query    db.reader    db.record-exists    db.rollback    db.set-transaction-type    db.statement    db.streaming-execute    db.table    db.update    db.writer

[ INDEX ] [ CONCEPTS ] [ TASKS ] [ SYNTAX ] [ LIBRARIES ] [ LEGACY LIBRARIES ] [ ERRORS ]