Dynamic Cursors

Teradata Applications

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.......

1 REPLY
Teradata Employee

Re: Dynamic Cursors

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