i want to pass schema file-name during runtime.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
saikat26
Participant
Posts: 11
Joined: Fri Oct 23, 2009 9:04 am

i want to pass schema file-name during runtime.

Post by saikat26 »

Hi,

I have a job which uses schema File. My requirement is like that in each and everytime i run my job my schema file name changes.
So can you please tell me how to pass job parameters during time.

Please Help me.
Thanks in Advance...
Hi i want to learn datastage...
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The usual way. Schema File is a property of the Sequential File stage (for example) and will accept a job parameter reference delimited with sharp signs.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
saikat26
Participant
Posts: 11
Joined: Fri Oct 23, 2009 9:04 am

Post by saikat26 »

I didnt understand clearly ..can you please explain in detail...

Thanks in Advance..
Hi i want to learn datastage...
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There is no more detail. The Schema File property will accept a job parameter reference as its value. The parameter reference will be resolved when the stage starts.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Sreenivasulu
Premium Member
Premium Member
Posts: 892
Joined: Thu Oct 16, 2003 5:18 am

Post by Sreenivasulu »

Take the schema file name dynamically during run time (i.e the file name would be a job parameter reading some logic)

Regards
Sreeni
ajay.vaidyanathan
Participant
Posts: 53
Joined: Fri Apr 18, 2008 8:13 am
Location: United States

Post by ajay.vaidyanathan »

Hi,

Add a parameter to your job properties and you will be able to pass your schema file name to it at run time.
Regards
Ajay
Post Reply