0 - 4 of 4 tags for cursor processing teradata stored procedures

Hi Folks,

I want to create a Stored Proc wherein I will first find a list of tables to be dropped as :

Hi All,
I need your help in converting FLAT LOGIC(Flat SQL) Stored procedure to a SET LOGIC(SET SQL). From what I understand, a Flat logic is a cursor based SQL while SET logic works on sets of data. 

Hi i have a cursor which returns me the date.
Belwo is the sample

FOR Cur_Dt AS Cur CURSOR FOR

SELECT STRT_DT

FROM table

WHERE STRT_DT

BETWEEN 1900 -01  01

AND 9999 01  01

 

Now i have a dynamic SQL..

Hi,
 
I have to create a stored procedure which returns resultset. Common answer to this was the usage of cursor inside the stored proc. I have few questions on using cursors inside stored procedure.
My first question would be Is there any other means by which we can return a resultset from a teradata stored procedure ?