Library: Database access (OMDB) legacy library Include: omdb.xin

Purpose

The dbDatabase 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

The OmniMark Database dynamic link library file ("omdb.dll" or "omdb.so") creates the dbDatabase OMX component. The related include file ("omdb.xin") defines the interface to that component. To use dbDatabase OMX components in your program, you must include the following in your program:

      include "omdb.xin"

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

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

Related OMDB library functions:

The functions

• dbOpenODBC - make a connection to an ODBC compliant database.
• dbOpenOCI8 - make a connection to an Oracle 8 (or higher) database using an Oracle 8 (or higher) client installation
• dbOpenOCI8i - make a connection to an Oracle 8i (or higher) database using an Oracle 8i (or higher) client installation
• dbSetTransactionType - set the mode of a database connection to either auto-commit or manual-commit.
• dbClose - close an existing database connection.

• dbCommit - commit all the insert, delete, or update operations performed since the last dbCommit or dbRollback.
• dbExecute - execute a single SQL statement on the specified database.
• dbProcedureOpen - open a connection to a procedure store in the specified database.
• dbQuery - execute a single SQL query on the specified database.
• dbRollback - roll back (cancel) all operations not yet committed to the database.
• dbStatementCompile - compile an SQL statement.
• dbTableOpen - open a connection to a table in a connected database.

Example

Once you have declared your dbDatabase OMX variables, you can use them with one of the dbOpen functions (such as dbOpenODBC) in the legacy OmniMark Database library to create connections to databases.

     include "omdb.xin"
  
     process
        local dbDatabase my-database
  
        set my-database to dbOpenODBC "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 legacy OmniMark Database library.

Other Library Functions    dbClose    dbCommit    dbDatabase    dbExecute    dbField    dbFieldPrepare    dbFieldSink    dbFieldValue    dbIsVersionCompatible    dbLibraryVersion    dbLibraryVersionOCI8    dbLibraryVersionOCI8i    dbLibraryVersionODBC    dbOpenOCI8    dbOpenOCI8i    dbOpenODBC    dbProcedure    dbProcedureClose    dbProcedureExecute    dbProcedureOpen    dbQuery    dbRecordExists    dbRecordMove    dbRecordMoveDynamic    dbRecordSetMove    dbRollback    dbSetTransactionType    dbStatement    dbStatementCompile    dbStatementDiscard    dbStatementExecute    dbStatementStreamingExecute    dbTable    dbTableClose    dbTableDelete    dbTableInsert    dbTableOpen    dbTableUpdate

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