DSXchange

Seems to me, everything is in the error message you posted. Your array size needs to be no more than 1567 with that row length to ensure the buffer size is not exceeded.

I would stick with the approach Ray mentioned and have implemented the very same myself, or at least something very similar using the techniques mentioned.

Note that there is also an InfoType of DSJ.JOBLASTTIMESTAMP to get the time the job finished.

thurmy34 wrote:I already did that the job work well the day after and abort the next day (is it clear ?).

Meaning, you removed the hashed file, it worked for a day or two afterwards and then aborted again?

If that's the case, what was the abort message? Can you post it in its entirety?

You need to define what in the heck you mean by 'junk' characters. Be as specific as possible and use a hex editor (or something similar, perhaps 'od') to get the ASCII values for them.

Hmmm... for some odd reason this was the first place I went with Chrome and it worked fine. Well, fine once I loaded Flash, otherwise certain aspects were broken but other than that in was fine.

Use 'ReturnValue' for a Routine Activity stage, for the Execute Command stage use a Custom trigger and check $CommandOutput instead.

Do an Exact search on "month end date" in the PX forum.

Rather than make people puzzle out and guess what you mean by "last calendar date" why not provide specific examples so it hopefully becomes clearer? For example, show an "END_DATE" value and what it should be transformed into as a "last calendar date".

Not sure why you would be using the OCI8 stage over the OCI stage, that may complicate things. Otherwise it should just be a case of updating your tnsnames entries to point to the 10g instance while still using the 9i client on your DataStage server. In other words, no changes to your jobs. That may...

The answer is 'yes' and we've seen people posting on how to do this, something a search should turn up I would think.

Not if both links are 'firing' at the same time. Sequential files by their very nature support multiple readers but only one writer at a time, so you'd need to arrange for them to run in a serial fashion.

Me, assuming this is a pathed hashed file, I would just remove the directory and let whatever process created it recreate it. Assuming you're not using it for persistent storage and couldn't afford to lose what's there. If this is an account based hashed file, then you'll need to delete the VOC entr...

Depending on what 'union' means to you, you can also investigate the Merge stage.

If you mean the 'Best Practices' document, you can download that from Kim Duke's site:

http://www.duke-consulting.com

Tips & Tricks page.