SET COPYCOMMIT 1
SET ARRAYSIZE 1000
COPY FROM qmfatd/at0505@0dbc:tisdb2q -
TO -
hria01/hria01@tubes -
INSERT -
T_EMP_DED_BKP-
USING SELECT-
DED_MPS_PAGE_NO DED_MPS_PAGE_NO,-
DED_MPS_SRC DED_MPS_SRC,-
DED_MPS_SRL DED_MPS_SRL,-
DED_MPS_TRAN_TYP DED_MPS_TRAN_TYP,-
DED_AMT_ADV DED_AMT_ADV,-
DED_CRY_AMT DED_CRY_AMT,-
DED_CRY_RLAMT DED_CRY_RLAMT,-
DED_DED_AMOUNT DED_DED_AMOUNT,-
DED_DED_CD DED_DED_CD,-
DED_DED_GRP DED_DED_GRP,-
DED_ENTRY_DT DED_ENTRY_DT,-
DED_FV_IND DED_FV_IND,-
DED_INSTL_AMT DED_INSTL_AMT,-
DED_INSTL_NO DED_INSTL_NO,-
DED_INTR_ACCRU DED_INTR_ACCRU,-
DED_INTR_BAL DED_INTR_BAL,-
DED_INTR_RECV DED_INTR_RECV,-
DED_INTR_ST_IND DED_INTR_ST_IND,-
DED_MATUR_DT DED_MATUR_DT,-
DED_OP_CODE DED_OP_CODE,-
DED_PERNO DED_PERNO,-
DED_POLICY_NO DED_POLICY_NO,-
DED_PRIN_AMT DED_PRIN_AMT,-
DED_PRIN_BAL DED_PRIN_BAL,-
DED_PROC_IND DED_PROC_IND,-
DED_START_DT DED_START_DT,-
DED_SUBCODE DED_SUBCODE,-
DED_YR_MTH DED_YR_MTH,-
DED_DOC_SRC DED_DOC_SRC,-
DED_DOC_BUNCH DED_DOC_BUNCH,-
DED_DOC_SRL DED_DOC_SRL,-
DED_MPS_BUNCH DED_MPS_BUNCH-
FROM dbadm02.V_EMP_DED_BKP;