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


ºÎ·Ï B. »ùÇà ÇÁ·Î±×·¥

ÀÌ Àý¿¡´Â DB2¿Í ÇÔ²² Á¦°øµÇ´Â »ùÇà ÇÁ·Î±×·¥¿¡ ´ëÇÑ Á¤º¸°¡ ÀÖ½À´Ï´Ù. ¸ðµç »ùÇà ÇÁ·Î±×·¥Àº sqllib µð·ºÅ丮ÀÇ samples ¼­ºêµð·ºÅ丮¿¡ ÀÖ½À´Ï´Ù. Áö¿øµÇ´Â °¢ ¾ð¾î¿¡ ´ëÇÑ ¼­ºêµð·ºÅ丮°¡ ÀÖ½À´Ï´Ù.

ÀÌ Ã¥¿¡¼­ »ç¿ëÇÑ »ùÇà ÇÁ·Î±×·¥Àº Áö¿øµÇ´Â È£½ºÆ® ¾ð¾î¿¡¼­ Embedded SQL¹® ¹× API È£ÃâÀÇ ¿¹¸¦ ³ªÅ¸³À´Ï´Ù. »ùÇà ÇÁ·Î±×·¥Àº ª°í ´Ü¼øÇÏ°Ô ÀÛ¼ºÇß½À´Ï´Ù. Á¦ÀÛ ÀÀ¿ëÇÁ·Î±×·¥¿¡¼­´Â ¸®ÅÏ ÄÚµå Æ¯È÷, API È£Ãâ ¹× SQL¹®ÀÇ SQLCODE ¶Ç´Â SQLSTATE¸¦ Á¡°ËÇÕ´Ï´Ù. ¿À·ù Á¶°Ç, SQLCODE ¹× SQLSTATE Á¶Àý¿¡ ´ëÇØ¼­´Â Áø´Ü Á¶Àý ¹× SQLCA ±¸Á¶ÀÇ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ. »ç¿ëÀÚ È¯°æ¿¡¼­ ÀÌ·± ÇÁ·Î±×·¥ÀÇ ¼³Ä¡, ºôµå ¹× ½ÇÇà¿¡ ´ëÇØ¼­´Â ÀÀ¿ëÇÁ·Î±×·¥ ºôµå ¾È³»¼­¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

ÁÖ:

  1. ÀÌ Àý¿¡¼­´Â DB2¿¡¼­ Áö¿øÇÏ´Â ¸ðµç Ç÷§Æû¿ë ÇÁ·Î±×·¡¹Ö ¾ð¾îÀÇ »ùÇà ÇÁ·Î±×·¥¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù. ¸ðµç »ùÇà ÇÁ·Î±×·¥ÀÌ ¸ðµç Ç÷§ÆûÀ̳ª Áö¿øµÇ´Â ¸ðµç ÇÁ·Î±×·¡¹Ö ¾ð¾î·Î Æ÷Æ®µÇ´Â °ÍÀº ¾Æ´Õ´Ï´Ù.

  2. DB2 »ùÇà ÇÁ·Î±×·¥Àº ±× ¾î¶°ÇÑ º¸Áõµµ ¾øÀÌ "ÀÖ´Â ±×´ë·Î" Á¦°øµË´Ï´Ù. IBMÀÌ ¾Æ´Ñ »ç¿ëÀÚ°¡ Àüü ǰÁú, ¼º´ÉÀÇ À§ÇèÀ» °¨¼öÇÏ°í °áÇÔÀ» Á¤Á¤ÇÕ´Ï´Ù.

»ùÇà ÇÁ·Î±×·¥Àº DB2 ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß(DB2 AD) Ŭ¶óÀÌ¾ðÆ®¿Í ÇÔ²² Á¦°øµË´Ï´Ù. »ùÇà ÇÁ·Î±×·¥À» ÅÛÇø®Æ®·Î »ç¿ëÇÏ¿© »ç¿ëÀÚÀÇ ÀÀ¿ëÇÁ·Î±×·¥À» ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.

»ùÇà ÇÁ·Î±×·¥ ÆÄÀÏ È®ÀåÀº Áö¿øµÇ´Â °¢ ¾ð¾î ±×¸®°í °¢ ¾ð¾îÀÇ Embedded SQL ¹× ºñembedded SQL ÇÁ·Î±×·¥¿¡¼­ ´Ù¸¨´Ï´Ù. ÆÄÀÏ È®ÀåÀÚ´Â ¾ð¾î¿¡¼­ ÇÁ·Î±×·¥ ±×·ì¿¡ ´ëÇØ¼­µµ ´Ù¸¦ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·¸°Ô ¼­·Î ´Ù¸¥ »ùÇà ÆÄÀÏ È®ÀåÀº ´ÙÀ½°ú °°Àº Å×À̺í·Î ºÐ·ùµË´Ï´Ù.

