DSXchange

That's right, multi-row return from reference lookup is supported in ODBC and UV stage types. Search the forum or consult on-line help for more information.

Three separate views?

You will probably find it easier leaving everything of data type numeric. All you need is a suitable If..Then..Else, and plain arithmetic.

Not unless you can specify where they (the delimiters) should be. A DataStage job may actually be easier than a script for this task.

This is a database (permissions) problem, not a DataStage problem. Get your DBA to tell you what error code 290 means. Ask in the context of tablespace management.

Go wrong?!! Moi?!!

Search is your friend. This has been answered multiple times in the past.

Is there any clue in the data to guide you to discern from which member a particular row comes?

... and you can invoke Help from there via the F1 key.

In that case you don't need the "Yes"/"No" flag.

You're going to have to execute a different script from DataStage, one that establishes a sqlplus session and can itself run the SQL statements in the other file. Use the -s option for sqlplus.

The DB2-Connect software is very similar, under the covers, to the ODBC API, at least for the data access parts, so you can probably get it to work. But, as "they" say, it won't be supported. If (when) you do get it to work, their spin doctors will then tout it as a feature!

Chandra, do you have any measurements to prove this assertion? IBM claims to have made substantial performance improvements to the Transformer stage in version 7.5.1.

Posting in the appropriate forum (the one for parallel jobs) would be a good start. Each forum has a statement of its purpose on the Forum screen, and in a sticky at the beginning of posts within the forum. Do you have a preferred stage type (Modify or Transformer) to accomplish this task? The answe...

I never get the same problem, because I don't try to force DataStage to do anything illegal.