All Forums Database
GuptaLav 1 post Joined 06/15
04 Jun 2015
Reg Rules and Limitations for Dynamic Result Sets

Hi Guys,
There is a requirement ..where in we have to create 2 Stored Proc ;
SP1-- Returns dynamic result set (multiple rows/multiple colums) as output via cursor.
We want to create another SP2 (wrapper SP ) which should call SP1 internally , and returns resultset of SP1 as SP2 output...is it possible..?
We are using TD.14.10.
Please share some sample example...
 
Thanks,
Lav

dnoeth 4628 posts Joined 11/04
05 Jun 2015

Hi Lav,
have a look at ALLOCATE:
http://www.info.teradata.com/htmlpubs/DB_TTU_15_00/index.html#page/SQL_Reference/B035_1148_015K/ch03.139.001.html

Dieter

You must sign in to leave a comment.