Question:
Why does IDMSRPTS shows that one CALCKEY has been set to use STANDARD Sort Sequence when all others show NATURAL Sequence?
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
Additional Information:
IDMSRPTS - CA IDMS Reference - 19.0 - CA Technologies Documentation