Unexpected OQ098002 or OQ093031 in OLQ
Article ID: 72285
Updated On:
Products
IDMS
IDMS - Database
IDMS - ADS
Issue/Introduction
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.
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.
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)
Accessing Network-Defined Databases - (from the SQL Reference Guide)
Feedback
Yes
No
Powered by
