how to get values from an xml file to a variable in routine

parvathi · Post by **parvathi** » Mon Feb 12, 2007 4:24 am

Hi all,
I have generated an xml fileof the attached job in a routine.
the xml file contains the full information of the job.

Now i want to get job's process id and stage pid and cpu time from the xml ile generated .

Is there any way todo that.
Please help me

ArndW · Post by **ArndW** » Mon Feb 12, 2007 4:33 am

Is this a server/parallel job or a TX job?
If the former, you can use DSGetStageInfo() using the DSJ.STAGECPU key to get CPU time used in a stage. There is still a bug in this value, it doesn't actually return the CPU time used, but the CPU percentage; so you have to use the stage runtime computed by values returned in DSJ.STAGESTARTTIMESTAMP and DSJ.STAGEENDTIMESTAMP to get actual CPU time used.
The PID of a stage can be returned via the DSJ.STAGEPID key to DSGetStageInfo().

parvathi · Post by **parvathi** » Mon Feb 12, 2007 5:59 am

ArndW wrote:Is this a server/parallel job or a TX job?
If the former, you can use DSGetStageInfo() using the DSJ.STAGECPU key to get CPU time used in a stage. There is still a bug in this value, it ...

this is a server job. Is it not possible to get from the xml file

ray.wurlod · Post by **ray.wurlod** » Mon Feb 12, 2007 3:28 pm

Read the XML file and parse the tags. When you've found the start tag start collecting characters until you find the end tag. You can use the Index() function to determine the character position of the tags.