DB2 Data Export Import

C:\users\yexuxia>set Db2instance=tcashman

C:\users\yexuxia>db2
(c) Copyright IBM Corporation 1993,2007
DB2 Client 10.5.0 command-line processor

DB2 = Connect to Tcashman user Db2inst1 using ' 1qaz! QAZ '

Database connection Information

Database Server = db2/aix64 9.7.0
SQL Authorization id = db2inst1
Local Database alias = Tcashman

DB2 = Export to D:\3.csv of del select * from T_planstate
The SQL3104N Export utility is beginning exporting data to the file "D:\3.csv".

The exported data is then opened in an Excel table.

Export formatted as TXT

DB2 = Export to D:\2.txt of del select * from T_planstate
The SQL3104N Export utility is beginning exporting data to the file "D:\2.txt".

The SQL27981W utility failed to verify that a connected or detached data partition exists in the target table or source table.

The sql3105n Export utility has finished exporting the "7" line.

SELECT * from "SYSIBM". " syscolumns "where tbname= ' t_user ' view the table's column field names, properties

DB2 = delete from T_carinfo where carnum like ' 10% '
Db20000i SQL Command completed successfully.

DB2 = Import from D:\3.csv of the Del INSERT into T_carinfo importing table Data command