Previous Topic: 4.2.1 Generation Dependencies

Next Topic: 4.2.3 MCG Operation

4.2.2 Generated Outputs


Figure 4-1 above illustrated that the MCG produced outputs
for a number of different CA MICS libraries. A maintenance
report is also produced:  the Generation Definition
Statements Report, which displays the statements that have
been defined.  If any errors were detected in editing the
statements, error messages appear immediately after the
statement's display or at the end of the entire list.

The MCG produces most of the required SAS, MICF, JCL, and
documentation members for a component.  Additional user code
(for example, for the detail format routine DYcccFMT) must be
provided to complete the component.  The following list
describes the members that are produced by the MCG.   Figure
4-3 provides a cross-reference between the generated member
and the MCG member that produced it.

The conventions used in naming the different types of
members are:

ccc - Three-character component identifier
iii - Three-character information area identifier
fff - Three-character file identifier
sss - Three-character component job step number.

                    CA MICS Member Overview

The following is a brief description of the purpose of
each of the SAS, PROTOLIB, and document members involved in a
component implementation.

DATABASE TAILORING

1. SAS Members - 'sharedprefix.MICS.SOURCE'

   $cccCYC1:  Test Aging and Delete Cycle Macros

              Contains macros defining the file deletes and
              PROC DATASET aging statement for cycle
              maintenance in the MICSGT update test process.

   #cccSFD    Selective File Definition Macros
    and
   $cccSFD:   Contains one macro for each file, defining the
              file as active or inactive (fffSFD).

   cccCHECK:  Database Check Routine

              Contains executable code to print the first 10
              observations of all files in the DETAIL and
              TABLES timespans and to perform a TABLES list
              frequency distribution (PROC FREQ) according to
              the defined sequence pattern for all files in
              DAYS, WEEKS, MONTHS, and YEARS timespans.

   DYcccAGE   Daily File Aging Routine
     and
   DYcccRGE:  Contains executable code to update the
              Checkpoint and Input History Log Files for this
              component's input data.  It also performs
              database cycle maintenance daily by aging for
              DETAIL and DAYS files, and WEEKS week-to-date
              and MONTHS month-to-date files using the
              generated macros in the
              prefix.MICS.USER.SOURCE($cccCYCS) member.

   DYcccSUM:  Daily Summarization/Update Routine

              Contains executable code to insert the new file
              in the DAYS timespan, and to update the
              week-to-date and month-to-date files in the
              WEEKS and MONTHS timespans respectively for
              the files supported in the applicable
              timespans.

   DYcccIUA:  Incremental Update File Aging Routine

              Contains executable code to update the
              incremental update Checkpoint and Input History
              Log Files for this component's input data.  It
              also performs incremental update database cycle
              aging for DETAIL and DAYS files using the
              generated macros in the
              prefix.MICS.USER.SOURCE($cccCYCS) member.

   DYcccIUR:  Incremental Update Daily File Roll-up Routine

              Contains executable code to copy the "today
              to-date" incremental update DETAIL and DAYS
              level files to the appropriate unit database
              DETAIL and DAYS timespan data sets.  This
              processing is executed during the DAILY job to
              "roll-up" the incremental update database to
              the production unit database files.

   DYcccIUS:  Incremental Update Summarization/Update Routine

              Contains executable code to combine DETAIL and
              DAYS level files from the current incremental
              update with the "today to-date" files resulting
              from today's prior incremental update
              executions for this product.

   WKcccAGE:  Weekly File Aging Routine

              Contains executable code to update the
              Checkpoint File for this component's weekly
              update.  It also performs database cycle
              maintenance weekly by aging the files supported
              in the WEEKS timespan using the generated
              macros in the #cccCYCS member.

   WKcccAUD:  Weekly Audit Archive Routine

              Contains executable code to update the archive
              weekly audit files for all files supported in
              the DETAIL or DAYS timespan and defined as
              eligible for the weekly audit archive process.

   WKcccHST:  Weekly History Archive Routine

              Contains executable code to update the archive
              weekly history files for all files supported in
              the WEEKS timespan and defined as eligible for
              the weekly history archive process.

   MNcccAGE:  Monthly File Aging Routine

              Contains executable code to update the
              Checkpoint File for this component's monthly
              update.  It also performs database cycle
              maintenance monthly by aging the files
              supported in the MONTHS timespan using the
              generated macros in the #cccCYCS member.

   MNcccHST:  Monthly History Archive Routine

              Contains executable code to update the archive
              monthly history files for all files supported
              in the MONTHS timespan and defined as eligible
              for the monthly history archive process.

   YRcccAGE:  Yearly File Aging Routine

              Contains executable code to update the
              Checkpoint File for this component's yearly
              update.  It also performs database cycle
              maintenance yearly by aging the files supported
              in the YEARS timespan using the generated
              macros in the #cccCYCS member.

   NOTE:      The next five members are maintained for
              compatibility with old-style SAS macros.  The
              old (SAS 79-style) macros defined in this
              member resolve to the new (%MACRO) macros
              described later.  The generated members are:
              #cccFLS, #cccKEEP, #cccLBLS, #cccSEQ, and
              #cccSUM.

   #cccFLS:   Element LENGTH, FORMAT, and INFORMAT Macros

              Contains three macros for each file defining
              the LENGTHs, FORMATs, and INFORMATs for all
              elements in the file, with unique definitions
              for the DETAIL (_fffFD), DAYS/WEEKS (_fffFDD),
              and MONTHS/YEARS (_fffFDM) timespans.

   #cccKEEP:  File KEEP Statement Macros

              Contains up to six macros for each file
              defining the elements to be kept by the KEEP
              statement in the DETAIL (_fffKPDT), DAYS
              (_fffKPDY), WEEKS (_fffKPWK), MONTHS
              (_fffKPMN), YEARS (_fffKPYR), and TABLES
              (_fffKPTB) timespans.

   #cccLBLS:  File LABEL Statement Macros

              Contains one macro for each file defining all
              the data elements' 40-character labels
              (_fffLBLS).

   #cccSEQ:   File Sequence Definition Macros

              Contains up to six macros for each file
              defining the file's unique sequence pattern for
              the DETAIL (_fffSEQX), DAYS (_fffSEQD), WEEKS
              (_fffSEQW), MONTHS (_fffSEQM), YEARS
              (_fffSEQY), and TABLES (_fffSEQT) timespans.

   #cccSUM:   File Summarization and Computation Macros

              Contains two macros for each file defining: (1)
              the processing logic for summarizing the data
              in the file to a higher level of granularity
              (_fffSUM), and (2) SAS expressions for all
              computed elements (_fffVCE).
