![]() |
I'm attempting to develop a stored procedure that takes a table name as a parameter, and performs column-by-column updates to whatever table is passed in. I have the dynamic SELECT query working correctly: SET CURSOR_SQL = 'SELECT * FROM ' || P_TABLE_NAME || ' ORDER BY rsid;'; Now I'm at the point where I need to fetch the cursor data into local variables...but I can't create table-specific local variables because I don't know what tables will be passed into this procedure.
01 Aug 2011
| 4 comments
,
|
![]() |
Hi, I'm new to Teradata but am in the process of converting all of my SQL to run on my new Teradata App db.... I have a SQL snippet loop query that runs on SQL Server but it will not run as is on Teradata. I think I need to do something with cursor but am unsure. Can someone tell me how to convert this statement to run on Teradata? Thanks in advance. CD1: UPDATE NFAA_TABLES.NFAA_REGIONCD
01 Jun 2010
| 4 comments
,
|
![]() |
i have couple of questions: how to pass queries in the procedure ( i would be passing different queries at different times)
15 Mar 2010
| 1 comment
,
|