IDMS/SQL: Coding ROWID literals

Products

• IDMS

Issue/Introduction

How do you code a literal constant that represents a ROWID in IDMS?

Environment

Release : All supported releases.
Component : IDMS/SQL

Resolution

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'
WHERE ROWID=X'0125A50100010008';
*+ Status = 0        SQLSTATE = 00000
*+ 1 row processed

Additional Information

SQL Virtual Keys