--- Begin Message ---Shaunn,The Select Statement fetch-first-clause, "fetch first n rows only", is in Version 7.
I don't know if an APAR can be applied to Version 6 to get this clause added.HTH
Leo Flores
"Johnson, Shaunn" wrote:
Howdy -
I'm connecting to DB2 via a command line processor for DB2 SDK 5.2.0
connecting to DB2 version 6.1.2 residing on OS/390.I want to simply do a select from a table and only get a few rows (maybe 10),
but I keep getting errors:[snip]
db2 => select c_marked from hgl0000.htgl0010_XXoot fetch first 10 rows only ;
SQL0199N The use of the reserved word "FETCH" following "" is not valid.
Expected tokens may include: "FOR WITH ORDER UNION EXCEPT QUERYNO OPTIMIZE ".
SQLSTATE=42601[/snip]
What am I doing wrong? I thought FETCH was a real command (at
least, that's what I am seeing at some of the documentation / sites
I am visiting.Suggestions? TIA!
-X
--- End Message ---
- [DB2EUG] selecting a limited number of rows from DB2 Johnson, Shaunn
- Leo Flores
