baije01

Tech Tip: CA IDMS IDMSRPTS CALCKEYs Sort Sequence

Discussion created by baije01 Employee on Jan 9, 2018

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 

Outcomes