Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 30 Jan 2003 @ 21:01:56 GMT


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


Subj:   Capturing Store Procedure error codes
 
From:   Gorrella, Srini

Hi,

How can I capture SPL compilation Error Codes ,when I'm compiling Stored Proc thru JCL on Mainframe

I'm using the following JCL

//BTQDDL1 EXEC PGM=BTQMAIN
//SYSTERM DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
.LOGON username;
.COMPILE DD = PROCCODE;
.IF ERRORDODE >0 THEN .QUIT ERRORCODE;
.LABEL ERRMSG1;
.REMARK 'ERROR INFORM DBA';
.QUIT ERRORCODE;
/*

I got some compilation error codes but still my JCL is returning with error code as 0 .

Can anyone help me out here .


Thanks,

Srini



     
  <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