DSXchange

All three stage types support more than two inputs. Which stage type you use depends on precisely how you need to combine them.

Are you using WebSphere Transformation Extender (TX)? If not, why are you posting in this forum?

Look at the generated OSH or the score, and note the schema associated with each virtual Data Set (that is, with the links). From which one has INTEGRATION_ID disappeared? Amend your metadata so that it is there. If it is no longer required, them remove it from any Sort stage or in-link sort specifi...

Very good.

For UniVerse, you use a dssh command or script.

The simplest of these will contain just the SELECT statement you require.

Welcome aboard. This particular forum is for WebSphere Transformation Extender (which used to be badged DataStage but no longer is). Can you please post your question on the forum for DataStage Server Edition? In short, NLS settings do not perform date format conversions of the type about which you ...

Search is your friend.

Losing the belief that a DataStage server can deliver an infinite supply of resources would be good also.

There's no inbuilt function, and if you wrote your own it would need to check all ten as well. So the extended expression with ten Index() functions is about as good as you're going to get. If the data volumes are small (say less than a couple of million rows) you might consider using a BASIC Transf...

You have not told us which database you are using, but the obvious mechanism seems to be an UPDATE statement containing two nested SELECT statements each of which includes a CASE construct to make the Yes/No decision. In DataStage, of course, you could perform lookups to make the decision. But you s...

You don't.

Think about what you're asking. The SQL in a DRS (or any SQL-capable stage) is intended to operate on the rows being processed. How could you guarantee this with "multiple SQL statements"?!

Error rate is probably most easily understood as "the likelihood of error" - to say that you are 90% confident in a result is the same as admitting that there is a 10% probability that the result is not correct. The M probability is the confidence that, if a match is found, it is a match. It is not ...

Insert a Copy, Modify or Transformer stage to convert the VarChar field(s) to Char for fixed-width. Include $APT_STRING_PADCHAR environment variable as a job parameter with its default value set to space if you need padding with space rather than 0x00.

From what stage type are you calling the stored procedure? ODBC? This would mean that you are calling the stored procedure once for each row extracted from the table, presumable expecting one row of "result" in each case? However you have not provided sufficient specific detail to permit more accura...

You need to multiply by 24 after performing the subtraction. DataStage complies with the usual rules for arithmetic operator precedence.

Quite some time. Indeed there will be a 7.5.3 late this year or early next year, according to the roadmap presentation at IoD 2007.

Describe your metadata (table definition).