Recommendations on Use of Rowid
It is recommended that application developers use primary keys as a method of access rather than rowids. Because primary keys are defined in the ANSI specification of SQL, using them to access data makes your applications more portable.
For a complete description on how to define and use primary keys to access data, see the HCL OneDB™ Guide to SQL: Reference and the HCL OneDB Guide to SQL: Tutorial.