Archives of the TeradataForum
Message Posted: Thu, 07 Feb 2008 @ 13:23:06 GMT
| Subj: || || Re: Teradata Stored procedures - Cursors |
| From: || || Victor Sokovin |
| ||I hear a general opinion that Teradata stored procedures are not standard ones (when compared to procedures in other DBs). If the issue is
to deal with Cursors, can any of you list what kind of issues we will run into?|| |
I am not aware of any generally accepted standards for stored procedures. SP are vendor specific extensions to the minimal SQL kernel, which
indeed get more and more standard thanks to the efforts of ANSI, vendors and user communities.
Teradata SP may strike you as minimalistic in their functionality if you come from the Oracle or SQL Server background; or they won't strike
you as such if you are from the Sybase world. So, it depends.
Now, the cursors. Teradata is used to store large amounts of data. Opening cursors on large tables is probably not a good idea but using them
for small tables should be fine if you really need record-by-record logic in your application and if you do not expect a lot of ready-to-use fancy