CA IDMS

Expand all | Collapse all

Record name mapping to 'SR' name

Jump to Best Answer
  • 1.  Record name mapping to 'SR' name

    Posted 12-13-2018 10:39 AM

    I want to know how many records I have of a specific name in an area. I have done a print space of the area and it tells me record counts by SRxxxx name. How do I map that SR name to the record names I have in IDD?



  • 2.  Re: Record name mapping to 'SR' name
    Best Answer

    Broadcom Employee
    Posted 12-13-2018 10:49 AM

    PRINT SPACE lists record by record ID  (SRnnnn)

    You can display the records for a given schema in the schema compiler,  or do LOOK SUBSCHEMA=xxxxxxxx which lists all records and shows the record ID for each.

     



  • 3.  Re: Record name mapping to 'SR' name

    Posted 12-13-2018 10:59 AM

    SR stands for Schema Record (if it doesn’t, it is a good coincidence)

     

    Single digit record ids represent members of the CALC set, variable-length records, relocated records, and index header and intermediate-level records

     

    For catalog dictionary or other records, look in the schema – the RECORD ID clause of the ADD RECORD statement relates to the SRXXX on the print space

     

    I think

     

     

    Chris Hoelscher

    Technology Architect, Database Infrastructure Services

    Technology Solution Services

    Humana Inc.

    123 East Main Street

    Louisville, KY 40202

    Humana.com

    (502) 476-2538 or 407-7266



  • 4.  Re: Record name mapping to 'SR' name

    Posted 12-17-2018 08:37 AM

    Appendix E in the Database Administration Guide shows the possible System Record (SR) types with an explanation of their purpose.