When reading database column DATETIME(fraction=6) into column DATETIME(fraction=0)

在进行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问题解决！