IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Stop after command in DB2 SQL query
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
vik775

New User


Joined: 10 Jun 2006
Posts: 1
PostPosted: Sat Jun 10, 2006 2:23 am
 Reply with quote
I want run a query from SPUFI to select only 10 records instead of thousands that it will return. Is there a row limit or Stopaft in DB2 SQL?
Thanks.
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA
PostPosted: Sat Jun 10, 2006 2:53 am
 Reply with quote
Last line of your SQL:

FETCH FIRST 10 ROWS ONLY

Dave
Back to top
View user's profile Send private message
anamikak

New User


Joined: 10 May 2006
Posts: 64
Location: Singapore
PostPosted: Tue Jun 13, 2006 4:04 pm
 Reply with quote
In SPUFI option you can specify the rows to be 10 or whatever number instead of the default mentioned there.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts RACF - Rebuild SETROPTS command which... All Other Mainframe Topics 3
No new posts Routing command Address SDSF to other... TSO/ISPF 2
No new posts DTL - how to define key with stacked ... TSO/ISPF 3
No new posts LTJ command CA Products 4
No new posts RC query -Time column CA Products 3
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us