//模式特权
GRANTCREATEINONSCHEMASCHEMA-nameTOUSER
//数据库特权
grantconnect,createtab,dbadmondatabasetouser
//索引特权
grantcontrolonindexindex-nametouser
//信息帮助(?XXXnnnnn)
例:?SQL30081
//SQL帮助(说明SQL语句的语法)
helpstatement
例如，helpSELECT
SQLSTATE帮助(说明SQL的状态和类别代码)
?sqlstate或?class-code
//更改与“管理服务器”相关的口令
db2adminsetidusernamepassword
//创建SAMPLE数据库
db2sampl
db2samplF:(指定安装盘)
//使用操作系统命令
!dir
//转换数据类型(cast)
SELECTEMPNO,CAST(RESUMEASVARCHAR(370))
FROMEMP_RESUME
WHERERESUME_FORMAT='ascii'
//要运行DB2Java存储过程或UDF，还需要更新服务器上的DB2数据库管理程序配置，以包括在该机器上安装JDK的路径
db2updatedbmcfgusingJDK11_PATHd:\sqllib\java\jdk
TERMINATE
updatedbmcfgusingSPM_NAMEsample
//检查DB2数据库管理程序配置
db2getdbmcfg
//检索具有特权的所有授权名
SELECTDISTINCTGRANTEE,GRANTEETYPE,'DATABASE'FROMSYSCAT.DBAUTH
UNION
SELECTDISTINCTGRANTEE,GRANTEETYPE,'TABLE'FROMSYSCAT.TABAUTH
UNION
SELECTDISTINCTGRANTEE,GRANTEETYPE,'PACKAGE'FROMSYSCAT.PACKAGEAUTH
UNION
SELECTDISTINCTGRANTEE,GRANTEETYPE,'INDEX'FROMSYSCAT.INDEXAUTH
UNION
SELECTDISTINCTGRANTEE,GRANTEETYPE,'COLUMN'FROMSYSCAT.COLAUTH
UNION
SELECTDISTINCTGRANTEE,GRANTEETYPE,'SCHEMA'FROMSYSCAT.SCHEMAAUTH
UNION
SELECTDISTINCTGRANTEE,GRANTEETYPE,'SERVER'FROMSYSCAT.PASSTHRUAUTH
ORDERBYGRANTEE,GRANTEETYPE,3
createtableyhdab
(idvarchar(10),
passwordvarchar(10),
ywlxvarchar(10),
khvarchar(10));
createtableywlbb
(ywlbbhvarchar(8),
ywmcvarchar(60))
//修改表结构
altertableyhdabALTERkhSETDATATYPEvarchar(13);
altertableyhdabALTERIDSETDATATYPEvarchar(13);
altertablelst_bsialterbsi_moneysetdatatypeint;
insertintoyhdabvalues
('20000300001','123456','user01','20000300001'),
('20000300002','123456','user02','20000300002');
//业务类型说明
insertintoywlbbvalues
('user01','业务申请'),
('user02','业务撤消'),
('user03','费用查询'),
('user04','费用自缴'),
('user05','费用预存'),
('user06','密码修改'),
('user07','发票打印'),
('gl01','改用户基本信息'),
('gl02','更改支付信息'),
('gl03','日统计功能'),
('gl04','冲帐功能'),
('gl05','对帐功能'),
('gl06','计费功能'),
('gl07','综合统计')
