|
|||||
|
||||||
Related Topics | Other Library Functions |
data type |
db.database |
Library: Database access (OMDB)
Import: omdb.xmd |
The db.database opaque data type 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.
Within your program, you can create as many instances of the db.database data type as you require by declaring global and local variables of type "db.database".
Please refer to Opaque Data Types for a general description of Opaque Data Types and how they are used.
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.
Once you have declared your db.database 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.
Copyright © Stilo International plc, 1988-2010.