SQLLDR - problem with WHEN clauses
SQLLDR - problem with WHEN clauses I have multiple when clauses in my control file, the data that i am loading in half of them satisfies the when clauses and gets inserted into the desired table. The other half arent (which i expect) but i was expecting the data that doesnt meet the when conditions to be placed into a discard file but there is none created. Any ideas? LOAD DATA INFILE '/u04/app/vpht_app/flat_files/icr_load/marc/sqlldr_load/CSSO_CCRBSCREDENTIALS_COMSUMER23062010160322.txt' BADFILE '/u04/app/vpht_app/flat_files/icr_load/marc/sqlldr_load/CSSO_CCRBSCREDENTIALS_COMSUMER23062010160322.bad' DISCARDFILE '/u04/app/vpht_app/flat_files/icr_load/marc/sqlldr_load/CSSO_CCRBSCREDENTIALS_COMSUMER23062010160322.dsc' INSERT INTO TABLE "DCVPAPP"."RBS_CC_CUSTOMERINFO" INSERT FIELDS TERMINATED BY ',' TRAILING NULLCOLS (CC_USER_NAME POSITION(24:73), ACCOUNTID POSITION(1:12), CUSTOMERID POSITION(14:22)) INTO TABLE "DCVPAPP"."...