Originally posted by tomate
test following
into table test when REGION = 'REGROLL' and REGION ='WWF'
I tried that also but it discards teh records

The following is logged into the log file

Record 1: Discarded - failed all WHEN clauses.
Record 2: Discarded - failed all WHEN clauses.
Record 3: Discarded - failed all WHEN clauses.
Record 4: Discarded - failed all WHEN clauses.
Record 5: Discarded - failed all WHEN clauses.
Record 6: Discarded - failed all WHEN clauses.
Record 7: Discarded - failed all WHEN clauses.
Record 8: Discarded - failed all WHEN clauses.
......................................
.........................

Here is the sample of the records

MBOC YR_1991 REGROLL BSPSIEB 1.000000 1.000000
ALLEP YR_1991 REGROLL COFYE 24.000000 24.000000
ALLEP YR_1991 REGROLL COLOP 48.000000 48.000000
ALLEP YR_1991 REGROLL COEPAM 8.000000 8.000000

Please suggest a way I can do this with or without sql loader.

Thanks
Anurag