CA IDMS IUA EIUA

Tech Tip: CA IDMS IDMSRPTS CALCKEYs Sort Sequence

  • 1.  Tech Tip: CA IDMS IDMSRPTS CALCKEYs Sort Sequence

    Posted 01-09-2018 11:44 AM

    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