DSXchange

It's only special in that that's all that it does (apart from giving you the ability to specify non-default buffer sizes and timeout value). That is, it's a special way in the GUI to make an explicit process boundary visible.

I agree. You are on UNIX, but getting a Windows pathname in the error message. This strongly suggests that a default value is being used for the folder's pathname. If you're loading the folder name from a job parameter, check (in the log, in the "job start" event) that the parameter value has been c...

You're running one process. The simplest way to think of it is that a passive stage between two active stages is a process boundary. Your design still only has one active stage. The IPC stage is a special case, in that it forces a process boundary. This answer is applicable to server jobs (parallel ...

Try importing the sequential file's table definition. Stay on the Format tab until you have it correct. Put 032 into the column delimiter field and click Preview. Experiment with other combinations (maybe 000 in the quote character field), clicking Preview each time until you're happy with what's di...

Error code 80012 decodes (from SYS.MESSAGE) to "unable to set remote uid or gid".

Check, therefore, that your user ID and password are correct.
If they are, check that that user is in a group that is allocated to an appropriate DataStage role.

Your code will never perform a reset. I make this assertion based on the axiom that if you've written a handler for something, it will never happen. Seriously, though, it's a useful utility to have. There are some other things that could be done at the same time, such as cleaning out old files from ...

I'll add one more to Vincent's list, for more mature projects into their maintenance cycle, and that is regression testing. Regression testing can simplistically be described as testing that proves changes haven't broken anything else. There is a wide-open marketplace out there (not just in DataStag...

Vincent only alluded to the real-time interface (RTI) services that you can get from Ascential. Under this regime, your design is effectively implemented as a callable service in real time. So, for example, a data entry operator could, prior to (or as part of) committing entry of name and address da...

Looks OK, except that there's no need to reset for DSJS.RUNWARN (finished with warnings). Jobs that exit with DSJS.VALFAILED, however, do need to be reset. You don't check to determine that the reset was OK (status should be DSJS.RESET after DSWaitForJob). :D :D :D Kudos for good documentation! Ever...

Depending on your DB2 settings you may need to use substring and concatenation techniques to re-arrange the day, month and year components of the date.

This is an example where DataStage is probably unnecessary. Use Oracle bulk unloader to unload to stdout, and pipe that result to Oracle bulk loader to load from stdin.

suri wrote:had to

Why?
There's a reason DataStage has the graphical interface, so you don't have to write code unnecessarily.

Maybe there IS such a beast as a poscket PC?

By the way, how does DataStage do this at the moment if this option is not used? Without the deadlock daemon running DataStage does not clean up after defunct processes, as far as I am aware. There are some utilities that can be used to do so manually, such as dslictool . (This is functionally much...

Because it follows the "." character in the job name, the file name is being used as the invocation id (unique identifier) of a multi-instance job. This will work in your case, particularly if you mv or rm the file once it's processed. MetaStage's post-and-notify mechanism for propagating knowledge ...