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
Using sqlldr command
Moderators: chulett, rschirm, roy
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,
,
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,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers