"After" script in a Oracle Plugin
Posted: Sun Oct 05, 2003 2:18 pm
Greetings,
My mapping has a output OCI Plugin and I populate my target table there withe several source tables. In the "After SQL" tab I have a update script that updates one of my target columns to Zero if it NULL.
When I stop this job for some reason I find that the job comes to the "Aborted" state but the target table is getting locked. I am afraid it is bcoz of this After script.
Will DS release the table b4 it comes out of the thread. This is happening for lot of jobs. Kindly advice.
Is it advisable to have scripts is Before/After.
Thanks,
Badhri ...
Badhrinath Krishnamoorthy
www.cognizant.com
My mapping has a output OCI Plugin and I populate my target table there withe several source tables. In the "After SQL" tab I have a update script that updates one of my target columns to Zero if it NULL.
When I stop this job for some reason I find that the job comes to the "Aborted" state but the target table is getting locked. I am afraid it is bcoz of this After script.
Will DS release the table b4 it comes out of the thread. This is happening for lot of jobs. Kindly advice.
Is it advisable to have scripts is Before/After.
Thanks,
Badhri ...
Badhrinath Krishnamoorthy
www.cognizant.com