I am trying to run the following query on DB2 on Mainframe:
"SELECT rownumber() OVER (ORDER BY ANSWEROPTION) as row_next,
ANSWEROPTION FROM BHF.VRAT018_ANSOPTION order by row_next"
For this query I am getting rownumber() method not supported. Thismethod is required so that I can get, say 21 to 40 records from database.
Ne ponters?
Regards,
Sameer
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
