-180 SQL CODE (Illegal Date-Time Format) Loading into DATA FIL

Products

• Repository

Issue/Introduction

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**********************  

 

 

Environment

Component: XTR

Resolution

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.