表 215. SQL ステートメント (DB2 ユニバーサル・データベース)
SQL ステートメント | 動的1 | コマンド行プロセッサー (CLP) | コール・レベル・インターフェース3 (CLI) | SQL プロシージャー |
---|---|---|---|---|
ALLOCATE CURSOR | X | |||
割り当てステートメント | X | |||
ASSOCIATE LOCATORS | X | |||
ALTER { BUFFERPOOL, NICKNAME,10 NODEGROUP, SERVER,10 TABLE, TABLESPACE, USER MAPPING,10 TYPE, VIEW } | X | X | X | |
BEGIN DECLARE SECTION2 | ||||
CALL | X9 | X4 | X | |
CASE ステートメント | X | |||
CLOSE | X | SQLCloseCursor(), SQLFreeStmt() | X | |
COMMENT ON | X | X | X | X |
COMMIT | X | X | SQLEndTran, SQLTransact() | X |
複合 SQL (組み込み) | X4 | |||
複合ステートメント | X | |||
CONNECT (タイプ 1) | X | SQLBrowseConnect(), SQLConnect(), SQLDriverConnect() | ||
CONNECT (タイプ 2) | X | SQLBrowseConnect(), SQLConnect(), SQLDriverConnect() | ||
CREATE { ALIAS, BUFFERPOOL, DISTINCT TYPE, EVENT MONITOR, FUNCTION, FUNCTION MAPPING,10 INDEX, INDEX EXTENSION, METHOD, NICKNAME,10 NODEGROUP, PROCEDURE, SCHEMA, TABLE, TABLESPACE, TRANSFORM TYPE MAPPING,1 TRIGGER, USER MAPPING,10 TYPE, VIEW, WRAPPER10 } | X | X | X | X11 |
DECLARE CURSOR2 | X | SQLAllocStmt() | X | |
DECLARE GLOBAL TEMPORARY TABLE | X | X | X | X |
DELETE | X | X | X | X |
DESCRIBE8 | X | SQLColAttributes(), SQLDescribeCol(), SQLDescribParam()6 | ||
DISCONNECT | X | SQLDisconnect() | ||
DROP | X | X | X | X11 |
END DECLARE SECTION2 | ||||
EXECUTE | SQLExecute() | X | ||
EXECUTE IMMEDIATE | SQLExecDirect() | X | ||
EXPLAIN | X | X | X | X |
FETCH | X | SQLExtendedFetch()7, SQLFetch(), SQLFetchScroll()7 | X | |
FLUSH EVENT MONITOR | X | X | X | |
FOR ステートメント | X | |||
FREE LOCATOR | X4 | X | ||
GET DIAGNOSTICS | X | |||
GOTO ステートメント | X | |||
GRANT | X | X | X | X |
IF ステートメント | X | |||
INCLUDE2 | ||||
INSERT | X | X | X | X |
ITERATE | X | |||
LEAVE ステートメント | X | |||
LOCK TABLE | X | X | X | X |
LOOP ステートメント | X | |||
OPEN | X | SQLExecute(), SQLExecDirect() | X | |
PREPARE | SQLPrepare() | X | ||
REFRESH TABLE | X | X | X | |
RELEASE | X | X | ||
RELEASE SAVEPOINT | X | X | X | X |
RENAME TABLE | X | X | X | |
RENAME TABLESPACE | X | X | X | |
REPEAT ステートメント | X | |||
RESIGNAL ステートメント | X | |||
RETURN ステートメント | X | |||
REVOKE | X | X | X | |
ROLLBACK | X | X | SQLEndTran(), SQLTransact() | X |
SAVEPOINT | X | X | X | X |
select-statement | X | X | X | X |
SELECT INTO | X | |||
SET CONNECTION | X | SQLSetConnection() | ||
SET CURRENT DEFAULT TRANSFORM GROUP | X | X | X | X |
SET CURRENT DEGREE | X | X | X | X |
SET CURRENT EXPLAIN MODE. | X | X | X, SQLSetConnectAttr() | X |
SET CURRENT EXPLAIN SNAPSHOT | X | X | X, SQLSetConnectAttr() | X |
SET CURRENT PACKAGESET | ||||
SET CURRENT QUERY OPTIMIZATION | X | X | X | X |
SET CURRENT REFRESH AGE | X | X | X | X |
SET EVENT MONITOR STATE | X | X | X | X |
SET INTEGRITY | X | X | X | |
SET PASSTHRU10 | X | X | X | X |
SET PATH | X | X | X | X |
SET SCHEMA | X | X | X | X |
SET SERVER OPTION10 | X | X | X | X |
SET 変換変数5 | X | X | X | X |
SIGNAL ステートメント | X | |||
SIGNAL SQLSTATE5 | X | X | X | |
UPDATE | X | X | X | X |
VALUES INTO | X | |||
WHENEVER2 | ||||
WHILE ステートメント | X | |||