CURSOR to fetech only first 20 rows.

Prasad Toshniwal · New User Joined: 05 May 2008 Posts: 4 Location: PUNE

Hi,

There is one table containing 50 rows and i want to fetech only first 20 rows.

Is it necessary to use cursor here if yes then what would be my query and declarations if required.

Thanks,
Prasad

anil.csk · New User Joined: 22 Oct 2007 Posts: 16 Location: Noida

when you go declare the cursor
declare a1 cursor for select .....where ... for fetch first 20 rows.

Prasad Toshniwal · New User Joined: 05 May 2008 Posts: 4 Location: PUNE

Anil,

Thanks. As i am new in DB2 could you please elaborate more on this.

Thanks,
Prasad Toshniwal

expat · Posted: Thu Sep 04, 2008 1:50 pm

Prasad Toshniwal

Please post in the correct forum.
Topic moved to the correct forum.

anil.csk · New User Joined: 22 Oct 2007 Posts: 16 Location: Noida

hi,
use the given link that will be use full for you for the cursor understanding.

publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/c0005280.htm

umasankar.eee06 · New User Joined: 04 Sep 2008 Posts: 11 Location: chennai

Hi prasad,
U can use OPTIMIZE FOR 20 ROWS in fetch declaration.