Originally posted by JUNE

Load Data
infile *
choose one of the following options (truncate,append,replace)
into table (table_name)
when (21:30) = 'regroll' or (21:30) = 'regroll2)
(column_name postion(x:x)
... continue to enter the record format
...
)
BEGINDATA
MBOC YR_1991 REGROLL BSPSIEB 1.000000 1.000000
ALLEP YR_1991 REGROLL COFYE 24.000000 24.000000
ALLEP YR_1991 REGROLL1 COLOP 48.000000 48.000000
ALLEP YR_1991 REGROLL2 COEPAM 8.000000 8.000000


Hi,
Sql Loader does not support the OR operator and thats teh reason I need to use a shell script.

Please see my other thread where I had the same question for sql loader

http://www.dbasupport.com/forums/sho...threadid=11922

Thanks
Anurag