- 创建索引------create unique index gwdev.gg_fy_dsxfyjlb_pk on gwdev.gg_fy_dsxfyjlb (daishengxfyxh asc )pctfree 10 allow reverse scans; grant control on index gwdev.gg_fy_dsxfyjlb_pk to user db2inst1;
- 授权用户--------grant select,insert,update,delete on table gwdev.ss_nbbd_ssqzzajlb to user gwdev;
- 赋给字段初始值----alter table gwdev.ss_nbbd_xggztjd alter column chulizt set with default '0' ;
- 导表数据----export to "d:/tab_cat.txt" of del messages "d:/message.txt" select * from gwdev.tab_cat where catid like 'ss%';
db2相关操作
最新推荐文章于 2020-05-15 08:30:45 发布