Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 01 Jul 2003 @ 15:31:36 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Type "Cursor" is not available
From:   Shweta Agrawal


I am working on Teradata version VR4.1

"Declare Cursor" doesn't work on it.

The "For Cursor" statement works fine but for "Declare Cursor" it gives me an error saying type "cursor" is not available. Surely, it is taking "Declare cursor" statment as a variable declaration statement. Though the statement and its use are given in the Server's own documentation cd.

Now my problem is that if i use "for cursor" statement instead of Declare Cursor, the query become more expensive. As i have to access the rows randomly. I am doing TPC-H benchmarking of the performance of server and this is needed for the Refresh query RF1, so is itok to compromise with more expensive construct.? Is there any other clause that can work as an alternative. Or any patch or upgrade that can let me use the "Declare Cursor" statement.


- Shweta


Shweta Agrawal
Roll no. 02329013
MTech in IT, KReSIT,
IIT Bombay.

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