DSXchange

If you saved as CSV why are you trying to open a TXT file? If you saved as CSV from Excel giving the name CORAM.TXT Excel would have created CORAM.TXT.CSV Error code 2 means "file not found". That means that CORAM.TXT is not in the directory. Look there to see whether CORAM.TXT.CSV or CORAM.CSV is t...

Even PeopleSoft were able to be convinced that it couldn't be automated. And they do have buckets of money they could have thrown at it.

A quick thought, with no detailed thought. How about aligning the two Transfomer stages horizontally, with Collate_balancing_entries above and Collate_GL_entries below? You should be able to resize the link collectors horizontally too, so as to spread out the link labels. Put the hashed file stage b...

The UNIX hostname can be used in the SMTP Mail server name on a UNIX machine - each UNIX machine (if so configured) can be its own SMTP mail server.

What I suspect is happening here is that, when the job has finished writing to the text file, it closes the input files; therefore when it tries to get more information to load into the hashed file, it finds the file closed. The design that uses a Transformer to split the single output from the Merg...

To clarify, DataStage does not support routines with a variable number of arguments. Therefore, as others suggested, you can pass to (or from) any argument a delimited list. The routine (or caller) needs to parse the list. If the delimiter is a dynamic array delimiter character (for example, @FM) th...

The error message, as you can see from its tags (in square brackets) is being generated within DB2. Talk with your DBA about possible causes of deadlocks and timeouts, such as other operations happening in the database. I was once badly bitten because overnight batch update processes were run, about...

I just wanted to check that the OP was across this!

I've found that it's OK to put the server's host name into the SMTP Mail server name field in the Notification Activity.

A slightly better library is here (these cover the most recent UniVerse version on which DataStage was built). Note that there are some commands that are explicitly blocked in the Administrator client's command window. These include: LOGTO (don't know why - this was not blocked in 4.2) HELP (because...

Silence on the forum usually means one of three things. (1) no-one knows the answer (2) someone is thinking about the answer but hasn't got there yet (3) someone who knows the answer has not logged in again yet This forum is NOT a support organization. If you want support, go to your support provide...

I'd opt for a solution that prepared data files for SQL*Loader, then use that actually to load the Oracle tables. What volume of data do you consider "huge"? I note that you are claiming to be running parallel jobs on Windows. Is this really the case? Finally, please don't post the same question mor...

Hashed file lookups are by primary key. Primary keys can not be null (by definition). Likewise the primary keys in your tables can not be null. Therefore how are you getting nulls? You load the key value from your table into a hashed file. You perform a lookup against the key. It is either found (an...

Given that you are only using the NEXTVAL property of the sequence within the SQL there is no reason to believe it's anything within DataStage. Could any other Oracle user - even you - be doing SELECT SEQ_ASYSCORPSK.NEXTVAL FROM DUAL; to check what is happening? This also increments the sequence. If...

You might be inspired by a BAT file for finding the DS Engine directory on Windows.