Why does IDMSRPTS show that one CALCKEY has been set to use STANDARD Sort Sequence when all others show NATURAL Sequence.

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

There is no Schema Record syntax to select STANDARD or NATURAL sort seq for a CALC key, but the Schema Compiler selected STANDARD for one of our CALC records and NATURAL for all others.  IDMSRPTS shows this in SETDES report.

The Calckey element is defined as follows:

02 OUR-CALC-KEY DISPLAY S9(08).

Environment

Release: IDADSO00100-18.5-ADS-for CA-IDMS
Component:

Resolution

The Schema Compiler will force STANDARD Sort Sequence for Calckeys that include any of the following datatypes:

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