代码改成: declare mycur cursor for SELECT DATE(A.BUSINESS_DATE),A.ORG_CD ,A.EX_ORG_CD ,B.EXPORT_FLAG ...
显示全部
代码改成:
declare mycur cursor for
SELECT DATE(A.BUSINESS_DATE),A.ORG_CD
,A.EX_ORG_CD
,B.EXPORT_FLAG
,A.LEAF_TYPE_CD,A.LEAF_VARIETY_CD
,B.LEAF_RANK_CD
,B.LEAF_LEVEL_CD,B.LEAF_LEVEL_NO
,(SELECT MAX(C.LEAF_TYPE_NAME) FROM CM_LEAF_TYPE C WHERE A.LEAF_TYPE_CD=C.LEAF_TYPE_CD)
,A.LEAF_VARIETY_NAME
,B.LEAF_RANK_NAME,B.LEAF_LEVEL_NAME
,SUM(B.WEIGHT),SUM(B.AMOUNT),SUM(B.SUB_AMOUNT1+B.SUB_AMOUNT2)
,0,0
FROM BU_BUYINVOICE_MAS A,
BU_BUYINVOICE_DETAIL B
WHERE A.BUYINVOICE_MAS_ID = B.BUYINVOICE_MAS_ID
AND A.BUSINESS_YEAR = BUSINESS_YEAR
GROUP BY DATE(A.BUSINESS_DATE),A.ORG_CD
,A.EX_ORG_CD
,B.EXPORT_FLAG
,A.LEAF_TYPE_CD,A.LEAF_VARIETY_CD,B.LEAF_RANK_CD
,B.LEAF_LEVEL_CD,B.LEAF_LEVEL_NO
,A.LEAF_VARIETY_NAME
,B.LEAF_RANK_NAME,B.LEAF_LEVEL_NAME;
call SYSPROC.ADMIN_CMD('LOAD FROM ( SELECT DATE(A.BUSINESS_DATE),A.ORG_CD
,A.EX_ORG_CD
,B.EXPORT_FLAG
,A.LEAF_TYPE_CD,A.LEAF_VARIETY_CD
,B.LEAF_RANK_CD
,B.LEAF_LEVEL_CD,B.LEAF_LEVEL_NO
,(SELECT MAX(C.LEAF_TYPE_NAME) FROM CM_LEAF_TYPE C WHERE A.LEAF_TYPE_CD=C.LEAF_TYPE_CD)
,A.LEAF_VARIETY_NAME
,B.LEAF_RANK_NAME,B.LEAF_LEVEL_NAME
,SUM(B.WEIGHT),SUM(B.AMOUNT),SUM(B.SUB_AMOUNT1+B.SUB_AMOUNT2)
,0,0
FROM BU_BUYINVOICE_MAS A,
BU_BUYINVOICE_DETAIL B
WHERE A.BUYINVOICE_MAS_ID = B.BUYINVOICE_MAS_ID
AND A.BUSINESS_YEAR = BUSINESS_YEAR
GROUP BY DATE(A.BUSINESS_DATE),A.ORG_CD
,A.EX_ORG_CD
,B.EXPORT_FLAG
,A.LEAF_TYPE_CD,A.LEAF_VARIETY_CD,B.LEAF_RANK_CD
,B.LEAF_LEVEL_CD,B.LEAF_LEVEL_NO
,A.LEAF_VARIETY_NAME
,B.LEAF_RANK_NAME,B.LEAF_LEVEL_NAME) OF CURSOR insert into B_BUY_SUM ') ;
call时候提示:SELECT 或 VALUES 语句的列 "1" 与表列 "1" 不兼容。源列具有 sqltype
"384",而目标列具有 sqltype "496"。
这是什么原因?
收起