³q¸ô¬ü¬ì§Þ
¤½¥q²¤¶|³Ì·s®ø®§|§Þ³N»PªA°È| ¸Ñ¨M¤è®× | ¸ê°T°Ï | Ápµ¸§Ú­Ì|µ×­^©Û¶Ò|ºô¯¸¾ÉÄý| ¦^­º­¶
¸ê°T°Ï

²£«~·s°T
°V½m½Òµ{
¬¡°Ê&¨ä¥L
§Þ³N½×¾Â
¦¨¥\®×¨Ò


AcuSQL® - ¨ÏCOBOL¥i¤º´OSQL»yªk

µ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±z­n´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°²³]±z­n§ä¥X¦b¬YÀɮפº¬Y¤@µ§°O¿ýªº¬Y­ÓÄæ¦ìªº­È¡A¦pªG¨Ï¥Î¼Ð·ÇCOBOLªºI/O±Ô­z¡A±z±N¥²¶·¶}±ÒÀɮסA³vµ§Åª¨úª½¨ì±z§ä¨ì±z©Ò·Q­nªº°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¨Ó´y­z¨ä¥¦Äæ¦ìªº­È¡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 À³¥Îµ{¦¡°õ¦æ©ó¤U­z¥D¾÷ :

UNIX® /Linux® ¡AWindows® 95/98/ME, Windows NT® , Windows 2000, and Windows XP .

  • ¸ê®Æ¨Ó·½¦ì©ó¤U­z¥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¡¨ ¤º´y­zªº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­±ªºªí®æ´y­z¹ï 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´y­z¹ï 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´y­z¦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´y­z¦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±z­n³]©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°õ¦æ¡C­nª`·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°õ¦æ¡A­n°õ¦æ¤@¤äESQLªºµ{¦¡¨Ã¤£»Ý­n¯S§Oªº¿ï¶µ©Î²Õºc³]©w¡C­n±qDOS©R¥O¦C±Ò°Êµ{¦¡¡A¥u­n¿é¤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