DSXchange

You need to bounce the DataStage server for the change to be of effect.

That is correct. You can use the NullToEmpty or NullToZero. Or you can use NVL in Oracle itself.

As Roy asked, is there a logic? Can one record have max 2 sub-records?

Will all the cols be populated at all time?

Answering these will give better understanding.

Set AutoCommit ON/OFF

Doh!! Unwanted question. Ignorant me.

Craig,

What is a PITA?

Piece of cake...pity work....?

It must be an OR clause. i.e. finished OR finished with warning.

Can you open the sequencer job stage to confirm that the property is linked correctly.

That represents the (one) key value supplied for the reference link.

Both run in the DBMS and hence there is no performance difference. The User Defined SQL can be enhanced by the developer to perform better.

What do you mean by decimal?

If you want to check whether it is numeric or 'non alphabetic', use OConv.

You can use Num() for other situations.

Call the second link for warning and pass to the second job.

There are lots of posts about that in the forum. Search.

You can use DSGetJobInfo from routines. So I wonder why to go for any Utility to call the same.

It appears to raise the problem when writing into an hash file. Check the link/stage LKP_hash_serial_mig_event_class.