INCLUDE/EXCLUDE statement (CTDAPRV)

The INCLUDE statement defines the selection criteria for reports to be processed. The EXCLUDE statement defines the selection criteria for reports which are not to be processed.

The selection parameters which can be specified in the INCLUDE/EXCLUDE statements are described in Table 201.

The following rules apply to INCLUDE and EXCLUDE statements:

• Several INCLUDE and EXCLUDE statements can be specified.
• All selection parameters are optional. Each selection parameter can be specified several times in the INCLUDE and EXCLUDE statement. In an INCLUDE or EXCLUDE statement, similar selection parameters are related by logical OR, while different selection parameters are related by logical AND.
• CTDAPRV selects all reports that satisfy the parameter DAYS and selection parameters in the INCLUDE statements, except those that satisfy the selection parameters in the EXCLUDE statements.
• If the EXCLUDE statements are missing, all reports that satisfy the parameter DAYS and selection parameters in the INCLUDE statements are selected.
• If the INCLUDE statements are missing, all reports that satisfy the parameter DAYS, except those which satisfy the selection parameters in the EXCLUDE statements, are selected.
• If both the INCLUDE and EXCLUDE statements are missing, all Control-D reports that satisfy the parameter DAYS are selected.
• If DAYS=DATE the following parameters are mandatory in the selection stream: USER, REPNAME, DATE.

  Table 201 CTDAPRV INCLUDE/EXCLUDE selection parameters

  Parameter	Description
  APPROVAL	The approval name. Complete value or mask. Maximum length of 8 characters.
  USER	The report recipient. Complete value or mask. Maximum length of 8 characters.
  REPNAME	The report name. Complete value or mask. If blanks or apostrophes are included in the report name, the report name must be specified between apostrophes and any apostrophes included in the report name must be doubled. Maximum length of 50 characters.
  JOBNAME	The name of the job that created the report. Complete value or mask. Maximum length of 8 characters.
  CATEGORY	The report category. Complete value or mask. Maximum length of 8 characters.
  DATE	Date of report. Maximum length of 8 characters.
  JOBID	ID of the job that created the report. Maximum length of 8 characters.