Date Validation

Whenever DATABridge processes numeric or alpha items that are cloned as relational database date data types, it checks the validity of the data. Invalid dates are usually stored as NULL. The DATABridge Client for Microsoft SQL Server stores bad or NULL dates as 1/1/1900, when the DAOPT_Allow_Nulls bit (1) in the da_options column of the corresponding DATAITEMS control table entry has not been set. The DATABridge Client for Oracle uses the date 1/1/0001 instead. A numeric date of all 0s or all 9s is treated as NULL rather than an error. Similarly, an ALPHA date that is all blanks is treated as a NULL date.