Oracle Bulk Load - Truncate and direct=true options

guysen · Post by **guysen** » Tue May 03, 2005 11:10 am

We are trying to build a DataStage Server JOB which would load up an Oracle table via the Oracle OCI Load. Is there a way to specify the TRUNCATE and DIRECT=TRUE in the COntrol File.

Thanks

kcbland · Post by **kcbland** » Tue May 03, 2005 2:01 pm

Only thru an after-routine/job call to edit the control file programmatically. You're better off spooling to a sequential file and loading thru a hand-written ctl file anyway.