Date, time, and timestamp fields used by the INCREL parameter

 

The INCREL parameter allows date, time, and timestamp fields. The copy command compares the input field value chronologically to the value in the date, time, or timestamp field to determine if it should select the record. The system attempts to convert the input string and the actual field value to an internal form that is chronologically compared. These rules apply to the conversion:

• If the from-field is a date field, the system determines if the user-input field value is in the same format and has the same separator as specified in the current job under which the copy command is running. The format can be *MDY, *DMY, *YMD, or *JUL and can use a slash (/), hyphen (-), period (.), comma (,), or blank ( ) for the separator. If the user-input field value does not use the same format or separator form of the current job, the system determines if it is one of the SAA^® formats (*ISO, *USA, *EUR, OR *JIS) or if it is a YYYYDDD form with no separators. If the system determines that the user-input field value is one of these forms, it converts the input string to an internal form. The from-field is then converted to its internal form, and the comparison is made. If the user-input string format cannot be determined, or the length or data value is not valid, a diagnostic message is issued and the copy operation ends. You must left-justify the date portion of the user-input field value; it can contain trailing blanks.

• If the from-field is a time field, the system determines if the user-input field value is in the same format and has the same separator as specified in the current job under which the copy command is running. The format can be HHMMSS and have a colon (:), comma (,), period (.), or blank ( ) for the separator. If the user-input field value is not in the specified format and separator form of the current job, the system determines if it is in one of the SAA formats (*ISO, *USA, *EUR, or *JIS). If the system determines that the user-input key value is in one of these forms, it converts the input string to an internal form. The from-field is then converted to its internal form, and the chronological comparison is made. If the user-input string format cannot be determined or the length or data value is not valid, a diagnostic message is issued and the copy operation ends. You must left-justify the time portion of the user-input field value; it can contain trailing blanks.

• If the from-field is a timestamp field, the system first determines if the user-input field value is in the SAA format or YYYYMMDDHHMMSS form (no separators). If the system determines that the user-input field value is in one of these forms, it converts the input string to an internal form. The from-field is then converted to its internal form and the chronological comparison is made. If the user input string format cannot be determined, or the length or data value is not valid, a diagnostic message is issued and the copy operation ends. You must left-justify the timestamp portion of the user-input field value; it can contain trailing blanks.

 

Parent topic:

Selecting records based on field value (INCREL parameter)