DSXchange

Hi,
I've created a small job in which an orabulk stage takes input from a sequential file. The control file and dat file have been generated. Can you tell how to proceed in order to load the data into the table?
Thanks&Regards,
Priyadarshini

Hi and Welcome Aboard ,
You have put manual on the load action by the description you gave, so you need only to invoke a command line sqldr to load the data.

You can search this forum on for this info or consult your DBA on the exact syntax you need.

IHTH,

Now you need a little script or batch file to do the actual call to sqlldr. Have a chat with your DBA if you've never worked with it before, they can walk you through the syntax and best practices.

Once you've got it working outside of DataStage, then you can add a call to the batch into the appropriate 'after job' section of a DS job. Or execute it at the tail end of a Sequencer job via either the Routine Activity or Execute Command stage.