Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


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

Hi

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.


Regards

- Shweta

--

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



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