DSXchange

A routine must return its result through a variable called Ans- your routine code does not appear to assign a value to this variable.

That sounds like the Engine directory has been damaged, corrupted or moved. I haven't got access to DataStage this week (doing something else). Contact your support provider to learn what code UVI0001 means. For example, has someone removed the hidden file /.dshome ? Has someone moved the DS Engine ...

DS_LICENSE (among other things) records when each client is connected, so is updated when any client connects or disconnects. All of the entries in catdir are object code - the ones you've listed are used when DataStage jobs run (for example $DS.SEQOPEN opens a file from a Sequential File stage). Th...

EREPLACE is less efficient than CONVERT where appropriate to use it. CONVERT performs character-by-character conversion. EREPLACE replaces one substring with another. You can use CONVERT to replace single characters with other single characters, including "". However, if you want to replace one or m...

A job can't attach to itself for the simple reason that it already is attached to itself! You can use DSJ.ME for the job handle argument (always the first argument) in the DSGet... discovery functions. The structure of the repository is scheduled to change; in the Hawk release (Sep 2005) if all goes...

There are also scripts to let you set and reset impersonation mode (for that is what it's called), in the sample directory.

No. It suggests that the indexing in the project you're looking at with Manager or Designer needs rebuilding (search for DS.REINDEX). Version Control uses a different project; I'd guess that the indexing there is intact.

The columns, including their derivations, are properties of the LINK, not of the stage. Therefore, if you drop the columns - from either end of the link, the derivations are lost. I believe, without having the ability to test it this week, that the same is true even if you overwrite the column infor...

You'll find REMOVE statement in the DataStage BASIC manual. It picks one element at a time from a dynamic array. The SETTING variable indicates what level of element was chosen; 0 indicates end-of-list.

Can you ask the technical dude and let us know? That way your pioneering efforts won't be wasted!

Even though you're on UNIX, removing CR as well as LF is not a bad move, since the original source could have been a DOS file. If it wasn't then there aren't any CR characters, so there's no harm done.

Jobs are stored in DS_JOBS. It's the table that maps job names to job numbers. It does not record instances. Being capable of running in multiple instances is a property of the job; the individual instances are not separate jobs. Instances are run-time, not design-time, properties, and so are stored...

It will work in all versions from 1.0 through 7.5.

You have to tell DataStage which are the search keys, as opposed to the primary key(s). Any column that is constrained, mark as Key. Any column that is not constrained, mark as not Key.

The Dynamic Relational Stage always displays SQL with Oracle (positional) parameter markers, even though it uses the correct ones "under the covers". However, the poster specifies that an ODBC stage has been used. The SQL was passed through to DB2 (the message came back from the database, not from t...