View Only
  • 1.  Record name mapping to 'SR' name

    Posted Dec 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 Dec 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 Dec 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

    (502) 476-2538 or 407-7266

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

    Posted Dec 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.