Dynamic value for parameter in parameter set

nagarjuna · Post by **nagarjuna** » Fri Jul 24, 2009 8:36 am

I have a parameter set called param_set .I have created value file file1 .In this parameter set i have 20 parameters .One of the parameter is START_TIME .In parameter set and value file its value is 2006/01/01 .I want this paramter START_TIME should be equal to the time on which batch runs .

I am referring this parameter START_TIME in a job as param_set.START_TIME .In order to populate batch start time i am calling the job like this :

dsjob - run -param param_set=file1 -param param_set.START_TIME=`date +'%Y/%m/%d'` project_name job_name .

I am able to run the job and its population START_TIME with current batch time.

But when i put this job in a sequence its populating old value ( 2006/01/01 ) only .I am not able to get current batch time in it .

i am using below command :

dsjob - run -param param_set=file1 -param param_set.START_TIME=`date +'%Y/%m/%d'` project_name seq_name .

Can anyone suggest where i am going wrong ?

Thank you all

Nagarjuna

ArndW · Post by **ArndW** » Fri Jul 24, 2009 8:41 am

Can you put an "echo" command into the script to ensure that the command line is working? Also, could your default date format be YYYY/DD/MM instead of the expected YYYY/MM/DD?

nagarjuna · Post by **nagarjuna** » Fri Jul 24, 2009 8:49 am

Thanks for your prompt reply

For an individual job , Its populating correctly .But when i am using sequence , its populating default value .

nagarjuna · Post by **nagarjuna** » Fri Jul 24, 2009 8:56 am

Arndw ,

I have small question . I am calling this job in a sequence .I have included param_set as parameter in job properties of sequence . when we double click the job activity in the job sequence , we will get mapping of job sequence parameters to job parameters . In that , what should be the value of param_set ? predefined or param_set or job sequence parameter ? will it make any difference ?? Please let me know if i am not clear in my question .

Thanks
Nagarjuna

ArndW · Post by **ArndW** » Fri Jul 24, 2009 9:11 am

It would seem that you've located the source of the problem. I'm not at a datastage client where I can check, but I seem to recall you use the local definition when using a parameter set value within a sequence to pass on the value.

nagarjuna · Post by **nagarjuna** » Mon Jul 27, 2009 1:48 pm

Thank you all ...It got resolved

chulett · Post by **chulett** » Mon Jul 27, 2009 1:51 pm

Ok, you should know the drill by now - what was the resolution?

synsog · Post by **synsog** » Tue Feb 05, 2013 4:32 pm

Hi Nagarjuna,
Can you please provide us details on the resolution, as we are also facing the same problem

avicorp_1983 · Post by **avicorp_1983** » Wed Feb 06, 2013 1:42 am

HI Sysnog,
If you read nagarjuna post carefully you will find the answer there if self.
Or
See the setting in the Job activity for your job.

Regards,

S_K_G_1983