DSXchange

Posted: **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

Posted: **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.

DSXchange

Oracle Bulk Load - Truncate and direct=true options

Oracle Bulk Load - Truncate and direct=true options