open

The EGL open statement creates a list from a database, based on selection criteria you provide, and creates a pointer that you can use to move through the list. The open statement currently works only with SQL databases, where it produces a result set and a cursor.

Syntax

Syntax diagram for the core open statement
listID
A character string of your choice that you use to identify the list the open statement creates. Once you open the file, you can use the listID with a positional get statement, or with the replace, delete, or close statements.
openOptions
Additional options for customizing the open statement, based on the data access technology you are using. See the related references for information on the data access technologies available to you.
explicitCode
Explicit code embedded in the open statement, where your data access technology permits it (as SQL does).
into field
The EGL host variables that receive values from the list (see Host variables).
preparedStatementID
The identifier for the code created with an EGL prepare statement, allowing dynamic processing. For more information, see prepare.
using field
The EGL host variables that are made available to the prepared statement at run time.
recordVariable
The name of a record variable. If you do not specify explicitCode, EGL derives the necessary information for the open from the properties and contents of this variable.

For examples and error conditions, see the topic for a particular data access technology in the related references at the end of this topic.


Feedback