Packed concatenated CALC keys in OLQ.

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

This document describes how to specify the value of a concatenated CALC key in OLQ when the component fields are packed

Environment

Release: All supported releases.

Resolution

When specifying the values of a CALC key in OLQ, the syntax used is:-

WHERE CALC = 12345

If the key is concatenated and each individual component is packed, the following syntax can be used to specify the values of each field:-

OBT REC-NAME WHERE CALC = 123 456

The above statement would retrieve the record whose concatenated calc key components have the values 123 and 456 respectively.