Parameter File Usage

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
Divya_K
Participant
Posts: 3
Joined: Thu Dec 13, 2007 2:29 am
Location: India

Parameter File Usage

Post by Divya_K »

Can you tell me how to get the parameter values for a specific job from a file, as I dont want it to be hardcoded in the job properties.
Thanks,
Divya
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

Post by dnat »

Check this link

viewtopic.php?t=106875
Divya_K
Participant
Posts: 3
Joined: Thu Dec 13, 2007 2:29 am
Location: India

Parameter file format

Post by Divya_K »

hii..
i want to use a parameter file whose format wil hav "name,value" pair.
Can you let me know how to use it...
Thanks,
Divya
aakashahuja
Premium Member
Premium Member
Posts: 210
Joined: Wed Feb 16, 2005 7:17 am

Post by aakashahuja »

Hmmmm.... although never tried it but I guess that you can do it in this fashion:

1. Have your name value pair in a text file as comma separated (any separator would do).
2. Write a basic routine to fetch that file, read it sequentially, use string in column1 as parameter name and string in column2 as value.

I guess the functions you might want to look at is DSSetParam (hope my memory is intact :wink: )

Hope this helps.

Cheers
Aakash
L'arrêt essayant d'être parfait… évoluons.
Divya_K
Participant
Posts: 3
Joined: Thu Dec 13, 2007 2:29 am
Location: India

Re: Parameter file usage in parallel job

Post by Divya_K »

oh thx!!
can u tell me where to cal the parameter file name in the job..?? n can u also quote me an example for writing a routine which you mentioned??
Thanks,
Divya
Post Reply