STANDARD vs NATURAL sort sequence for CALC key in IDMSRPTS

Products

• IDMS
• IDMS - Database

Issue/Introduction

There is no schema record syntax to select STANDARD or NATURAL sort sequence for a CALC key, but the schema compiler selected STANDARD for one CALC record and NATURAL for all others. IDMSRPTS shows this in the SETDES report.

The CALC key element is defined as follows:

02 CALC-KEY DISPLAY S9(08).

Environment

Release: All supported releases.

Resolution

The schema compiler will force STANDARD sort sequence for CALC keys that include any of the following datatypes:

NUMERIC (signed)
DECIMAL (signed)
INTEGER
SMALLINT
FLOAT
REAL
DOUBLE PRECISION
VARCHAR
LONGINT
VAR GRAPHIC