load data append into table POSCORE3 fields terminated by "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( clientID CHAR, custodianID CHAR, accountNo "translate(:accountNo, '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'ZYXWUVUTSRQPONMLKJIHGFEDCBA9876543210')", securityType CHAR, symbol CHAR, currencyCode CHAR, asOfDate DATE "MM/DD/YYYY", shortLong CHAR, quantity DECIMAL EXTERNAL, localcloseprice DECIMAL EXTERNAL, baseCcyClosePrice DECIMAL EXTERNAL, adjUnitCost DECIMAL EXTERNAL, unadjUnitCost DECIMAL EXTERNAL, adjBaseUnitCost DECIMAL EXTERNAL, unadjLocUnitCost DECIMAL EXTERNAL, adjTradeTotCost DECIMAL EXTERNAL, unadjTradeTotCost DECIMAL EXTERNAL, adjBaseTotCostBasis DECIMAL EXTERNAL, unadjBaseTotCostBasis DECIMAL EXTERNAL, projTradeCcyAnnInc DECIMAL EXTERNAL, repBaseCcyAnnInc DECIMAL EXTERNAL, localMV DECIMAL EXTERNAL, repMV DECIMAL EXTERNAL, adjLocalUGL DECIMAL EXTERNAL, unadjLocalUGL DECIMAL EXTERNAL, adjRepUGL DECIMAL EXTERNAL, unadjRepUGL DECIMAL EXTERNAL, localAccInt DECIMAL EXTERNAL, repAccInt DECIMAL EXTERNAL, repCurrcode CHAR, adjstLocGL DECIMAL EXTERNAL, stLocGL DECIMAL EXTERNAL, adjltLocGL DECIMAL EXTERNAL, ltLocGL DECIMAL EXTERNAL, adjstRepGL DECIMAL EXTERNAL, stRepGL DECIMAL EXTERNAL, adjltRepGL DECIMAL EXTERNAL, ltRepGL DECIMAL EXTERNAL, processed constant "N", ID__ "db_seq_position.nextval" )