Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 29 Mar 2004 @ 19:41:38 GMT


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


Subj:   Re: Queryman error trapping
 
From:   Jim Downey

This is what I use:

.LABEL XXXX050100
.SET ERRORLEVEL 3807 SEVERITY 0
RELEASE LOCK WORKDB.ET_DATA
,       OVERRIDE
;
.IF ERRORCODE=3807 THEN .GOTO XXXX050199
DROP TABLE WORKDB.ET_DATA
;
.LABEL XXXX050199
.SET ERRORLEVEL 3807 SEVERITY 8

The first .SET makes 3807 a non error...(the message still displays). The .IF statement bypasses code that depends upon the table being present. The last .SET turns the severity back to be condition code 8 (Each script resets any variables that have been changed)


Jim



     
  <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