Optimize for n Rows

kvivek · New User Joined: 09 May 2005 Posts: 51 Location: Singapore

Hi All,

In the Cursor if we specify OPTIMIZE FOR First 20 ROWS, Does it mean that we could fetch only the First 20 rows and when I try to fetch the 21st record Will it throw End of cursor?

If it is not, what exactly happens when we write OPTIMIZE FOR N ROWS?

Thanks,
Vivek

sivatechdrive · Posted: Wed May 11, 2005 3:07 pm

Hi Friend

i suppose there may not be any error in trying to retrieve the 21st row...
check the site
aurora.vcu.edu/db2help/db2d0/frame3.htm#db2d0168

Regards
Siva