Ç¥ 37À» ºü¸¥ ÂüÁ¶ Áö¿ø µµ±¸·Î »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ±× ±¸¹®À» Æ÷ÇÔÇÏ¿© ¸ðµç ¸í·É¹®¿¡ ´ëÇÑ ¿ÏÀüÇÑ ¼³¸íÀº SQL ÂüÁ¶¼ÀÇ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
Ç¥ 37. SQL¹®(DB2 Universal Database)
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 (Embedded) | 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 transition-variable5 | X | X | X | X | ||
SIGNAL¹® | X | |||||
SIGNAL SQLSTATE5 | X | X | X | |||
UPDATE | X | X | X | X | ||
VALUES INTO | X | |||||
WHENEVER2 | ||||||
WHILE¹® | X | |||||
|