Search found 1 match

by philip_shajee
Mon Mar 24, 2008 2:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Only inserts through Oracle Enterprise stage
Replies: 18
Views: 7323

vnspn wrote:But, this doesn't sound correct.

If we have Insert statements at both Insert SQL and Update SQL, then the same row it going to get inserted twice, is it not?
The update SQL will get executed only if the Insert SQL fails.