DB2常用命令大全列表.docVIP

DB2常用命令大全列表 登陆电子对帐数据库22.5.233.142 db2 connect to ebill user ebank using ebank 登陆公司网银数据库22.5.233.142 db2 connect to ebank5 user ebank using ebank 备份表 db2 export to EBC_BILL_LIST_2007_7.ixf of ixf select * from EBC_BILL_LIST where EBL_BILL_SIGNBACK_FLAG = 1 and YEAR(EBL_CREATE_DATE) = 2007 and MONTH(EBL_CREATE_DATE) = 7 导入数据 db2 import from EBC_BILL_LIST_2007_7.ixf of ixf replace into EBC_BILL_LIST 导出建库表的SQL db2look -d ebank5 -a -e -x -o creatab.sql 用db2move将数据备份出来 db2move ebank5 export 导入数据库所有的数据 db2move ebank5 import 将数据导入新库中 db2move ebank5 load 运行存储过程 db2 call EB_UPDATE_STATE