OLQ 098002 No record found using concatenated key
search cancel

OLQ 098002 No record found using concatenated key

book

Article ID: 6111

calendar_today

Updated On:

Products

IDMS IDMS - Database IDMS - ADS

Issue/Introduction

Unexpected message “OLQ 098002 No record found” when retrieving data in OLQ with a concatenated calc or index key.

Environment

CA-IDMS, OLQ, any supported release.

Cause

The cause is the IDD DICTIONARY OPTION, "DECIMAL-POINT IS COMMA".

Resolution

Change the DICTIONARY OPTION to DECIMAL-POINT IS PERIOD or ensure that there is always at least one space after the comma or period (full stop) which is acting as a separator.

If you are using DECIMAL-POINT IS PERIOD or there is at least one space after the separator, there is no problem.

If you are using DECIMAL-POINT IS COMMA and there is no space after the separator, you get the 098002  message.

Examples:

Using:
SET OPTIONS FOR DICTIONARY
    DECIMAL-POINT IS PERIOD
    .

GET R1 WHERE CAL=1, 2
R1
  R1-DBKEY         :       0/151013:1
  KEY1             :      1
  KEY2             :      2
  DAT1             :      3
END OF RECORD

GET R1 WHERE CAL=1. 2
R1
  R1-DBKEY         :       0/151013:1
  KEY1             :      1
  KEY2             :      2
  DAT1             :      3
END OF RECORD

GET R1 WHERE CAL=1 2
R1
  R1-DBKEY         :       0/151013:1
  KEY1             :      1
  KEY2             :      2
  DAT1             :      3
END OF RECORD

GET R1 WHERE CAL=1,2
R1
  R1-DBKEY         :       0/151013:
  KEY1             :      1
  KEY2             :      2
  DAT1             :      3
END OF RECORD
 
GET R1 WHERE CAL=1.2
OLQ 093032 08  The compound value given does not specify the same # of values as in the group.

Using:
SET OPTIONS FOR DICTIONARY
    DECIMAL-POINT IS COMMA
    .   

GET R1 WHERE CAL=1, 2
R1
  R1-DBKEY         :       0/151013:1
  KEY1             :      1
  KEY2             :      2
  DAT1             :      3
END OF RECORD

GET R1 WHERE CAL=1. 2
R1
  R1-DBKEY         :       0/151013:1
  KEY1             :      1
  KEY2             :      2
  DAT1             :      3
END OF RECORD

GET R1 WHERE CAL=1 2
R1
  R1-DBKEY         :       0/151013:1
  KEY1             :      1
  KEY2             :      2
  DAT1             :      3
END OF RECORD

GET R1 WHERE CAL=1,2
OLQ 098002 04  No record found.

GET R1 WHERE CAL=1.2
OLQ 098002 04  No record found.

Additional Information

For more information, see About SET OPTIONS

Attachments

1558533955275TEC1051293.zip get_app