INCLUDE

Syntax:

INCLUDE field_id low high

Where:

field_id = A specific field ID. This is a dictionary-defined Identifier or Resource.

low = The LOW or FROM selection value

This statement specifies an include record condition. Records that are of the type specified by the field ID and contain the specified field values will be included in processing.

Other considerations:

• The specified field value must be equal to or greater than the low value and equal to or less than the high value.
• The low and high values can specify up to 8 characters each.
• Spaces are the delimiters. If spaces are required in the low or high values, replace the spaces with a colon (:).
• Up to one hundred include conditions are supported.
• The default is none (no inclusions).
• A date keyword can be used as the low and high value for identifier fields with date values. Keywords automatically calculate specific dates. See Keywords for the list of date keywords.

Examples

INCLUDE DB2SDT 2006359 2007359

The value DB2SDT specifies the Db2 records start date. (DB2SDT date format is YYYYDDD.) Records with a start date greater than or equal to 2006359 and less than or equal to 2007359 are included in processing.

Note: The CIMSSDT field is also a start date field that is in Julian format.

INCLUDE DB2SDT **PREMON

If the current month is July 2007, then **PREMON equals 2007121 2007151 (June 1st through June 31st 2007). By default, the keyword values are converted to Julian format, YYYYDDD.

The value in the DB2SDT field would have to be equal or greater than 2007121 and less than or equal to 2007151 to be included.

A value of G in the high parameter causes the date values to be converted into YYYYMMDD format.

INCLUDE DB2SDT **PREMON G

If this month is July 2007, **PREMON G equals 20070601 20070631 (YYYYMMDD). The value in the DB2SDT field would have to be equal or greater than 20070601 and less than or equal to 20070631 for the record to be included.