DSXchange

Do you have DB2 client software installed on your PC? As far as DB2 is concerned, a DataStage job is just another client application. If the answer is yes, get your DB2 DBA to verify that it is configured correctly.

FEMS sends OIM XML via MQ to WWPRT RDBMS with BRL for CBS

You have been detected as a Government or military employee.
Windows will now enter sleep mode.

These can be selected from the expression editor in 7.5 and later.

They can also be used in 7.0 and later, but have to be typed in.

Yes, but not recommended. Separate IDs mean that you can easily track who did what, when it comes time to allocate blame. Or praise.

Prefer DataStage constants. "They" may change the actual values.

If Oracle does not generate the information you are going to have to do a whole lot of testing to ensure that constraints aren't violated (and so on) before sending the row to Oracle. And if you're going to go to that amount of trouble, you may as well reject the row straight away rather than sendin...

Messages of that kind usually indicate either an index on a Repostitory table that needs re-indexing, or possibly a corrupted SYS.MESSAGE table. In the latter case, however, you typically get only the error code between the brackets, for example [81012].

I suspect (from the contributors list) that Sudhakar was trying to post an FAQ.

If someone has an answer they will post. Don't push.

If you want urgent responses, sign up for premium support from your support provider, and learn the true cost of "urgent".

This is an all volunteer site.

Anything that generates unexpected output (that is, more than "started" and "finished") in the DSD.StageRun file in &PH& will cause the contents of that file to be logged as a warning.

This behaviour continues to be the case in 7.5 and 7.5.1.

Passive stages don't have row counts.

Active stages have row counts, and links have row counts.

Passive stages merely expose methods that active stages invoke to move data to and from persistent storage.

Welcome aboard. :D

What "experts"?

Correction from my side regarding the way the job looks like, actually the link for the sequential file is coming from transformer not from the source. which i couldnt represent here. thanks rajesh Wrap your diagram in code tags, and use Preview to get it right. SOURCE ---> TRANSFORMER-----> DATABA...

No you didn't. You replaced it with a zero-length string. This is not the same as null.

Null is "unknown". To replace with null you would have used the system variable @NULL, and rendered your result unusable.

A lookup IS a join. A lookup is a left outer join, in that it returns NULL if the lookup does not succeed. You can convert this to an inner join by constraining the Transformer output to only those rows for which the lookup succeeded. However it is not possible to achieve a full outer join (or a Car...