我在使用db2 load 命令导入文件时,文件中超长的字段在导入过程中给默认截取掉了,而且数据类型不一致的字段,导入到目标表中默认为null,而且最终导入完成后的统计信息也没有报错,显示全部导入成功,很费解,求大神帮忙!!!
日志如下:
**SQL3500W The utility is beginning the "LOAD" phase at time "2017-05-15
09:02:23.558649".
SQL3519W Begin Load Consistency Point. Input record count = "0".
SQL3520W Load Consistency Point was successful.
SQL3125W The character data in row "F0-6" and column "1" was truncated
because the data is longer than the target database column.
SQL3123W The field value in row "F0-6" and column "6" cannot be converted to
a PACKED DECIMAL value. A null was loaded.
SQL3125W The character data in row "F0-6" and column "9" was truncated
because the data is longer than the target database column.
SQL3125W The character data in row "F0-6" and column "10" was truncated
because the data is longer than the target database column.
SQL3227W Record token "F0-6" refers to user record number "6".
SQL3110N The utility has completed processing. "12" rows were read from the
input file.
SQL3519W Begin Load Consistency Point. Input record count = "12".
SQL3520W Load Consistency Point was successful.
SQL3515W The utility has finished the "LOAD" phase at time "2017-05-15
09:02:23.666979".
SQL3107W There is at least one warning message in the message file.
Number of rows read = 12
Number of rows skipped = 0
Number of rows loaded = 12
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 12**