Add, delete, modify, query, and organize
Add
Insert into docsummitinfo (APPID, DOCRESULT, EXITVALUE, LOGDESC, DOCFLAG)
(Select appid, DOCRESULT, EXITVALUE, LOGDESC, DOCFLAG from docsummitinfoBAK)
Delete
1. delete from (Select * from autek. tempmainbak fetch first 20 rows only)
Delete the first 20 queried items
Modify
Query
Backup restoration
Import and Export
Import
1. db2 load from "C: \ 20110816 \ 20151116_bankenterpri
SeCA.txt "OF del modified by coldel0x7c replace into" AUTEK ". TEMPMAINBAK
Import the files separated by "|" into the table. 0x7C is the hexadecimal format of the vertical ascii code.
2. database characters of 1386 GBK
C: \ Documents ents and Settings \ Piggy> db2 load from "C: \ 20110816 \ 20151116_bankenterpri
SeCA.txt "OF del modified by codepage = 1386 coldel0x23 replace into" PIGGY ". TEMP
MAINBAK
Set characters
Db2set DB2CODEPAGE = 819
Db2set DB2CODEPAGE = 1208
The character set of the db2 database is:
> Db2 get db cfg for db_name
SQL sorting
1. SQL Server can be written
Case field when null
In DB2, the case when field is null.