ÀÌ Àý¿¡´Â DB2¿Í ÇÔ²² Á¦°øµÇ´Â »ùÇà ÇÁ·Î±×·¥¿¡ ´ëÇÑ Á¤º¸°¡ ÀÖ½À´Ï´Ù. ¸ðµç »ùÇà ÇÁ·Î±×·¥Àº sqllib µð·ºÅ丮ÀÇ samples ¼ºêµð·ºÅ丮¿¡ ÀÖ½À´Ï´Ù. Áö¿øµÇ´Â °¢ ¾ð¾î¿¡ ´ëÇÑ ¼ºêµð·ºÅ丮°¡ ÀÖ½À´Ï´Ù.
ÀÌ Ã¥¿¡¼ »ç¿ëÇÑ »ùÇà ÇÁ·Î±×·¥Àº Áö¿øµÇ´Â È£½ºÆ® ¾ð¾î¿¡¼ Embedded SQL¹® ¹× API È£ÃâÀÇ ¿¹¸¦ ³ªÅ¸³À´Ï´Ù. »ùÇà ÇÁ·Î±×·¥Àº ª°í ´Ü¼øÇÏ°Ô ÀÛ¼ºÇß½À´Ï´Ù. Á¦ÀÛ ÀÀ¿ëÇÁ·Î±×·¥¿¡¼´Â ¸®ÅÏ ÄÚµå Æ¯È÷, API È£Ãâ ¹× SQL¹®ÀÇ SQLCODE ¶Ç´Â SQLSTATE¸¦ Á¡°ËÇÕ´Ï´Ù. ¿À·ù Á¶°Ç, SQLCODE ¹× SQLSTATE Á¶Àý¿¡ ´ëÇØ¼´Â Áø´Ü Á¶Àý ¹× SQLCA ±¸Á¶ÀÇ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ. »ç¿ëÀÚ È¯°æ¿¡¼ ÀÌ·± ÇÁ·Î±×·¥ÀÇ ¼³Ä¡, ºôµå ¹× ½ÇÇà¿¡ ´ëÇØ¼´Â ÀÀ¿ëÇÁ·Î±×·¥ ºôµå ¾È³»¼¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
ÁÖ:
»ùÇà ÇÁ·Î±×·¥Àº DB2 ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß(DB2 AD) Ŭ¶óÀÌ¾ðÆ®¿Í ÇÔ²² Á¦°øµË´Ï´Ù. »ùÇà ÇÁ·Î±×·¥À» ÅÛÇø®Æ®·Î »ç¿ëÇÏ¿© »ç¿ëÀÚÀÇ ÀÀ¿ëÇÁ·Î±×·¥À» ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.
»ùÇà ÇÁ·Î±×·¥ ÆÄÀÏ È®ÀåÀº Áö¿øµÇ´Â °¢ ¾ð¾î ±×¸®°í °¢ ¾ð¾îÀÇ Embedded SQL ¹× ºñembedded SQL ÇÁ·Î±×·¥¿¡¼ ´Ù¸¨´Ï´Ù. ÆÄÀÏ È®ÀåÀÚ´Â ¾ð¾î¿¡¼ ÇÁ·Î±×·¥ ±×·ì¿¡ ´ëÇØ¼µµ ´Ù¸¦ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·¸°Ô ¼·Î ´Ù¸¥ »ùÇà ÆÄÀÏ È®ÀåÀº ´ÙÀ½°ú °°Àº Å×À̺í·Î ºÐ·ùµË´Ï´Ù.
´ÙÀ½ Å×ÀÌºí¿¡¼´Â À¯Çüº° »ùÇà ÇÁ·Î±×·¥À» ¼³¸íÇÕ´Ï´Ù.
ÁÖ:
Ç¥ 38. ¾ð¾îº° »ùÇà ÆÄÀÏ È®ÀåÀÚ
¾ð¾î | µð·ºÅ丮 | Embedded SQL ÇÁ·Î±×·¥ | embeddedµÇÁö ¾Ê´Â SQL ÇÁ·Î±×·¥ |
---|---|---|---|
C |
samples/c samples/cli(CLI ÇÁ·Î±×·¥) | .sqc | .c |
C++ | samples/cpp |
.sqC (UNIX) .sqx (Windows & OS/2) |
.C (UNIX) .cxx (Windows & OS/2) |
COBOL |
samples/cobol samples/cobol_mf | .sqb | .cbl |
JAVA | samples/java | .sqlj | .java |
REXX | samples/rexx | .cmd | .cmd |
Ç¥ 39. ÇÁ·Î±×·¥ ±×·ìº° »ùÇà ÆÄÀÏ È®ÀåÀÚ
»ùÇà ±×·ì | µð·ºÅ丮 | ÆÄÀÏ È®ÀåÀÚ |
---|---|---|
ADO, RDO, MTS |
samples\ADO\VB (Visual Basic) samples\ADO\VC (Visual C++) samples\RDO samples\MTS |
.bas .frm .vbp (Visual Basic) .cpp .dsp .dsw (Visual C++) |
CLP | samples/clp | .db2 |
OLE |
samples\ole\msvb (Visual Basic) samples\ole\msvc (Visual C++) |
.bas .vbp (Visual Basic) .cpp (Visual C++) |
OLE DB | samples\oledb | .db2 |
SQL ÇÁ·Î½Ãµà¾î | samples/sqlproc |
.db2 .c .sqc (Ŭ¶óÀÌ¾ðÆ® ÀÀ¿ëÇÁ·Î±×·¥) |
User Exit | samples/c |
.cad (OS/2) .cadsm (UNIX & Windows) .cdisk (UNIX & Windows) .ctape (UNIX) |
ÁÖ: |
|
DB2¸¦ ¼³Ä¡ÇÑ µð·ºÅ丮ÀÇ samples ¼ºêµð·ºÅ丮¿¡ »ùÇà ÇÁ·Î±×·¥ÀÌ ÀÖ½À´Ï´Ù. Áö¿øµÇ´Â °¢ ¾ð¾î¿¡ ´ëÇÑ ¼ºêµð·ºÅ丮°¡ ÀÖ½À´Ï´Ù. ´ÙÀ½ ¿¹´Â Áö¿øµÇ´Â °¢ Ç÷§Æû¿¡¼ C ¶Ç´Â C++·Î ÀÛ¼ºÇÑ »ùÇÃÀ» ã´Â ¹æ¹ýÀ» ³ªÅ¸³À´Ï´Ù.
µ¥ÀÌÅͺ£À̽º ÀνºÅϽº µð·ºÅ丮°¡ ÀÖ´Â sqllib/samples/c ¾Æ·¡¿¡ Embedded SQL ¹× DB2 API ÇÁ·Î±×·¥ÀÇ C ¼Ò½º Äڵ尡 ÀÖ½À´Ï´Ù. DB2 CLI ÇÁ·Î±×·¥ÀÇ C ¼Ò½º ÄÚµå´Â sqllib/samples/cli¿¡ ÀÖ½À´Ï´Ù. »ùÇà Å×À̺íÀÇ ÇÁ·Î±×·¥¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº DB2 ÀνºÅϽº°¡ ÀÖ´Â ÇØ´ç samples ¼ºêµð·ºÅ丮ÀÇ README ÆÄÀÏÀ» ÂüÁ¶ÇϽʽÿÀ. README ÆÄÀÏ¿¡´Â ÀÌ Ã¥¿¡ ³ª¿µÇ¾î ÀÖÁö ¾ÊÀº Ãß°¡ »ùÇõµ ÀÖ½À´Ï´Ù.
DB2 ¼³Ä¡ µð·ºÅ丮 ¾Æ·¡ÀÇ %DB2PATH%\samples\c¿¡ Embedded SQL ¹× DB2 API ÇÁ·Î±×·¥ÀÇ C ¼Ò½º Äڵ尡 ÀÖ½À´Ï´Ù. DB2 CLI ÇÁ·Î±×·¥ÀÇ C ¼Ò½º ÄÚµå´Â %DB2PATH%\samples\cli¿¡ ÀÖ½À´Ï´Ù. %DB2PATH% º¯¼ö¿¡¼ DB2°¡ ¼³Ä¡µÈ À§Ä¡¸¦ ÆÇº°ÇÕ´Ï´Ù. DB2¸¦ ¼³Ä¡ÇÑ µå¶óÀ̺꿡 µû¶ó %DB2PATH%´Â drive:\sqllib¸¦ Áö½ÃÇÕ´Ï´Ù. »ùÇà Å×À̺íÀÇ »ùÇà ÇÁ·Î±×·¥¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ÇØ´ç %DB2PATH%\samples ¼ºêµð·ºÅ丮ÀÇ README ÆÄÀÏÀ» ÂüÁ¶ÇϽʽÿÀ. README ÆÄÀÏ¿¡´Â ÀÌ Ã¥¿¡ ³ª¿µÇ¾î ÀÖÁö ¾ÊÀº Ãß°¡ »ùÇõµ ÀÖ½À´Ï´Ù.
»ç¿ëÀÚÀÇ Ç÷§ÆûÀÌ Ç¥ 38¿¡ ¼³¸íµÇ¾î ÀÖÁö ¾ÊÀº °æ¿ì »ç¿ëÀÚ È¯°æÀÇ °íÀ¯ ³»¿ë¿¡ ´ëÇØ¼´Â ÀÀ¿ëÇÁ·Î±×·¥ ºôµå ¾È³»¼¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
»ùÇà ÇÁ·Î±×·¥ µð·ºÅ丮´Â ´ëºÎºÐÀÇ Ç÷§Æû¿¡¼ º¸Åë Àбâ Àü¿ëÀÔ´Ï´Ù. »ùÇà ÇÁ·Î±×·¥À» º¯°æÇϰųª ºôµåÇϱâ Àü¿¡ ±× ÇÁ·Î±×·¥À» ÀÛ¾÷ µð·ºÅ丮·Î º¹»çÇϽʽÿÀ.