Topic
  • No replies
ES8D_machone_foust
ES8D_machone_foust
4 Posts

Pinned topic LOAD FROM CLIENT INTO TABLE IN PARTITIONED DATABASE

‏2011-09-08T19:12:19Z |
I used the DMT to unload data from oracle and used command line db2load.sql script to load to db2 9.7. the db2 database is partitioned. I am running this load job from my PC which is also the location of the data to be loaded

I have used several versions of this code, but get SQL2032n PARAMETER IS NOT VALID
LOAD CLIENT FROM
"C:\IBM DATA MOVEMENT TOOL\migr\data\rdx_cred_card_orig_ft_cc_appl_applt.txt"
OF DEL
MODIFIED BY CODEPAGE=1208 COLDEL~ ANYORDER USEDEFAULTS CHARDEL"" DELPRIORITYCHAR
METHOD P (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23)
MESSAGES "C:\IBM DATA MOVEMENT TOOL\migr\msg\rdx_cred_card_orig_ft_cc_appl_applt.txt"
REPLACE INTO "RDX_CRED_CARD_ORIG"."FT_CC_APPL_APPLT"
(
"APPL_ID_KEY",
"APPLT_ID",
"APPLT_FICO_ID",
"APPLT_BNI_ID",
"APPLT_INCM_ID",
"APPLT_OTHR_INCM_ID",
"APPLT_CRED_BUR_ID",
"APPLT_CIN",
"APPLT_CRED_BUR_RISK_MDL",
"APPLT_CRED_BUR_BNI_MDL",
"APPLT_CRED_BUR_CD",
"APPLT_CRED_BUR_NM",
"APPLT_FRD_STAT_INDC",
"APPLT_SEQ_NBR",
"APPLT_FICO",
"APPLT_BNI",
"APPLT_INCM",
"APPLT_OTHR_INCM",
"APPL_CNTR",
"FRST_INSRT_DT",
"LST_UPDT_DT",
"DATA_SRC_SYS_ID",
"MRK_FOR_DEL_FLG"
)
FOR EXCEPTION "RDX_CRED_CARD_ORIG_EXP"."FT_CC_APPL_APPLT"
PARTITIONED DB CONFIG MODE PARTITION_AND_LOAD
--STATISTICS YES WITH DISTRIBUTION AND DETAILED INDEXES ALL
;