DSXchange

If we are using multi node configuration file in DS job, for Join Stage shouldn't we partition the incoming links in HASH mode and on the same key ? Also if Join Stage has all the links coming from Database tables then from perfomance point of view is it a better idea to use Database Stage with Quer...

[quote="ray.wurlod"]Welcome aboard. :D If you draw a reject output link from the DB2/UDB Enterprise stage, the columns from the input link will automatically appear. An additional column, called sqlcode, will also ...[/quote] Ray , Thanks for your input ! How we can add new sqlcode column ...

Hi , Can somebody tell me how to trap Database Errors using UDB Enterprize Stage ? If we use API stage then Datastage director throws out DB Error Code. But for UDB stage it doesn't happen...Is there some config setting we have to do so that UDB EE stage also throws out extact DB error code. Thanks ...