Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 19 Mar 2003 @ 13:54:41 GMT

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

Subj:   Re: Two questions
From:   Geoffrey Rommel

[From another thread:]

  But how I can check "NUM" value which is the output of stored procedure.  

  First - can I call a stored proc that has an output parm from queryman and if so, how?  

Call your stored procedure with the exact name of the output variable, and the answer will be returned to bteq or Queryman. For instance, if your procedure is defined like this:

create procedure testproc01
(out delphic_reply varchar(6))
begin ...

you must call it like this:

call testproc01(delphic_reply);

The result will then show up like any other result. Only one row can be returned per call.

  <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: 28 Jun 2020