The following error is received when executing DBXLOAD to populate the DATA FIL entity
* MESSAGE: SQE00180 ***** AN SQL ERROR HAS OCCURRED. ***** DB2 MESSAGE: DSNT408I SQLCODE: -180 ERROR: THE STRING REPRESENTATION OF A DATETIME VALUE HAS INVALID SYNTAX **********************END OF MESSAGE**********************
Component: XTR
The error is caused by the attribute EXPIRATION DATE (EXP_DATE) which has a default value of '9999-12-31'.
Execute the following SQL to update the map to remove the default value and update the ATTR CODE for EXP_DATE
* UPDATE repowner.DBX_SCREEN_ATTR SET DEFAULT_VALUE = ' ' WHERE COLUMN_NAME = 'EXP_DATE' AND MAP_ID = 270;
UPDATE repowner.DBX_IO_MAP_ATTR SET STORAGE_TYPE = 'D' WHERE COLUMN_NAME = 'EXP_DATE' AND MAP_ID = 270;
COMMIT; *
Note.
Change repowner to your Repository owner and change the map id accordingly if the map has been extended.