Database functions perform tasks using databases. By default, all database styles recognized by the system are supported. A typical use of these functions is to reference tables created for ODBC or JDBC in Windows and DB2 (DB2/2). The functions you can use are listed below. Click on the function name to jump to a discussion of that function.
|
Function |
Result |
|
Adds a record to an open database table. Optionally returns one (1) on success or zero (0) on failure. |
|
|
Closes an open database table. Optionally returns one (1) on success or zero (0) on failure. |
|
|
Deletes a record from a database table. Optionally returns one (1) on success or zero (0) on failure. |
|
|
Retrieves a record by key value from an open database table. Optionally returns one (1) on success or zero (0) on failure. |
|
|
Retrieves the first record from an open database table. Optionally returns one (1) on success or zero (0) on failure. |
|
|
Retrieves the next record from an open database table. Optionally returns one (1) on success or zero (0) on failure. |
|
|
Opens a database table. Optionally returns one (1) on success or zero (0) on failure. |
|
|
Creates the DAL variables associated with a table record. |
|
|
Streamlines the use of DAL with ODBC or JDBC and memory tables by creating DFD files and using only memory tables |
|
|
Updates a record retrieved from a database table. Optionally returns one (1) on success or zero (0) on failure. |
The functions are generic for any supported database including ODBC (Open Data Base Connectivity) or JDBC (Java Database Connectivity) compliant databases and DB2/2 compliant databases
.
| Note | The customer is responsible for licensing and installing the desired database product and any required operating system driver. |
All database access is routed through the system’s database library DLL. This DLL handles interfacing with the supported types of databases. Each database type has an associated database handler. Database handlers can be described in an INI control group which begins with DBHANDLER: followed by the database handler name, such as:
< DBHandler:ODBC >
< DBHandler:JDBC >
© Copyright 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices