This section describes all SQL commands that are specific to embedded SQL.
Command | Description |
|---|---|
ALLOCATE DESCRIPTOR | Allocate an SQL descriptor area |
CONNECT | Eestablish a database connection |
DEALLOCATE DESCRIPTOR | Deallocate an SQL descriptor area |
DECLARE | Define a cursor |
DESCRIBE | Obtain information about a prepared statement or result set |
DISCONNECT | Terminate a database connection |
EXECUTE IMMEDIATE | Dynamically prepare and execute a statement |
GET DESCRIPTOR | Get information from an SQL descriptor area |
OPEN | Open a dynamic cursor |
PREPARE | Prepare a statement for execution |
SET AUTOCOMMIT | Set the autocommit behavior of the current session |
SET CONNECTION | Select a database connection |
SET DESCRIPTOR | Set information in an SQL descriptor area |
TYPE | Define a new data type |
VAR | Define a variable |
WHENEVER | Specify the action to be taken when an SQL statement causes a specific class condition to be raised |
See
Refer to the SQL commands listed in "SQL Commands" under "Reference" in the PostgreSQL Documentation, which can also be used in embedded SQL, unless stated otherwise.
