Link Names
Moderators: chulett, rschirm, roy
Link Names
Hello Gurus,
I need help in extracting the Input and Output link names for a job using the Universe stage.
sequnetial file stage---> transformstage1 ---> transformstage2 ---> DRS stage
Any help with this is appreciated!
I need help in extracting the Input and Output link names for a job using the Universe stage.
sequnetial file stage---> transformstage1 ---> transformstage2 ---> DRS stage
Any help with this is appreciated!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I can not see a UniVerse stage in the job design you documented, am I missing something?
The usual, and officially documented, approach to get link names is to invoke the DSGetStageInfo() function in a routine.
The usual, and officially documented, approach to get link names is to invoke the DSGetStageInfo() function in a routine.
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.
I'd like to extract the Input/Output link names in the same order as they are designed for each Stage in a give Job.
example:
sequential file-->transformerstage1(XX)-->transformerstage2(YY)-->DRS
Sequential File Link is Input to transformerstage1
XX is the Output Link from transformerstage1
XX is the Input link to transformerstage2
YY is Output link from transformerstage2
YY is the Input link to DRS stage
DSGetStageInfo returns the link names when it is called within the job itself.
Ideally, I'd like the Universe stage extract the link names (input and output) in the same order as designed.
example:
sequential file-->transformerstage1(XX)-->transformerstage2(YY)-->DRS
Sequential File Link is Input to transformerstage1
XX is the Output Link from transformerstage1
XX is the Input link to transformerstage2
YY is Output link from transformerstage2
YY is the Input link to DRS stage
DSGetStageInfo returns the link names when it is called within the job itself.
Ideally, I'd like the Universe stage extract the link names (input and output) in the same order as designed.
Chulett,
Thanks for your quick response.
I am calling DSGetStageInfo function in a routine just to test it. I passed the Job Name for Arg1, for Arg2 Stage Name and Arg3 Info Type (DSJ.LINKLIST)
Call DSGetStageInfo (Result, Arg1, Arg2,Arg3)
Ans=Result
The value in the Result is a "-1".
But, when I call the DSGetStageInfo funciton within the job and pass DSJ.ME as "Job Name", DSJ.ME as the "Stage Name" and "DSJ.LINKLIST" as the Info Type it returns the input/output links seperated by commas only for that particular stage.
What I am trying to achieve here is to get all the input/output links in the same sequence as designed for a given stage within a job. I was able to extract Job and Stage names from DS_JOBS and DS_JOBOBJECTS files for all the jobs in my project.
Any help with this is appreciated!
Thanks for your quick response.
I am calling DSGetStageInfo function in a routine just to test it. I passed the Job Name for Arg1, for Arg2 Stage Name and Arg3 Info Type (DSJ.LINKLIST)
Call DSGetStageInfo (Result, Arg1, Arg2,Arg3)
Ans=Result
The value in the Result is a "-1".
But, when I call the DSGetStageInfo funciton within the job and pass DSJ.ME as "Job Name", DSJ.ME as the "Stage Name" and "DSJ.LINKLIST" as the Info Type it returns the input/output links seperated by commas only for that particular stage.
What I am trying to achieve here is to get all the input/output links in the same sequence as designed for a given stage within a job. I was able to extract Job and Stage names from DS_JOBS and DS_JOBOBJECTS files for all the jobs in my project.
Any help with this is appreciated!
Chulett,
Can you pls. shed some light for establishing a Job Handle to a given job?
I tried calling the DSAttachJob function in a routine just to test it.
Call DSAttachJob (Job_Handle,Arg1, Arg2)
Ans=Job_Handle
I passed Job Name for Arg1 and DSJ.ERRNONE and the Job_Handle returns an Integer "0".
Any help is appreciated!
Can you pls. shed some light for establishing a Job Handle to a given job?
I tried calling the DSAttachJob function in a routine just to test it.
Call DSAttachJob (Job_Handle,Arg1, Arg2)
Ans=Job_Handle
I passed Job Name for Arg1 and DSJ.ERRNONE and the Job_Handle returns an Integer "0".
Any help is appreciated!
DSAttachJob() is a function, not a subroutine. It won't compile or run with a CALL.
Use "JobHandle = DSAttachJob(Arg1,Arg2)"
Use "JobHandle = DSAttachJob(Arg1,Arg2)"
Last edited by ArndW on Tue Jul 08, 2008 10:33 am, edited 1 time in total.
Code: Select all
jHandle=DSAttachJob(Arg1,Arg2)
Arg2 = Error Level
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I use DSJ.ERRNONE but that choice doesn't affect the attachment, only subsequent use of the handle. Have you tried actually using the handle in subsequent steps? From the docs:
JobHandle is the name of a variable to hold the return value which is subsequently used by any other function or routine when referring to the job. Do not assume that this value is an integer.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Still cannot resolve the issue. Wondering whether is it possible to get all the input/output link names in the same sequence for all the jobs in a given project.chulett wrote:I use DSJ.ERRNONE but that choice doesn't affect the attachment, only subsequent use of the handle. Have you tried actually using the handle in subsequent steps? From the docs:
JobHandle is the name of a variable to hold the return value which is subsequently used by any other function or routine when referring to the job. Do not assume that this value is an integer.
Still cannot resolve the issue. Wondering whether is it possible to get all the input/output link names in the same sequence for all the jobs in a given project.chulett wrote:I use DSJ.ERRNONE but that choice doesn't affect the attachment, only subsequent use of the handle. Have you tried actually using the handle in subsequent steps? From the docs:
JobHandle is the name of a variable to hold the return value which is subsequently used by any other function or routine when referring to the job. Do not assume that this value is an integer.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What is the value of Arg1?
Don't assume, check - maybe using DSLogInfo().
If the job name is not spelled and cased correctly, DSAttachJob() will fail to attach the job.
Don't assume, check - maybe using DSLogInfo().
If the job name is not spelled and cased correctly, DSAttachJob() will fail to attach the job.
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.