DSXchange

Instead of space give %20 like

PARAM1='A%20B%20C'

HI Chulett, I am collecting job statistics from this routine.I have a file with all job names in it,and files path is being passed as parameter. My routine has to read that file and for each job name in that file, it should get stats and write to another file. For this, the routine should go through...

Forum,

Awaiting your reply.

Thanks All.

HI forum, I have a text file with more than 10 records(job names). I want to write a routine, which will read that file, and for each record i.e., for each job name, it should get jobs statistics using DSinfo function and write to file again. I can read the file using seq commands, but how can I mak...

Thanks chulett and kunal.

My approach is, In the job activity stage itself, I called the routine directly where we assign parameters. This eliminated before routine stage and also I got routine output directly stored to my parameter.

Thanks All.

Hi forum, I had a sequnecer and i am using a routine in it. In the same job if i want to use that routines output, to be used as a parameter, how can i achieve that. I know that Ans will be storing output value, but how to take it to next stage to be used as a parameter. I will be having a job activ...

Thanks Chulette. It is the reason why i am not getting end stamp.

Marking my post as resolved.

Hi Prasanna, Thanks for pointing out., 'Ans' is a default variable expecting some return value. I gave Ans=0 in code and it compiled successfully. I ran this as an After job routine and could see results in logfiles. But I couldnt see END Timestamp. I searched in forum, and syntax looks correct. Any...

Hi Ray, Thanks for your reply, but I couldnt download stats due to restrictive environment I am in. HiChulett, Thanks for suggestion and I started learning routines. For the same topic which I posted, I am facing below error when compiling the routine. Can any one look in to it and tell why I am fac...

Hi, I need to capture Audit info like job start time, end time, no. of rows processed etc into a table. My plan is to write a routine which will write all the stats to a sequential file and then I am planning to read that file and update database.. I want to know if i can achieve all the above in an...

Hi All, I am adding an update on this. I replaced External Source stage with sequential file and the job completed successfully. So, want to know if there is any problem with External Source stage. XML is placed in D drive of Windows Server and Path is passed to Ext source as " ls //Foldername/...

@Priyadarshi, o/p of external source is just routed to XML input stage and till that part job is running fine. Once XML stage tried to parse the data, error is coming.

@Istasur, Can i know what patches you want me to install?

HI Forum, I am getting below error when i am trying to read a xml file. I am using Externalsource stage to give input to xml input stage. XML file and its path given are fine, but still getting below error. "XML_Input_10,0: Fatal Error: Fatal: XML input document parsing failed. Reason: Xalan fa...