Unexpected OQ098002 or OQ093031 in OLQ

Document ID : KB000072285
Last Modified Date : 13/03/2018
Show Technical Document Details
If all (true for both command mode and menu mode) or part (true only for menu mode) of a record's CALC key is defined as USAGE COMP and is more than one fullword in length internally (i.e. PIC 9(n) where n>=10), then unexpected results can occur in OLQ.

The nature of the unexpected results includes, but is not limited to, the following:-
OLQ 098002 No Record Found (when the record exists), or
OLQ 093031 Key field data type does not match constant.
CA IDMS, all supported releases.
OLQ does not support doubleword fields as key fields (calc or index).
The recommendation is to use the CA-IDMS SQL Option to access such data.
Additional Information:
CA Online Query for CA IDMS - (User Guide)
Accessing Network-Defined Databases - (from the SQL Reference Guide)