Im trying to retrive N rows from a select, but in DB2 version 6. It not alowed to use the "FETCH FIRST N ROWS ONLY" sintax and it do not recognize the ROWID or ROW_NUMBER() columns ou functions. I need do this in one SQL request. Another case is that should run without using any PK or similars. Example:
SQL Server: "SELECT TOP N * FROM (select * from table_a)"
Oracle: "SELECT * FROM (select * from table_a) ta WHERE ta.rownum <= N
Whether ur shop wont update the versions r not??? bcz v r not clear with ur requirement... so without that RowNum,Fetch facility the only way is Primary key.. u too locked that.. then how my frnd..?????