Forums Register Login

Rownum in DB2 V 7.2 - Mainframe

+Pie Number of slices to send: Send
Hi,
What is the equivalent for romwnum for DB2 V 7.2 mainframe. row num works for versions 8.0 and higher and not for 7.2 version on mainframe.
+Pie Number of slices to send: Send
+Pie Number of slices to send: Send
I tried it before and both rownum and fetch would not work.
+Pie Number of slices to send: Send
The query
Select * from table fetch first 20 rows ONLY seems to be working. The query runs only if the key work "only" is present.

Thanks guyz!!!
My honeysuckle is blooming this year! Now to fertilize this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1243 times.
Similar Threads
Connection from datasource in WSAD to connect to DB2 in mainframe SQLSTATE=58031
stale jdbc Connection
2 phase commit
Calling DB2 stored procedures
WSAD db2 driver failure.
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 08:24:59.