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

ABT "FETCH FIRST 5 ROWS ONLY"


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ysuryawanshi_mcs
Warnings : 1

New User


Joined: 25 Mar 2006
Posts: 15
Location: pune(India)

PostPosted: Tue Apr 18, 2006 7:22 pm
Reply with quote

SELECT * 00010
FROM DEPT 00020
FETCH FIRST 5 ROWS ONLY; 00030
---------+---------+---------+---------+---------+---------+---------+-------
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "FIRST". SOME SYMBOLS THAT
MIGHT BE LEGAL ARE: UNION
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHSM1 SQL PROCEDURE DETECTING ERROR
Back to top
View user's profile Send private message
a1javeed

New User


Joined: 10 Dec 2005
Posts: 20
Location: KUWAIT

PostPosted: Tue Apr 18, 2006 7:59 pm
Reply with quote

hi
may be the DB2 version of urs dosen't support this
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 To get the count of rows for every 1 ... DB2 3
No new posts PuTTY - "User is not a surrogate... IBM Tools 5
No new posts Exclude rows with > than x occurre... DFSORT/ICETOOL 6
No new posts Fetch data from programs execute (dat... DB2 3
No new posts Convert single row multi cols to sing... DFSORT/ICETOOL 6
Search our Forums:

Back to Top