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

Document ID : KB000012213
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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).

Answer:

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