Output values of one job used as Parameter values in another

[DS_MJ]

Job5 is not able to pickup the parameters because it is not in the format that it requires. It should be pipe delimited. Gateleys provided you with the correct format.

Notice that you must create and string to define all your parameter as :

" Paremeter = value | parameter2 = value | paramenter3 = value | ...| ParamenterN = ValueN"

In order to bring your parameters in that format, you have to use the command that gateleys provided

Code: Select all

UtilityRunJob('Job5',"Par1=":C1:"|Par2=":C2, 0,0) 

But my data is not seperated via "|" but rather "space". When I put a pipe the job fails.

JOB2 (fatal error from DSSetParam): Job control fatal error (-3)
(DSGetParamInfo) Parameter ' COL_B' not found in JOB5

When I dont put a "|" it runs and in the dummy file get to view the data as follows:

JOB5=3?JOB5?2006-05-15 15:43:12?2006-05-15 15:43:13?Xfm.Src?Xfm.ViewData?0?0

[DSguru2B]

From the error it looks like you have not defined the parameter COL_B.
Make sure you are hardcoding the correct parameter names when you call the UtilityRunJob().
Try this

Code: Select all

UtilityRunJob('Job5',"Col_Dt=":C1:"|Col_Tm=":C2, 0,0)

Where C1 is the value from columnA and C2 is the value from ColumnB.

[mab_arif16]

Job5 is not able to pickup the parameters because it is not in the format that it requires. It should be pipe delimited. Gateleys provided you with the correct format.

Notice that you must create and string to define all your parameter as :

" Paremeter = value | parameter2 = value | paramenter3 = value | ...| ParamenterN = ValueN"

In order to bring your parameters in that format, you have to use the command that gateleys provided

Code: Select all

UtilityRunJob('Job5',"Par1=":C1:"|Par2=":C2, 0,0) 

Can this same thing be done in parallel job,or there there some other way to do it in parallel

[us1aslam1us]

Hi Abdul,

Yes you can use UtilityJobRun transform function for parallel job too orelse as suggested by DSGURU2B you can pass these values through the unix script.

Thanks
Sam

[mab_arif16]

Hi Abdul,

Yes you can use UtilityJobRun transform function for parallel job too orelse as suggested by DSGURU2B you can pass these values through the unix script.

Thanks
Sam

I dont see the UtilityJobRun transform function in the transformer stage ,it is in user variable activity stage ,but dont know how to pass teh parameters from sequential file.

[us1aslam1us]

That will be in the Basic transformer.

Thanks
Sam