Execute statement for a relational database

You can use the EGL execute statement to run either a prepared SQL statement or a set of one or more non-prepared SQL statements.
You can use an execute statement to issue an SQL statement of any of the following types:
You cannot use an execute statement to issue an SQL statement that returns a result set or to issue an SQL statement of any of the following types:

Syntax



Syntax diagram for the execute statement with SQL

field
A value of an EGL simple type that is compatible with the corresponding database column. The list of simple values is set into the statement in a way that matches the list of column entries.
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.

If you issue a prepared statement, the variable is optional and is ignored if present.

stmt
A set of one or more SQL statements.

You can use a prepared statement in place of #sql{stmt}.


Compatibility

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