Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 06 Jul 2004 @ 09:25:02 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Macro Failure using BTEQ..
From:   Arnaud_Balat

A quick look at the NCR documentation on the BTEQ utility would describe you all the commands and more specifically the EXIT command to use as below:

After your exec statement add the line:

     .exit errorcode

With errorcode being the error code generated by the last Teradata SQL request.

If you run more than one macro in your bteq, you might want to play with the ERRORLEVEL command as well.


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