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
