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

Popular posts from this blog

Oracle: To clean up WRI$_ADV_OBJECTS