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
OracleConnectorPX stage to run PL/SQL
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers