DB2 v7.2 中的高级 SQL 过程脚本编制

　2008-09-09 16:30:15　来源：WEB开发网　闂傚倸鍊风欢姘缚瑜嶈灋闁圭虎鍠栫粻顖炴煥閻曞倹瀚�

闂傚倸鍊风粈渚€骞夐敓鐘插瀭闁汇垹鐏氬畷鏌ユ煙閹殿喖顣奸柛搴＄У閵囧嫰骞掗幋婵冨亾閻㈢ǹ纾婚柟鐐灱濡插牊绻涢崱妤冃℃繛宀婁簽缁辨捇宕掑鎵佹瀸闂佺懓鍤栭幏锟�

濠电姷鏁告慨顓㈠箯閸愵喖宸濇い鎾寸箘閹规洟姊绘笟鈧ḿ褍煤閵堝悿娲Ω閳轰胶鍔﹀銈嗗笂閼冲爼鍩婇弴銏＄厪闁搞儮鏅涙禒褏绱掓潏鈺佷槐闁轰焦鎹囬弫鎾绘晸閿燂拷闂傚倸鍊风欢姘缚瑜嶈灋闁圭虎鍠栫粻顖炴煥閻曞倹瀚�　　闂傚倸鍊烽懗鑸电仚缂備胶绮〃鍛村煝瀹ュ鍗抽柕蹇曞У閻庮剟姊虹紒妯哄闁诲繑姘ㄩ埀顒佸嚬閸撶喎顫忓ú顏勫瀭妞ゆ洖鎳庨崜浼存⒑闁偛鑻晶顔剧磼婢跺﹦绉虹€殿喖顭锋俊姝岊槷闁稿鎹囧Λ鍐ㄢ槈濞嗗繑娈橀梻浣风串缂嶁偓濞存粠鍓熼崺鈧い鎺戝€归弳顒勬煕鐎ｎ亷韬€规洑鍗冲鍊燁槾闁哄棴绠撻弻銊╂偆閸屾稑顏�

核心提示： 在上面的输出中，成功执行了脚本，DB2 v7.2 中的高级 SQL 过程脚本编制(5)，但我们注意到屏幕输出不同于日志文件（output.log）的输出，用粗体突出显示了这些差别，请注意最后一句由下面 DB2 的 VALUES 语句发出的注释：This will get written t

在上面的输出中，成功执行了脚本，但我们注意到屏幕输出不同于日志文件（output.log）的输出。用粗体突出显示了这些差别，并且它们都是用感叹号（!）作为前缀的 OS“echo”命令。因为那些命令都在 OS 级别上执行，而不是由 DB2 执行，所以没有通过 -z 标志记录它们的输出。

请注意最后一句由下面 DB2 的 VALUES 语句发出的注释：

This will get written to the screen AND log file

被同时写到屏幕和日志文件，因为这个命令是由 DB2，而不是 OS 执行的。

下面是当脚本在星期三运行时相对应的屏幕和日志文件的结果：

屏幕输出日志文件输出 beginning complex.db2 DB21034E　The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0438N　Application raised error with diagnostic text: "Script is for MON & FRI only!" SQLSTATE=80000 Retrieving from HELLO table.. MYCOL -------------------- 0 record(s) selected. Cleaning up... SQL0100W　No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.　SQLSTATE=02000 This will get written to screen, but not to log file 1 ----------------------------------- This will get written to the screen AND log file 1 record(s) selected. 　DB21034E　The command was processed as an SQL statement because it was not a valid Command Line Processor command.　During SQL processing it returned: SQL0438N　Application raised error with diagnostic text: "Script is for MON & FRI only!" SQLSTATE=80000 MYCOL -------------------- 0 record(s) selected. SQL0100W　No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.　SQLSTATE=02000 1 ----------------------------------- This will get written to the screen AND log file 1 record(s) selected.