Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 07 Feb 2008 @ 13:23:06 GMT

  <Prev Next>   <<First <Prev

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


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019