DSXchange

"Arg1" is not the job name but rather a job handle that you need to establish and DSJ.ME is short for 'the current job'. See DSAttachJob and DSDetachJob.

Something will need to determine the current date and pass it to the job in question. Typically, that would be a Sequence job using a Routine Activity stage to get the date in your desired format.

Looks like a two-part effort. First use DSGetJobInfo with an InfoType of DSJ.JOBFULLSTAGELIST, then loop through the results and call DSGetStageInfo with DSJ.LINKLIST.

We know. The answer is out there if you search as suggested. I don't see the need to spell it out one more time when a moment of effort on your part would reveal all.

Search the forums for "ParamValue/Limitvalue is not appropriate" - this issue has been discussed a bajillion times.

Convert DATE1 to internal format using IConv. Use @DATE for the system date in the same format. Subtract. Add 1. Use OConv to get back to an 'external' date.

http://it.toolbox.com/blogs/infosphere/is-the-datastage-parallel-transformer-evil-9801 Ah yes, a Vincent blog. Keep in mind the fact that his observations are just over two years old now and - from what I understand - the stage has since been vindicated, rewritten to dramatically improve its speed.

Yes, ones established in the user's environment outside of what the Project thinks exist. We just had a longish discussion of the need and the -local option, and that was put forth as the answer when a Project defined variable was overwriting a user level one and the poster want the user one to surv...

Shouldn't have to. Properly set up, they will automatically be picked up from the environment and the environment variables will be specific to the project.

Sure! :D You can open the file in Append mode and write the record to it. Or capture the count in a separate file (with a link to an Aggregator, for instance) and then concatenate it in append mode to the main file after job. I'm sure there are other techniques. cat record_file >> detail_file Have y...

You're going to need to be more explicit. And what purpose does your example job serve? It is an example of what, in other words.

You have to ensure you have exclusive access to the Project - no running jobs, no orphaned client connections - nothing other than you can be in / connected to the project - or it won't work. Did you?

Doesn't seem like you have the decimal portion set up correctly: result type "decimal[1,0]" won't hold the contents of a 10 character string, hence the message.

Maybe we can get it added to Quality Stage.

As do I. Usually it's best to ask a more general 'how do I' question rather than focus on your perceived solution without giving us any clue about the problem you are trying to solve. We can usually get you on the right / much more better road to take you to your goal once we know what that is.