Hi guru's,
Could you please suggest some methods to use parameter file in parallel jobs?In server jobs i was using DSSetParamFile before/after subroutine.Thanks.
Reading parameter file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 22
- Joined: Mon Apr 02, 2007 4:02 am
- Location: MUMBAI
- Contact:
You can use this ..If i got ur qs right
Hi ,
If the qs is related to "how you can use parameters for file names or other things " then you can do this :
You can click on Job properties tab and on that you can declare a number of parameters as :
e.g,
parmSourceFilePath
and declare it as string and give some default value .
And in property tab of the stage use the format like
#parmSourceFilePath#
thi is the thing that you can do in server i hope same scenario will be there in PX . Just correct me if i am wrong.
Cheers
If the qs is related to "how you can use parameters for file names or other things " then you can do this :
You can click on Job properties tab and on that you can declare a number of parameters as :
e.g,
parmSourceFilePath
and declare it as string and give some default value .
And in property tab of the stage use the format like
#parmSourceFilePath#
thi is the thing that you can do in server i hope same scenario will be there in PX . Just correct me if i am wrong.
Cheers
Smrutiranjan Nayak
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I do not have DSSetParamFile available in my Repository. Can you please advise whether this is an user-defined subroutine? If it ships with DataStage, can you please advise in which category it is to be found?
Parallel jobs do support before/after subroutines.
Parallel jobs do support before/after subroutines.
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.
You cant use a parameter file for setting the job parameters. But you can implement the same using the environment variables. Define all the parameters you want to use for different jobs in the environment file and go to the jobparameters tab (Ctrl + J) add the environment variables that you want to use in this job as parameters with default value(Column Name in the job parameters tab) as $PROJDEF
Go to stage variables in your transformer define stagevariables with Initialvalue as GetEnvironment("parameter name from env file with double couts ")
Now use this stage variable as the parameter in the transformer. This should give you the value u have set in the environment file
Let me know if this helps.
-- JK
Go to stage variables in your transformer define stagevariables with Initialvalue as GetEnvironment("parameter name from env file with double couts ")
Now use this stage variable as the parameter in the transformer. This should give you the value u have set in the environment file
Let me know if this helps.
-- JK
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Check out PNav on Kim Duke's web site.
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.