2. SAS Members - 'sharedprefix.MICS.INCLLIB'

   DAYsss:    %INCLUDE List for Daily DB Update

              Contains executable code to include all of the
              CA MICS SAS macro and executable code members
              required for the daily database update step.

   WEEKsss:   %INCLUDE List for Weekly DB Update

              Contains executable code to include all of the
              CA MICS SAS macro and executable code members
              required for the weekly database update step.

   MONTHsss:  %INCLUDE List for Monthly DB Update

              Contains executable code to include all of the
              CA MICS SAS macro and executable code members
              required for the monthly database update step.

   YEARsss:   %INCLUDE List for Yearly DB Update

              Contains executable code to include all of the
              CA MICS SAS macro and executable code members
              required for the yearly database update step.

   cccGTEST:  %INCLUDE List for Testing Online Database

              Contains executable code to include all of the
              CA MICS SAS macro and executable code members
              required to test all online database update
              and reporting functions.  This %INCLUDE list is
              used by the MICSGT generation and test
              procedure.
3. JCL PROTOLIB Members - 'sharedprefix.MICS.PROTOLIB'

   DYcccsss:  Step JCL for Daily Job

              Contains PROTOLIB JCL that, when generated by
              the MJG, produces the step JCL for this
              component that is used in a database unit's
              daily update job.

   WKcccsss:  Step JCL for Weekly Job

              Contains PROTOLIB JCL that, when generated by
              the MJG, produces the step JCL for this
              component that is used in a database unit's
              weekly update job.

   MNcccsss:  Step JCL for Monthly Job

              Contains PROTOLIB JCL that, when generated by
              the MJG, produces the step JCL for this
              component that is used in a database unit's
              monthly update job.

   YRcccsss:  Step JCL for Yearly Job

              Contains PROTOLIB JCL that, when generated by
              the MJG, produces the step JCL for this
              component that is used in a database unit's
              yearly update job.

   WKccc300:  Step JCL Portion for Weekly Archive

              Contains PROTOLIB JCL that, when generated by
              the MJG, produces JUST the input and output JCL
              data definition statements (DD statements) used
              to update the audit and weekly history archive
              files (if not being generated in the optional
              stand-alone AUDIT and/or HISTW jobs).

   MNccc300:  Step JCL Portion for Monthly Archive

              Contains PROTOLIB JCL that, when generated by
              the MJG, produces JUST the input and output JCL
              data definition statements (DD statements) used
              to update the monthly history archive files (if
              not being generated in the optional stand-alone
              HISTM job).

   AUDIT:     JCL for Stand-Alone Weekly Audit Archive

              Optionally contains PROTOLIB JCL that, when
              generated by the MJG, produces JUST the input
              and output JCL data definition statements (DD
              statements) used to update the audit archive
              files.

   HISTW:     JCL for Stand-Alone Weekly History Archive

              Optionally contains PROTOLIB JCL that, when
              generated by the MJG, produces JUST the input
              and output JCL data definition statements (DD
              statements) used to update the audit weekly
              history files.

   HISTM:     JCL for Stand-Alone Monthly History Archive

              Optionally contains PROTOLIB JCL that, when
              generated by the MJG, produces JUST the input
              and output JCL data definition statements (DD
              statements) used to update the audit monthly
              history files.
4. Data Members - 'sharedprefix.MICS.GENLIB'

   cccFCT:    File Definition Table (FCT)

              Contains data that defines each file and the
              timespans in which they are supported for the
              component.  This member is used to support the
              CA MICS Information Center Facility (MICF) with
              database complex configuration information.

