wood burning stoves 2.0*
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
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!!!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Rownum in DB2 V 7.2 - Mainframe
 
Similar Threads
2 phase commit
Calling DB2 stored procedures
Connection from datasource in WSAD to connect to DB2 in mainframe SQLSTATE=58031
stale jdbc Connection
WSAD db2 driver failure.