• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Rownum in DB2 V 7.2 - Mainframe

 
vaithee sub
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 221
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is this applicable?
 
vaithee sub
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I tried it before and both rownum and fetch would not work.
 
vaithee sub
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic