Appendix A. Special CA MICS Processing › A.3 SPECIAL Database Execution Definitions › A.3.2 SPECIAL Select/Force Option

A.3.2 SPECIAL Select/Force Option

The input data processed by a SPECIAL database may be
selected from a to-date file of input data.  It may also be
desirable to bypass normal duplicate data elimination and
force specified periods of data into the SPECIAL database.

SPECIAL databases are more open to such selection and forcing
of data.  However, a facility exists that can be used to
define select and force parameters that apply to all
component update routines active in the DAILY process.  This
is accomplished by user specification of the SELECT and FORCE
statements in the SPECIAL database unit's parameter library
member EXECDEF.

Only one SELECT statement is allowed in EXECDEF.  The SELECT
statement will cause the DAILY update to perform as if you
coded the desired selection window on each component record
in the checkpoint data set.  The time stamp bounds listed on
the statement must follow the rules of formatting such a time
stamp:

    SELECT     ddmmmyy:hh:mm:ss.th   ddmmmyy:hh:mm:ss.th
               -------------------   -------------------
                  beginning time         ending time

where:
    ddmmmyy        - day, month, and two-digit year of date
    hh:mm:ss.th    - hour,  minute, and second to hundredths
                     of the time of day
    beginning time - the time-stamp that begins the selection
                     window
    ending time    - the time-stamp that ends the selection
                     window
    punctuation    - (: and .) is coded in the positions
                     shown

For example:

prefix.MICS.PARMS(EXECDEF):
    ...
    SELECT     05AUG82:05:00:00.00   05AUG82:05:59:59.99

which selects data from the fifth hour of August 5, 1982.


Only one FORCE statement is allowed in EXECDEF.  The FORCE
statement will cause the DAILY update to perform as if you
coded the desired force window on each component record
in the checkpoint data set.  The time stamp bounds listed on
the statement must follow the rules of formatting such a time
stamp:

    FORCE      ddmmmyy:hh:mm:ss.th   ddmmmyy:hh:mm:ss.th
               -------------------   -------------------
                  beginning time         ending time

where:
    ddmmmyy        - day, month, and two-digit year of date
    hh:mm:ss.th    - hour, minute, and second to hundredths
                     of the time of day
    beginning time - the  time  stamp  that  begins the force
                     window
    ending time    - the time-stamp that ends the force
                     window
    punctuation    - (: and .) is coded in the positions
                     shown

For example:

prefix.MICS.PARMS(EXECDEF):
    ...
    FORCE      05AUG82:05:00:00.00   05AUG82:05:59:59.99

which forces data from the fifth hour of August 5, 1982.

See the discussion of the CA MICS Select and Force
Facilities, in section 4.1.5 of this guide.