ecpg-sql-commands.md 1.6 KB
Newer Older
K
KyleZhang 已提交
1 2 3 4 5 6
## 36.14. Embedded SQL Commands

[ALLOCATE DESCRIPTOR](ecpg-sql-allocate-descriptor.html) — allocate an SQL descriptor area[CONNECT](ecpg-sql-connect.html) — establish a database connection[DEALLOCATE DESCRIPTOR](ecpg-sql-deallocate-descriptor.html) — deallocate an SQL descriptor area[DECLARE](ecpg-sql-declare.html) — define a cursor[DECLARE STATEMENT](ecpg-sql-declare-statement.html) — declare SQL statement identifier[DESCRIBE](ecpg-sql-describe.html) — obtain information about a prepared statement or result set[DISCONNECT](ecpg-sql-disconnect.html) — terminate a database connection[EXECUTE IMMEDIATE](ecpg-sql-execute-immediate.html) — dynamically prepare and execute a statement[GET DESCRIPTOR](ecpg-sql-get-descriptor.html) — get information from an SQL descriptor area[OPEN](ecpg-sql-open.html) — open a dynamic cursor[PREPARE](ecpg-sql-prepare.html) — prepare a statement for execution[SET AUTOCOMMIT](ecpg-sql-set-autocommit.html) — set the autocommit behavior of the current session[SET CONNECTION](ecpg-sql-set-connection.html) — select a database connection[SET DESCRIPTOR](ecpg-sql-set-descriptor.html) — set information in an SQL descriptor area[TYPE](ecpg-sql-type.html) — define a new data type[VAR](ecpg-sql-var.html) — define a variable[WHENEVER](ecpg-sql-whenever.html) — specify the action to be taken when an SQL statement causes a specific class condition to be raised

 This section describes all SQL commands that are specific to embedded SQL. Also refer to the SQL commands listed in [SQL Commands](sql-commands.html), which can also be used in embedded SQL, unless stated otherwise.