load data
append
into table PERFCORE3
fields terminated by "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS (
clientID                CHAR,
code                    "translate(:code, '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'ZYXWUVUTSRQPONMLKJIHGFEDCBA9876543210')",
assetClassCode          CHAR,
beginDate               DATE "MM/DD/YYYY",
endDate                 DATE "MM/DD/YYYY",
returnAfterFeeTWR       DECIMAL EXTERNAL,
returnAfterFeeIRR       DECIMAL EXTERNAL,
returnBeforeFeeTWR      DECIMAL EXTERNAL,
returnBeforeFeeIRR      DECIMAL EXTERNAL,
afterFeeIdentiferTWR    DATE "MM/DD/YYYY",
beforeFeeIdentiferTWR   DATE "MM/DD/YYYY",
PROCESSED               CONSTANT "N",
ID__                    "db_seq_PERF.nextval"
)