Search found 2 matches

by henryb01
Tue Jun 15, 2004 7:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Did you know? Running Oracle blocks, trapping rejects &
Replies: 5
Views: 4872

I should have noted that this is a Target/Update Oracle OCI. My 'update action' is 'user-defined sql'. Ideally I would like to put my begin/end block in the user defined tab of the SQL tab but I get the following error when I try that: "%1 is not supported for pre-defined update action". I...
by henryb01
Mon Jun 14, 2004 11:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Did you know? Running Oracle blocks, trapping rejects &
Replies: 5
Views: 4872

Does this technique work on version 6?

I have tried using a begin end block but I get a runtime error. The code works fine when we don't have the begin/end portion. But I would like to use your technique for trapping errors. Any ideas what my problem might be? Or does the begin/end only work in version 7? Here is the runtime error: HRMS3...