Archives of the TeradataForum

Message Posted: Wed, 06 Nov 2002 @ 11:11:55 GMT


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

Subj:		Re: How to display a record set using Stored procedure

From:		Dennis Calkins

Syed Arifuddin wrote:

How can i display table content as a record set in Teradata? I am writing a stored procedure which contains bussiness logic and basically i want to display the table content as a recordset which is generated inside a stored procedure.Your help in this regard will be highly appreciated.

Hi,

You do a select after the call returns

Call sp1;
sel * from sp1_results;