ROWID

DB2 mode only. Data type is integer. Contains the physical row number of the current record. The XDB Server reports this value when a referential integrity error occurs or when a duplicate value is detected in a unique index. You can use ROWID anywhere an expression can be used. For example:

SELECT * FROM CUSTOMER WHERE ROWID = 22;

gets the record in physical row 22. And,

SELECT ROWID,NAME,ADDRESS, FROM CUSTOMER;

gets the row numbers along with other fields in the CUSTOMER table.

When ROWID is used with a join, it represents the row number of the first table in the join.