Unexpected message “OLQ 098002 No record found” when retrieving data in OLQ with a concatenated calc or index key.
The cause is the IDD DICTIONARY OPTION, "DECIMAL-POINT IS COMMA".
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.
For more information, see About SET OPTIONS