Unexpected OQ098002 or OQ093031 in OLQ

Document ID : KB000072285
Last Modified Date : 13/03/2018
Show Technical Document Details
Issue:
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.
Environment:
CA IDMS, all supported releases.
Resolution:
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)