Archives of the TeradataForum

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

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

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