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

Purpose

The db.database OMX component allows you to use either your existing ODBC-compliant software drivers or your Oracle client drivers to create a connection to and manipulate a database.

Usage Notes

Within your program, you can create as many instances of the db.database OMX component as you require by declaring global and local variables of type "db.database".

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

Related OMDB library functions:

The functions

• db.open-odbc - make a connection to an ODBC compliant database.
• db.open-oci8i - make a connection to an Oracle database using an Oracle 8i client installation
• db.open-oci9i - make a connection to an Oracle database using an Oracle 9i client installation
• db.open-oci10g - make a connection to an Oracle database using an Oracle 10g client installation
• db.close - close an existing database connection.

• db.set-transaction-type - set the mode of a database connection to either auto-commit or manual-commit.
• db.commit - commit all the insert, delete, or update operations performed since the last db.commit or db.rollback.
• db.execute-in - execute a single SQL statement on the specified database.
• db.open-procedure - open a connection to a procedure store in the specified database.
• db.query - execute a single SQL query on the specified database.
• db.rollback - roll back (cancel) all operations not yet committed to the database.
• db.compile-statement - compile an SQL statement.
• db.open-table - open a connection to a table in a connected database.

Example

Once you have declared your db.database OMX variables, you can use them with one of the db.open functions (such as db.open-odbc) in the OmniMark Database library to create connections to databases.

  import "omdb.xmd" prefixed by db.
  
  process
     local db.database my-database
  
     set my-database to db.open-odbc "MyDatabase"

Assuming that no errors occur when establishing the connection to the database, you can now manipulate the data in that database using the other functions in the OmniMark Database library.

Related Syntax    db.open-odbc    db.close    db.execute-in    db.query    db.open-table    db.open-procedure    db.commit    db.set-transaction-type    db.rollback    db.compile-statement

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 ]