Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 02 Jun 2010 @ 15:29:27 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Setting Stored Procedure Exit Status ??
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, June 02, 2010 10:59 -->

Thank you for the reply, but I don't quite understand the statement, " You can also cause an intentional error if you think it should stop say 1/0 will raise an error."

How can we cause and 'intentional' error and if we do, what do we check for in the BTEQ script that called the Proc when it returns?

e.g. in a BTEQ script we code the folowing:

     CALL mydb.purge_data ( "MEG"  /* OUT: VARCHAR(1000), nullable */ );

When we return to the script, what would we code to detect that the proc 'logically/physically' aborted so we could terminate it with a .QUIT 8 - for example"

Sorry if I'm not making this clearer - apologies.

  <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