sql.txt

CICS简单入门例程 CICS环境构架 1 安装服务器 1） 建立用户CICSTEST（要用超户权） 2）用CICSTEST用户登录 3）安装DB2指定CICSTEST为管理用户

CREATE TABLE USERLIST (ID INTEGER  NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1, NO CACHE ) , LOGINID VARCHAR (10)  NOT NULL , PASSWD VARCHAR(10)  NOT NULL , RULES INTEGER  NOT NULL ,USERNAME VARCHAR(10))  DATA CAPTURE NONE  
COMMENT ON COLUMN USERLIST.ID IS '用户编号'
COMMENT ON COLUMN USERLIST.LOGINID IS '用户登录的用户名'
COMMENT ON COLUMN USERLIST.PASSWD IS '用户口令'
COMMENT ON COLUMN USERLIST.RULES IS '用户权力级'
insert into userlist(loginid,passwd,rules,username) values ('admin','pwadmin',999,'张三')
insert into userlist(loginid,passwd,rules,username) values ('user1','pwuser1',100,'李四')
insert into userlist(loginid,passwd,rules) values ('user2','pwuser2',100)