DSXchange

Make sure that the last line in .odbc.ini has a line terminator.

Sparse lookup is only supported for Oracle and DB2 stages.

Windows XP is not a supported operating system for Information Server (other than for the client tier, and WAS is not part of the client tier).

You have provided no information about your job design. Your question is akin to "there's a red light showing in my car" with no other information.

Please remedy this deficiency, also advise whether there are any other errors or warnings in the logs prior to the ones you posted.

Please advise the data types of the non-grouping columns, what set operations you're performing on them, and whether you are used either of both of the Preserve Type and Decimal Output properties.

To do a lookup against a hashed file there must be a reference link from the Hashed File stage to a Transformer stage. A link from a Hashed File stage to a Sequential File stage is a stream query from the hashed file.

Use consistent link naming conventions, then you can interrogate the link row counts using a single generic routine.

No idea. It's YOU who is mucking around with STAGECOM.ARR - it's YOU who must decode whether what you're doing still maps onto the same structures as it used to in the Transformer stage code. I don't have your code, only you do.

I'm not sure if I'm missing something here. Following the clarifications, it seems to me that you need two outputs - one where the IDs match and the other where they don't. You even provided the logic yourself. But you don't need any code - just create a Transformer or Filter stage with two outputs,...

Is it because COL1 appears twice in the SELECT clause?

Can you execute this query from sqlplus or some other client?

KeyChange comes from the upstream Sort stage in what I was thinking.

You can generate key change detection within the Transformer stage using two stage variables, one to detect the change and another to "remember" the key from the previous row.

No-one has marked it as Resolved.

DSODB is the DataStage Operational DataBase, which supports the Operations Console. I have not investigated version 9.1 in sufficient detail to state whether STAGECOM.ARR still has the same structure as in earlier releases - every time we've mentioned it in the past we've asserted that the vendor do...

If that's your entire routine you need to replace ":=" with "=". The ":=" operator assumes that Ans already has a value to which you wish to concatenate the right-hand operand. Does this routine have arguments JOBNAME and STAGENAME? Can you test the routine OK using the...

With 2GB RAM I'd be surprised if Information Server even installed!