Creation of file with a name taken from a sequential file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Sreenivasulu
Premium Member
Premium Member
Posts: 892
Joined: Thu Oct 16, 2003 5:18 am

Creation of file with a name taken from a sequential file

Post by Sreenivasulu »

Hi All,

I want to create a file whose name would be dynamic. The file name has to be read from :roll: a sequential file.

Regards

:)
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

The filename is a job parameter, and the job parameter value is fed by the job control process. The job control process takes care of determining the value by whatever means necessary. Your choices for job control are Sequencers, BATCH, or custom control using the documented APIs.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

To paraphrase what Ken posted, your job control routine reads the sequential file, constructs the file name based on what it has read, and passes this to the job as a parameter value using DSSetParam before requesting execution of the job.
Within the job, the parameter reference is used to provide the file name.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
you could also use a job to read the file and get the file anme and then set user status with the file name and pass that as your paramter to the job.

just another way to get what the wise folks said before me :)
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
Image
Post Reply