该博客展示了如何在DB2中创建表并插入数据，以及在不同数据类型之间进行转换。首先创建了两个表t0528和t0528_target，分别使用decimal和numeric数据类型。接着，将数据插入t0528，再从t0528复制到t0528_target，证明了decimal(14,6)到numeric(14,6)的转换是成功的。
db2inst1@dblion-a:~> db2 "create table t0528(id int,col decimal(14,6))"
DB20000I The SQL command completed successfully.
db2inst1@dblion-a:~> db2 "create table t0528_target(id int,col numeric(14,6))"
DB20000I The SQL command completed successfully.
db2inst1@dblion-a:~> db2 "insert into t0528 values(1,2542.405000)"
DB20000I The SQL command completed successfully.
db2inst1@dblion-a:~> db2 "select * from t0528"
ID COL
----------- ----------------
1 2542.405000
1 record(s) selected.
db2inst1@dblion-a:~> db2 "insert into t0528_target select * from t0528"
DB20000I The SQL command completed successfully.
db2inst1@dblion-a:~> db2 "select * from t0528_target"
ID COL
----------- ----------------
1 2542.405000
1 record(s) selected.
db2inst1@dblion-a:~>
decimal(14,6) 转换为 numeric(14,6) 没有问题，应该是你转换问题。收起
381
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
