Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Query to retrieve first 7 rows.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Prasad Toshniwal
Warnings : 1

New User


Joined: 05 May 2008
Posts: 4
Location: PUNE

PostPosted: Thu Sep 04, 2008 1:01 pm    Post subject: CURSOR query
Reply with quote

Prasad Toshniwal wrote:
If there are 20 rows in one table and i need to retrieve first 7 rows only.How to do this.IS it compulsory to use cursor here and if yes please let me know the query.
Thanks,
Prasad.
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Sep 04, 2008 1:33 pm    Post subject:
Reply with quote

Hi Prasad,

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

http://ibmmainframes.com/viewtopic.php?t=27071&highlight=row
http://ibmmainframes.com/viewtopic.php?t=25806&postdays=0&postorder=asc&start=15
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Sep 04, 2008 7:35 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
shabir46

New User


Joined: 24 Jan 2008
Posts: 6
Location: Kerala

PostPosted: Fri Sep 05, 2008 4:10 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Sep 05, 2008 7:10 pm    Post subject:
Reply with quote

Hello,
shabir46 wrote:
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.
Without an "ORDER By" clause this query would be just garbage..

Check the links posted before in this thread, you would get the reason behind with details..
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Omegamon for DB2 query ashek15 DB2 0 Wed Feb 15, 2017 11:25 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us