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.


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