ok, i am able to run sqlldr80,
My .ctl file looks like this and reports an "expecting INTO and got "fields terminated by.."
<
Load Data
infile 'bxvu0120020403-2C.txt'
APPEND
into table PPV_MASTERTEXT
(EVENT_ID,EVENT_DT,EVENT_DESC,EVENT_AMT,EVENT_CAT,e1,e2)
fields terminated by "," optionally enclosed by '^'
>
so i tried
<
Load Data
infile 'bxvu0120020403-2C.txt'
APPEND
into table PPV_MASTERTEXT
fields terminated by "," optionally enclosed by '^'
(EVENT_ID,EVENT_DT,EVENT_DESC,EVENT_AMT,EVENT_CAT,e1,e2)
>
.. and get "partial record found at eof - but this is misreporting because it still says this even if i rename the filename in the .ctl file to something that does not exist and run it ..
ca you tell me if the syntax looks correct please,
thanks!