DSXchange

Hi All,

I want to run a Merge query in the Oracle connector PX stage and get the number of records processed in the director log.

The PL/SQL block runs fien but in the director we can only see.
"Number of records processed by the PL/SQL block on the current node: 1."

How can i get the output of the block in the director saying : 9 records merged.

Can this be done.

Thanks,
Samyam

You can't. Strangely enough, I just had this exact same conversation with a co-worker yesterday. All of the MERGE processing happens inside the database completely out of sight of DataStage, all it knows about is the one record that triggered the procedure / anonymous block.

Perhaps it could be engineered to write those results out somewhere, say perhaps a flat file? Then something after job could read the file and use DSLogInfo() to get it into the job's log.