使用DB2 存储过程设置了游标 declare c1 cursor for SELECT A.TICKET_ID,A.EIGEN_CODE,A.RAND_CODE,A.DRAW_NO,A.PRV_ID,A.GAME_ID,A.WAGE_NO,A.CURRENT_NO,A.MULTI_ISSUE_FLAG,A.MULTI_ISSUE_COUNT,A.GT_SEQ_ID,(CASE A.TICKET_STATE WHEN 0 THEN coalesce(B...
显示全部使用DB2 存储过程
设置了游标
declare c1 cursor for SELECT A.TICKET_ID,A.EIGEN_CODE,A.RAND_CODE,A.DRAW_NO,A.PRV_ID,A.GAME_ID,A.WAGE_NO,A.CURRENT_NO,A.MULTI_ISSUE_FLAG,A.MULTI_ISSUE_COUNT,A.GT_SEQ_ID,(CASE A.TICKET_STATE WHEN 0 THEN coalesce(B.TICKET_STATE,CAST(0 AS SMALLINT)) ELSE A.TICKET_STATE END) TICKET_STATE,A.BET_TIME,A.MOV_TIME,A.TICKET_BET_SUM,A.DRAW_ENTRY,A.TOTAL_AMOUNT,A.BET_DETAIL,A.VIP_ID,A.LOG_GT_ID,A.PH_GT_ID,A.OPERATOR_ID,A.MOV_LOG_GT_ID,A.MOV_PH_GT_ID,A.MOV_OPERATOR_ID,A.OPERATE_MODE,A.POP_ATTR,A.SIGNARTURE FROM SALE_B001_01_B A LEFT JOIN SALE_B001_CNFM_01_B B ON A.TICKET_ID = B.TICKET_ID
再使用DB2 load
load from c1 of cursor insert into SALE_B001_C
进行导入以后,提示这个错误
DB2 9.5
WINDOWS
SQL3508N 装入或装入查询期间,当访问类型为 "TEMP_FILE" 的文件或路径时出错。原因码:"6"。路径:"D:DB2NODE0000SQL00002loadDB20FFFA.PIDDB208001.OIDlo"。
给看看。。。谢谢了。
收起