Archives of the TeradataForum

Message Posted: Fri, 21 May 2004 @ 08:43:00 GMT

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

Hi Guys,

Anyone know how to display the out parameter after a call to a stored procedure? It would be ideal if I could do something like the following in QueryMan or BTEQ.

     declare outVariable;

     call myProc(outVariable);

     print outVariable;

This is of course just pseudocode as I know declare only works in a stored proc and there is no print statement (although strangely enough the compiler doesn't complain about the print keyword in a stored procedure...).

Sonny.

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