#  d�W Š �nuWbnz‡� dJe`ftgœh¦iÀjÓklLmŒn´öàÃÔèÁµé¹ PL/SQL äÁèä´éà»Ô´ä¿ÅìÍÔ¹¾ØµäÁèä´éà¡Ô´¢éͼԴ¾ÅÒ´ÃéÒÂá碳ÐàµÃÕÂÁ»ÃÐÁÇżŠCÃËÑʼèÒ¹: àª×èÍÁµè͡Ѻ Oracle äÁèä´éà»Ô´ä¿ÅìÅÔʵìäÁèä´éãªé ID ¼ÙéãªéàÁ×èÍ SQLCHECK = FULL à·èÒ¹Ñé¹ Ãкº¨ÐäÁè»ÃÐÁÇżŠID ¼Ùéãªé¹Õ館³äÁèÊÒÁÒöÃÐºØ PARSE = FULL àÁ×èÍ CODE = CPP¡Ó˹´ãËé UNSAFE_NULL=YES ä´é ËÒ¡ MODE=ORACLE áÅÐ DBMS=V7 ËÃ×Í V8ãªé SQLCHECK=NONE äÁèä´é ¡ÓÅѧãªé SYNTAXÃкºäÁèãªé DBMS=V6_CHAR â»Ã´ãªé CHAR_MAP=VARCHAR2 áÅÐ DBMS=V7 á·¹o2pŒqçr$s_t…u±ÒÃкºäÁè»ÃÐÁÇżŵÑÇàÅ×Í¡ CHAR_MAP à¹×èͧ¨Ò¡ãËéãªéä´é੾ÒÐ CHAR_MAP=VARCHAR2 ÊÓËÃѺ DBMS=V6ÃкºäÁè»ÃÐÁÇżŵÑÇàÅ×Í¡ OBJECTS à¹×èͧ¨Ò¡ãËéãªéä´é੾ÒÐ OBJECTS=YES ÊÓËÃѺ DBMS=V6 ËÃ×Í V7ãªé DBMS=V6 äÁèä´é ¡ÓÅѧãªé DBMS=NATIVE áÅÐ CHAR_MAP=VARCHAR2ãªéÍÒÃì¡ÔÇàÁ¹µì MODE=ANSI ¢Í§ºÃ÷Ѵ¤ÓÊÑ觡Ѻ DBMS=V6 äÁèä´éà»Ô´ä¿ÅìàÍÒµì¾Øµà¾×èÍà¢Õ¹¢éÍÁÙÅäÁèä´é¤Ø³µéͧÃкØÊèǹ¢ÂÒÂä¿Åìâ´ÂãªéµÑÇàÅ×Í¡ HEADERàÅÔ¡ãªé¡ÒõÃǨÊͺÀÒÉÒâ´Â TimesTen LPM€N«OÇPæQR#SBTcU„V¤W»àãªé¡ÒáÓ˹´ÃٻẺ¡ÒäǺ¤ØÁ¡ÒÃàÃÔèÁµé¹ãËÁè¢Í§ ASAãªé¡ÒÃàª×èÍÁµèÍÍѵâ¹ÁѵÔä»ÂѧºÑ­ªÕ ops$ ä´é¡ÒÃáÁ»ÍÒàÃÂìáÅÐʵÃÔ§µÑÇÍÑ¡ÉûԴà¤ÍÃìà«ÍÃì·Ñé§ËÁ´·Õè¨Ð¤ÍÁÁÔµ¤èÒ CMAX ÊÓËÃѺ¾ÙÅ¡ÒÃàª×èÍÁµèͤèÒ CMIN ÊÓËÃѺ¾ÙÅ¡ÒÃàª×èÍÁµèͤèÒ CINCR ÊÓËÃѺ¾ÙÅ¡ÒÃàª×èÍÁµèͤèÒ TIMEOUT ÊÓËÃѺ¾ÙÅ¡ÒÃàª×èÍÁµèͤèÒ CNOWAIT ÊÓËÃѺ¾ÙÅ¡ÒÃàª×èÍÁµè;ÒÃì«â´Âãªé Common SQL Front End»ÃÐàÀ·¢Í§ÃËÑÊ·Õè¨ÐÊÃéÒ§»ÃÐàÀ·ªØ´ÍÑ¡¢ÃзÕè¤ÍÁä¾àÅÍÃì C ãªéä´é XJYtZŒ[µ\Û]û^&_E`ea•bÇòá·¹·Õèä¿Åì¤Í¹¿Ôà¡Íàêѹ¢Í§Ãкº´éÇÂä¿ÅìÍ×è¹ãªé¡ÒþÙÅ¡ÒÃàª×èÍÁµèÍä´éá¡é䢤ӵèÍ·éÒª×èÍä¿Åì C++ ·Õèà»ç¹´Õ¿ÍŵìÃͧÃѺÃٻẺ¤ÓÊÑè§á·Ã¡/àÅ×Í¡ÍÒàÃÂì DB2âËÁ´·Õè·Ó§Ò¹ÃèÇÁ¡Ñº v6/v7/v8 ä´éÊÃéÒ§ÁÒâ¤Ã '#define SQLCODE sqlca.sqlcode' ¡Ó˹´ÊÑ­Åѡɳì¢Í§¾ÃÕâ»Ãâ«Êà«ÍÃì¡Ó˹´ªèǧàÇÅÒ¾Ô¹¢Í§Íͺਡµìã¹á¤ªÃкؤÇÒÁËÁÒ SQL Ẻ䴹ÒÁÔ¤à»ç¹ Oracle ËÃ×Í ANSIÃкºÊè§¢éͤÇÒÁáÊ´§¢éͼԴ¾ÅÒ´ä»·Õèà·ÍÃìÁÔ¹ÑÅËÃ×ÍäÁèª×èÍä¿ÅìÅÔʵìÊÓËÃѺ¢éͼԴ¾ÅÒ´¢Í§ä¿Åì intype cPdwe¨fÙgh*i8jQknlŠmÂnâýÃͧÃѺ¡ÒÃá¨é§ÍÕàǹµì¡ÒÃà¼Âá¾Ãè-¡ÒÃÊÁѤáÒÃá¿Å¡ FIPS ¢Í§¡ÒÃãªéÃÒ¡Ò÷Õèãªé¡Ñº ANSI äÁèä´éÃкØÊèǹ¢ÂÒÂä¿Åì¢Í§ÊèǹËÑÇ·ÕèàµÃÕÂÁ¡ÒäÍÁä¾ÅìáÅéÇÃЧѺ¡ÒäǺ¤ØÁ¢Í§à¤ÍÃìà«ÍÃìã¹á¤ªà¤ÍÃìà«ÍÃ쾺¨Ø´·ÕèºÑ¹·Ö¡¡è͹¡ÒÃá·Ã¡·ÕèãªéºÑ¿à¿ÍÃìª×èÍä¿ÅìÍÔ¹¾Øµ¾Ò¸ä´àä·ÍÃբͧä¿Åì·ÕèÃÇÁª×èÍä¿ÅìÍÔ¹¾Øµ¢Í§¢éÍÁÙÅ»ÃÐàÀ·¤ÇÒÁÂÒÇàä¤ÍÃ촢ͧä¿ÅìÍÔ¹¾Øµà¾ÔèÁ¤ÓÊÑè§ä´àä·Õ¿¢Í§àÅ¢·ÕèºÃ÷ѴãËé¡ÑºÃËÑÊ·ÕèÊÃéÒ§¢Öé¹á¡é䢪×èÍä¿ÅìÅÔʵì·Õèà»ç¹´Õ¿Íŵì¤ÇÒÁÂÒÇàä¤ÍÃ촢ͧä¿ÅìÅÔʵì oPpnq�rÃsít u%vBw{x�yŸz±Ϩӹǹ¢éÍÁÙÅ·ÕèÊÃéÒ§ã¹ä¿ÅìÅÔʵì¤ÇÒÁÂÒÇÊÙ§ÊØ´ÊÓËÃѺÅÔà·ÍÃÑŢͧʵÃÔ§·ÕèÊÃéÒ§¢Ö鹨ӹǹà¤ÍÃìà«ÍÃìẺà»Ô´·Õèà¡çºäÇéÊÙ§ÊØ´¨Ó¹Ç¹á¶ÇÊÙ§ÊØ´·Õè¨ÐãªéºÑ¿à¿ÍÃì㹤ÓÊÑè§á·Ã¡¡ÒÃãªéÃËÑʵÒÁ¡® ANSI ËÃ×Í OracleÃͧÃѺâ¿Å·/´ÑºàºÔÅã¹ÃкºÃкصÑÇá»ÃÍÑ¡¢ÃÐÀÒÉÒ»ÃШӪҵԤǺ¤ØÁÇèҨдÓà¹Ô¹¡ÒáѺÅѡɳзҧÀÒÉҢͧÍÑ¡¢ÃÐ NLS ÍÂèÒ§äÃÃͧÃѺ»ÃÐàÀ·Íͺਡµìª×èÍä¿ÅìàÍÒµì¾Øµ¤Çº¤ØÁ¡ÒÃãªé ORACA¤ÇÒÁÂÒÇàä¤ÍÃ촢ͧä¿ÅìàÍÒµì¾Ø· {V|‰}¡~·à€�6‚Yƒx„™…©†Æ‡àóª¹Ô´·ÕèÁÕ¡ÒÃÊÃéÒ§àÍÒµìäŹì [yes/no/]¤Ó¹Ó˹éҢͧª×èÍàÍÒµìäŹì¤ÇÒÁÂÒÇྨ¢Í§ä¿ÅìÅÔʵì¤Çº¤ØÁÇèҨоÒÃì«ÃËÑÊ·ÕèäÁèãªè SQL ËÃ×ÍäÁè¨Ó¹Ç¹á¶Ç·Õè´Ö§¢éÍÁÙÅäÇé¡è͹àÁ×èÍà»Ô´à¤ÍÃìà«ÍÃì¤Çº¤ØÁ¡ÒÃÃÕÅÕÊà¤ÍÃìà«ÍÃì¨Ò¡á¤ªà¤ÍÃìà«ÍÃì¶éÒãªè ÊÃéÒ§àÍÒµìäŹìã¹°Ò¹¢éÍÁÙŹÕé¤Çº¤ØÁ¡ÒÃá¿Å¡¢éͼԴ¾ÅÒ´·ÕèàÅ×Í¡¨Ó¹Ç¹¡ÒõÃǨÊͺ SQL ã¹àÇÅÒ¤ÍÁä¾Å좹Ҵᤪ¢Í§¤ÓÊÑè§ä´àä·ÍÃÕ·Õ辺ä¿ÅìÊèǹËÑÇÃкºÊÓÃͧà¾×èÍãªéÀÒÂã¹à·èÒ¹Ñé¹ÃкءÒÃãªéÁÑŵÔà¸Ã´ ˆ>‰oŠ˜‹ÃŒå�Ž-�H�{{ãªéÃËÑÊ»ÃÐàÀ· Oracle ËÃ×Í ANSI ¡Ñº SQL Ẻ䴹ÒÁÔ¤ãªé¡Òô֧¤èÒ NULL â´ÂäÁèÁÕµÑÇá»Ãºè§ªÕéä´éʵÃÔ§àª×èÍÁµèͪ×èͼÙéãªé/ÃËÑʼèÒ¹ [@dbname]ÃٻẺªØ´ÍÑ¡¢ÃзÕèµÑÇá»Ã UTF16 ãªéãªéâ¤Ã§ÊÃéÒ§ Varchar ·Õèá¹è¹Í¹ä´éàÇÍÃìªÑ¹¢Í§Íͺਡµì·Õè¨ÐáÊ´§à»ç¹¼ÅÅѾ¸ìÃÇÁ¢éÍÁÙÅÍéÒ§ÍÔ§ã¹ä¿ÅìÅÔʵìãªé¡Ñº¡ÒÃà¸Ã´ã¹Ãкº·Õèà»ç¹´Õ¿Íŵì¢Í§ÇÔ¹â´ÇÊìä´é \r ÿÿÿÿ