Close Comman in ODBC Enterprise

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
Apotluri
Premium Member
Premium Member
Posts: 25
Joined: Sun Dec 25, 2005 10:38 pm

Close Comman in ODBC Enterprise

Post by Apotluri »

Hi all,

I am using ODBD enterprise stage to load the target oracle table, which invloves Inserting new records and updating the existing.

Now, the user have come up with a requirement that has to Update the table with a different logic after the load is completed, Can I use the Close Command Option to update the records after the Insert and Update action is completed?

The Information for the Close Command is "Type: String
SQL statement to be executed before insert array is processed. This statement is executed only once on the conductor node.", so, I am not sure if the Close Command will execute after the actual insert/update action is committed?

Please help.

Thanks, as always.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

ProfileStage?

Moderator: please move to Parallel forum
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply