The EGL sqlLib library contains functions and variables that you can use in connection with a relational database.
The following table lists the library functions:
| Function | Description |
|---|---|
| beginDatabaseTransaction([database]) | Begins a relational-database transaction, but only when the EGL runtime is not committing changes automatically. |
| connect (database, userID, password[, disconnectOption[, isolationLevel[, commitControl]]]) | Closes all result sets, releases locks, ends any existing connection, and connects to the database. |
| result = constructQuery (sqlRecord, valueDictionary, matchOption) | Returns an SQL condition based on a dictionary that contains comparison operators and values. |
| defineDatabaseAlias (alias, database) | Creates an alias that can be used to establish a new connection to a database to which your code is already connected. |
| disconnect ([database]) | Disconnects from the specified database or (if no database is specified) from the current database. |
| disconnectAll () | Disconnects from all the currently connected databases. |
| loadTable (filename, insertIntoClause[, delimiter]) | Loads data from a file into a relational database. The function is available only for Java™ generation. |
| queryCurrentDatabase (product, release) | Returns the product and release number of the currently connected database. |
| setCurrentDatabase (database) | Activates the specified database. |
| unloadTable (filename, selectStatement[, delimiter]) | Unloads data from a relational database into a file. The function is available only for Java generation. |
The following table lists the library variables:
| Variable | Description |
|---|---|
| currentSchema (EGL system variable) | Holds the name of a schema to be prepended to all table names at runtime. |
| sqlLib.sqlData (EGL system variable) | Contains a number of globally available error codes, messages, and other information about the interaction of EGL with your SQL database. |