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.