ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß ¾È³»¼­


ºÎ·Ï


ºÎ·Ï A. Áö¿øµÇ´Â SQL¹®

Ç¥ 37:

Ç¥ 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
Notes:
  1. ÀÌ ¸ñ·ÏÀÇ ¸ðµç ¸í·É¹®À¸·Î Á¤Àû SQL·Î ÄÚµùÇÒ ¼ö ÀÖÁö¸¸ X Ç¥½ÃµÈ ¸í·É¹®Àº µ¿Àû SQL·Î ÄÚµùÇϽʽÿÀ.
  2. ÀÌ ¸í·É¹®À» ½ÇÇàÇÒ ¼ö ¾ø½À´Ï´Ù.
  3. X´Â SQLExecDirect()³ª SQLPrepare() ¹× SQLExecute()¸¦ »ç¿ëÇÏ¿© ÀÌ ¸í·É¹®À» ½ÇÇàÇÒ ¼ö ÀÖÀ½À» ³ªÅ¸³À´Ï´Ù. ÇØ´ç DB2 CLI ±â´ÉÀÌ ÀÖÀ» °æ¿ì ÇÔ¼ö À̸§ÀÌ ³ª¿­µË´Ï´Ù.
  4. ÀÌ ¸í·É¹®ÀÌ µ¿ÀûÀÌÁö´Â ¾ÊÁö¸¸ SQLExecDirect()³ª, SQLPrepare() ¹× SQLExecute()¸¦ È£ÃâÇÒ ¶§ DB2 CLI¸¦ »ç¿ëÇÏ¿© ÀÌ ¸í·É¹®À» ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
  5. CREATE TRIGGER¹®¿¡¼­¸¸ À̸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
  6. SQL DESCRIBE¹®À» »ç¿ëÇØ¼­¸¸ Ãâ·ÂÀ» ±â¼úÇÒ ¼ö ÀÖÁö¸¸ DB2 CLI¸¦ »ç¿ëÇϸé SQLDescribeParam() ÇÔ¼ö·Î ÀԷµµ ±â¼úÇÒ ¼ö ÀÖ½À´Ï´Ù.
  7. SQL FETCH¹®À» »ç¿ëÇÏ¿© ÇÑ ¹æÇâÀ¸·Î Çѹø¿¡ ÇÑ Ç྿ °¡Á®¿Ã ¼ö ÀÖÁö¸¸ DB2 CLI SQLExtendedFetch() ¹× SQLFetchScroll() ÇÔ¼ö¸¦ »ç¿ëÇØ¼­´Â ¹è¿­·Î °¡Á®¿Ã ¼ö ÀÖ½À´Ï´Ù. ´õ ³ª¾Æ°¡ ¾î¶² ¹æÇâÀ¸·Îµç °á°ú ¼¼Æ®ÀÇ ¾î¶² À§Ä¡¿¡¼­µç °¡Á®¿Ã ¼ö ÀÖ½À´Ï´Ù.
  8. DESCRIBE SQL¹®ÀÇ ±¸¹®Àº CLP DESCRIBE ¸í·ÉÀÇ ±¸¹®°ú ´Ù¸¨´Ï´Ù. DESCRIBE SQL¹®¿¡ ´ëÇØ¼­´Â SQL ÂüÁ¶¼­¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ. DESCRIBE CLP ¸í·É¿¡ ´ëÇØ¼­´Â Command Reference¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
  9. ¸í·ÉÇà ÇÁ·Î½Ãµà¾î¸¦ ÅëÇØ CALLÀ» ¹ßÇàÇÒ °æ¿ì ´ÙÀ½ ÇÁ·Î½Ãµà¾î¿Í ±× ¸Å°³º¯¼ö¸¸ Áö¿øµË´Ï´Ù. (JAR ÆÄÀÏ ¼³Ä¡, ´ëü ¹× Á¦°Å ÂüÁ¶).
  10. ¸í·É¹®Àº ¿¬ÇÕ µ¥ÀÌÅͺ£À̽º ¼­¹ö¿¡ ´ëÇØ¼­¸¸ Áö¿øµË´Ï´Ù.
  11. SQL ÇÁ·Î½Ãµà¾î´Â »öÀÎ, Å×ÀÌºí ¹× ºä¿¡ ´ëÇØ¼­¸¸ CREATE ¹× DROP¹®À» ½ÇÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]