DSXchange

Just as an aside, don't use the ABORT statement in job control. Use: Call DSLogFatal("Some meaningful reason for stopping", "Some context") instead. That way the controlling job will stop gracefully, and log a message saying why it stopped. A Call to DSLogFatal never returns. So...

I have names of all the jobs in a file. In a job control, i need to read the name of the job from file, evaluate some information using DS functions & pass them to the parameters defined for the 'Controlled Job' .
& this needs to be repeated for all the jobs.

Try detaching hJob1 when you're done with that job, so that you don't get a job locked situation. Why are you executing the same job 18 times? ... The file i am reading has 18 enteries. While initially learning for reading a file sequentially, i saw that i need to loop it for the number of enteries...

i have searched the forum for ReadSeq & tried umptine times but still problem persists. May i know the syntax for simply reading a single column of a file & file which has just 1 column , sequetially & then passing the column name to the variables. Just want to cross-check what i have gi...

Hi , I am running a job control as follows(for reading job names from a file & get the corresponding information in variables) OPENSEQ 'C:\Project_Files\JobName.txt' TO OUTPUT ELSE ABORT for i=1 to 18 READSEQ A FROM OUTPUT ELSE ABORT inivar=DSAttachJob(A,DSJ.ERRWARN) midvar=DSGetJobInfo(inivar,D...

Infact, not just the input ,any column on which you are operating.

It is obtain a substring of the input column.
Further,the expression you are calculating can be given as a constraint,Stage variable's derivation or an output column derivation.

U can get to know the functionality if you carefully observe the output of your job by changing the arguments([1,2], [1,4] ...)

Yes, it surely does!

Thanks Craig, for your valuable assitance!

I am a bit late in reading your post, Craig :D I just finished up with doing same , then thought of checking for a reply here. Infact, your post reinforced that i did it correctly. Thanks! Now,i am done with getting the Job_Name Job_NO Stage_Name , for a particular Job(hardcoded the job name in Job ...

Hi Craig, I browsed the forum as guided by you but didnt have the luck. From the link that you sent in your last post, i saw that somebody tried with: Convert(";", @VM, FIELD2) In a transformer and load it into a hash file as a non key column. Can you please explain the @VM functionality, ...

I did a search for the same(Reading Normalized) but didnt get the desirable.
Can you please tell how to read in a Normalized manner!

I am able to do it using Field functions but for that i should know before hand that how many stages i have in job.
How i am supposed to leave it for datastage to get the number of stages & then do the same for all stages in a job & further for all the jobs.

Those comma delimited fields are basically the stage names of all the stages in a particular job. So, maximum number is also not fixed..! To be more precise, from DSGetJobInfo(variable,DSJ.STAGELIST) , i get a comma delimited column containing all stage name of a job. But, requirment is to have them...