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

Purpose

The db.statement data type is used to receive the compiled SQL statement from db.compile-statement. Through this data type, 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 data type 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 data type.

Please refer to Opaque Data Types for a general description of opaque data types 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 Topics 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 ]