db2应用经验《一》.txt

来自「db2 指定某个字符串中的第几个字符的更新」· 文本 代码 · 共 27 行

DB2应用经验《一》
//建立数据库DB2_GCB 
CREATE DATABASE DB2_GCB ON G: ALIAS DB2_GCB 
USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM DFT_EXTENT_SZ 32 
//连接数据库 
connect to sample1 user db2admin using password

//建立别名 
create alias db2admin.tables for sysstat.tables; 
CREATE ALIAS DB2ADMIN.VIEWS FOR SYSCAT.VIEWS 
create alias db2admin.columns for syscat.columns; 
create alias guest.columns for syscat.columns; 

//建立表 
create table zjt_tables as 
(select * from tables) definition only; 
create table zjt_views as 
(select * from views) definition only; 

//插入记录 
insert into zjt_tables select * from tables; 
insert into zjt_views select * from views; 

//建立视图 
create view V_zjt_tables as select tabschema,tabname from zjt_tables;