DSXchange

Don't assume everyone knows what your acronym means or can be bothered to google it up.

Toyota Financial Services?
Team Four Star?
Texas Forest Service?

Needs a little... disambiguation.

What database? What is the attribute's data type? Are you delivered the XML or do you need to generate it?

Okay... doesn't really change what you need to do or how I would have answered. And your "1 then 2 then 3" is just "-1 three times".

Not sure why you keep mentioning a 'loop counter' as there's no need to loop to go back more than one month. So you just need an offset to drive how many months to go back? I'd suggest you go to Ray's site (coming soon!) and click on any of his download links. Cancel that download (or add it to your...

If you haven't already, involve your official support provider as well.

You missed their issue, Ray. Job N fails and they want to restart from Job N-1, not N.

That's an important piece of information, let's get you in the correct forum for this...

That code would be appropriate for either a Server job or a routine, yet you've marked the post as Parallel and posted in the Parallel forum. So... are you looking for a native PX solution?

Okay... how about the nodes question?

You may also want to involve your DBA when it 'hangs' to see if there are any issues on the database side, blocking locks and the like. Does it still hang if you run it on a single node? Assuming there are multiple nodes (>1) at the moment.

Perhaps this will help?

I'm assuming it is buried in here somewhere since he pointed other people to it in the past. I'm sure there's better examples, but there you go.

:idea: Don't apologize, simply don't do it. Start your own thread and link back to the other topic if you really think it would help. There you go, all done. Now you are the master of your own destiny. :wink: How about more details about your job and what it is meant to accomplish. Typically all one...

JobActivity_Stage_Name.$JobStaus = DSJS.RUNOK

Those variables are mentioned all over the place but here is one entry with all of them: http://www-01.ibm.com/support/knowledge ... ml?lang=en

Honest question - dynamically?