Query to retrieve first 7 rows.

Anuj Dhawan · Posted: Thu Sep 04, 2008 1:33 pm

Hi Prasad,

Is your last post in continuation with the first post of this thread ? However, check these link if they serve the purpose -

ibmmainframes.com/viewtopic.php?t=27071&highlight=row
ibmmainframes.com/viewtopic.php?t=25806&postdays=0&postorder=asc&start=15

dick scherrer · Posted: Thu Sep 04, 2008 7:35 pm

Hello Prasad,

First - when you have a new question, you should start a new topic for your question rather than reply to some existing topic.

Second - as you will learn if you contnue to work with databases, there is no such thing as "first 7 rows". You might retrieve some 7 rows, but there is nothing automatically "first" about them. If you read the same sequential file 5 times, the first 7 records will always be the first 7. If you read a table 7 times, the first 7 rows may or may not be the same ones each time.

shabir46 · New User Joined: 24 Jan 2008 Posts: 6 Location: Kerala

Hi Prasad,

If you want to just retrieve the first 7 rows from a table, you can use the 'FETCH FIRST 7 ROWS ' command to serve the purpose.

Or if you want to do achive the same purpose through a program, then you can use the cursor and use the cursors iteratively to get 7 rows.

Shabir

Anuj Dhawan · Posted: Fri Sep 05, 2008 7:10 pm

Hello,