db2应用经验《二》.txt

db2 指定某个字符串中的第几个字符的更新

DB2应用经验《二》
//建立触发器 
CREATE TRIGGER zjt_tables_del 
AFTER DELETE ON zjt_tables 
REFERENCING OLD AS O 
FOR EACH ROW MODE DB2SQL 
Insert into zjt_tables1 values(substr(o.tabschema,1,8),substr(o.tabname,1,10)) 

//建立唯一性索引 
CREATE UNIQUE INDEX I_ztables_tabname 
ON zjt_tables(tabname); 

//查看表 
select tabname from tables 
where tabname='ZJT_TABLES'; 

//查看列 
select SUBSTR(COLNAME,1,20) as 列名,TYPENAME as 类型,LENGTH as 长度 
from columns 
where tabname='ZJT_TABLES'; 

//查看表结构 
db2 describe table user1.department 
db2 describe select * from user.tables 

//查看表的索引 
db2 describe indexes for table user1.department