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:
- ALTER
- CALL
- CREATE ALIAS
- CREATE INDEX
- CREATE SYNONYM
- CREATE TABLE
- CREATE VIEW
- DECLARE global temporary table
- DELETE
- DROP INDEX
- DROP SYNONYM
- DROP TABLE
- DROP VIEW
- GRANT
- INSERT
- LOCK
- RENAME
- REVOKE
- SAVEPOINT
- SET
- SIGNAL
- UPDATE
- VALUES
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:
- CLOSE
- COMMIT
- CONNECT
- CREATE FUNCTION
- CREATE PROCEDURE
- DECLARE CURSOR
- DESCRIBE
- DISCONNECT
- EXECUTE
- EXECUTE IMMEDIATE
- FETCH
- OPEN
- PREPARE
- ROLLBACK WORK
- SELECT
- INCLUDE SQLCA
- INCLUDE SQLDA
- WHENEVER
Syntax
- 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.
|