﻿* SET_DB_F.TXT HARASAWA (Symforware)
F-COMMENT_BEGIN
*********( CREATE DATABASE )*********************************
*(PERMISSION_BEGIN)*
NAME=OP
=WRITE1_OPEN{F.TXT}{OT}{/}WRITE1_CLOSE{}ERROR{};
NAME=
*(PERMISSION_END)*
=WRITE1{'CREATE DATABASE I_?_SYSTEM?;'};
*(PERMISSION_BEGIN)*
=SET{W_CM='SET RDBNAME=?$INSTANCE?&rdbddlex -d I_?_SYSTEM?'};
NAME=CL_CMD
=WRITE1_CLOSE{};
=COMMAND{?W_CM? \I\TMP\F.TXT}; 
NAME=
REPEAT0=$W0PERMISSION
=SET{W_DRV=DRIVE1};
REPEAT=2  (W_REAL_TEST##=REAL;TEST)
=SET{W0REPEAT2CNT=0};
REPEAT2=2 (W_M_W) 
=COMPUTE{W0REPEAT2CNT+=1};
=SET{W_M_W=W_M_W?W0REPEAT2CNT?};
=SET{W_DBS='I?_SYSTEM??W_R_T##??W_M_W??W_PER$$?'};
COPY=OP
=SET{W_DBSPACE='CREATE DBSPACE ?W_DBS? ALLOCATE FILE'
=+' ?W_DRV?:?_P?I?_P?DATABASE?_P??_SYSTEM?.I?_P?'
++=+'I?_SYSTEM??W_R_T##??W_M_W??W_PER$$?.DBS'
=+' ATTRIBUTE SPACE (250M);'}; 
=WRITE1{W_DBSPACE};
COPY=CL_CMD
REPEAT2=
=SET{W_DRV=DRIVE4};
REPEAT0=
*********( CREATE USER )*************************************
=MESSAGE{CREATE USER};
*COPY=OP
*=WRITE1{'SET SYSTEM PARAMETER USER_CONTROL=YES;'};
*COPY=CL_CMD
=LOGIN_SQL{SET SYSTEM PARAMETER USER_CONTROL=YES};
REPEAT0=$W0PERMISSION
REPEAT=2 (W_REAL_TEST##)
=SET{WPAS=W_PASSWORD_?W_REAL_TEST##?};
=SET{W_CU='CREATEDB CREATEUSER'};
=SET{W0REPEAT2CNT=0};
REPEAT2=4 (W_DIOL)
=COMPUTE{W0REPEAT2CNT+=1};
=SET{W_DIOL=W_DIOL?W0REPEAT2CNT?};
=IF{W0REPEAT2CNT=4}SET{WPAS=W_PASSWORD_LINK};
*=IF{W0REPEAT2CNT=2}SET{W_CU=};
*COPY=OP
*=SET{W_WRITE='CREATE USER ?W_IS??W_R_T##??W_DIOL??W_PER$$?'
*=           +' WITH DBMS PASSWORD ''?WPAS?'' FOR USER'};  
=LOGIN_SQL{CREATE USER ?W_IS??W_R_T##??W_DIOL??W_PER$$?
=                 WITH DBMS PASSWORD '?WPAS?' FOR USER}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
*=WRITE1{W_WRITE};
*COPY=CL_CMD
REPEAT0=
*=LOGIN_SQL{SET SYSTEM PARAMETER USER_CONTROL=NO};
*COPY=OP
*=WRITE1{'SET SYSTEM PARAMETER USER_CONTROL=NO;'};
*COPY=CL_CMD
*********( CREATE SCEMA )************************************
=MESSAGE{CREATE SCHEMA};
REPEAT0=$W0PERMISSION
REPEAT=2  (W_REAL_TEST##=REAL;TEST)
=SET{W0REPEAT2CNT=0};
REPEAT2=2 (W_M_W=M,W) 
=COMPUTE{W0REPEAT2CNT+=1};
=SET{W_M_W=W_M_W?W0REPEAT2CNT?};
=LOGIN_SQL{CREATE SCHEMA ?W_IS??W_R_T##??W_M_W??W_PER$$?}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
REPEAT0=
*************( GRANT ALL )***********************************
REPEAT0=$W0PERMISSION
=MESSAGE{GRANT_SCHEMA(?W_PER$$?)};
REPEAT=3
=SET{W0REPEAT2CNT=0};
=SET{W_PERX='ZZZZ'};
REPEAT2=2 (ZZZZ,自分)
=COMPUTE{W0REPEAT2CNT+=1};
=SET{W='GRANT ALL PRIVILEGES ON SCHEMA ?W_IS??W_RTT##?'};
=LOGIN_SQL{?W?M?W_PER$$? TO ?W_IS?RDZZZZ}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{?W?M?W_PER$$? TO ?W_IS??W_RRT##?D?W_PERX?}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{?W?W?W_PER$$? TO ?W_IS??W_RRT##?D?W_PERX?}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{?W?W?W_PER$$? TO ?W_IS??W_RRT##?I?W_PERX?}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{?W?W?W_PER$$? TO ?W_IS??W_RRT##?O?W_PERX?}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=SET{W='GRANT ALL PRIVILEGES ON DBSPACE ?W_IS??W_RTT##?'};
=LOGIN_SQL{?W?M?W_PER$$? TO ?W_IS?RDZZZZ}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{?W?M?W_PER$$? TO ?W_IS??W_RRT##?D?W_PERX?}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{?W?W?W_PER$$? TO ?W_IS??W_RRT##?D?W_PERX?}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{?W?W?W_PER$$? TO ?W_IS??W_RRT##?I?W_PERX?}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{?W?W?W_PER$$? TO ?W_IS??W_RRT##?O?W_PERX?}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF{W_PER$$='ZZZZ'}JUMP{J};
=SET{W_PERX=W_PER$$};
REPEAT2=
=J:
REPEAT0=
*(PERMISSION_END)*
F-COMMENT_END
