Hi,
Can anyone guide me how to use config file as the input to the job.
Requirement- I am using a sybase stage with a stored procedure contains more than 7 left outer joins to the master table and then using sort and aggregator stage (Max() function for row to column conversion) and loading into sequential file. since the file gets created everyday with more than 1lakh records.
so client has guided me to use the same stored procedure and run on unix machine and create a config file for that stored procedure and call the job.
So please if someone is aware let me know how to use config file as the input to the job.
how to generate config file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please explain what a "config file" actually means in the context (that of a Sybase stored procedure executed from the command line, presumably). Do you mean a "script file"? Can you provide an example?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ray,ray.wurlod wrote:Please explain what a "config file" actually means in the context (that of a Sybase stored procedure executed from the command line, presumably). Do you mean a "script file"? Can you provide an examp ...
You have understood correct, can you please guide me in how can we execute the stored procedure in command line ...