DATE_NULL_VALUE

In an XDBC configuration file, set the DATE_NULL_VALUE configuration variable to a valid date, as per the format specified by the XFD DATE directive, to be used when translating dates between a DATETIME type and a COBOL data type.

This date is used in the following situations:

When translating COBOL data to a DATETIME, if the COBOL data item is the same value as the DATA_NULL_VALUE value, NULL is used.
When translating a DATETIME type to a COBOL data item, if the DATETIME is an SQL NULL value, the COBOL item is set to the value of DATE_NULL_VALUE.

Note: During translation, any information missing from the date string will default to the lowest possible value.

Example:

With the following variable set:

DATE_NULL_VALUE       1969021100000000

the following translations occur:

Original item	Translated to
COBOL item is the same value as DATE_NULL_VALUE	SQL NULL
DATETYPE is NULL	1969021100000000