All Forums Teradata Applications
prashanth.bose 4 posts Joined 03/10
15 Mar 2010
Dynamic Cursors

i have couple of questions:

how to pass queries in the procedure ( i would be passing different queries at different times)
execute them as cursors
how to find out the no of coulmns in the cursor and fetch them into strings or array( as no of columns in the queries would be changing each for each call)

Please let me know how to do the above things using teradata procedures.....

Thanka in advance.......

Prashanth Bose
Adeel Chaudhry 773 posts Joined 04/08
01 Apr 2010

http://forums.teradata.com/forum/analytics/how-to-fetch-rows-from-a-teradata-cursor-when-i-am-not-sure-about-no-of-columns

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.