Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 11 Mar 2008 @ 18:16:21 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Stored Procedure Error Handling
 
From:   Bankston, Rob

The continue handler you have is for a Data Not Found situation. Try checking the SQLSTATE instead. SQLSTATE 42000 translates to SQLCODE 3807 which equates to Object does not exist.

     DECLARE CONTINUE HANDLER FOR SQLSTATE '42000'
                       CREATE GLOBAL TEMPORARY TABLE RENUM_CAND
                       (OLD_ACCT_ID CHAR(10) NOT NULL, NEW_ACCT_ID CHAR(10))
                       UNIQUE PRIMARY INDEX (OLD_ACCT_ID)
                       ON COMMIT PRESERVE ROWS;

Rob Bankston
Systems Consultant - Data Warehouse
Unum



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