Using ROWNUM and DUAL in DB2 9.7

The ROWNUM and DUAL supports are enabled by setting the DB2_COMPATIBILITY_VECTOR registry variable to ORA.

Oracle programmers use ROWNUM quite often to retrieve a controlled number of rows from a SQL statement. The same can be applied in DB2 9.7.