Archives of the TeradataForum
Message Posted: Tue, 01 Jul 2003 @ 15:31:36 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|