#  ! š2ï   )3>FP[cmw…�íöéë:KYg|Š•mx‡“� 8J‚¹îX £Úà»Ô´ä¿Åì %s äÁèä´éÃٻẺ¤ÓÊÑè§·Õè¤ÍÅÑÁ¹ì %u ºÃ÷Ѵ %u ã¹ä¿Åì %s äÁè¶Ù¡µéͧID ¢Í§ SQL ·Õè¤ÍÅÑÁ¹ì %u ºÃ÷Ѵ %u ã¹ä¿Åì %s äÁè¶Ù¡µéͧºÅçͤ IF/ELSE/ENDIF ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁè¶Ù¡µéͧãªé»ÃÐàÀ·¢éÍÁÙÅ㹺Ã÷Ѵ %u ¢Í§ä¿Åì %s äÁèä´éà§×èÍ¹ä¢ WHENEVER ·Õè¤ÍÅÑÁ¹ì %u ºÃ÷Ѵ %u ã¹ä¿Åì %s äÁè¶Ù¡µéͧ¡ÒôÓà¹Ô¹¡ÒõÒÁ¤ÓÊÑè§ WHENEVER ·Õè¤ÍÅÑÁ¹ì %u ºÃ÷Ѵ %u ã¹ä¿Åì %s äÁè¶Ù¡µéͧµÑÇá»ÃâÎʵì·Õè¤ÍÅÑÁ¹ì %u ºÃ÷Ѵ %u ã¹ä¿Åì %s äÁè¶Ù¡µéͧ > a � »ò!i”¼ñ¤ÓÊÑè§äÁèÍÂÙè·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %sÍÂÙèã¹Êèǹ¡ÒûÃСÒÈ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s áÅéÇäÁèÍÂÙèã¹Êèǹ¡ÒûÃСÒÈ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %sà»Ô´ä¿ÅìÊÓËÃѺ¡ÒÃÃÇÁ "%s" ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁèä´éäÁèä´é»ÃСÒÈ ID SQL "%s" ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %säÁèÃѺÃÙéÃٻẺ¤ÓÊÑè§ÀÒÉҢͧâÎʵì·ÕèäÁè»ÃÐÁÇżÅäÇé·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %sà»Ô´à¤ÍÃìà«ÍÃì·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁèä´é¾ÒÃ쫤ÓÊÑè§·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁèä´éµéͧ¡Òà "%s" áµè¾º "%.15s" ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s á·¹ >d�§Úò8l¡ÓÃѺµÑÇá»Ã·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁèä´éÃѺµÑÇá»Ã¡Ó˹´·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁèä´é¢éͼԴ¾ÅÒ´¢Í§ Oracle: %säÁèÁÕ¾×é¹·ÕèÇèÒ§ - ¨Ñ´ÊÃþ×é¹·Õè¨Ó¹Ç¹ %u 亵ìäÁèä´éÅçÍ¡ÍÍ¡¨Ò¡ ORACLE äÁèä´éµÑÇá»Ãºè§ªÕé "%s" ÁÕ»ÃÐàÀ·ËÃ×ͤÇÒÁÂÒÇ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁè¶Ù¡µéͧäÁèä´é»ÃСÒȵÑÇá»Ãºè§ªÕé "%s" ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %sµÑÇá»Ã¢Í§âÎʵì "%s" ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁè¶Ù¡µéͧÁÕ¡ÒûÃСÒÈ ID SQL "%s" ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s «éÓ Jy� ¶!Î$ñ% &O'c(})–²µÑÇàÅ×Í¡ "%s" ãªé¡ÑºµÑÇàÅ×Í¡ EXEC ORACLE äÁèä´éµÑÇàÅ×Í¡ "%s" äÁèªÑ´à¨¹¤èÒ·Õè¡Ó˹´ãËéµÑÇàÅ×Í¡ "%s" äÁè¶Ù¡µéͧµÑÇàÅ×Í¡ "%s" äÁè¶Ù¡µéͧäÁèÁÕà¤Ã×èͧËÁÒÂÊÓËÃѺµÑÇàÅ×Í¡ "%s"äÁèä´éÃкت×èÍä¿ÅìÍÔ¹¾ØµÅçÍ¡Í͹à¢éÒÊÙè ORACLE ´éÇ "%s" äÁèä´é àÅ¢·Õè¢éͼԴ¾ÅÒ´¢Í§ ORACLE: %uà»Ô´à¤ÍÃìà«ÍÃìäÁèä´éà»Ô´ä¿ÅìÍÔ¹¾Øµ "%s" äÁèä´éà»Ô´ä¿ÅìÅÔʵì "%s" äÁèä´éà»Ô´ä¿ÅìàÍÒµì¾Øµ "%s" äÁèä´é*,,y-·/û2A3‡Àµéͧãªé EXEC SQL INCLUDE SQLCA àÁ×èÍâËÁ´=ANSI áÅÐÁÕ¡ÒÃãªé WHENEVER SQLWARNING¢¹Ò´ÍÒàÃÂìã¹ÇÅÕ INTO/USING äÁèµÃ§¡Ñ¹ ¢¹Ò´µèÓÊØ´¤×Í: %s(%u:%u)Êèǹ¢Í§¤ÓÊÑè§ %s äÁè¤ÇÃÍÂÙè·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s Ãкº¨ÐäÁè»ÃÐÁÇżŤÇÒÁàËç¹/¤èÒ¤§·Õè¢Í§ÊµÃÔ§·ÕèàÃÔèÁã¡ÅéºÃ÷Ѵ %u ã¹ä¿Åì %s ÂѧäÁèÊÔé¹ÊØ´ÊÃéÒ§ Descriptor ã¹Ë¹èÇÂâ»Ãá¡ÃÁ·ÕèÊÔé¹ÊØ´·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁèä´é¢¹Ò´ %s ¢Í§ VARCHAR ãË­è¡ÇèÒ 65533 㹺Ã÷Ѵ %u ¢Í§ä¿Åì %s526p7¯8ï<1=q>¢ß%s ¢Í§µÑÇá»Ã FOR à»ç¹»ÃÐàÀ··ÕèäÁè¶Ù¡µéͧ㹺Ã÷Ѵ %u ¢Í§ä¿Åì %säÁ辺µÑÇÊÔé¹ÊØ´¤ÓÊÑè§·Õè¤Ò´äÇé·Õè¤ÍÅÑÁ¹ì %u ºÃ÷Ѵ %u ã¹ä¿Åì %s¡Ó˹´ãËéÍÒàÃÂì "%s" à»ç¹µÑÇá»Ã亹´ì·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁèä´éãªéÊèǹ¢Í§¤ÓÊÑè§ FOR 㹤ÓÊÑè§ SELECT ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁèä´é·Ñé§à¤ÍÃìà«ÍÃìáÅФÓÊÑè§ÁÕÊèǹ¢Í§¤ÓÊÑè§ AT ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %sà¡Ô´¢éͼԴ¾ÅÒ´·ÕèºÃ÷Ѵ %u ¤ÍÅÑÁ¹ì %u PLS-%u: %sµéͧãªéµÑÇàÅ×Í¡ SQLCHECK=SEMANTICS(FULL) àÁ×èÍÁÕ PL/SQL ÀÒÂã¹?8@oA¬BÏCDHEvF·òà¢éÒ¶Ö§¨Ø´ÊÔé¹ÊØ´ä¿Åì %s ¡è͹ÊÔé¹ÊØ´¤ÓÊÑè§·ÕèºÃ÷Ѵ %u!¡ÒÃãªéµÑÇá»ÃâÎʵì·ÕèÃкطء¤ÃÑ駨еéͧãªéµÑÇá»Ãºè§ªÕéà´ÕÂǡѹµéͧÁÕ ID ¼ÙéãªéáµèÂѧäÁèä´éÃкØäÇéãªé ID ¼ÙéãªéàÁ×èÍ SQLCHECK = FULL à·èÒ¹Ñé¹ Ãкº¨ÐäÁè»ÃÐÁÇżŠID ¼Ùéãªé¹Õé¡Ô¹ Ireclen ÁÕ¡ÒõѴ¤Ó·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %sµÑÇá»ÃâÎʵìáÅеÑÇá»Ãºè§ªÕéÁÕª×èÍà´ÕÂǡѹäÁèä´éµÑÇá»ÃâÎʵì "%s" ÁÕ»ÃÐàÀ·¢éÍÁÙÅ·ÕèãªéäÁèä´é㹺Ã÷Ѵ %u ¢Í§ä¿Åì %sÃٻẺ¤ÓÊÑè§äÁè¶Ù¡µéͧ ¤èÒàÍç¡«ìâ»à¹¹àªÕÂÅ㹤ÓÊÑè§ SQL: %s G>HSIyKËLêMNcO‰PÁãà»Ô´ä¿Åì¢éͤÇÒÁäÁèä´é¤ÇÒÁÂÒǪ×èÍÍÔ¹¾Øµà¡Ô¹¡ÇèÒ¤ÇÒÁÂÒÇÊÙ§ÊØ´ÁÕ¡ÒûÃСÒÈà¤ÍÃìà«ÍÃìäÇéáÅéÇ áµèÂѧäÁèÊÒÁÒöãªé¤ÓÊÑè§ OPEN ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %sµéͧÁÕ ":" ÍÂÙè¡è͹µÑÇá»Ãºè§ªÕé»ÃÐàÀ· DISPLAY µéͧà»ç¹ SIGN LEADING SEPARATE¡ÒÃãªéà¤Ã×èͧËÁÒÂâ¤Å͹¾ÃéÍÁ´éÇ»éÒ¡ӡѺµÑÇàÅ¢·Õè¤ÓÊÑè§ WHENEVER äÁèãªè ANSI¤Óàµ×͹ FIPS: ID ANSI SQL äÁè¶Ù¡µéͧANSI µéͧÁÕà¤Ã×èͧËÁÒÂâ¤Å͹·Õè»éÒ¡ӡѺ㹤ÓÊÑè§ WHENEVERÁÕ¡ÒÃãªé TYPE ¡Ñº ID ¢Í§ TYPE áÅéÇ QDRoS–UÈVïWX;YYZ|[±îãªé¢éÍ¡Ó˹´Êà¡Å¡Ñº»ÃÐàÀ·¢éÍÁÙÅ·ÕèÃкØäÁèä´é¢éÍ¡Ó˹´¤ÇÒÁÂÒÇáÅÐÊà¡Åµéͧà»ç¹¨Ó¹Ç¹àµçÁãªéµÑÇá»Ã亹´ìáÅеÑÇá»Ã¡Ó˹´ã¹¤ÓÊÑè§ CREATE äÁèä´éà¡Ô´¢éͼԴ¾ÅҴ㹡ÒÃà¢Õ¹¢éÍÁÙÅŧä¿Åì %sä¿Åì·ÕèÁÒ %s ÁÕ¤ÇÒÁÂÒÇà»ç¹ÈÙ¹Âìãªé¤ÓÊÑè§ EXEC SQL TYPE ¡ÑºÀÒÉÒâÎʵì¹ÕéäÁèä´éµéͧÁÕ ID »ÃÐàÀ··Õè¼Ùéãªé¡Ó˹´¢éÍ¡Ó˹´ TYPE ¢Í§ Oracle äÁè¶Ù¡µéͧµéͧÃкآéÍ¡Ó˹´·È¹ÔÂÁ/Êà¡ÅãËé¡Ñº¢éÍÁÙÅ»ÃÐàÀ· DECIMAL¤ÓÊÑè§ TYPE µéͧ¡ÒâéÍ¡Ó˹´ÃٻẺÊÓËÃѺ»ÃÐàÀ·¢éÍÁÙŢͧ Oracle\8]x^±_ß`aIb…c¨áãªé¤ÇÒÁÂÒÇáÅÐ/ËÃ×ÍÊà¡Å¡Ñº»ÃÐàÀ·¢éÍÁÙŢͧ Oracle ·ÕèÃкØãËéäÁèä´éµÑÇàÅ×Í¡äÁè¶Ù¡µéͧËÃ×Íà»ç¹àÇÍÃìªÑ¹à¡èÒ Ãкº¨ÐäÁè»ÃÐÁÇżŤÇÒÁÂÒÇÍÒàÃÂì¢Í§»ÃÐàÀ·¢éÍÁÙÅ char[n] µéͧ >= 2äÁèÁÕ¤ÓÊÑè§ PROGRAM, SUBROUTINE, FUNCTION ËÃ×Í BLOCK DATAãªé¤ÓÊÑè§ FETCH ¢Í§ÍÒàÃÂìàÁ×èÍ mode=ANSI14 äÁèä´éãªé»ÃÐàÀ· DECIMAL áÅÐ DISPLAY ¡Ñº COBOL áÅÐ PL/I ä´éà·èÒ¹Ñé¹ãªé¢éÍ¡Ó˹´Êà¡Å㹤͹à·ç¡«ì¹ÕéäÁèä´é¡Ó˹´¤ÇÒÁÂÒÇãËé¡Ñº»ÃÐàÀ· ROWID, DATE ËÃ×Í MLSLABEL äÁèä´é dDejf”gµhÜij(kgl˜m³ï»éÒ¡ӡѺ·ÕèäÁèãªè¨Ó¹Ç¹àµçÁäÁèãªè ANSIµÑǾÔÁ¾ìàÅç¡ 'e' ã¹µÑÇàÅ¢·È¹ÔÂÁäÁèãªè ANSIFOR UPDATE à»ç¹Êèǹ¢ÂÒ¢ͧ OracleÊèǹ¢Í§¤ÓÊÑè§ AT à»ç¹Êèǹ¢ÂÒ¢ͧ OracleÊèǹ¢Í§¤ÓÊÑè§ FOR à»ç¹Êèǹ¢ÂÒ¢ͧ OracleµéͧÁÕ¤ÓËÅÑ¡ WORK ÊÓËÃѺ ANSI ·Õè¹ÕèRELEASE à»ç¹Êèǹ¢ÂÒ¢ͧ Oracle ÊÓËÃѺ¤ÓÊÑè§ COMMIT áÅÐ ROLLBACK¤ÓÊÑè§ CONNECT ¢Öé¹ÍÂÙè¡Ñº¡ÒÃãªé§Ò¹Ãкº¢Í§ Oracleãªé¤ÓÊÑè§¹Õé¡Ñº ANSI äÁèä´éPL/SQL áÅÐ SQL ä´¹ÒÁÔ¤à»ç¹Êèǹ¢ÂÒ¢ͧ Oracle ÊÓËÃѺ ANSI SQL nDolp¤qÂrús8tJukv’w¾ñÊèǹ¢ÂÒ¢ͧ Oracle ÊÓËÃѺ¤ÓÊÑè§ WHENEVER¤èÒ SQLCHECK 㹤ÓÊÑè§ EXEC ORACLE ÁÒ¡¡ÇèÒ¤èÒºÃ÷Ѵ¤ÓÊÑè§»ÃÐàÀ·¢éÍÁÙÅãªé¡Ñº ANSI äÁèä´é¤èÒµÑÇàÅ×Í¡ DBMS ãªé¡Ñº¤èÒµÑÇàÅ×Í¡ MODE ·ÕèÃкØãËéäÁèä´éµéͧÁÕ¢éÍ¡Ó˹´¤ÇÒÁÂÒÇ㹤ÓÊÑè§ EXEC SQL VAR ÊÓËÃѺ»ÃÐàÀ· VARxxxµéͧÁÕÍÒàÃÂì·Õè¹ÕèÁÕÍÒàÃÂì¹Õé㹤ÓÊÑè§ ARRAYLEN áÅéÇ»ÃÐàÀ·µÑÇá»Ã¤ÇÒÁÂÒÇ ARRAYLEN äÁè¶Ù¡µéͧãªé¡ÒÃàÃÔèÁµé¹µÑÇá»ÃâÎʵì¡Ñº ANSI SQL äÁèä´é¤èҢͧµÑÇá»Ã¤èÒ¤§·Õèã¹Êèǹ¢Í§¤ÓÊÑè§ INTO ¨Ð¶Ù¡á¡éä¢ xJypz“{µ|æ~A€C�r„‡…ºõà¡Ô´¢éͼԴ¾ÅÒ´¡Ñºä¿Åì I/O ¢³ÐÊÃéÒ§ÃËÑÊãªéÍÒàÃÂì¢Í§¾ÍÂàµÍÃì VARCHAR äÁèä´éª×èÍä¿ÅìÍÔ¹¾ØµáÅÐàÍÒµì¾ØµàËÁ×͹¡Ñ¹¡ÒûÃСÒÈ VARCHAR ·Ñé§ËÁ´µéͧÍÂÙè㹺Ã÷Ѵà´ÕÂǡѹÃкصÑÇàÅ×Í¡ COMMON_NAME äÇé·ÕèµÓá˹è§ËÅѧà¡Ô¹ä»äÁ辺ËÃ×Íà»Ô´ä¿Åì¤Í¹¿Ôà¡Íàêѹ¢Í§ÃкºäÁèä´é%sà¡Ô´¢éͼԴ¾ÅÒ´ÃéÒÂáç¡Ñºâ»Ãà«Êà«ÍÃìºÃ÷Ѵ¤ÓÊÑè§µéͧÃкصÑÇàÅ×Í¡ "%s"¢¹Ò´ÍÒàÃÂì¢Í§µÑǺ觪ÕéµéͧäÁè¹éÍ¡ÇèҢͧµÑÇá»ÃâÎʵìµÑÇàÅ×Í¡ºÃ÷Ѵ¤ÓÊÑè§ MODE=ANSI µéͧÁÕµÑÇàÅ×Í¡ NLS_LOCAL=YES ‡>ˆj‰‰Š¶‹èŒ�YŽ—�·â¡ÒÃãªéà¤ÍÃìà«ÍÃìªØ´¼ÅÅѾ¸ìäÁèãªè SQL Áҵðҹ¡ÒûÃСÒÈ SQL_CURSOR äÁè¶Ù¡µéͧ¡ÒÃãªéµÑÇá»ÃâÎʵì¢Í§à¤ÍÃìà«ÍÃì SQL äÁè¶Ù¡µéͧà¤ÍÃìà«ÍÃìªØ´¼ÅÅѾ¸ìäÁèä´éãªé§Ò¹ã¹¾ÃÕ¤ÍÁä¾àÅÍÃì¹Õéà»ÅÕè¹ MAXLITERAL ËÅѧ¤ÓÊÑè§ EXEC ¢Í§ SQL äÁèä´éCREATE FUNCTION/PROCEDURE/PACKAGE/TRIGGER à»ç¹Êèǹ¢ÂÒ¢ͧ Oracle¤Ø³ÊÁºÑµÔ¡ÒÃÃÑ¡ÉÒ¤ÇÒÁ»ÅÍ´ÀÑ¢ͧà¸Ã´äÁèãªé§Ò¹ã¹¾ÃÕ¤ÍÁä¾àÅÍÃì¹ÕéäÁ辺¤ÓÊÑè§ EXEC SQL CONTEXT USEµÑÇá»Ã¤Í¹à·ç¡«ìÃѹä·ÁìÁÕ»ÃÐàÀ··ÕèäÁè¶Ù¡µéͧ �D‘v’Ÿ“Ìèøéê7ëxì¨íÇßUNSAFE_NULL=YES µéͧãªé¡Ñº DBMS=V7 áÅÐ MODE=ORACLE¤ÓÊÑè§¹Õéãªéä´éàÁ×èÍ THREADS=YES à·èÒ¹Ñ鹤èÒµÑÇàÅ×Í¡âÎʵìäÁè¶Ù¡µéͧ Ãкº¨ÐäÁè»ÃÐÁÇżÅãªé DBMS=V6 äÁèä´é ¡ÓÅѧãªé DBMS=NATIVE á·¹¤Ø³äÁèÁÕÊÔ·¸ÔìÃѹ Pro*COBOLÊÔ·¸Ôì㹡ÒÃãªé Pro*COBOL ã¡ÅéËÁ´ÍÒÂØµÑÇÍÑ¡Éà "%c" ã¹¾×é¹·ÕèµÑǺ觪Õé·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁè¶Ù¡µéͧºÃ÷ѴµèÍà¹×èͧ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁè¶Ù¡µéͧ㹤ÓÊÑè§ EXEC ·Õè¨Ø´ÊÔé¹ÊØ´ä¿ÅìäÁ辺 PROCEDURE DIVISION î>ïxð•ñÄòó/ôqõ„öÀó¤ÓÊÑè§ EXEC àÃÔèÁµé¹ã¹¾×é¹·Õè A ºÃ÷Ѵ %u ã¹ä¿Åì %s äÁèä´éäÁ辺 WORKING-STORAGE SECTIONãªéàä¤ÍÃì´ËÅÒÂÍÕÅÔàÁ¹µìã¹ËÑÇ¢éÍ DECLARE äÁèä´éÊÓËÃѺ hostlan = COB74 ¤ÓÊÑè§ SQL µéͧµÒÁ´éÇ ELSE ËÃ×Í "."ÍÑ¡¢ÃзÕèà»ç¹¹ÑÅã¹ÅÔà·ÍÃÑŢͧµÑÇÍÑ¡ÉÃäÁè¶Ù¡µéͧÊèǹ¢Í§¤ÓÊÑè§ USAGE IS BINARY µéͧÊÔé¹ÊØ´´éÇ "." 㹺Ã÷Ѵà´ÕÂǡѹäÁ辺 DATA DIVISIONãªéµÑÇá»ÃÍÒàÃÂì PIC N "%s" ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁè¶Ù¡µéͧãªé "VARYING" ¡ÑºÊèǹ¢Í§¤ÓÊÑè§ PIC N PICTURE äÁèä´é ÷PønùœúÆûýLM:N_°‰± ²Àßùà·Õº¤èÒµÑÇá»Ã PIC N %s äÁèä´éãªéÅÔà·ÍÃÑŢͧÍÑ¡¢ÃÐ "N" ã¹ PL/SQL ÀÒÂã¹äÁèä´éãªé SQLCA áÅеÑÇá»Ã SQLCODE ¾ÃéÍÁ¡Ñ¹äÁèä´é¡Ó˹´¢¹Ò´ºÑ¿à¿ÍÃì¡ÒÃá»Å§¤èÒÊÓËÃѺ»ÃÐàÀ·µÑÇÍÑ¡ÉÃà·èÒ¹Ñé¹¢¹Ò´ºÑ¿à¿ÍÃì¡ÒÃá»Å§¤èÒäÁè¶Ù¡µéͧ¤Ø³äÁèÁÕÊÔ·¸ÔìÃѹ Pro*FORTRANÊÔ·¸Ô㹡ÒÃãªé Pro*FORTRAN ã¡ÅéËÁ´ÍÒÂØ»éÒ¡ӡѺ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s äÁè¶Ù¡µéͧ¤Ø³äÁèÁÕÊÔ·¸ÔìÃѹ Pro*CÊÔ·¸Ôì㹡ÒÃãªé Pro*C ã¡ÅéËÁ´ÍÒÂØID "%s" ¶Ù¡µÑ´àËÅ×Í 31 µÑÇÍÑ¡ÉäسäÁèÁÕÊÔ·¸ÔìÃѹ Pro*PL/I >xay}ܢݻæÝç èOé‘ËÊÔ·¸Ôì㹡ÒÃãªé Pro*PL/I ã¡ÅéËÁ´ÍÒÂØ¤Ø³äÁèÁÕÊÔ·¸ÔìÃѹ Pro*PascalÊÔ·¸Ôì㹡ÒÃãªé Pro*Pascal ã¡ÅéËÁ´ÍÒÂØ¤Ø³äÁèÁÕÊÔ·¸ÔìÃѹ Pro*AdaÊÔ·¸Ôì㹡ÒÃãªé Pro*Ada ã¡ÅéËÁ´ÍÒÂØäÁ辺¤ÓÊÑè§á¾ç¤à¡¨ â»Ã«Õà¨ÍÃìËÃ×Ϳѧ¡ìªÑ¹ã¹ %sID ·ÕèºÃ÷Ѵ %d ã¹ä¿Åì %s ÁÕ¢¹Ò´ÂÒÇà¡Ô¹ä»ÊÓËÃѺÃËÑÊ·ÕèÊÃéÒ§ã¹ä¿Åì %s¾º EXEC SQL INCLUDE ¢Í§ä¿Åì %s ·ÕèäÁè¶Ù¡µéͧ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %s¤Óàµ×͹ FIPS: ãªé»ÃÐàÀ·¢éÍÁÙÅ㹺Ã÷Ѵ %u ¢Í§ä¿Åì %s äÁèä´éë¶Ð÷Ñ÷ÒÓÔ#Õ&Ö)×4Ø8Ù>ÚXÛvÜyÝ|ނ߉à‘á›âœã§ä¹åºæ»ç¿èÈéÎêÔëÜå¤Óàµ×͹ FIPS: äÁèä´é»ÃСÒȵÑÇá»ÃâÎʵì "%s" ·ÕèºÃ÷Ѵ %u ã¹ä¿Åì %sINTO/µÑÇá»Ã亹´ìÊÔé¹ÊØ´¤ÓÊÑè§ SQL:GETPUTBlock.FieldINTOVALUESÊèǹ¢Í§¤ÓÊÑè§ VALUES (...)Êèǹ¢Í§¤ÓÊÑè§ÊÔé¹ÊØ´¢Í§ VALUESSQ0SQLSQLCA SQLCA, &sqlca, ]ÊÔé¹ÊØ´ä¿Åì)(,ANYSTATEMENTCURSORDEFINEDATABASEundefined#ìÚíî ï ðñ2ò3ó<ô?õAöE÷JøOùTúZûbüfýnþoÿ„Œ‘𛤥­ºÀ Ç Ë Ñ Ö âçó0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,FORAT: or string/numeric const&Pro*COBOLyesnolongshortquoteapostansi14terminalnoneOptions:vÊèǹ¢Í§¤ÓÊÑè§ PICTUREEND-EXECTIMESCONTINUE..:IaddressÊÔé¹ÊØ´¤ÓÊÑè§oraclelimitedfullansi13iso13ansi13/iso13iso14ansi14/iso14°¼ÆÈÓØàêñ÷ !"$#-4/5O6ƒ7º8Ð9Ù:âïROLLBACK TO FOR UPDATEISPro*FORTRANPro*CPro*PL/IPro*PascalPro*Adasyntaxsemanticsansiisoansi/isokr_cansi_cv6v7vnativev8ãªéºÅçͤ˹èǤÇÒÁ¨Ó·Õè¨Ñ´ÊÃÃà¡Ô¹¾º¢éͼԴ¾ÅÒ´ÀÒÂã¹ PRO* ¢³Ð¾ÂÒÂÒÁãªé pccfre(%8.x,%u) ¾º¢éͼԴ¾ÅÒ´ÀÒÂã¹ PRO* ¢³Ð¾ÂÒÂÒÁãªé pccrlc(%8.x,%u,%u) µÑÇàÅ×Í¡ºÃ÷Ѵ¤ÓÊÑè§: ¨Ó¹Ç¹àµçÁÊÑ­Åѡɳìhost_language;n<|=ˆ>•?¤@©A¯B·CÏDûE"F@GfHŽIžJÅKçõinput_filenameinclude_pathlist_filenameoutput_filenameAM_ID¼ÙéãªéÃËÑʼèÒ¹¢¹Ò´¾×é¹·Õè¤Í¹à·ç¡«ì (K)¶éÒãªè ãËéãªé¡ÒäǺ¤ØÁ¡ÒÃàÃÔèÁµé¹ãËÁè¢Í§ ASA»éÒ¡ӡѺàÃÔèÁµé¹¢Í§ FORTRAN ·Õè¨ÐÊÃéÒ§¡Ó˹´ÊÑ­Åѡɳìà¾×èÍãªéã¹ IFDEF»éÒ¡ӡѺÊÔé¹ÊØ´¢Í§ FORTRAN ·Õè¨ÐÊÃéÒ§¶éÒãªè Ãкº¨ÐáÊ´§¢éͼԴ¾ÅÒ´·Õèà·ÍÃìÁÔ¹ÑÅÃٻẺä¿ÅìÍÔ¹¾Øµ¶éÒãªè ãËéÃЧѺ OraCursor (äÁèÃкØãËÁè)COBOL, COB74, FORTRAN, Pascal, PLIª×èÍä¿ÅìÍÔ¹¾ØµL\M{N¡O¼PÕQíRST6UQV\WyX¢YÃàª×è;Ҹ¢Í§ä¿Åì EXEC SQL INCLUDE¶éÒãªè ãËéÊÃéÒ§ÃËÑÊ inline (äÁèãªé AM)¤ÇÒÁÂÒÇàä¤ÍÃì´ä¿ÅìàÍÒµì¾Øµ¤ÇÒÁÂÒÇàä¤ÍÃì´ä¿ÅìÍÔ¹¾ØµµÑǤÑè¹ÅÔà·ÍÃÑŢͧ COBOLÃÐÂТͺ´éÒ¹«éÒ (੾ÒÐ PL/I à·èÒ¹Ñé¹)ª×èÍä¿ÅìÅÔʵìÃٻẺàä¤ÍÃì´ä¿ÅìÅÔʵì¤ÇÒÁÂÒÇàä¤ÍÃ촢ͧä¿ÅìÅÔʵì»ÃÐàÀ·ÅÔʵì¤ÇÒÁÂÒÇÊÙ§ÊØ´¢Í§ÊµÃÔ§ÅÔà·ÍÃÑŨӹǹÊÙ§ÊØ´¢Í§ OraCursors ã¹á¤ªà¤ÍÃìà«ÍÃì¶éÒà»ç¹ ansi ãËé·ÓµÒÁÁҵðҹ ANSI (ISO13 ¤×ͪ×èÍá·¹¢Í§ ANSI13)Z\[\ˆ]¢^½_Ó`èab@cad|e¥f¸gËúª×èÍä¿ÅìàÍÒµì¾Øµ (ÃËÑÊ·ÕèÊÃéÒ§¢Öé¹)ãªé ORACAÃٻẺàä¤ÍÃì´ä¿ÅìàÍÒµì¾Øµ¤ÇÒÁÂÒÇàä¤ÍÃì´ä¿ÅìàÍÒµì¾Øµ¤ÇÒÁÂÒÇྨ¢Í§ä¿ÅìÅÔʵìID ¡ÒÃà¢éÒãªé§Ò¹âÁ´ÙŶéÒãªè ãËéàª×èÍÁâ§ãËÁè·Ø¡¤ÃÑé§·Õèãªé¤ÓÊÑè§ FETCH/USING¶éÒãªè ãËéÊÃéÒ§ÃËÑÊ¡ÒÃà¢éÒãªéãËÁè¶éÒãªè ãËéÃÕÅÕÊ OraCursor ËÅѧÃѹÃÐÂТͺ´éÒ¹¢ÇÒ (੾ÒÐ PL/I)¶éÒãªè ãËéÊÃéÒ§¢éͼԴ¾ÅÒ´ FOUND ã¹ SELECTÃдѺ¡ÒõÃǨÊͺ SQLÃдѺ¡ÒõÃǨÊͺ SQLID ¼ÙéãªéáÅÐÃËÑʼèÒ¹·ÕèãªéÅçÍ¡Í͹à¢éÒÊÙè Oracleh†i¯jìkólmno+p0q5rDsit~u›v²wÅxÞyèzó{ö|ùÿ¶éÒãªè ãËéÊÃéÒ§ xref ÊÓËÃѺÊÑ­Åѡɳì PRO* "[*]" áÊ´§¤ÇÒÁ¶Ù¡µéͧ¢Í§µÑÇàÅ×Í¡¹Õéâ´Âãªé EXEC ORACLE OPTIONUNKNOWN¡ÓÅѧ¾ÃÕ¤ÍÁä¾Åì %s ID ¼Ùéãªé: ÃËÑʼèÒ¹: µÑÇàÅ×Í¡»Ñ¨¨ØºÑ¹Ë¹éÒ Ê¶ÔµÔÃËÑʼÅÅѾ¸ì: %u¨Ó¹Ç¹¢éͤÇÒÁ·ÕèÃдѺ¤ÇÒÁÃØ¹áç %c: %u¨Ó¹Ç¹ºÃ÷ѴÍÔ¹¾Øµ: %u¨Ó¹Ç¹µÑÇá»ÃâÎʵì·Õè»ÃСÒÈ: %u¨Ó¹Ç¹ª×èÍà¤ÍÃìà«ÍÃì: %u¨Ó¹Ç¹ª×èͤÓÊÑè§: %u¨Ó¹Ç¹äºµìÊÙ§ÊØ´·Õèãªé: %uID ¢Í§ SQLµÑÇá»ÃâÎʵìRefDefºÃ÷Ѵ}\~^z€±�Ï‚ƒ„…A†`‡sˆ›‰¯Šéã¹ÊÑ­Åѡɳì·Õè¡Ó˹´äÇéÅèǧ˹éÒà¡Ô´¢éͼԴ¾ÅÒ´ÃéÒÂáç㹠PL/SQL ·ÕèÁÕ¤ÓÊÑè§ SQL »Ñ¨¨ØºÑ¹ PRO* ¾º¢éͼԴ¾ÅÒ´ÀÒÂã¹ (%d). â»Ã´µÔ´µèͽèÒºÃÔ¡ÒÃÅÙ¡¤éҢͧ Oracle Corporation Current_of_cursoràÃÕ¡ pc5fty¢éͼԴ¾ÅÒ´ - äÁ辺µÑÇá»Ã亹´ìã¹ÅÔʵì¤ÇÒÁÅéÁàËÅǢͧ¡ÒÃÃÑ¡ÉÒÊÔ·¸Ôì: #¶éÒãªè ãËéá¿Å¡ FIPSºÃ÷Ѵ¤Çº¤ØÁ¤ÍÁä¾àÅÍÃì #line ¢Í§àÍÒµì¾Øµ *¤Ó¹Ó˹éÒª×èÍä¿ÅìÊÓËÃѺª×èͺÅçͤ»¡µÔ·ÕèÊÃéÒ§¢Öé¹ÊÃéÒ§ K&R C ËÃ×Í ANSI C ‹JŒb�•ŽÑ�é� ‘M’p“ޔŕàùâËÁ´¡ÒÃãªé V7/V8 ÃèÇÁ¡Ñ¹¶éÒãªè Ãкº¨ÐãËéãªéâ»Ãá¡ÃÁÂèÍ·ÕèÁÕ SQL µèÍ·ÕèÁÒä´épx: ¶éÒãªè ¤Ø³ÊÒÁÒöàª×èÍÁµèÍä»ÂѧºÑ­ªÕ ops$ ä´éâ´ÂÍѵâ¹ÁѵÔcomp/comp-5 ã¹ Pro*COBOL¶éÒãªè Ãкº¨ÐÂÍÁÃѺÃÒ¡ÒÃã¹¡ÅØèÁ VARCHAR ·Õè¼Ùéãªé¡Ó˹´¶éÒãªè Ãкº¨ÐÂÍÁÃѺ¡ÒûÃСÒȵÑÇá»ÃâÎʵì PIC N¶éÒãªè Ãкº¨Ð¶×ÍÇèÒÁÕµÑÇá»Ã SQLCODE¶éÒãªè ¨ÐÊÒÁÒöãªéÁÑŵÔà¸Ã´ä´é¶éÒãªè ãËéãªé¡Òô֧¢éÍÁÙÅ·Õèà»ç¹¹ÑÅ«Öè§äÁèä´é»éͧ¡Ñ¹äÇéÀÒÉҢͧâÎʵì·Õè¶Ù¡µéͧ: AdaÀÒÉҢͧâÎʵì·Õè¶Ù¡µéͧ: C –J—n˜�™«šÆhûi jLkol«mÐøÀÒÉҢͧâÎʵì·Õè¶Ù¡µéͧ: COBOL, COB74ÀÒÉҢͧâÎʵì·Õè¶Ù¡µéͧ: FORTRANÀÒÉҢͧâÎʵì·Õè¶Ù¡µéͧ: PascalÀÒÉҢͧâÎʵì·Õè¶Ù¡µéͧ: PLI¶éÒà»ç¹¨Ó¹Ç¹àµçÁ comp-1 ¤×Í short áÅÐ comp-2 ¤×Í longãªéã¹ÃÕÅÕʻѨ¨ØºÑ¹áÅÐÃÕÅÕʵèÍä»äÁèä´é¶éÒãªè ãËéãªé¡ÒäǺ¤ØÁ¡ÒÃàÃÔèÁµé¹ãËÁè¢Í§ ASA¶éÒãªè Ãкº¨Ð¶×ÍÇèÒÁÕµÑÇá»Ã SQLCODEpx: ¶éÒãªè ¤Ø³ÊÒÁÒöàª×èÍÁµèÍä»ÂѧºÑ­ªÕ ops$ ä´éâ´ÂÍѵâ¹ÁѵÔãªéã¹ÃÕÅÕʻѨ¨ØºÑ¹áÅÐÃÕÅÕʵèÍä»äÁèä´é¶éÒãªè ãËéÊÃéÒ§ÃËÑÊ ANSI C nJoop¤qÉrôs t&uDviw‘x¤ͤӹÓ˹éÒª×èͺÅçͤ»¡µÔ·ÕèÊÃéÒ§¢Öé¹ [*]¶éÒà»ç¹¨Ó¹Ç¹àµçÁ comp-1 ¤×Í short áÅÐ comp-2 ¤×Í longÊÃéÒ§ comp-5 á·¹·Õè¨ÐÊÃéÒ§µÑÇá»Ã compãªéà¾×èÍÃкØä¿Åì¤Í¹¿Ôà¡Íàêѹ·Õè¼Ùéãªé¡Ó˹´âËÁ´¡ÒÃãªé V7/V8 ÃèÇÁ¡Ñ¹ÊÓÃͧà¾×èÍãªéÀÒÂã¹à·èÒ¹Ñ鹡Ó˹´ÊÑ­Åѡɳìà¾×èÍãªéã¹ IFDEFãªéã¹ÃÕÅÕʻѨ¨ØºÑ¹áÅÐÃÕÅÕʵèÍä»äÁèä´é¶éÒãªè Ãкº¨ÐáÊ´§¢éͼԴ¾ÅÒ´·Õèà·ÍÃìÁÔ¹ÑŶéÒãªè ãËéá¿Å¡ FIPSÃٻẺ¢Í§ºÃ÷Ѵä¿ÅìÍÔ¹¾Øµ ybz‘{�|«}Î~óû€�<‚mƒ|„‰…‘†¬‡Íî¶éÒãªè ãËéÃЧѺ OraCursor (äÁèµéͧÃкØãËÁè) [*]ÀÒÉҢͧâÎʵìª×èÍä¿ÅìÍÔ¹¾Øµª×è;Ҹ¢Í§ä¿Åì EXEC SQL INCLUDE [*]ãªéã¹ÃÕÅÕʻѨ¨ØºÑ¹áÅÐÃÕÅÕʵèÍä»äÁèä´é*irecfm*¤ÇÒÁÂÒÇàä¤ÍÃì´ä¿ÅìÍÔ¹¾ØµºÃ÷Ѵ¤Çº¤ØÁ¤ÍÁä¾àÅÍÃì #line ¢Í§àÍÒµì¾ØµµÑǤÑè¹ÊÓËÃѺÅÔà·ÍÃÑŢͧʵÃÔ§ COBOL ÃÐÂТͺ´éÒ¹«éÒª×èÍä¿ÅìÅÔʵì*lrecfm*¤ÇÒÁÂÒÇàä¤ÍÃ촢ͧä¿ÅìÅÔʵì»ÃÐàÀ·ÅÔʵì [*]¤ÇÒÁÂÒÇÊÙ§ÊØ´¢Í§ÊµÃÔ§ÅÔà·ÍÃÑÅ [*] ˆP‰}ŠÇ‹úŒ'�:Ž]�{�ƒ‘ž’´“Øý¨Ó¹Ç¹ÊÙ§ÊØ´¢Í§ OraCursors ã¹á¤ªà¤ÍÃìà«ÍÃì [*]¶éÒà»ç¹ ansi ãËé·ÓµÒÁÁҵðҹ ANSI ¶éÒãªè Ãкº¨ÐãËéãªéâ»Ãá¡ÃÁÂèÍ·ÕèÁÕ SQL µèÍ·ÕèÁÒä´é¶éÒãªè Ãкº¨ÐÂÍÁÃѺ¡ÒûÃСÒȵÑÇá»ÃâÎʵì PIC NµÑÇàÅ×Í¡ÊÓËÃѺʶҹЪ×èÍä¿ÅìàÍÒµì¾Øµ (ÃËÑÊ·ÕèÊÃéÒ§¢Öé¹)ãªé¾×é¹·Õè¡ÒÃÊ×èÍÊÒà ORACA [*]*orecfm*¤ÇÒÁÂÒÇàä¤ÍÃì´ä¿ÅìàÍÒµì¾Øµ¤ÇÒÁÂÒÇྨ¢Í§ä¿ÅìÅÔʵìáÊ´§àÇÍÃìªÑ¹ PL/SQL ¢Í§¾ÃÕ¤ÍÁä¾àÅÍÃìãªéã¹ÃÕÅÕʻѨ¨ØºÑ¹áÅÐÃÕÅÕʵèÍä»äÁèä´é ”D•i–Ž—³˜Á™îš9›]œw�•Ìãªéã¹ÃÕÅÕʻѨ¨ØºÑ¹áÅÐÃÕÅÕʵèÍä»äÁèä´éãªéã¹ÃÕÅÕʻѨ¨ØºÑ¹áÅÐÃÕÅÕʵèÍä»äÁèä´é¶éÒãªè ãËéÃÕÅÕÊ OraCursor ËÅѧÃѹ [*]ÃÐÂТͺ´éÒ¹¢ÇÒ¶éÒãªè ãËéÊÃéÒ§¢éͼԴ¾ÅÒ´ FOUND ã¹ SELECT [*]ÃдѺ¡ÒõÃǨÊͺ SQL <ÃٻẺ¤ÓÊÑè§ ËÃ×ÍẺ¨Ó¡Ñ´/ÀÒÉÒ ËÃ×ÍẺàµçÁ/äÁèµÃǨÊͺ>¶éÒãªè Ãкº¨ÐʹѺʹع¡Ò÷ӧҹ¢Í§ AdaÊÓÃͧà¾×èÍãªéÀÒÂã¹à·èÒ¹Ñé¹¶éÒãªè ¨ÐÊÒÁÒöãªéÁÑŵÔà¸Ã´ä´é¶éÒãªè ãËéãªé¡Òô֧¢éÍÁÙÅ·Õèà»ç¹¹ÑÅ«Öè§äÁèä´é»éͧ¡Ñ¹äÇ鞟I €©ID ¼ÙéãªéáÅÐÃËÑʼèÒ¹·ÕèãªéÅçÍ¡Í͹à¢éÒÊÙè Oracle¶éÒãªè Ãкº¨ÐÂÍÁÃѺÃÒ¡ÒÃã¹¡ÅØèÁ VARCHAR ·Õè¼Ùéãªé¡Ó˹´¶éÒãªè ãËéÊÃéÒ§¢éÍÁÙÅÍéÒ§ÍÔ§ÊÑ­Åѡɳì [*]ÿÿÿÿ