5. Documentation Members - 'sharedprefix.MICS.INC.TEXT'

   #INSfffE:  Data Element List

              Contains text for a single file; lists the data
              elements supported.  This documentation member
              is stored in the INC.TEXT library and is used
              in the product guides.

   #INSfffS:  File Organization Box

              Contains text for a single file; lists the
              sequence/summarization pattern for this file in
              each timespan in which the file is supported.
              This documentation member is stored in the
              INC.TEXT library and is used in the product
              guides.

   #INScccF:  General File Matrix Chart

              Contains text for all files in the component,
              listing each file and the timespans in which
              it is supported.  This documentation member is
              stored in the INC.TEXT library and is used in
              the product guides.
6. SAS Autocall Macros - 'sharedprefix.MICS.MACAUTOS'

   cccACCT:   Component Account Code Definition Macro

              Contains the SAS LENGTHs, FORMATs, and LABELs
              of the account code data elements defined for
              this component.

   cccC:      Component Description Macro

              Contains a list of all files in the component,
              the information areas to which they belong,
              and the essential and derived options used in
              their generation.

   cccCLEN:   Component Element Length Macros

              Contains SAS length descriptors for the common
              data elements used by files in the component.

   fffDERV:   File Derived Element Computation Macros

              Contains SAS statements necessary to calculate
              every derived data element in the file.

   fffFMT:    File Format and Informat Macros

              Contains SAS format and informat descriptors
              for each data element in the file, in all
              timespans.

   fffKEEP:   File Keep Macros

              Contains the data element KEEP list for the
              file in all timespans.

   fffLEN:    File Length Macros

              Contains SAS length descriptors for each data
              element in the file, in all timespans.

   fffLBL:    File Label Macros

              Contains SAS label statements for each data
              element in the file in any timespan.

   fffSEQ:    File Sequence Macros

              Contains the list of data elements, by
              timespan, that describe the key structure and
              summarization break of the file.

   fffSUM:    File Summarization Macros

              Contains the SAS statements necessary to
              summarize the file into a higher timespan.
              Derived data elements are recalculated by
              the fffDERV macro, referenced by the fffSUM
              macros.
7.  Data members -

    sharedprefix.MICS.ISPTLIB

              These members are ISPF tables used in support
              of the CA MICS online applications and end-user
              facilities.

    sharedprefix.MICS.MCOLIB

              These SAS files and SAS views support CA MICS
              generation and operational processes and also
              provide information to the CA MICS end-user
              applications.


COMPONENT SHELL GENERATION - ONE TIME ONLY EXECUTION
1. SAS Members - 'sharedprefix.MICS.SOURCE'

   $cccMSTR:  Master Options

              Contains macros that define component options
              or special flags.  The member is initially
              empty following a shell generation.

   #cccEXIT:  User Exit Macros

              Contains one macro for each file (_USRSfff)
              that provides a CA MICS exit (Null SAS Macro)
              immediately before the file is written in the
              daily format routine.

   DYcccFMT:  Daily Input Format Routine

   NOTE:      Items followed by an asterisk contain
              executable code, which must be completed by the
              user, to perform the following functions:

              o  Input raw input data (*)
              o  Edit raw input data (*)
              o  Verify input data against checkpoint
                 low/high dupdate ranges for duplicate data
                 test
              o  Use checkpoint processing facilities for
                 NODATE, SELECT, and/or FORCE options
              o  Insert files in the DETAIL timespan
              o  Support Selective File Definition (SFDs)
              o  Support User File Exits
              o  Update Checkpoint File low/high update
                 ranges
              o  Update Input History Log File with update
                 activity, record counts, and update ranges
              o  Sort all DETAIL files and drop duplicate
                 data.

   DYcccMBO:  Daily MBO Report Routine

              Contains executable code to produce this
              component's daily management objective routine.
              This member is initially empty following a
              shell generation.

   WKcccMBO:  Weekly MBO Report Routine

              Contains executable code to produce this
              component's weekly management objective
              routine.  This member is initially empty
              following a shell generation.

   MNcccMBO:  Monthly MBO Report Routine

              Contains executable code to produce this
              component's monthly management objective
              routine.  This member is initially empty
              following a shell generation.

   DYcccEXC:  Daily Exception Analyzer Routine

              Contains executable code, which must be
              completed by the user, to perform the exception
              analysis that has been defined for this
              component.  This member contains only standard
              DATA, SET, initialization, and termination
              code.  You must add the actual exception
              analyzers.

   cccEVA:    Exception Value Analyzer Routine

              Contains executable code, which must be
              completed by the user, to perform the exception
              value analysis for those elements used in this
              component's exception analyzer.  This member
              contains only standard DATA, SET,
              initialization, and termination code.  You must
              add the actual exception value analyzers.
2. Documentation Members - 'sharedprefix.MICS.INC.TEXT'

   PICccc:    Data Dictionary PIC List

              Contains the PIC list necessary to generate the
              data dictionary appendix for this component.

   eeeeeeee:  Data Dictionary Shell

              Contains the outline or "shell" member for the
              data dictionary member for this data element.