µL¼ÐÃD¤å¥ó
»Ýn ESQL¶Ü?AcuSQL®©Î³\´N¬O±z©Ò§ä´Mªº¤u¨ã
¦³«Ü¦hÀ³¥Îµ{¦¡¦b¦s¨úÃöÁp¦¡¸ê®Æ®wªº¸ê®Æ®É¨Ï¥Î¤º´O¦¡ SQL(ESQL)¡A¦]¬°¥¦§Q¥Î¤FÃöÁp¦¡¸ê®Æ®w¯S¦³ªºI/O¤èªk¡A©Ò¥HESQL¥i¥H´£¨Ñ¤@Ó¦³®Ä²v¥B¥i¦æªº¤èªk¨Ó¦s¨ú©MºûÅ@¦b¸ê®Æ®w¤Wªº¸ê®Æ¡C
ª½¨ì²{¦b¡A°²¦p±zn´O¤J SQL¨ì±zªºACUCOBOL-GT®¤º¡A±z¥²¶·±q±zªº¸ê®Æ®w¼t°Ó¨ú±o¤@Ó¹w¥ý½sĶ¾¹(precompiler)¡A¨Ã±N¨ä¾ã¦X¶iAcucorp®ªºµo®iÀô¹Ò¤º¡C³oÁö«D§xÃøªº¤u§@¡A¦ý¥i¯à·|ÂàÅܦ¨¬°ºÞ²z¼h¦¸¤WªºÁô¼~¡C
²{¦b Acucorp¦³¤F¤@ӸѨM¤è®×¡XAcuSQL®¡A¦]¬°§Ú̪ºAcuSQL®¤u¨ãºò±Kªº¾ã¦X¨ìµo®i¨t²Î»PAcuBench®³oÓ¾ã¦X©Ê¶}µoÀô¹Ò¡A¦p¦¹´NÅý¨Ï¥ÎESQL«Øºc©MºûÅ@µ{¦¡Åܱo®e©ö¦h¤F¡C
ESQL vs COBOL I/O
ESQL¬O¤£¦P©óANSI¼Ð·ÇCOBOLªºI/O±Ôz¡A¨º¨Ç¥i¹ïÃöÁp¦¡¸ê®Æ®w°õ¦æªº°ò¥»ESQL¹Bºâ¬O¤£¦P©ó¹ïCOBOLÀɮתº¹Bºâ¡C¨Ò¦p¡G°²³]±zn§ä¥X¦b¬YÀɮפº¬Y¤@µ§°O¿ýªº¬YÓÄæ¦ìªºÈ¡A¦pªG¨Ï¥Î¼Ð·ÇCOBOLªºI/O±Ôz¡A±z±N¥²¶·¶}±ÒÀɮסA³vµ§Åª¨úª½¨ì±z§ä¨ì±z©Ò·Qnªº°O¿ý¡A±µµÛ¤~¹ê»ÚŪ¨ú¾ãµ§°O¿ý¡C¨Ï¥Î¯Á¤Þ¥i¥H¥[³t¾ãÓ¹Lµ{¡A¦ý°£¦¹¤§¥~¹ï°õ¦æ®Ä¯qªº½Õ®Õ´N¨S¦³¨ä¥¦¥i¥H°µ¤F¡C
¨Ï¥Î ESQL±z¥i¥H¶i¦æ¤@Ó¬d¸ß¨Ã¥BÅý¶Ç¦^¨Óªº¸ê®Æ´N¬O±z©ÒnªºÄæ¦ì¡A´N¹³±z¦b¨Ï¥ÎCOBOLªºI/O¡A±z¥i¥H¨Ï¥Î¯Á¤Þ¡A¦ý±z¤]¥i¥H¦b±zªº¬d¸ß¤W³]©w¤W©M¤U¡C±z¥i¥H¨Ï¥Îwhere¤l¥y¨Ó´yz¨ä¥¦Äæ¦ìªºÈ¡A¨ä¤¤¥]¬A«DÁäȪºÄæ¦ì¡A³o¼Ëªº«ü¥O¥i¥HÅýSQL±Ôz¥»¨°µ¨ì©úÅ㪺°õ¦æ®Ä¯q½Õ®Õ¡A¤]´N¬OÅý¥¦«D±`¦³®Ä²v¡C
AcuSQL®·§Æ[
AcuSQL®´£¨Ñ¹ïn´O¤J¦bCOBOLì©l½X¤¤ªºµ²ºc¤Æ¬d¸ß»y¨¥(SQL)±Ôzªº¤ä´©¡A¥Ø«eAcuSQL®¹ïESQLªº¤ä´©¬O«Ø¥ß¦bIBM SQL©MISO ANSI SQL92¼Ð·Ç¤W¡A³o¼Ëªº²Õ¦X¬Û¹ï´N´£¨Ñ¹ïIBM DB2©MSQL92¬Û®e¸ê®Æ¨Ó·½ªº¦s¨ú¡C
AcuSQL®¬O¸g¥Ñ¹w¥ý½sĶ¾¹©M¤@¯S§Oªº°õ¦æ¾¹°ÊºA³sµ²µ{¦¡®wªº¨Ï¥Î¨Ó¤ä´©±µ¦¬¥B°õ¦æ¯S§Oªº¤º´OSQLªºµ{¦¡¡C³Q´O¤J¨ìCOBOLµ{¦¡¤¤ªºSQL¨Ã«DANSI¼Ð·Ç¡A°²¦p±z¥´ºâ½sĶ§t¦³ESQL ªºµ{¦¡¡A±z±N·|±µ¨ì³\¦hµo¥Í¦bSQL«ü¥O¦æªº¿ù»~¡C¬°¤FÅý½sĶ¦¨¥\¨Ã¥B²£¥Í¥Øªº½X¡A¥²¶·¶i¦æ¤@¨Ç³B²z¥H«K±NSQL§ïÅܦ¨¬°COBOL½sĶ¾¹»P°õ¦æ¾¹©ÒÁA¸Ñªº®æ¦¡¡C
³o´N¬O¬°¦ó»Ýn AcuSQL®¹w¥ý³B²z¾¹(preprocessor)¡A ¥¦±½´M¾ãÓCOBOLì©l½X¥H§ä¥XESQL¡A«O¯d¨º¨ÇESQL ¦ý§ï¦¨¬°µù¸Ñ®æ¦¡¡A±µµÛ±N¥¦ÂàĶ¦¨¼Ð·ÇªºCOBOL±Ôz¡A¦Ü©ó¨ä¥¦ªºµ{¦¡½X«h¤£¥h¸IIJ¨Ã«O¯d¬°ì¨Óªº¼Ë¦¡¡C¤@Ó¦¨¥\ªº¹w¥ý½sĶ·|²£¥Í¤@ÓÁ{®ÉÀÉ¡A¥¦±µµÛ³Q¥Î¨Ó°µ¬°¼Ð·ÇACUCOBOL-GT®½sĶ°Ê§@ªº¿é¤J¶µ¡C
AcuSQL®¿ï¨ú¤º´O¦¡SQLªºµ{¦¡½X¡A¨ä®æ¦¡´N¹³¡G
EXEC SQL
CREATE TABLE ACUTEST2
(EMPLOYEE_NAME CHAR(20) NOT NULL
DATE_COLUMN TIMESTAMP
VACATION_DAYS INTEGER
COMMENTS CHAR(20)
PRIMARY KEY (EMPLOYEE_NAME)
END-EXEC.
±µµÛ±N¥¦ÂàĶ¦¨¦p¹Ï¤@ªº®æ¦¡¡C
¡m¹Ï¤@¡n
³oÓ¹w¥ý½sĶªº°Ê§@¥i¶}©l©ó AcuBench ®¤u§@¥x©Î±q ACUCOBOL-GT® ªº©R¥O¦C¡C¦b AcuBench® ¤¤¡A·í±z¦b¤@Ó ESQL ÀɮפW³]©w ?/FONT>pre-compile?/FONT> ¿ï¶µ¡A¤u§@¥x¦b¨C¦¸±M®×³Q«Ø»s©ÎÀɮ׳Q½sĶ®É´N·|¦Û°Êªº¹w¥ý½sĶ¸ÓÀɮסC©Ò¦³¹w¥ý½sĶªº¿ù»~·|³QÅã¥Ü¦b AcuBench® ªº¿é¥Xµøµ¡¤¤¡C¦b ACUCOBOL-GT
®©R¥O¦C¦³¤@²Õ½sĶºX¼m¥i±Ò°Ê¹w¥ý½s Ķ¡F¦Ó¿ù»~«h³Q¾É¦V¨ì¼Ð·Ç¿é¥X¡C
¦b¦¨¥\¹w¥ý½sĶ±µµÛ¦¨¥\ªº½sĶ«á·|²£¥Í¤@¥Øªº½X¡A¸Ó¥Øªº½X´N¤w·Ç³Æ³Q°õ¦æ¾¹¥ß§Y°õ¦æ¡C·í¥Øªº½X°õ¦æ®É¡A ESQL±Ôz(²{¦b¬O¼Ð·ÇCOBOLªº±Ôz)³Q¶Ç»¼µ¹AcuSQL®ªº°ÊºA³sµ²µ{ ¦¡®w (DLL)¡A¥¦·|»P¸ê®Æ®w³sµ²³nÅé·¾³q¡A«Ø¥ß³s±µ¡A±µµÛÂ^¨ú©M¼g¦^¸ê®Æ©M¥æ´«°T®§¡C
AcuSQL®ªº°õ¦æ Àô¹Ò¡G
- COBOL À³¥Îµ{¦¡°õ¦æ©ó¤Uz¥D¾÷ :
UNIX® /Linux® ¡AWindows® 95/98/ME, Windows NT® , Windows 2000, and Windows XP .
- ¸ê®Æ¨Ó·½¦ì©ó¤Uz¥D¾÷¥¥x :
- Windows NT, Windows 2000
- UNIX/Linux
- OS/390 ® (DB2 only)
- platforms that provide ODBC level 2 connectivity to the application host
- ¸ê®Æ¨Ó·½ºØÃþ¤ä´© :
- IBM DB2
- Microsoft SQL Server
- ISO/ANSI SQL92 accessible data sources
¶}µoÀô¹Ò»Ý¨D :
- AcuSQL ® software, Version 6
- Disk space: 10 MB (The disk space requirement varies slightly depending on the operating system used.)
- Memory: No additional memory is required.
- ACUCOBOL-GT ® development system
- ODBC level 2 API connection to your database. For DB2, IBM's DB2
Connect™ is recommended.
- Any required networking software support
°²¦p±zªºÀ³¥Îµ{¦¡·Ç³Æ¦s¨ú DB2 ¸ê®Æ®w¡A±z¥²¶·¦w¸Ë¡B²Õºc¡A¨Ã¥B¦b¶}µo±zªº ESQL µ{¦¡¤§«e´ú¸Õ±zªº BD2 ³sµ²³nÅé¡C¦bì¼t¡A¹ï DB2 ¸ê®Æ®wªº¦s¨ú¬O¨Ï¥Î IBM ªº ¡§DB2 Connect¡¨ ³nÅé¨Ó´ú¸Õ¡A©Ò¥H°²¦p±z¥´ºâÅý±zªºÀ³¥Îµ{¦¡¦s¨ú DB2 ¸ê®Æ¨Ó·½ªº¸Ü¡A§ÚÌ·|«Øij±z¨Ï¥Î¸Ó³nÅé¡CµM¦Ó¡A¥ô¦ó¼t°Ó¤w¸g¾A·í²Õºc¹Lªº ODBC Level 2 API ³sµ²³nÅéÀ³¸Ó¤]¦³§@¥Î¡C
°²¦p±zªºÀ³¥Îµ{¦¡·Ç³Æ¦s¨ú SQL92 ¬Û®eªº¸ê®Æ¨Ó·½¡A±zªº¸ê®Æ¨Ó·½¥²¶·¸m©ó¥ô¦ó±z±q Windows ¨ì±zªº¸ê®Æ¨Ó·½¤§¶¡¤w¸g¦³¥i§@¥Îªº ODBC API ³sµ²ªº¥D¾÷¤W¡C
µ{¦¡ªº·Ç³Æ
±zªº ESQL COBOLì©l½X¥²¶·²Å¦X¦bIBMªº¥Xª©«~S10J-8158-00¡G ¡§Embedded SQL Programming Guide, Version 5¡¨ ¤º´yzªºSQL¡A©ÎISO/ANSI SQL 92¼Ð·Ç¡C°²¦p±z²{¦³ªºÀ³¥Îµ{¦¡¤w¸g§t¦³¤º´O¦¡SQL¨Ó¦s¨úDB2¸ê®Æ®w¡A¨Ã¥B±z¨Ã¨S¦³¦bµ{¦¡¤¤¨Ï¥Î¥ô¦ólarge object¸ê®Æ«¬ºA(LOBs)¡A±zÀ³¸Ó¤£¥²¹ï±zªºESQL°µ¥ô¦ó§ïÅÜ¡C
¸ê®Æ¬q¸¨ (Data Division)
¦b¸ê®Æ¬q¸¨¤¤¤ä´©¤U±ªº SQL±Ôz¡G
SQL INCLUDE
SQL declarations
¨Ò¦p¡G
EXEC SQL INCLUDE SQLCA END-EXEC.
EXEC SQL INCLUDE SQLDA END-EXEC.
EXEC SQL INCLUDE filename END-EXEC.
EXEC SQL BEGIN DECLARE SECTION END-EXEC.
¡K SQL declarations
EXEC SQL END DECLARE SECTION END-EXEC.
¼Ð·Çªº SQLCA©MSQLDA INCLUDEÀɮ׬O«Ø¥ß¦b¹w¥ý½sĶ¾¹¡A¨Ã¥B·í¥¦Ì¦bì©l½X¤¤³Q«ü©w®É³£·|³Q¥]§t¶i¨Ó¡C³o¨ÇÀɮפw¸g¯S§Oקï½Õ¾ãÅýAcuSQL®¨Ï¥Î¡A¤£nÀ|¸Õ¥H§OºØª©¥»¨Ó¨ú¥N¡C
¸ê®Æ«¬ºA
¬°¤F½T«O¸ê®Æ¨Ó·½©M±zªº COBOL µ{¦¡¦³¾A·í¨Ã¥B¥¿½Tªº¸ê®Æ¤Ç°t¡A±z¥²¶·Åý SQL ªº¸ê®Æ«¬ºA¤Ç°t¦X¾Aªº COBOL ¸ê®Æ«¬ºA¡C¦b³oùØn´£¿ô¥Ø«e¥u¦³¤ä´©©T©wªø«×©MÅܰʪø«×ªº¤å¦r¦r¦ê¡C¤U±ªºªí®æ´yz¹ï DB2 ªº¸ê®Æ«¬ºA¬Û®e©Ê¡C
SQL Type
|
COBOL Type
|
Description
|
CHAR(n) |
01 name PIC X(N). |
Fixed-length character string
|
DATE |
01 name PIC X(10). |
10-byte character string
|
DECIMAL(p,n) |
01 name PIC S9(m)V9(n) COMP-3.
|
Packed decimal (where m=p-n)
|
DOUBLE |
01 name USAGE IS DOUBLE
|
Double-precision floating point
|
INTEGER |
01 name PIC S9(9) COMP-5.
|
32-bit signed integer |
LONG VARCHAR(n) |
01 name.
03 name-length PIC S9(4) COMP-5.
03 name-name PIC X(n). |
Variable length character string
|
REAL |
01 name PIC S9(4) USAGE IS COMP-1.
|
Single-precision floating porint
|
SMALLINT |
01 anme PIC S9(4) COMP-5.
|
16-bit signed integer |
TIME |
01 name PIC X(8). |
8-byte character string
|
TIMESTAMP |
01 name PIC X(26). |
26-byte character string
|
VARCHAR(n) |
01 name.
03 name-length PIC S9(4) COMP-5.
03 name-name PIC X(n). |
Variable-length character string (n ,<=4000)
|
¦Ó¤U±ªºªí®æ«h´yz¹ï MSSQLªº¸ê®Æ«¬ºA¬Û®e©Ê¡C
SQL Type
|
COBOL Type
|
Description
|
CHAR(n) |
01 name PIC X(n). |
Fixed-length character string
|
DATETIME |
01 name PIC X(25). |
25-byte character string
|
DECIMAL(p,n) |
01 name PIC S9(m) V9(n) COMP-3.
|
Packed decimal (where m = p-n)
|
DOUBLE PRECISION |
01 name USAGE IS DOUBLE.
|
Double-precision floating point
|
INTEGER |
01 name PIC S9(9) COMP-5.
|
32-bit signed integer |
REAL |
01 name PIC S9(4) USAGE IS COMP-1.
|
Single-precision floating point
|
SMALLINT |
01 name PIC S9(4) COMP-5.
|
16-bit signed integer |
VARCHAR(n) |
01 name.
03 name-length PIC S9(4) COMP-5.
03 name-name PIC X(n). |
Variable-length character string (n <= 4000)
|
CONNECT©MDISCONNECT±Ôz
CONNECT©MDISCONNECT¨âÓ±Ôzªº»yªk¤À§O´yz¦p¤U¡G
CONNECT TO server-name [AS connection-name]
USER userid USING passwd]
CONNECTION±Ôz·|À|¸Õ»Pserver-name«Ø¥ß¤@ӨϥΪ̬°useridªº³sµ²¡A¦Ó ¡§AS connection-name¡¨ ¤l¥y«h«ü©w¤@Ó¯S©wªº¦WºÙµ¹³sµ²¡CÄ´¦p¡G
CONNECT TO big-data AS con1 USER :uid USING :pwd
¦b¤W±ªº¨Ò¤l¤¤¡A uid»Ppwd³£¬OÄÝ©ó¥D¾÷ÅܼơA©Ò¿×ªº¥D¾÷ÅܼƬO«ü¥ô¦ó©w¸q¦bSQL DECLARE¬q¸¨¤ºªº¸ê®Æ¶µ¥Ø¡A³q±`¥D¾÷ÅܼÆ̳Q¨Ï¥Î¦bSQL±Ôz¤º¨Ã¥B¥²¶·¥H«_¸¹(¡§:¡¨)«e¤Þ¡C
¦Ó DISCONNECT±Ôzªº»yªk«h´yz¦p¤U¡G
DISCONNECT { CURRENT | ALL | connection-name }
CONNECT RESET
DISCONNECT·|Ãö³¬¥Ø«eªº³sµ²¡A©ÎªÌ¬O©Ò«ü©w¦WºÙ¬Æ©Î¬O©Ò¦³ªº³sµ²¡CDISCONNECT CURRENT©MCONNECT RESET·|Åý¥Ø«eªº³sµ²Ãö³¬¡A·í¥Ø«eªº³sµ²³QÃö³¬°_¨Ó«á¡A¥Ø«e³sµ²ªºÈ·|«O«ùªÅªº¡C¦pªG±zn³]©w¤@Ó·sªº¥Ø«e³sµ²¡A±z¥²¶·¨Ï¥ÎSET CONNECT¨Ó³]©w¡C
ESQLªºÂàĶ¹Lµ{
AcuSQL®¹w¥ý½sĶ¾¹·|¿ëÃѨÃÂàĶESQL±Ôz¨ìCOBOL±Ôz¡C¥¦ÂǥѦbì©l½X¤º§ä´MÃöÁä¦r ¡§EXEC SQL¡¨©M ¡§END-EXEC¡¨ ¨Ó¿ëÃÑESQL¡A·í¥¦µo²{¨ì³o¨Ç°O¸¹¡A¥¦·|¨Ï¥Îµù°O©M¦æ¸¹±N¨ä¥]°_¨Ó¡A±µµÛåªR¨Ã¥B²£¥ÍCOBOLµ{¦¡½X¡A¨ä¤¤¥]§t¹ïAcuSQL®µ{¦¡®wªºCALLs¡C¨Ò¦p¡G
¡K <COBOL code>
EXEC SQL
¡K <SQL code>
END-EXEC.
¡K <COBOL code>
±N·|³QÂàĶ¦¨¡G
¡K <COBOL code>
¡K <translated SQL code>
¡K <commented original ESQL code>
**LINE** BEGIN 134
* EXEC SQL
* ¡K <SQL code>
* END-EXEC**LINE** END 139
¡K <COBOL code>
¥X²{¦bµù¸Ñ¦æ¤¤ªº¦æ¸¹¬O«ü¥Ü¦b¿é¤JÀɤ¤ì¨Óªº¦æ¸¹¡C
¦¨¥\ªº¹w¥ý½sĶ·|²£¥Í¤@ӼȮɪº COBOLì©lÀÉ¡A³oÀÉ®×±µµÛÅýACUCOBOL-GT®½sĶ¥H²£¥Í¤@Ó¥i°õ¦æªº¥ØªºÀÉ¡C¸Ó¼È®ÉÀɦb ¡§-Po¡¨ ³oӿﶵ¦³«ü©w®É·|³QÀx¦s°_¨Ó¡C
±Ò°Ê¹w¥ý½sĶ¾¹¥\¯à
±z¥i¥H±q ACUCOBOL-GT®©R¥O¦C¦ñÀHµÛ¤U¦Cªº½sĶ¾¹¶}Ãö¨Ó±Ò°Ê¹w¥ý½sĶ¾¹ªº¥\¯à¡G
-Pn
|
Åý ACUCOBOL-GT
®¶È¹w¥ý½sĶ³Q«ü¦WªºÀɮסC¹w¥ý½sĶ¦¨¥\®É·|²£¥Í¤@Ó¹L´ç COBOL ÀÉ¡A¨ä¹w³]ÀɦW¬° ¡§ input-file-name.asq ¡¨ ¡C
|
-Ps
|
Åý ACUCOBOL-GT
®¹w¥ý½sĶ©M½sĶ©Ò«ü©wªº¨Ó·½ÀɮסC |
¦Ó¤U¦Cªº½sĶ¾¹¶}Ãö·|¼vÅT¹w¥ý½sĶ¾¹ªº®Ä¯à¡G
-Pr
|
«ü¥Ü¹w¥ý½sĶ¾¹°õ¦æ¸û¼eÃPªº»yªkÀˬd¡C ¡§ -Pr ¡¨ ¬O³]pµ¹¦b¤º´O¦¡ SQL »yªk¨Ã¨S¦³¿í´` IBM SQL ©Î SQL 92 ¡A¦ý¹ï±z©Òn¦s¨úªº¸ê®Æ®w¦Ó¨¥¬O¥¿½TµL»~ªº®ÉÔ¡C
¡§-Pr ¡¨ ¨Ã¤£¹ï¤U¦Cªº±Ôz°õ¦æ»yªkªºÀˬd¡G
SELECT INTO FROM
VALUES
DELETE
INSERT
DECLARE CURSOR FOR SELECT
UPDATE
nª`·Nªº¬O ALTER ¡B CREATE ©M GRANT ±Ôzªº»yªk¦b¥ô¦ó¼Ò¦¡³£¤£Àˬd¡C |
-Pk rlist
|
«ü¥Ü¹w¥ý½sĶ¾¹¨Ï¥Î¨Æ¥ý³]p¹Lªº«O¯d¦r²Õ¦X¡C rlist ¥i¯à¬O ¡§ DB2 ¡¨ ( ¨Ï¥Î DB2 ¦r²Õ ) ¡A©ÎªÌ¬O ¡§ EXT ¡¨ ¨Ó¨Ï¥ÎÂX¥Rªº«O¯d¦r²Õ¡C EXT ¬O¹w³]È¡C
|
-Pi dir
|
«ü©w¹w¥ý½sĶ¾¹±N§ä´M¦b ESQL INCLUDE ±Ôz¤¤©Ò«ü¦WªºÀɮשҦbªº¸ô®|¡CÄ´¦p ¡§ -Pi c:\SQL\include\ ¡¨ ±N¨Ï¹w¥ý½sĶ¾¹¦b¥Ø¿ý ¡§ c:\SQL\include\ ¡¨ ¤º´M§ä¦b SQL INCLUDE ±Ôz¦³«ü¦WªºÀɮסC±z¤]¥i¥H³z¹L ACUSQL®_INCLUDE ³oÓÀô¹ÒÅܼƨӫü©w·j´M¸ô®|¡C¦pªG³o¨âºØ¤è¦¡³£¦³¨Ï¥Îªº¸Ü¡A±N¥H ¡§ -Pi ¡¨ ªº«ü©w¬°Àu¥ý¡C
|
-Po file-name
|
µ¹¤©¹L´çÀɱz©Ò«ü©wªºÀɮצWºÙ¡C
|
-Pw
|
Åý¹w¥ý½sĶ¾¹¶É¦L¥Ø«eªº«O¯d¦r¦ê¨ì¼Ð·Ç¿é¥X³]³Æ ( ¨Ï¥Î ¡§ -Pk ¡¨ «h¬O³]©w«O¯d¦r¦ê ) ¡A¦¹®É¨S¦³¥ô¦ó¹w¥ý½sĶ©Î½sĶªº°Ê§@³Q°õ¦æ¡Cnª`·N ¡§ -Pw ¡¨ ¤£À³¸Ó»P¨ä¥¦ªº¹w¥ý½sĶ¶}Ãö¤@°_¨Ï¥Î¡C
|
°õ¦æµ{¦¡
¦b±z²Ä¤@¦¸¨Ï¥ÎAcuSQL®¤§«e¡A±zÀ³¸Ó¹ï±z±qWindows¨ì¸ê®Æ¥D¾÷ªº³sµ²³nÅé¶i¦æ´ú¸Õ¡C¦bÀ|¸Õ°õ¦æ±zªºµ{¦¡¤§«e¡A«D±`»Ýn¥Ñ±zÃÒ¹ê±zªº¸ê®Æ®w³sµ²³nÅ骺¥\¯à¥¿½T©Ê¡C
¦b¦¨¥\¦a¹w¥ý½sĶ©M½sĶ¹L«á©Ò²£¥Í¥X¨Óªºµ{¦¡¥Øªº½X¤w·Ç³Æ¦n¥i¥H°¨¤W°õ¦æ¡An°õ¦æ¤@¤äESQLªºµ{¦¡¨Ã¤£»Ýn¯S§Oªº¿ï¶µ©Î²Õºc³]©w¡Cn±qDOS©R¥O¦C±Ò°Êµ{¦¡¡A¥un¿é¤J±zACUCOBOL-GT®ªº°õ¦æ¾¹¦WºÙ(¹w³]¬° ¡§wrun32.exe¡¨ )¡A¨ä«á¸òµÛ¥i°õ¦æµ{¦¡ªºÀɮצWºÙ¡C
¦Ü©ó°õ¦æ¹Lµ{¤§¶¡©Ò¹J¨ìªºSQL¿ù»~°T®§·|³Q¾É¦V¨ì¼Ð·Ç¿ù»~¿é¥X¡A°Ñ¦Ò±zªº
SQL°Ñ¦Ò¤â¥U¥HÀò±o¸ÓSQL¿ù»~°T®§©Ò¥Nªíªº·N¸q¡Cµ{¦¡³]p®v¥i¥H¦b¥L̪ºµ{¦¡¤¤ÂÇ¥ÑÀˬdSQLSTATE©MSQLCODEªºÈ¨ÓÀˬd¿ù»~½X¡C
|