How do you code a literal constant that represents a ROWID in IDMS?
Release : All supported releases.
Component : IDMS/SQL
The form of a ROWID literal is X'0125A50100010008'.
The 0125A501 is the database key, the 0001 is the page group, and the 0008 is the radix (number of bits in the line index).
For example, it can be used in the SET clause of an UPDATE like this:
UPDATE EMPNET1.DEPARTMENT SET DEPT_NAME_0410='XXX'
*+ Status = 0 SQLSTATE = 00000
*+ 1 row processed