|
|
Archives of the TeradataForum
Message Posted: Tue, 26 Oct 2004 @ 19:09:40 GMT
Subj: | | Re: Stored Procedure: Error Raising |
|
From: | | Sappal, Neeraj |
BTEQ provides capability of reporting an error to the script and even it can stop the job if it encounters an error. This is how we implement
in ETL strategy where we run multiple procedures in serial. Our ETL does not support the exact error messages to be sent to the user. The error
messages are stored in the job log tables and we check the details from those tables if any of the job fails. Even in case exact error is received
by the users, they would still require to check the details of data to find exact problem.
Thanks.
| |