Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 12 Dec 2008 @ 12:49:32 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Help on cursors in teradata
From:   Sridhar Nakka


I am novice to Teradata and here in our company we are migrating from Oracle9i to TeradataV2R6.

In our DW we have PL/SQL for Transformation.

We have lots of cursor used in our scripts.

I want to make those scripts as Teradata specific.

Is there any alternate way where I can implement Cursor logic in ANSI-SQL. I thought of Global Temporary table but It will have storage issue.

If anybody is having any idea or anybody have implemented please let me know.

Thanks in Advance


Sridhar Nakka

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