OLQ 095001 database status 0308 get record in set using SORTKEY

Products

• IDMS
• IDMS - Database

Issue/Introduction

Retrieving a record in OLQ  gets an IDMS error status 0308 when using WHERE SORTKEY or WHERE key_name

OLQ 095001 08  CA IDMS problem - database status = 0308

This syntax without a WHERE clause works OK:

GET FIRST REC1 IN IX-REC1

The following syntax with a WHERE clause fail with 0308:

GET FIRST REC1 IN IX-REC1 WHERE SORTKEY = 20010127
GET FIRST REC1 IN IX-REC1 WHERE REC1-DATE = 20010127

 

 

Environment

Release : 19.0

Component : IDMS/DB

Cause

This is due to a bug caused when optional bit 340 is enabled in RHDCOPTF.

Resolution

This is resolved by PTF SO08100.

Although the description of the PTF does not mention it, it also contains the fix for IDMS problem 5448 - OLQ GET RECORD IN SET USING SORT KEY ERROR 0308 OPT 340

The circumvention is to turn off optional bit 340.