|"´ÙÁß ½º·¹µå È¥ÇÕ ÀÀ¿ëÇÁ·Î±×·¥" ¼½¼Ç¿¡ ´ÙÀ½ÀÇ ³»¿ëÀ» Ãß°¡ÇØ¾ß ÇÕ´Ï´Ù.
´ÙÀ½Àº ÀÌ ÀåÀÇ »õ·Î¿î ¼½¼ÇÀÔ´Ï´Ù.
DB2 CLI À¯´ÏÄÚµå ÀÀ¿ëÇÁ·Î±×·¥ Áö¿øÀÇ µÎ ÁÖ¿ä ¿µ¿ªÀÌ ÀÖ½À´Ï´Ù.
´ÙÀ½Àº À¯´ÏÄÚµå(W) ¹× ANSI(A) ¹öÀüÀ» ¸ðµÎ Áö¿øÇÏ´Â ODBC API ÇÔ¼öÀÇ ¸ñ·ÏÀÔ´Ï´Ù. (À¯´ÏÄÚµåÀÇ °æ¿ì ÇÔ¼ö À̸§¿¡ W°¡ ÀÖ½À´Ï´Ù.)
SQLBrowseConnect SQLForeignKeys SQLPrimaryKeys SQLColAttribute SQLGetConnectAttr SQLProcedureColumns SQLColAttributes SQLGetConnectOption SQLProcedures SQLColumnPrivileges SQLGetCursorName SQLSetConnectAttr SQLColumns SQLGetDescField SQLSetConnectOption SQLConnect SQLGetDescRec SQLSetCursorName SQLDataSources SQLGetDiagField SQLSetDescField SQLDescribeCol SQLGetDiagRec SQLSetStmtAttr SQLDriverConnect SQLGetInfo SQLSpecialColumns SQLDrivers SQLGetStmtAttr SQLStatistics SQLError SQLNativeSQL SQLTablePrivileges SQLExecDirect SQLPrepare SQLTables
¹®ÀÚ¿ ±æÀÌÀμö¸¦ ¸®ÅÏ ¶Ç´Â ÃëÇÏ´Â À¯´ÏÄÚµå ÇÔ¼ö´Â ¹®ÀÚ¼ö·Î¼ Àü´ÞµË´Ï´Ù. ¼¹ö µ¥ÀÌÅÍ¿¡ ´ëÇÑ ±æÀÌ Á¤º¸¸¦ ¸®ÅÏÇÏ´Â ÇÔ¼öÀÇ °æ¿ì, Ç¥½Ã Å©±â¿Í Á¤¹Ðµµ´Â ¹®ÀÚ ¼ö·Î ¼³¸íÇÕ´Ï´Ù. ±æÀÌ(µ¥ÀÌÅÍÀÇ Àü¼Û Å©±â)°¡ ¹®ÀÚ¿ ¶Ç´Â ºñ¹®ÀÚ¿ µ¥ÀÌÅ͸¦ ÂüÁ¶ÇÒ ¼ö ÀÖ´Â °æ¿ì, ±æÀÌ´Â 8Áø¼ö·Î ¼³¸íµË´Ï´Ù. ¿¹¸¦ µé¾î, SQLGetInfoW´Â ±æÀ̸¦ ¹ÙÀÌÆ®¼ö·Î ÃëÇÏÁö¸¸, SQLExecDirectW´Â ¹®ÀÚ¼ö¸¦ »ç¿ëÇÕ´Ï´Ù. CLI´Â ÀÀ¿ëÇÁ·Î±×·¥ÀÇ ¹ÙÀεù¿¡ µû¶ó °á°ú ¼¼Æ®¸¦ À¯´ÏÄÚµå ¶Ç´Â ANSI·Î ¸®ÅÏÇÕ´Ï´Ù. ÀÀ¿ëÇÁ·Î±×·¥ÀÌ SQL_C_CHAR¿¡ ¹ÙÀεåÇÒ °æ¿ì, µå¶óÀ̹ö´Â SQL_WCHAR µ¥ÀÌÅ͸¦ SQL_CHAR·Î º¯È¯ÇÕ´Ï´Ù. µå¶óÀ̹ö °ü¸® ÇÁ·Î±×·¥Àº ANSI µå¶óÀ̹ö¸¦ À§ÇØ SQL_C_WCHARÀ» SQL_C_CHAR¿¡ ¸ÊÇÎÇÏÁö¸¸ À¯´ÏÄÚµå µå¶óÀ̹ö¸¦ À§Çؼ´Â ¸ÊÇÎÇÏÁö ¾Ê½À´Ï´Ù.
µÎ »õ·Î¿î CLI ¶Ç´Â ODBC Á¤ÀÇ µ¥ÀÌÅÍ À¯Çü, SQL_C_WCHAR°ú SQL_WCHARÀÌ ÀÖ½À´Ï´Ù. SQL_C_WCHARÀº C ¹öÆÛ¿¡ UCS-2 µ¥ÀÌÅÍ°¡ ÀÖÀ½À» ÀǹÌÇÕ´Ï´Ù. SQL_WCHARÀº ƯÁ¤ Ä÷³ ¶Ç´Â ¸Å°³º¯¼ö Ç¥½Ã¹®ÀÚ¿¡ À¯´ÏÄÚµå µ¥ÀÌÅÍ°¡ µé¾î ÀÖÀ½À» ÀǹÌÇÕ´Ï´Ù. DB2 À¯´ÏÄÚµå ¼¹öÀÇ °æ¿ì, ±×·¡ÇÈ Ä÷³Àº SQL_WCHAR·Î ¼³¸íµË´Ï´Ù. º¯È¯Àº ±×·¡ÇÈ µ¥ÀÌÅÍ À¯Çü »çÀÌ¿¡¼ »Ó¸¸ ¾Æ´Ï¶ó SQL_C_WCHAR°ú SQL_CHAR, SQL_VARCHAR,SQL_LONGVARCHAR ¹× SQL_CLOB »çÀÌ¿¡¼ Çã¿ëµË´Ï´Ù.
SQL µ¥ÀÌÅÍ À¯Çü |
S Q L _ C _ C H A R |
S Q L _ C _ W C H A R |
S Q L _ C _ L O N G |
S Q L _ C _ S H O R T |
S Q L _ C _ T I N Y I N T |
S Q L _ C _ F L O A T |
S Q L _ C _ D O U B L E |
S Q L _ C _ T Y P E _ D A T E |
S Q L _ C _ T Y P E _ T I M E |
S Q L _ C _ T Y P E _ T I M E S T A M P |
S Q L _ C _ B I N A R Y |
S Q L _ C _ B I T |
S Q L _ C _ D B C H A R |
S Q L _ C _ C L O B _ L O C A T O R |
S Q L _ C _ B L O B _ L O C A T O R |
S Q L _ C _ D B C L O B _ L O C A T O R |
S Q L _ C _ B I G I N T |
S Q L _ C _ N U M E R I C |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BLOB |
X |
X |
|
|
|
|
|
|
|
|
D |
|
|
|
X | |||
CHAR |
D |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
|
|
|
X |
X | |
CLOB |
D |
X |
|
|
|
|
|
|
|
|
X |
|
|
X |
| |||
DATE |
X |
X |
|
|
|
|
|
D |
|
X |
|
|
|
|
| |||
DBCLOB |
|
X |
|
|
|
|
|
|
|
|
X |
|
D |
|
|
X | ||
DECIMAL |
D |
X |
X |
X |
X |
X |
X |
|
|
|
X |
X |
|
|
|
X |
X | |
DOUBLE |
X |
X |
X |
X |
X |
X |
D |
|
|
|
|
X |
|
|
|
X |
X | |
FLOAT |
X |
X |
X |
X |
X |
X |
D |
|
|
|
|
X |
|
|
|
X |
X | |
GRAPHIC (ºñ À¯´ÏÄÚµå) |
X |
X |
|
|
|
|
|
|
|
|
|
|
D |
|
| |||
GRAPHIC(À¯´ÏÄÚµå) |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
D |
|
|
|
X |
|
INTEGER |
X |
X |
D |
X |
X |
X |
X |
|
|
|
|
X |
|
|
|
X |
X | |
LONG VARCHAR |
D |
X |
|
|
|
|
|
|
|
|
X |
|
|
|
| |||
LONG VARGRAPHIC (ºñ À¯´ÏÄÚµå) |
X |
X |
|
|
|
|
|
|
|
|
X |
|
D |
|
| |||
LONG VARGRAPHIC (À¯´ÏÄÚµå) |
X |
X |
|
|
|
|
|
|
|
|
X |
|
D |
|
|
|
|
|
NUMERIC |
D |
X |
X |
X |
X |
X |
X |
|
|
|
|
X |
|
|
|
X | ||
REAL |
X |
X |
X |
X |
X |
D |
X |
|
|
|
|
X |
|
|
|
X | ||
SMALLINT |
X |
X |
X |
D |
X |
X |
X |
|
|
|
|
X |
|
|
|
X |
X | |
BIGINT |
X |
X |
X |
X |
X |
X |
X |
|
|
|
X |
X |
|
|
|
D |
X | |
TIME |
X |
X |
|
|
|
|
|
|
D |
X |
|
|
|
|
| |||
TIMESTAMP |
X |
X |
|
|
|
|
|
X |
X |
D |
|
|
|
|
| |||
VARCHAR |
D |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
|
|
|
X |
X | |
VARGRAPHIC (ºñ À¯´ÏÄÚµå) |
X |
X |
|
|
|
|
|
|
|
|
|
|
D |
|
| |||
VARGRAPHIC (À¯´ÏÄÚµå) |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
X |
D |
|
|
|
X |
|
À¯´ÏÄÚµå ÀÀ¿ëÇÁ·Î±×·¥ÀÌ Áö¿øµÇ±â Àü¿¡ 1¹ÙÀÌÆ® ¹®ÀÚ µ¥ÀÌÅÍ·Î ÀÛ¾÷Çϵµ·Ï ÀÛ¼ºµÈ ÀÀ¿ëÇÁ·Î±×·¥Àº GRAPHIC=1,2 ¶Ç´Â 3, Patch2=7 µî°ú °°ÀÌ ÀÏ·ÃÀÇ cli ini ÆÄÀÏ Å°¿öµå ½Ã¸®Áî¿¡ ÀÇÇØ 2¹ÙÀÌÆ® ±×·¡ÇÈ µ¥ÀÌÅÍ·Î ÀÛ¾÷Çϵµ·Ï ¸¸µé ¼ö ÀÖ½À´Ï´Ù. ÀÌ¿Í °°Àº Àӽà Á¶Ä¡¿¡ µû¶ó ±×·¡ÇÈ µ¥ÀÌÅÍ°¡ ¹®ÀÚ µ¥ÀÌÅͷΠǥ½ÃµÇ¸ç ¶ÇÇÑ º¸°íµÇ´Â µ¥ÀÌÅÍÀÇ ±æÀÌ°¡ ´Þ¶óÁý´Ï´Ù.
|À̵é Å°¿öµå´Â À¯´ÏÄÚµå ÀÀ¿ëÇÁ·Î±×·¥¿¡ ´õ ÀÌ»ó ÇÊ¿äÇÏÁö ¾ÊÀ¸¸ç, |½ÇÁ¦·Î ½É°¢ÇÑ ºÎÀÛ¿ëÀÌ ÀÖÀ¸¹Ç·Î »ç¿ëÇؼ´Â ¾ÈµË´Ï´Ù. À̸¦ ¾Ë°í ÀÖÁö ¾ÊÀ¸¸é, ƯÁ¤ |ÀÀ¿ëÇÁ·Î±×·¥ÀÌ À¯´ÏÄÚµå ÀÀ¿ëÇÁ·Î±×·¥ÀÏ °æ¿ì, ±×·¡ÇÈ µ¥ÀÌÅÍ Ã³¸®¿¡ ¿µÇâÀ» |ÁÖ´Â Å°¿öµå ¾øÀÌ ½ÃµµÇϵµ·Ï ±ÇÀåÇÕ´Ï´Ù.
ºñ À¯´ÏÄÚµå µ¥ÀÌÅͺ£À̽º¿¡¼ LONG VARGRAPHIC ¹× LONG VARCHAR Ä÷³ÀÇ µ¥ÀÌÅÍ´Â ºñ±³µÉ ¼ö ¾ø½À´Ï´Ù. ³»ÀçµÈ ÄÚµå ÆäÀÌÁö º¯È¯ÀÌ Áö¿øµÇÁö ¾ÊÀ¸¹Ç·Î GRAPHIC/VARGRAPHIC ¹× CHAR/VARCHAR Ä÷³ÀÇ µ¥ÀÌÅÍ´Â ¸í½ÃÀû À¯Çüº¯È¯(cast) ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© ¼·Î ºñ±³Çϰųª ÇÒ´çµÉ ¼ö¸¸ ÀÖ¾ú½À´Ï´Ù. ¿©±â¿¡´Â GRAPHIC/VARGRAPHIC ¸®ÅÍ·²ÀÌ CHAR/VARCHAR ¸®ÅÍ·²°ú G Á¢µÎºÎ¿¡ ÀÇÇØ Â÷º°ÈµÇ´Â GRAPHIC/VARGRAPHIC ¹× CHAR/VARCHAR ¸®ÅÍ·²ÀÌ Æ÷ÇԵ˴ϴÙ.
À¯´ÏÄÚµå µ¥ÀÌÅͺ£À̽ºÀÇ °æ¿ì, GRAPHIC/VARGRAPHIC°ú CHAR/VARCHAR ¸®ÅÍ·² »çÀÌÀÇ À¯Çüº¯È¯(CAST)Àº ÇÊ¿äÇÏÁö ¾Ê½À´Ï´Ù. ¶ÇÇÑ, G Á¢µÎºÎ°¡ GRAPHIC/VARGRAPHIC ¸®ÅÍ·² ¾Õ¿¡ ÇÊ¿äÇÏÁö ¾Ê½À´Ï´Ù. ÃÖ¼ÒÇÑ ÇÑ Àμö°¡ ¸®ÅÍ·²À̸é, ³»ÀçµÈ º¯È¯ÀÌ ¹ß»ýÇÕ´Ï´Ù. ÀÌ´Â G Á¢µÎºÎ°¡ Àְųª ¾ø´Â ¸®ÅÍ·²À» SQLPrepareW() ¶Ç´Â SQLExecDirect()¸¦ »ç¿ëÇÏ´Â ¸í·É¹® ³»¿¡¼ »ç¿ëÇÒ ¼ö ÀÖµµ·Ï ÇØÁÝ´Ï´Ù. LONG VARGRAPHICÀÇ ¸®ÅÍ·²Àº G Á¢µÎºÎ¸¦ °¡Á®¾ßÇÕ´Ï´Ù.
ÀÚ¼¼ÇÑ Á¤º¸´Â SQL ÂüÁ¶¼ÀÇ "Á¦3Àå ¾ð¾î ¿ä¼Ò"¿¡¼ "µ¥ÀÌÅÍ À¯Çü°£ À¯Çüº¯È¯"À» ÂüÁ¶ÇϽʽÿÀ.
´ÙÀ½ ¼¼ °³ÀÇ Å°¿öµå¸¦ Ãß°¡ÇÏ¿© À¯´ÏÄÚµå ÀÀ¿ëÇÁ·Î±×·¥ÀÌ µ¥ÀÌÅ×À̽º¿¡ ¿¬°áµÉ ¶§ ¿©ºÐÀÇ ¿À¹öÇìµå¸¦ ÇÇÇÒ ¼ö ÀÖµµ·Ï ÇÏ¿´½À´Ï´Ù.
À¯´ÏÄÚµå Áö¿øÀÌ »ç¿ë °¡´ÉÇÏ°í, À¯´ÏÄÚµå ÀÀ¿ëÇÁ·Î±×·¥ÀÌ È£ÃâÇÑ °æ¿ì, ÄÚµåÆäÀÌÁö º¯È¯¿¡ ÀÇÇÑ ºÒÇÊ¿äÇÑ ÀÚ·á ¼Õ½ÇÀÌ ¾øµµ·Ï º¸ÀåÇϱâ À§ÇÏ¿© CLI´Â ÃÖ¼±ÀÇŬ¶óÀ̾ðÆ® ÄÚµå ÆäÀÌÁö¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇÏ·Á°í ½ÃµµÇÕ´Ï´Ù. ÀÌ´Â ÄÚµå ÆäÀÌÁö°¡ ±³È¯µÇ¹Ç·Î ¿¬°á ½Ã°£À» Áõ°¡½ÃÅ°°Å³ª ¶Ç´Â ÀÌ·¯ÇÑ Áö¿øÀÌ Ãß°¡µÇ±â ÀÌÀü¿¡´Â ¹ß»ýÄ¡ ¾Ê¾Ò´ø Ŭ¶óÀ̾ðÆ®¿¡¼ÀÇ ÄÚµå ÆäÀÌÁö º¯È¯À» ÃÊ·¡ÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÀÌ Å°¿öµå¸¦ True·Î ¼³Á¤Çϸé, µ¥ÀÌÅÍ°¡ ¼¹ö¿¡ ¼Û½ÅµÇ±â ÀÌÀü¿¡ ¿ì¼±ÀûÀ¸·Î ¸ðµç À¯´ÏÄÚµå µ¥ÀÌÅÍ°¡ ÀÀ¿ëÇÁ·Î±×·¥ÀÇ ±¹Áö ÄÚµå ÆäÀÌÁö·Î º¯È¯µÇµµ·Ï ÇÕ´Ï´Ù. ÀÌ´Â ±¹Áö ÄÚµå ÆäÀÌÁö¿¡¼ ´ëÇ¥µÉ ¼ö ¾ø´Â µ¥ÀÌÅÍÀÇ µ¥ÀÌÅÍ ¼Õ½ÇÀ» ÃÊ·¡ÇÒ ¼ö ÀÖ½À´Ï´Ù.
ºñ À¯´ÏÄÚµå ÀÀ¿ëÇÁ·Î±×·¥Àº ¾ðÁ¦³ª ÀÀ¿ëÇÁ·Î±×·¥ÀÇ Áö¿ª ÄÚµåÆäÀÌÁö ¶Ç´Â DB2Codepage ȯ°æ¼³Á¤À» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇÕ´Ï´Ù. ±âº»°ªÀ¸·Î CLI´Â À¯´ÏÄÚµå ÀÀ¿ëÇÁ·Î±×·¥ÀÌ UTF-8 ¹× UCS-2 ÄÚµå ÆäÀÌÁö¸¦ »ç¿ëÇÏ¿© À¯´ÏÄÚµå µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áµÇµµ·Ï º¸ÀåÇϸç, µ¥ÀÌÅͺ£À̽ºÀÇ ÄÚµå ÆäÀÌÁö¸¦ »ç¿ëÇÏ¿© ºñ À¯´ÏÄÚµå µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áµË´Ï´Ù. ÀÌ´Â ÄÚµå ÆäÀÌÁö º¯È¯¿¡ µû¸¥ ºÒÇÊ¿äÇÑ µ¥ÀÌÅÍ ¼Õ½ÇÀÌ »ý±âÁö ¾Êµµ·Ï º¸ÀåÇÕ´Ï´Ù.
¿¬°á½Ã¿¡ ¿©ºÐÀÇ ¿À¹öÇìµå¸¦ ÇÇÇϱâ À§ÇÏ¿© ºñ À¯´ÏÄÚµå µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇÏ´Â °æ¿ì, »ç¿ëÀÚ´Â ÀÌ Å°¿öµå¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽ºÀÇ ÄÚµå ÆäÀÌÁö¸¦ ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
°ª 1À» ÁöÁ¤ÇÏ¿© SQLDriverConnect()°¡ Ãâ·Â ¿¬°á ¹®ÀÚ¿¿¡¼ ¿Ã¹Ù¸¥ °ªÀ» ¸®ÅÏÇϵµ·Ï ÇÏ¿© ÇØ´ç °ªÀÌ ¹Ì·¡ÀÇ SQLDriverConnect() È£Ãâ¿¡ »ç¿ëµÉ ¼ö ÀÖµµ·Ï ÇÕ´Ï´Ù.
ÀÌ Å°¿öµå´Â ConnectCodepage=1208°ú µ¿ÀÏÇϸç Æí¸®¼ºÀ» À§ÇØ Ãß°¡ÇÏ¿´½À´Ï´Ù. OS/390 ¹öÀü 7 ¶Ç´Â ±× ÀÌ»óÀÇ DB2¿¡ ¿¬°áÇÏ´Â °æ¿ì, ÀÌ Å°¿öµå¸¦ »ç¿ëÇÏ¿© ¿©ºÐÀÇ ¿¬°á ¿À¹öÇìµå¸¦ ÇÇÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿©ºÐÀÇ Ã³¸®°¡ ÇÊ¿äÇÏÁö ¾ÊÀ¸¹Ç·Î, ÀÌ Å°¿öµå¸¦ WindowsÀÇ DB2, UnixÀÇ DB2 ¶Ç´Â OS/2 µ¥ÀÌÅͺ£À̽ºÀÇ DB2¿¡ »ç¿ëÇÒ ÇÊ¿ä´Â ¾ø½À´Ï´Ù.
|´ÙÀ½Àº "¼³Ä¡ ¹× ±¸¼º" ¼ºê¼½¼ÇÀÇ DISABLEMULTITHREAD ±¸¼º Å°¿öµå ±âº»°ªÀ» Á¤Á¤ÇÕ´Ï´Ù. |
´ÙÀ½ Á¤º¸´Â "ȸé À̵¿ Ä¿¼" ¼½¼Ç¿¡ Ãß°¡µÇ¾î¾ß ÇÕ´Ï´Ù.
Unix, Windows ¹× OS/2 Ç÷§Æû¿ë UDB Ŭ¶óÀ̾ðÆ®´Â OS/390 ¹öÀü 7 µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ ¼öÇàÇÒ ¶§ °»½Å°¡´ÉÇÑ ¼¹öÃø ȸé À̵¿ Ä¿¼¸¦ Áö¿øÇÕ´Ï´Ù. 3Ãþ(three-tier) ȯ°æ¿¡¼ OS/390 ȸé À̵¿ Ä¿¼¸¦ ¾×¼¼½ºÇÏ·Á¸é, Ŭ¶óÀ̾ðÆ® ¹× °ÔÀÌÆ®¿þÀÌ°¡ DB2 UDB ¹öÀü 7.1, FixPak 3 ÀÌ»óÀ» ½ÇÇà ÁßÀ̾î¾ß ÇÕ´Ï´Ù.
ȸé À̵¿ Ä¿¼¸¦ ¾×¼¼½ºÇÒ ¼ö ÀÖ´Â 2°³ÀÇ ÀÀ¿ëÇÁ·Î±×·¥ »ç¿ë ÀÎÅÍÆäÀ̽º(ODBC ¹× JDBC)°¡ ÀÖ½À´Ï´Ù. JDBC ÀÎÅÍÆäÀ̽º´Â Á¤Àû ȸé À̵¿ Ä¿¼¸¸À» ¾×¼¼½ºÇÒ ¼ö ÀÖÁö¸¸, ODBC ÀÎÅÍÆäÀ̽º´Â Á¤Àû ¹× keyset À§ÁÖ(keyset-driven) ¼¹öÃø ȸé À̵¿ Ä¿¼¸¦ ¾×¼¼½ºÇÒ ¼ö ÀÖ½À´Ï´Ù.
¾Æ·¡ Å×À̺íÀº ODBC¿¡¼ OS/390 ¹öÀü 7 Ä¿¼¿¡ ´ëÇÑ ±âº» ¼Ó¼ºÀ» ³ª¿ÇÕ´Ï´Ù.
Ç¥ 11. ODBC¿¡¼ OS/390 Ä¿¼¿¡ ´ëÇÑ ±âº» ¼Ó¼º
Ä¿¼ À¯Çü | Ä¿¼ ¹Î°¨¼º | Ä¿¼ °»½Å°¡´É | Ä¿¼ µ¿½Ã¼º | Ä¿¼ ȸé À̵¿ |
---|---|---|---|---|
Æ÷¿öµå Àü¿ëa | ¹ÌÁöÁ¤ | °»½Å°¡´ÉÇÏÁö ¾ÊÀ½ | Àбâ Àü¿ë µ¿½Ã¼º | ȸé À̵¿ °¡´ÉÇÏÁö ¾ÊÀ½ |
Á¤Àû | ¹Î°¨ÇÏÁö ¾ÊÀ½ | °»½Å°¡´ÉÇÏÁö ¾ÊÀ½ | Àбâ Àü¿ë µ¿½Ã¼º | ȸé À̵¿ |
keyset À§ÁÖ (keyset-driven) | ¹Î°¨ÇÔ | °»½Å°¡´É | °ª µ¿½Ã¼º | ȸé À̵¿ |
|
¸ðµç ODBC ÆäÄ¡ ¹æÇâÀº SQLFetchScroll ¶Ç´Â SQLExtendedFetch ÀÎÅÍÆäÀ̽º¸¦ ÅëÇØ Áö¿øµË´Ï´Ù.
keyset À§ÁÖ(keyset-driven) Ä¿¼´Â °»½Å°¡´ÉÇÑ Ä¿¼ÀÔ´Ï´Ù. CLI µå¶óÀ̹ö´Â Á¶È¸°¡ SELECT ... FOR READ ONLY Á¶È¸·Î¼ ¹ßÇàµÇ°Å³ª FOR UPDATE ÀýÀÌ ÀÌ¹Ì Á¸ÀçÇÏ´Â °æ¿ì¸¦ Á¦¿ÜÇÏ°í FOR UPDATE ÀýÀ» Á¶È¸¿¡ Ãß°¡ÇÕ´Ï´Ù. OS/390¿ë DB2¿¡¼ ±¸ÇöµÇ´Â keyset À§ÁÖ(keyset-driven) Ä¿¼´Â °ª µ¿½Ã¼º Ä¿¼ÀÔ´Ï´Ù. °ª µ¿½Ã¼º Ä¿¼´Â ÃÖÀû Àá±ÝÀÇ °á°ú¸¦ °¡Á®¿À¸ç, ¿©±â¼ °ªÀº °»½ÅÀ̳ª »èÁ¦°¡ ½ÃµµµÉ ¶§±îÁö º¸À¯µÇÁö ¾Ê½À´Ï´Ù. °»½Å ¶Ç´Â »èÁ¦°¡ ½ÃµµµÇ¸é, µ¥ÀÌÅͺ£À̽º ¼¹ö´Â ÀÀ¿ëÇÁ·Î±×·¥ÀÌ °Ë»öÇÑ ÀÌÀü °ª°ú ÁÖ¿ä Å×À̺íÀÇ ÇöÀç °ªÀ» ºñ±³ÇÕ´Ï´Ù. °ªÀÌ ÀÏÄ¡ÇÏ´Â °æ¿ì, °»½Å ¶Ç´Â »èÁ¦°¡ ¼º°øÇÕ´Ï´Ù. °ªÀÌ ÀÏÄ¡ÇÏÁö ¾Ê´Â °æ¿ì, Á¶ÀÛÀÌ ½ÇÆÐÇÕ´Ï´Ù. ½ÇÆÐÇÑ °æ¿ì, ÀÀ¿ëÇÁ·Î±×·¥Àº ´Ù½Ã °ªÀ» Á¶È¸ÇÏ°í ¿©ÀüÈ÷ Àû¿ë°¡´ÉÇÏ´Ù¸é °»½Å ¶Ç´Â »èÁ¦¸¦ ´Ù½Ã ¹ßÇàÇØ¾ß ÇÕ´Ï´Ù.
ÀÀ¿ëÇÁ·Î±×·¥Àº µÎ°¡Áö ¹æ½ÄÀ¸·Î keyset À§ÁÖ(keyset-driven) Ä¿¼¸¦ °»½ÅÇÒ ¼ö ÀÖ½À´Ï´Ù.
ȸé À̵¿ Ä¿¼ Áö¿øÀº »õ·Î¿î ±â´ÉÀ̹ǷÎ, OS/390¿ë UDB ¶Ç´Â Unix, Windows ¹× OS/2¿ë UDB´Â Çൿ ¶Ç´Â ¼º´É º¯°æÀÌ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù. ȸé À̵¿ Ä¿¼°¡ Áö¿øµÇ±â Àü¿¡´Â, ȸé À̵¿ Ä¿¼¸¦ ¿äûÇÑ ÀÀ¿ëÇÁ·Î±×·¥ÀÌ Æ÷¿öµå Àü¿ë Ä¿¼¸¦ ¹Þ±â ¶§¹®¿¡ ÀÌ·± °æ¿ì°¡ ¹ß»ýÇÕ´Ï´Ù. ȸé À̵¿ Ä¿¼ Áö¿øÇϱâ ÀüÀÇ ÀÀ¿ëÇÁ·Î±×·¥ÀÇ ÀÌÀü È°µ¿À» º¹¿øÇÏ·Á¸é, ´ÙÀ½°ú °°Àº ±¸¼º Å°¿öµå¸¦ db2cli.ini ÆÄÀÏ¿¡ ¼³Á¤ÇϽʽÿÀ.
Ç¥ 12. ȸé À̵¿ Ä¿¼°¡ Áö¿øÇϱâ Àü¿¡ ÀÀ¿ëÇÁ·Î±×·¥ È°µ¿À» º¹¿øÇÏ´Â ±¸¼º Å°¿öµå °ª
±¸¼º Å°¿öµå ¼³Á¤ | ¼³¸í |
---|---|
PATCH2=6 | ȸé À̵¿ Ä¿¼(keyset À§ÁÖ(keyset-driven) ¹× Á¤Àû ¸ðµÎ)°¡ Áö¿øµÇÁö ¾ÊÀ½À» ³ªÅ¸³»´Â ¸Þ½ÃÁö¸¦ ¸®ÅÏÇÕ´Ï´Ù. CLI´Â ÀÚµ¿À¸·Î ȸé À̵¿ Ä¿¼¿¡ ´ëÇÑ ¸ðµç ¿äûÀ» Æ÷¿öµå Àü¿ë Ä¿¼·Î ³·Ãä´Ï´Ù. |
DisableKeysetCursor=1 | ¼¹öÃø ¹× Ŭ¶óÀ̾ðÆ®Ãø keyset À§ÁÖ(keyset-driven) ȸé À̵¿ Ä¿¼ ¸ðµÎ¸¦ »ç¿ëÇÏÁö ¾Ê½À´Ï´Ù. ÀÌ°ÍÀº keyset À§ÁÖ(keyset-driven) Ä¿¼°¡ ¿äûµÉ ¶§ CLI µå¶óÀ̹ö°¡ ÀÀ¿ëÇÁ·Î±×·¥¿¡ Á¤Àû Ä¿¼¸¦ ºÎ¿©Çϵµ·Ï °Á¦ÇÏ´Â µ¥ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù. |
UseServerKeysetCursor=0 | Ŭ¶óÀ̾ðÆ®Ãø keyset À§ÁÖ(keyset-driven) Ä¿¼ ¶óÀ̺귯¸®¸¦ »ç¿ë ÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ÀÇ ¼¹öÃø keyset À§ÁÖ(keyset-driven) Ä¿¼¸¦ »ç¿ëÇÏÁö ¾ÊÀ½À¸·Î½á keyset À§ÁÖ(keyset-driven) Ä¿¼¸¦ ½Ã¹Ä·¹ÀÌÆ®ÇÕ´Ï´Ù. Ŭ¶óÀ̾ðÆ®Ãø Ä¿¼°¡ ¸¹Àº ¾çÀÇ ¿À¹öÇìµå¸¦ ¹ß»ý½ÃÅ°°í ÀϹÝÀûÀ¸·Î ¼¹öƯ Ä¿¼º¸´Ù ¼º´ÉÀÌ ³ª»Ú¹Ç·Î ¼¹öÃø keyset À§ÁÖ(keyset-driven) Ä¿¼¿¡¼ ¹®Á¦Á¡ÀÌ ¹ß»ýÇÒ ¶§¸¸ ÀÌ ¿É¼ÇÀ» »ç¿ëÇϽʽÿÀ. |
´ÙÀ½ÀÇ ÁÖÀÇ»çÇ×ÀÌ Ã¥¿¡¼ ´©¶ôµÇ¾ú½À´Ï´Ù.
Any SQL statement that can be prepared dynamically, other than a query, can be executed as a statement inside a compound statement. Note: Inside Atomic Compound SQL, savepoint, release savepoint, and rollback to savepoint SQL statements are also disallowed. Conversely, Atomic Compound SQL is disallowed in savepoint.
´ÙÀ½Àº CLI ÀúÀå ÇÁ·Î½Ãµà¾î¿¡ ´ëÇØ ¹®¼ÈµÇÁö ¾ÊÀº Á¦ÇÑ»çÇ×ÀÔ´Ï´Ù.
If you are making calls to multiple CLI stored procedures, the application must close the open cursors from one stored procedure before calling the next stored procedure. More specifically, the first set of open cursors must be closed before the next stored procedure tries to open a cursor.
´ÙÀ½Àº ÀÌ Ã¥ÀÇ Á¤º¸¸¦ º¸ÃæÇÏ´Â ³»¿ëÀÔ´Ï´Ù.
CLI/ODBC µå¶óÀ̹ö´Â »ç¿ëÀÚ°¡ ÀûÇÕÇÑ Æ¯±Ç ¶Ç´Â ±ÇÇÑÀ» °®°í ÀÖ´Â °æ¿ì, º¸Åë CLI/ODBC ÀÀ¿ëÇÁ·Î±×·¥ÀÌ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ SQLÀ» óÀ½ ½ÇÇàÇÒ ¶§ CLI ÆÐÅ°Áö¸¦ ÀÚµ¿À¸·Î ¹ÙÀεåÇÕ´Ï´Ù. CLI ÆÐÅ°ÁöÀÇ ÀÚµ¿ ¹ÙÀεå´Â ÀúÀå ÇÁ·Î½Ãµà¾î³»¿¡¼ ¼öÇàµÉ ¼ö ¾øÀ¸¹Ç·Î, ÀÀ¿ëÇÁ·Î±×·¥ÀÌ ¼öÇàÇÏ´Â Á¦ÀÏ Ã³À½ µ¿ÀÛÀÌ CLI ÀúÀå ÇÁ·Î½Ãµà¾î¸¦ È£ÃâÇÏ´Â °ÍÀÎ °æ¿ì ¹ß»ýÇÏÁö ¾Ê½À´Ï´Ù. ±×·¯¹Ç·Î, »õ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ CLI ÀúÀå ÇÁ·Î½Ãµà¾î¸¦ È£ÃâÇÏ´Â CLI ÀÀ¿ëÇÁ·Î±×·¥À» ½ÇÇàÇϱâ Àü¿¡, ÀÌ ¸í·ÉÀ¸·Î CLI ÆÐÅ°Áö¸¦ Çѹø ¹ÙÀεåÇØ¾ß ÇÕ´Ï´Ù.
db2 bind <BNDPATH>/@db2cli.lst blocking all
db2bind "%DB2PATH%\bnd\@db2cli.lst" blocking
±ÇÀåÇÏ´Â Á¢±Ù ¹æ¹ýÀº ·±Å¸Àӽà ÀÚµ¿ ¹ÙÀε带 ¿¹¹æÇϱâ À§ÇØ µ¥ÀÌÅͺ£À̽º ÀÛ¼º½Ã À̵é ÆÐÅ°Áö¸¦ Ç×»ó ¹ÙÀεåÇÏ´Â °ÍÀÔ´Ï´Ù. »ç¿ëÀÚ¿¡°Ô Ư±ÇÀÌ ¾ø°Å³ª ´Ù¸¥ ÀÀ¿ëÇÁ·Î±×·¥ÀÌ µ¿½Ã¿¡ ÀÚµ¿ ¹ÙÀε带 ½ÃµµÇÏ´Â °æ¿ì ÀÚµ¿ ¹ÙÀε尡 ½ÇÆÐÇÒ ¼ö ÀÖ½À´Ï´Ù.