DSXchange

Doing a "reset" might work and trigger a purge - you could try it on your 1044 job (a meaningful number to American taxpayers) and see if it works. If that works you could ensure that jobs get reset before running (such as when called from sequences) and that would ensure that you wouldn't get any r...

The job won't abort until it hits 50 warnings by default, it always aborts on the first error. As stated earlier, the different behaviour is caused by differing number of allowed warnings. Get rid of your warnings and the behaviour will be the same.

This means that you are working in a server and not a parallel job.

Kris - the 2 values for the time "hs" part were zero, so I still don't know if it is "half seconds" or hundredths of a second. Assuming that <nn> are values from 00 to 99 then you depending on which database timestamp format you want you could either truncate the last two positions to get pure secon...

The string_from_decimal doesn't have an option to suppress the sign character so you will always get it and need to remove it. A modify stage can't use embedded functions, but you could put another modify stage with a trim() to get rid of the leading spaces or just a substring function to get rid of...

Kris, what is a "hs", or could you give an example of the time part for my understanding?

Can you start the job with the same parameters manually? This might be a broken project or job definition, since the call to DSWaitForJob() did not return a valid code.

The OVERflow file might get cleaned up when a log file gets purged, but not always. With large overflow files the Date-Time-Modified will certainly get changed when you purge your log. Did you check the purge setting for your job 1044 (I go to the Directory and do a clear log and you can see the cur...

What is the warning you are getting?

I am not sure how you can do this in DOS. What you need to do is write a .BAT script to do this remote login, then call the batch script from DataStage. I did a quick search on Google using but am not sure if any really offerred a pure DOS/Windows TELNET and .BAT solution. I still think that using r...

Ok, and if you put another DSLogInfo() at the end of the routine that outputs the DCOUNT(Ans,'|') does it have appropriate values?

You posted that your DataStage server is on Windows, so in order for a job to login to a UNIX machine and perform some action(s) you need to execute a shell from DataStage. This shell would be a DOS command, but with a tool such as MKS Toolkit installed you could issue a rsh . A pure DOS solution wo...

OK, have you checked your read speed to ensure that it is constant? Also, what is your transaction isolation setting for this job as this can have an impact? Since you are doing a update or insert the speed changes could be accounted for by this method - might it make more sense to change the order ...

I would split this into 2 steps, the first is creating your data file, and the second adds the header and trailer records. This is easy to do using UNIX commands - namely the cat command to concatenate data streams and the wc -l command to get your line count from the original data file. This one-li...

What happened with the DSLogInfo() output added to your routine in the job? Were the parameter values as you expected?