埋め込み SQL 文

便宜上組み込まれている INSERT、DELETE(SEARCHED) および UPDATE(SEARCHED) を除き、ここでは、標準の SQL 文とは動作がやや異なる埋め込み SQL 文や、標準の SQL 文に追加された埋め込み SQL 文を説明します。

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 DECLARE SECTION
Signals the beginning of the DECLARE section.
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.
BIND CONNECTION
Enables a JDBC connection object to be shared with OpenESQL.
CALL
Executes a stored procedure.
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.
DECLARE DATABASE
Declares the name of a database.
DECLARE STATEMENT
他の ESQL SQL 方言との互換性を提供します。OpenESQL プリプロセッサはこれを受け入れますが、処理はしません。
DELETE (位置付け)
Deletes the row most recently fetched by using a cursor.
DELETE (検索)
Removes table rows that meet the search criteria.
DESCRIBE
Provides information on prepared dynamic SQL statements.
DISCONNECT
Closes the connection(s) to a database. In addition, all cursors opened for that connection are automatically closed.
END DECLARE SECTION
Terminates a host variable declaration section begun by a BEGIN DECLARE SECTION statement.
EXECSP
Executes a stored procedure.
EXECUTE
Processes dynamic SQL statements.
EXECUTE IMMEDIATE
Immediately executes the SQL 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 CONNECTION
Places an OpenESQL connection object into the supplied host variable such that the objects can then be shared with other JDBC programs.
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.
GET NEXT RESULT SET
Makes the next result set available to an open cursor.
INCLUDE
Includes the definition of the specified SQL data structure or source file in the COBOL program.
INSERT
Adds new rows to a table.
INTO
結果の 1 行を取得し、SQL Server INSERT、UPDATE、または DELETE 文の OUTPUT 句で戻された項目の値を、INTO リストで指定されたホスト変数に割り当てます。
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.
PREPARE
Processes dynamic SQL statements.
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 (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.
SET CONCURRENCY
Sets the concurrency option for cursors.
SET CONNECTION
Sets the named connection as the current connection.
SET OPTION
Enables you to set OpenESQL options.
SET SCROLLOPTION
Enables you to set cursor scrolling options.
SET TRACELEVEL
Enables you to dynamically set or change the reporting level of OpenESQL traces for native applications.
SET TRANSACTION ISOLATION
Sets the transaction isolation level for the current connection to one of the isolation level modes specified by ODBC.
SYNCPOINT
Closes all open cursors that were not opened using the WITH HOLD clause, even if the application has not appropriately closed them.
UNBIND CONNECTION
Disassociates OpenESQL from the original JDBC connection object.
UPDATE (位置付け)
UPDATE (検索)
Updates a table or view based on specified search conditions.
WHENEVER
Specifies the default action after running an Embedded SQL statement when a specific condition is met.

上位ヘルプ： OpenESQL

関連概念

埋め込み SQL

関連項目

SQL