在进行datastage开发过程中发现如下错误
DB2_Connector_0: Schema reconciliation detected a size mismatch for column CREATEDT. When reading database column DATETIME(fraction=6) into column DATETIME(fraction=0), truncation, loss of precision or data corruption can occur. (CC_DBSchemaRules::reportSizeMismatch, file CC_DBSchemaRules.cpp, line 1,692)
问题描述:
进行字段插入是将timestamp插入到timestamp中,字段CREATEDT是timestamp类型
--解决:
将他的length改为30,scale改为6问题解决!