IXF类型数据件数确认方法

yourkeychen

DB2有IXF和CSV两种格式的数据导入和导出
使用CSV方式的时候,可以通过计算CSV文件的行数来确认数据的件数
而使用IXF方式时,如何确认IXF文件数据的件数呢?

目的是当想数据库中导入数据后,
通过查询数据库数据件数或IMPORT返回值求的成功件数,
在求的数据文件件数,通过两者对比,以确认是否所有数据是否一致.

我笨故我在new

导入数据的时候显示的不是一清二楚吗

db2inst1@test:~> db2 "import from staffg.ixf of ixf replace into staffg"
SQL3150N  The H record in the PC/IXF file has product "DB2    02.00", date
"20080109", and time "015823".

SQL3153N  The T record in the PC/IXF file has name "staffg.ixf", qualifier "",
and source "            ".

SQL3109N  The utility is beginning to load data from file "staffg.ixf".

SQL3110N  The utility has completed processing.  "35" rows were read from the
input file.

SQL3221W  ...Begin COMMIT WORK. Input Record Count = "35".

SQL3222W  ...COMMIT of any database changes was successful.

SQL3149N  "35" rows were processed from the input file.  "35" rows were
successfully inserted into the table.  "0" rows were rejected.


Number of rows read         = 35
Number of rows skipped      = 0
Number of rows inserted     = 35
Number of rows updated      = 0
Number of rows rejected     = 0
Number of rows committed    = 35

jansonwang

9494 顶楼上的

degal

up

暮云

同意二楼的