With the exception of INSERT, DELETE(SEARCHED) and UPDATE(SEARCHED) which are included for your convenience, the embedded
SQL statements described here work somewhat differently, or are in addition to, standard SQL statements.
ALLOCATE CURSOR Defines a cursor and associates it with a result set locator variable.
ASSOCIATE LOCATORS Gets the result set locator value for each result set returned by a SQL CLR stored procedure.
BEGIN TRAN Provides compatibility with Embedded SQL implementations that do not conform to the ANSI SQL standard with respect to transaction
management and, in particular, the Micro Focus Embedded SQL Toolkit for Microsoft SQL Server.
CALL Executes a stored procedure or a Pro*COBOL function.
CLOSE Discards unprocessed rows and frees any locks held by the cursor.
COMMIT Makes any changes made by the current transaction on the current connection permanent in the database.
CONNECT Attaches to a specific database using the supplied user name and password.
DECLARE CURSOR Associates the cursor name with the specified SELECT statement and enables you to retrieve rows of data using the FETCH statement.
FETCH Retrieves a row from the cursor's results set and writes the values of the columns in that row to the corresponding host variables
(or to addresses specified in the SQLDA data structure).
GET DIAGNOSTICS Enables you to get diagnostic information for the last OpenESQL statement executed.
GET HDBC Enables you to use ODBC calls that require you to supply the ODBC connection handle.
GET HENV Enables you to use ODBC calls that require you to supply the ODBC environment handle.
INTO Retrieves one row of results and assigns the values of the items returned by an OUTPUT clause in a SQL Server INSERT, UPDATE,
or DELETE statement to the host variables specified in the INTO list.
OPEN Runs the SELECT statement specified in the corresponding DECLARE CURSOR statement to produce the results set that is accessed
one row at a time by the FETCH statement.
PERSIST Saves information defined in a cursor SELECT statement as XML files.
QUERY ODBC Delivers a results set in the same way as a SELECT statement, and must therefore be associated with a cursor via DECLARE and
OPEN, or DECLARE, PREPARE and OPEN.
RESET CONNECTION Closes all open cursors, even if the application has not appropriately closed them.
ROLLBACK Backs out any changes made to the database by the current transaction on the current connection, or partially rolls back changes
to a previously set save point.
SAVEPOINT Sets a transaction save point to which a current transaction can be rolled back, resulting in a partial roll back.
SELECT DISTINCT (using DECLARE CURSOR) Associates the cursor name with the SELECT DISTINCT statement and enables you to retrieve rows of data using the FETCH statement.
SELECT INTO Retrieves one row of results and assigns the values of the items in a specified SELECT list to the host variables specified
in the INTO list.
SET AUTOCOMMIT Enables you to control ODBC AUTOCOMMIT mode at runtime.