ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

IDMS/SQL: Coding ROWID literals

book

Article ID: 226563

calendar_today

Updated On:

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