Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 23 Mar 2006 @ 14:32:09 GMT

  <Prev Next>   <<First <Prev

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.

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020