 |
 |
Archives of the TeradataForum
Message Posted: Thu, 23 Mar 2006 @ 14:32:09 GMT
| Subj: | | Re: Passing SQLSTATE in Stored Procedures back to BTEQ? |
| |
| From: | | Geoffrey Rommel |
> call sysdba.collect_stats('dba_tool','dw_ops_stats_hist','testing');
> *** Failure 5628 collect_stats:Column testing not found in
> dba_tool.dw_ops_stats_hist.
| | So it does return an error code appropriate, it seems. | |
Just to clarify, the stored procedure is not returning a value. The error code is coming from the CALL statement. It gets the job done,
though.
| |
