Search found 1 match

by m.amari
Thu Nov 16, 2006 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reporting error in Batch of a Shell Unix executing sql
Replies: 2
Views: 871

Reporting error in Batch of a Shell Unix executing sql

Hi to all.

I have to launch a shell unix (in a batch) who executes a .sql.
Sql file executes a stored procedure Oracle.

My problem is to return an error message in the batch if anythings goes wrong in the sql ( proc invalid, tables not founded...).

Thanks,
M.