DSXchange

It's probably easier to add another project, as this does all the work for you. You do not have to set up a user/password; DataStage uses operating system authentication. You might want to use groups and DataStage roles (managed via the Administrator client) to limit who can do what in the new proje...

What do you mean by "killed by DBA"? If the DBA is killing processes that have open cursors, how is DataStage informed that this is the case? There's a right way and a wrong way. You need to educate the DBA. Are you trying to do too many insert operations before a commit? Try reducing the rows per t...

Yes, executing in ksh.

Weird!

oerr ORA 979 returns

00979, 00000, "not a GROUP BY expression"
// *Cause:
// *Action:

which isn't all that helpful!

Perhaps (he suggested, clutching at straws) qualify the column names with the table name?

Exactly. Usually more Transformer stages. Separate them using IPC stages (or just use row buffering) to achieve pipeline parallelism.

There is a maximum number of links supported by each stage type. For the Transformer stage it is 127, with an additional limit of a maximum of one stream input link. Don't even think of trying to hit this limit "just because you can"! It's an engineering limit set that high because no-one would ever...

Couldn't get set to work in this way on AIX 5.2.

It might be over the top, but I've always used awk (with printf) to accomplish this kind of parsing.

Welcome aboard! :D One of the strengths of DataStage is that it's very tolerant of data type mismatches, as it doesn't use data types internally. So the correct way to perform this conversion, as Kim says, is to do nothing! If you're really worried about it you could apply a Trim() or TrimB() functi...

Major bummer! Has anyone deleted the &PH& directory? If not, does the user ID under which the DataStage job is run have rwx permission to the &PH& directory in the project? Every DataStage process runs as a "phantom", which is DataStage-speak for background process. Every phantom has to keep a recor...

The job control code, if hand-crafted, is performed in a Server Job, on the Job Control tab in the job properties window. It's written in DataStage BASIC. Within Job Control, you can attach jobs, set their parameter values, request their run, wait for them to finish, interrogate their status and sta...

"not recognised as an internal or external command" is almost always an indication that the executable in question is in a directory that is not in your PATH PATH is an environment variable. These are set (in Windows) through the Control Panel, System applet. I'm assuming you're on Windows because o...

That's slightly misleading documentation; it should really say "the process" rather than "the user". Named COMMON is deallocated when the process finishes; in DataStage this means effectively when the active stage finishes, or when the job finishes if the COMMON is allocated in a before-job or after...

The Director has a filter which, by default, shows the 100 most recent events. You can invoke the filter via Ctrl-T, by choosing Filter Entries... from the View menu, or by right mouse click in the Log view and choosing Filter from the pop-up menu. Can't really help much with the PX problem, except ...

Welcome aboard! :D Search this forum for topics like "delta" and "changed data detection" or "CDD". You will find a wealth of information. If the records in the source systems have a column named something like "Update Date", then it's a simple matter of having your extraction phase constrain on tha...

Which set is that? On AIX the set command does not appear to have a parsing function. It appears to be a synonym for the env command.