¾ð¾îº° »ùÇà ÆÄÀÏ È®ÀåÀÚ
Ç¥ 38.

ÇÁ·Î±×·¥ ±×·ìº° »ùÇà ÆÄÀÏ È®ÀåÀÚ
Ç¥ 39.

´ÙÀ½ Å×ÀÌºí¿¡¼­´Â À¯Çüº° »ùÇà ÇÁ·Î±×·¥À» ¼³¸íÇÕ´Ï´Ù.

Embedded SQLÀÌ ¾ø´Â DB2 API »ùÇà ÇÁ·Î±×·¥
Ç¥ 40.

DB2 API Embedded SQL »ùÇà ÇÁ·Î±×·¥
Ç¥ 41.

DB2 API°¡ ¾ø´Â Embedded SQL »ùÇà ÇÁ·Î±×·¥
Ç¥ 42.

»ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö »ùÇà ÇÁ·Î±×·¥
Ç¥ 43

DB2 CLI »ùÇà ÇÁ·Î±×·¥
Ç¥ 44.

Java JDBC »ùÇà ÇÁ·Î±×·¥
Ç¥ 45.

Java SQLJ »ùÇà ÇÁ·Î±×·¥
Ç¥ 46.

SQL Procedure »ùÇà ÇÁ·Î±×·¥
Ç¥ 47.

ActiveX Data Object, Remote Data Object ¹× Microsoft Transaction Server »ùÇà ÇÁ·Î±×·¥
Ç¥ 48.

OLE(Object Linking and Embedding) ÀÚµ¿È­ »ùÇà ÇÁ·Î±×·¥
Ç¥ 49.

OLE DB(Object Linking and Embedding Database) Å×À̺í ÇÔ¼ö
Ç¥ 50.

¸í·ÉÇà 󸮱â(CLP) »ùÇà ÇÁ·Î±×·¥
Ç¥ 51.

·Î±× °ü¸® User Exit ÇÁ·Î±×·¥
Ç¥ 52.

ÁÖ:

  1. Ç¥ 41¿¡´Â DB2 API¿Í Embedded SQL¹®À» Æ÷ÇÔÇÑ ÇÁ·Î±×·¥ÀÌ ÀÖ½À´Ï´Ù. ¸ðµç DB2 API »ùÇà ÇÁ·Î±×·¥¿¡ ´ëÇØ¼­´Â Ç¥ 40 ¹× Ç¥ 41¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ. Java SQLJ¸¦ Á¦¿ÜÇÑ ¸ðµç Embedded SQL »ùÇà ÇÁ·Î±×·¥¿¡ ´ëÇØ¼­´Â Ç¥ 41 ¹× Ç¥ 42¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

  2. DB2 CLI UDF ÇÁ·Î±×·¥ÀÌ ¾ø´Â UDF »ùÇà ÇÁ·Î±×·¥Àº Ç¥ 43¿¡ ³ª¿Í ÀÖ½À´Ï´Ù. ÀÌ¿¡ ´ëÇØ¼­´Â Ç¥ 44¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.


Ç¥ 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)

ÁÖ:

µð·ºÅ丮 ºÐ¸®¹®ÀÚ
UNIXÀÇ °æ¿ì /ÀÔ´Ï´Ù. OS/2 ¹× Windows Ç÷§Æû¿¡¼­´Â \ÀÔ´Ï´Ù. Å×ÀÌºí¿¡¼­ Windows ¹×/¶Ç´Â OS/2¿¡¼­¸¸ µð·ºÅ丮°¡ »ç¿ë °¡´ÉÇÑ °æ¿ì¸¦ Á¦¿ÜÇϸé UNIX ºÐ¸®¹®ÀÚ°¡ »ç¿ëµË´Ï´Ù.

ÆÄÀÏ È®ÀåÀÚ
È®ÀåÀÌ Çϳª¸¸ Á¸ÀçÇÏ´Â Å×ÀÌºí¿¡¼­ »ùÇÿ¡ ´ëÇØ Á¦°øµË´Ï´Ù.

»ùÇà ¼Ò½º ÄÚµå ¸µÅ©
»ùÇà Å×À̺íÀÇ ÀϺÎ(´Ù´Â ¾Æ´Ô) ÇÁ·Î±×·¥¿¡ ´ëÇØ Á¦°øµË´Ï´Ù.

Embedded SQL ÇÁ·Î±×·¥
ÇÁ·Î±×·¥ ¼öÇà½Ã Embedded SQL¹®ÀÌ ÇØ¼®µÇ´Â REXX Embedded SQL ÇÁ·Î±×·¥À» Á¦¿ÜÇϰí´Â »çÀü ó¸® ÄÄÆÄÀÏÀ» ¿ä±¸ÇÕ´Ï´Ù.

