教你疾速驾驭DB2数据库中的相关饬令-3

 
33. 表或视图特权
grant select,delete,insert,update on tables to user
grant all on tables to user WITH GRANT OPTION
34. 次序递次包特权
GRANT EXECUTE
ON PACKAGE PACKAGE-name
TO PUBLIC
35. 情势特权
GRANT CREATEIN ON SCHEMA SCHEMA-name TO USER
36. 数据库特权
grant connect,createtab,dbadm on database to user
37. 索引特权
grant control on index index-name to user
38. 信息副手 (? XXXnnnnn )
例:? SQL30081
39. SQL 副手(声名'); SQL 语句的语法)
help statement
歧，help SELECT
40. SQLSTATE 副手(声名'); SQL 的状况和类别代码)
? sqlstate 或 ? > 41. 改观与"管理效能器"相关的口令
db2admin setid username password
42. 创立 SAMPLE 数据库
db2sampl
db2sampl F:(指定安置盘)
43. 运用利用零碎饬令
! dir
44. 转换数据规范 (cast)
SELECT EMPNO, CAST(RESUME AS VARCHAR(370))
FROM EMP_RESUME
WHERE RESUME_FORMAT = 'ascii'
45. UDF
要运转 DB2 Java 存储历程或 UDF，还需求更新效能器上的
DB2 数据库管理次序递次设置配备摆设，以包孕在该机器上安置 JDK 的途径
db2 update dbm cfg using JDK11_PATH d:\sqllib\java\jdk
TERMINATE
update dbm cfg using SPM_NAME sample
46. 反省 DB2 数据库管理次序递次设置配备摆设
db2 get dbm cfg
47. 检索具有特权的全数受权名
SELECT DISTINCT GRANTEE, GRANTEETYPE, 'DATABASE' FROM SYSCAT.DBAUTH
UNION
SELECT DISTINCT GRANTEE, GRANTEETYPE, 'TABLE ' FROM SYSCAT.TABAUTH
UNION
SELECT DISTINCT GRANTEE, GRANTEETYPE, 'PACKAGE ' FROM SYSCAT.PACKAGEAUTH
UNION
SELECT DISTINCT GRANTEE, GRANTEETYPE, 'INDEX ' FROM SYSCAT.INDEXAUTH
UNION
SELECT DISTINCT GRANTEE, GRANTEETYPE, 'COLUMN ' FROM SYSCAT.COLAUTH
UNION
SELECT DISTINCT GRANTEE, GRANTEETYPE, 'SCHEMA ' FROM SYSCAT.SCHEMAAUTH
UNION
SELECT DISTINCT GRANTEE, GRANTEETYPE, 'SERVER ' FROM SYSCAT.PASSTHRUAUTH
ORDER BY GRANTEE, GRANTEETYPE, 3
create table yhdab
(id varchar(10),
password varchar(10),
ywlx varchar(10),
kh varchar(10));
create table ywlbb
(ywlbbh varchar(8),
ywmc varchar(60))
48. 改削表布局
alter table yhdab ALTER kh SET DATA TYPE varchar(13);
alter table yhdab ALTER ID SET DATA TYPE varchar(13);
alter table lst_bsi alter bsi_money set data type int;
insert into yhdab values
('20000300001','123456','user01','20000300001'),
('20000300002','123456','user02','20000300002');

 
来自: 新客网(www.xker.com) 详文参考：http://www.xker.com/page/e2008/0128/46629_3.html


版权声明： 原创作品，答应转载，转载时请务必以超链接情势标明文章 原始出处 、作者信息和本声明。不然将穷究执法责任。