LOAD DATA
INFILE * 
INTO TABLE TMPTPC_PRT_CTLG
TRUNCATE
FIELDS TERMINATED BY "|"
TRAILING NULLCOLS
(ITM_NO, 
EPR_DT DATE "YYYY-MM-DD", 
UPC_CD, 
INCL_QTY, 
CORE_VAL_FL, 
CORE_VAL_AMT, 
ITM_DS, 
ITM_LGTH "greatest(:ITM_LGTH,.01)", 
ITM_WDTH "greatest(:ITM_WDTH, .01)", 
ITM_HGHT "greatest(:ITM_HGHT,.01)", 
ITM_WGHT "greatest(:ITM_WGHT,.01)", 
SH_LGTH "greatest(:SH_LGTH,.01)", 
SH_WDTH "greatest(:SH_WDTH,.01)", 
SH_HGHT "greatest(:SH_HGHT,.01)", 
SH_WGHT "greatest(:SH_WGHT,.01)",
NBR_PER_CRTN, 
NBR_CRTN_PER_PLLT, 
STD_SH_TYP,
UNIT_PER_OTBND_SH,
TRK_MTHD,
AUTO_QC_FL "decode(:AUTO_QC_FL,'Y','Y','N','N',' ','N','N')",
ALT_UOM, 
VELOCITY_CD,
FRT_CLS_GRND,
FRT_CLS_AIR,
RCPT_QTY_LMT,
NO_CST_FL "decode(:NO_CST_FL,'Y','Y','N','N',' ','N','N')",
ITM_CAT_NO,
ITM_SUB_CAT_NO1,
ITM_SUB_CAT_NO2,
RCL_FL "decode(:RCL_FL,'0','N','1','Y',' ','N','N')")

00913941A1930||||N|0.0|Chaincable|0.00001|0.00001|0.00001|0.00001|0.00001|0.00001|0.00001|0.00001||||||N||||||N|1|||N