IBM COBOL »ùÇÃ
AIX, OS/2 ¹× Windows 32 ºñÆ® ¿î¿µ üÁ¦ÀÇ °æ¿ì¿¡¸¸ cobol ¼­ºêµð·ºÅ丮¿¡ Á¦°øµË´Ï´Ù.

Micro Focus Cobol »ùÇÃ
AIX, HP-UX, OS/2 ¹× Windows 32 ºñÆ® ¿î¿µ üÁ¦ÀÇ °æ¿ì¿¡¸¸ cobol_mf ¼­ºêµð·ºÅ丮¿¡ Á¦°øµË´Ï´Ù.

Java »ùÇÃ
Java UDF»Ó ¾Æ´Ï¶ó JDBC(Java Database Connectivity) ¾ÖÇø´, ÀÀ¿ëÇÁ·Î±×·¥ ¹× ÀúÀå ÇÁ·Î½Ãµà¾î, SQLJ(Embedded SQL for Java) ¾ÖÇø´, ÀÀ¿ëÇÁ·Î±×·¥ ¹× ÀúÀå ÇÁ·Î½Ãµà¾îµµ ÇØ´çÇÕ´Ï´Ù. Áö¿øµÇ´Â ¸ðµç DB2 Ç÷§Æû¿¡¼­´Â Java »ùÇÃÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.

REXX »ùÇÃ
AIX, OS/2 ¹× Windows NT ¿î¿µ üÁ¦¿¡ ´ëÇØ¼­¸¸ Á¦°øµË´Ï´Ù.

CLP »ùÇÃ
SQL¹®À» ½ÇÇàÇÏ´Â ¸í·ÉÇà 󸮱⠽ºÅ©¸³Æ®ÀÔ´Ï´Ù.

OLE »ùÇÃ
Windows 32 ºñÆ® ¿î¿µ üÁ¦ Àü¿ëÀ¸·Î Á¦°øµÈ, Microsoft Visual Basic ¹× MicrosoftVisual C++ÀÇ OLE(Object Linking and Embedding)¿ëÀÔ´Ï´Ù.

ADO, RDO ¹× MTS »ùÇÃ
Windows 32 ºñÆ® ¿î¿µ üÁ¦ Àü¿ëÀ¸·Î Á¦°øµÈ, Microsoft Visual Basic ¹× Microsoft Visual C++ÀÇ ActiveX Data Object »ùÇðú Microsoft Visual BasicÀÇ Remote Data Object ¹× Microsoft Transaction Server »ùÇÃÀÔ´Ï´Ù.

User Exit »ùÇÃ
µ¥ÀÌÅͺ£À̽º ·Î±× ÆÄÀÏÀ» º¸°üÇÏ°í °Ë»öÇÏ´Â µ¥ »ç¿ëµÇ´Â ·Î±× °ü¸® User Exit ÇÁ·Î±×·¥ÀÔ´Ï´Ù. ÀÌ ÆÄÀÏÀÇ È®ÀåÀÚ¸¦ .c·Î º¯°æÇÏ°í ÆÄÀÏÀ» C ¾ð¾î ÇÁ·Î±×·¥À¸·Î ÄÄÆÄÀÏÇØ¾ß ÇÕ´Ï´Ù.

DB2¸¦ ¼³Ä¡ÇÑ µð·ºÅ丮ÀÇ samples ¼­ºêµð·ºÅ丮¿¡ »ùÇà ÇÁ·Î±×·¥ÀÌ ÀÖ½À´Ï´Ù. Áö¿øµÇ´Â °¢ ¾ð¾î¿¡ ´ëÇÑ ¼­ºêµð·ºÅ丮°¡ ÀÖ½À´Ï´Ù. ´ÙÀ½ ¿¹´Â Áö¿øµÇ´Â °¢ Ç÷§Æû¿¡¼­ C ¶Ç´Â C++·Î ÀÛ¼ºÇÑ »ùÇÃÀ» ã´Â ¹æ¹ýÀ» ³ªÅ¸³À´Ï´Ù.

»ç¿ëÀÚÀÇ Ç÷§ÆûÀÌ Ç¥ 38¿¡ ¼³¸íµÇ¾î ÀÖÁö ¾ÊÀº °æ¿ì »ç¿ëÀÚ È¯°æÀÇ °íÀ¯ ³»¿ë¿¡ ´ëÇØ¼­´Â ÀÀ¿ëÇÁ·Î±×·¥ ºôµå ¾È³»¼­¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

»ùÇà ÇÁ·Î±×·¥ µð·ºÅ丮´Â ´ëºÎºÐÀÇ Ç÷§Æû¿¡¼­ º¸Åë Àбâ Àü¿ëÀÔ´Ï´Ù. »ùÇà ÇÁ·Î±×·¥À» º¯°æÇϰųª ºôµåÇϱâ Àü¿¡ ±× ÇÁ·Î±×·¥À» ÀÛ¾÷ µð·ºÅ丮·Î º¹»çÇϽʽÿÀ.


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