What is the error codes tab in ODBC Stage meant for

VasanthRM · Post by **VasanthRM** » Sun Jun 12, 2005 8:16 am

hi,

With the ODBC Stage there is an option for fatal errors and warnings in the error tab.

This option is enabled only when the create table option is checked.

What is the use of it.
In which it can be used extensively ?

elavenil · Post by **elavenil** » Sun Jun 12, 2005 9:00 am

This option is enabled only "Call Stored Procedure" update action selected. And this option is to handle errors that would be occurred while stored procedure getting executed.

I have not got any chance to use this option. So i have no idea when this option can be extensively used.

Regards
Saravanan

ray.wurlod · Post by **ray.wurlod** » Sun Jun 12, 2005 5:01 pm

With Stored Procedures you can generate your own, non-standard, error and warning codes. This tab allows you to specify how DataStage should react when one is encountered. The choices are, essentially, "fail" (abort) or "warn" (log warning message). Although I haven't tried it, it may also be possible to handle errors and warnings generated by DDL statements.