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.

OLQ 095001 database status 0308 get record in set using SORTKEY

book

Article ID: 237107

calendar_today

Updated On:

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

 

 

Cause

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

Environment

Release : 19.0

Component : IDMS/DB

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.