The Interface to CA Datacom/DB › Creating the Summary File › Preparing Translate Control Statements

Preparing Translate Control Statements

The Translate Component uses the following control statements.

Datacom

This parameter statement supplies the CA Datacom Interface with installation-dependent defaults.

 Command            Keywords/Operands              Default

 Datacom            [SNAP  nnnn]                   0010
                    [CPUID x   ]                   space
                    [ACCT  name]                   none
                    [DATABASE nnn]                 none
                    [TBLNAM xxx]                   none

SNAP nnnn

specifies the count of rejected or invalid records to be snap dumped. If omitted, the Interface displays the first 10 records that it is unable to process successfully. To suppress this option, specify SNAP 0.

CPUID x

specifies the one-character CPU identifier that is put in all summary records. This CPU identification can be used by the report program for various grouping and chargeback rate application functions. If omitted, the Interface places a blank in the CPU identifier in the summary records.

ACCT name

specifies the member name of the User Account Table. See the section Creating A User Accounting Table later in this chapter.

DATABASE nnn

specifies the three-character database identifier that contains the Accounting Table to be translated.

TBLNAM xxx

specifies the three-character table name of the Accounting Table to be translated.

CRITERIA

This parameter statement uses time as the criteria for selecting data for processing. The Accounting Table record selection is based on the start time and start date contained in the Accounting Table record.

  Command            Keywords/Operands              Default

  CRITERIA           [SDATE xx/xx/xx]               00/01/01
                     [EDATE xx/xx/xx]               12/31/99
                     [STIME nnnn    ]               0000
                     [ETIME nnnn    ]               2359

SDATE xx/xx/xx

specifies the beginning date for data selection. All Accounting Table records from the SDATE until EDATE are included for translation. The date must be specified in the format mm/dd/yy. Years 00-60 are treated as the years 2000-2060, 61-99 are treated as the years 1961-1999.

EDATE xx/xx/xx

specifies the end date for data selection. All Accounting Table records prior to this date but after SDATE are included for translation. The date must be specified in the format mm/dd/yy. Years 00-60 are treated as the years 2000-2060, 61-99 are treated as the years 1961-1999.

Note: EDATE and SDATE can be supplied individually or together. Together they delimit the date range. Specified independently they set the start or ending date. When their values are equal, a single day is selected. The value of EDATE must not precede SDATES value, except when specifying dates from the year 2000. For example, SDATE 01/01/95 EDATE 01/01/94 produces a syntax error message, whereas SDATE 12/01/99 EDATE 01/01/00 will not.

STIME nnnn

specifies the beginning time for data selection. All Accounting Table records from this time until ETIME are included for translation.

ETIME nnnn

specifies the end time for data selection. All Accounting Table records prior to this time but after STIME are included for translation.

Note: ETIME and STIME can be supplied individually or together. Together they delimit the time range. Specified independently they set the start or end time. When they are equal, a single minute is selected. When ETIME precedes STIME, EDATE and SDATE are required and EDATE must be greater than SDATE.