This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Rownum in DB2  V 7.2 - Mainframe Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Rownum in DB2  V 7.2 - Mainframe" Watch "Rownum in DB2  V 7.2 - Mainframe" New topic
Author

Rownum in DB2 V 7.2 - Mainframe

vaithee sub
Greenhorn

Joined: Mar 12, 2004
Posts: 20
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.
Horatio Westock
Ranch Hand

Joined: Feb 23, 2005
Posts: 221
Is this applicable?
vaithee sub
Greenhorn

Joined: Mar 12, 2004
Posts: 20
I tried it before and both rownum and fetch would not work.
vaithee sub
Greenhorn

Joined: Mar 12, 2004
Posts: 20
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!!!
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Rownum in DB2 V 7.2 - Mainframe
 
Similar Threads
2 phase commit
Connection from datasource in WSAD to connect to DB2 in mainframe SQLSTATE=58031
stale jdbc Connection
Calling DB2 stored procedures
WSAD db2 driver failure.