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.
