 |
 |
Archives of the TeradataForum
Message Posted: Tue, 16 Dec 2008 @ 17:08:43 GMT
| Subj: | | Re: %TYPE and %ROWTYPE equivalent in Teradata |
| |
| From: | | Victor Sokovin |
| | How can we achieve this in teradata? Is there any equivalent functions avl? | |
No, there is none.
| | Or we have to declare all the variables explicitly? | |
Yes, and you could probably do a parsing exercise in your wrapper scripts and use such Teradata functions as TYPE(table_name.column_name) to
determine the data type of each column and then assign it to the cursor variable without really hardcoding the data type.
But then again you could just design a *Teradata* application and forget altogether about porting the Oracle code. In my opinion, there is
absolutely no benefit in the latter.
Victor
| |
