Prepare statement for a relational database

The EGL prepare statement creates a prepared statement, which is an executable SQL statement that is based on a customized string. The string conforms to SQL syntax. The prepared statement can be used in the with clause of other EGL statements that are used for accessing a relational database.

A prepared statement can have a structure that is known only at run time.

Syntax



Syntax diagram for the prepare statement with SQL

aString
The input string that conforms to SQL syntax.
SQLDataSource
A variable of type SQLDataSource. The variable includes connection details or references an EGL deployment descriptor entry that provides access to the connection details.
SQLStatement
The prepared statement, which is a variable of type SQLStatement. This variable is instantiated only by the EGL prepare statement.

Compatibility

Table 1. Compatibility
Target Issue
Java No issues
JavaScript Database access is not supported in JavaScript.