DB2 Import data from a file
[dev1ins1@dev601 ~]
$ db2 import from /usr/opt/app/dbdump/prod-msp_list.txt of del replace into WCS.XIMAGE_TEMP
SQL3109N The utility is beginning to load data from file
"/usr/opt/app/dbdump/prod-msp_list.txt".
SQL3110N The utility has completed processing. "10820" rows were read from
the input file.
SQL3221W ...Begin COMMIT WORK. Input Record Count = "10820".
SQL3222W ...COMMIT of any database changes was successful.
SQL3149N "10820" rows were processed from the input file. "10820" rows were
successfully inserted into the table. "0" rows were rejected.
Number of rows read = 10820
Number of rows skipped = 0
Number of rows inserted = 10820
Number of rows updated = 0
Number of rows rejected = 0
Number of rows committed = 10820
[dev1ins1@dev601 ~]
$ db2 "select count(*) from WCS.XIMAGE_TEMP"
1
-----------
10820
1 record(s) selected.
Comments
Post a Comment