﻿* SET_END.TXT HARASAWA
***********************************************************************
****************( バージョン　変更 )***********************************
****************( IXMENU ==> VERSION1,VERSION2 )***********************
=SET{W_VERSION2='1'};  I9MENU用*
=SET{W_VERSION1='9'};  I9MENU用は必ず'9'の事。*
****************( IPPRINT==> VERSION )*********************************
=SET{W_VERSION='3'};  IPRINT用*
************************************************************************
=SET{WC.FUNC1='ZZZZZZ_DAY_CHAR_FUNC'};
=SET{WC.FUNC2='ZZZZZZ_DAY_DATE_FUNC'};
=SET{WC.FUNC3='ZZZZZZ_WEEK_CHAR_FUNC'};
=SET{WC.FUNC4='ZZZZZZ_WEEK_DATE_FUNC'};
************************************************************************
=SET{TABLE='RUN'};EXIT3{TABLE};
DATA=TABLE{,1}{RUN,SKIP}
=IF{_DATA='SKIP'}EXIT{LOAD};
*******************************************************************
*=SET{_REAL_TEST='REAL'};
*=SET{W_M=_M_REAL};
*NAME=GRANT_VIEW
*REPEAT=2
*=MESSAGE{TABLE (?_REAL_TEST?) ?W_PER##?};
*REPEAT2=2
*F-=DBO_GRANT{?W_M?ZZ_?W_M_W$$?_?W_PER##?_OBJECT_VIEW}{SELECT}{PUBLIC};
*F-=DBO_GRANT{?W_M?ZZ_?W_M_W$$?_?W_PER##?_GRANT_VIEW}{SELECT}{PUBLIC};
*F-=DBO_GRANT{?W_M?ZZ_?W_M_W$$?_?W_PER##?_COLUMN_VIEW}{SELECT}{PUBLIC};
*F-=DBO_GRANT{?W_M?ZZ_?W_M_W$$?_?W_PER##?_INDEX_VIEW}{SELECT}{PUBLIC};
*REPEAT=
*NAME=
*I-D-=SET{_REAL_TEST='TEST'};
*=SET{W_M=_M_TEST};
*COPY=GRANT_VIEW
=SET{_REAL_TEST='REAL'};SET{W_M=_M_REAL};
REPEAT=2
=IF{##!=2}JUMP{REAL};
=MESSAGE{TABLE (TEST)};
=SET{_REAL_TEST='TEST'};
=SET{W_M=_M_TEST};
=JUMP{TEST};
=REAL:
*****( REAL)*****
************( I_DICTIONARY_TABLE  )********************************************
=DBO_CREATE_TABLE{?W_M?ZZ_I_DICTIONARY_TABLE}{ZZZZZZ_DATA_NAME,30,ZZZZZZ_LANG,C,2}
={ZZZZZZ_BASE_DATA_NAME,30,ZZZZZZ_TITLE,30,ZZZZZZ_MESSAGE,70,ZZZZZZ_COMMENT1,80,ZZZZZZ_COMMENT2,80,ZZZZZZ_TEST,C,4
=,ZZZZZZ_DEFAULT_TYPE,C,9,ZZZZZZ_DEFAULT_LENGTH1,INT,ZZZZZZ_DEFAULT_LENGTH2,INT
=,ZZZZZZ_TYPE1,C,1,ZZZZZZ_TYPE2,C,1,ZZZZZZ_LENGTH1,INT,ZZZZZZ_LENGTH2,INT,ZZZZZZ_CHECK,C,10
=,ZZZZZZ_CHECK61,54,ZZZZZZ_CHECK62,54,ZZZZZZ_CHECK63,54,ZZZZZZ_CHECK64,54,ZZZZZZ_CHECK65,54,ZZZZZZ_CHECK66,54}
=IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_DICTIONARY_TABLE}{TABLE}{PUBLIC};
***(自分自身のNCHAR確定の為実行)**
=SET{W_INSERT='INSERT INTO ?W_M?ZZ_I_DICTIONARY_TABLE(ZZZZZZ_LANG,ZZZZZZ_DEFAULT_TYPE'
=+',ZZZZZZ_DATA_NAME,ZZZZZZ_DEFAULT_LENGTH1)VALUES(''?_LANG?'',''NCHAR'''};
=SQL{?W_INSERT?,'ZZZZZZ_NAME',30)}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_INSERT?,'ZZZZZZ_DATA_NAME',30)}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_INSERT?,'ZZZZZZ_MESSAGE',70)}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_INSERT?,'ZZZZZZ_COMMENT1',80)}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_INSERT?,'ZZZZZZ_COMMENT2',80)}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
REPEAT2=6
=SQL{?W_INSERT?,'ZZZZZZ_CHECK6$$',54)}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
REPEAT2=
****************************************************************
*=DBO_DROP_TABLE{?W_M?ZZ_I_PERMISSION_TABLE};
=DBO_CREATE_TABLE{?W_M?ZZ_I_PERMISSION_TABLE}{ZZZZZZ_NAME,30,ZZZZZZ_PERMISSION,C,4,ZZZZZZ_USER,C,1}{}
= IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_I_ERROR? ?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_PERMISSION_TABLE}{TABLE}{PUBLIC};
=DBO_CREATE_TABLE{?W_M?ZZ_I_MENU_TABLE}
={ZZZZZZ_LANG,C,2,ZZZZZZ_MENU0,C,4,ZZZZZZ_MENU1,C,2,ZZZZZZ_MENU2,C,2,ZZZZZZ_MENU3,C,2}
={ZZZZZZ_PROGRAM_KIND,C,6,ZZZZZZ_PERMISSION,C,4,ZZZZZZ_PART,C,2,ZZZZZZ_SECURITY,C,1,ZZZZZZ_TEST,C,4,ZZZZZZ_COPY1,C,10
=,ZZZZZZ_COPY2,C,10,ZZZZZZ_COPY3,C,10,ZZZZZZ_COPY4,C,10,ZZZZZZ_COPY5,C,10,ZZZZZZ_MENU,30}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR??_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_MENU_TABLE}{TABLE}{PUBLIC};
*** PROGRAM CREATE ***
=DBO_CREATE_TABLE{?W_M?ZZ_I_PROGRAM_TABLE}
={ZZZZZZ_JOB,C,10,ZZZZZZ_SEQ,INT}{ZZZZZZ_PROGRAM,61}
= IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_PROGRAM_TABLE}{TABLE}{PUBLIC};
*** HELP CREATE ***
=DBO_CREATE_TABLE{?W_M?ZZ_I_HELP_TABLE}
={ZZZZZZ_LANG,C,2,ZZZZZZ_JOB,C,10,ZZZZZZ_SEQ,INT}{ZZZZZZ_CALL,C,10,ZZZZZZ_HELP,61}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_HELP_TABLE}{TABLE}{PUBLIC};
*** TABLE CREATE ***
=DBO_CREATE_TABLE{?W_M?ZZ_I_TABLE_TABLE}{ZZZZZZ_NAME,30}
={ZZZZZZ_TEST,C,4,ZZZZZZ_INDEX,INT,ZZZZZZ_PUBLIC,C,6,ZZZZZZ_COMMENT1,80,ZZZZZZ_COMMENT2,80}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_TABLE_TABLE}{TABLE}{PUBLIC};
*** TABLE CREATE ***
*=DROP_TABLE{?W_M?ZZ_I_COLUMN_TABLE}NOP{};
=DBO_CREATE_TABLE{?W_M?ZZ_I_COLUMN_TABLE}{ZZZZZZ_NAME,30,ZZZZZZ_DATA_NAME,30}
={ZZZZZZ_SEQ,INT,ZZZZZZ_DEFAULT_TYPE,C,9,ZZZZZZ_DEFAULT_LENGTH1,INT,ZZZZZZ_DEFAULT_LENGTH2,INT
=,ZZZZZZ_IX0,C,1,ZZZZZZ_IX1,C,1,ZZZZZZ_IX2,C,1,ZZZZZZ_IX3,C,1,ZZZZZZ_IX4,C,1,ZZZZZZ_IX5,C,1,ZZZZZZ_IX6,C,1,ZZZZZZ_IX7,C,1,ZZZZZZ_IX8,C,1,ZZZZZZ_IX9,C,1
=,ZZZZZZ_COMMENT1,80,ZZZZZZ_COMMENT2,80}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_COLUMN_TABLE}{TABLE}{PUBLIC};
*** OBJECT CREATE ***
=DBO_CREATE_TABLE{?W_M?ZZ_I_OBJECT_ID_TABLE}
={ZZZZZZ_KIND,C,5,ZZZZZZ_NAME,30}{ZZZZZZ_TEST,C,4,ZZZZZZ_CREATE,C,1,ZZZZZZ_PUBLIC,C,6,ZZZZZZ_COMMENT1,80,ZZZZZZ_COMMENT2,80}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_OBJECT_ID_TABLE}{TABLE}{PUBLIC};
*** OBJECT CREATE ***
=DBO_CREATE_TABLE{?W_M?ZZ_I_OBJECT_TABLE}
={ZZZZZZ_KIND,C,5,ZZZZZZ_NAME,30,ZZZZZZ_SEQ,INT}{ZZZZZZ_COM,C,1,ZZZZZZ_SIGN,C,1,ZZZZZZ_OBJECT,59}
=  JUMP{ERROR_OBJECT};
=JUMP{JJJ};
=ERROR_OBJECT:IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
*=SQL{SELECT ' ' FROM ?W_M?ZZ_M_ZZZZ_COLUMN_VIEW WHERE ZZZZZZ_NAME='ZZZZZZ_I_OBJECT_TABLE'
*= AND ZZZZZZ_DATA_NAME='ZZZZZZ_SIGN'}JUMP{ERR_COLUMN_VIEW};
*=JUMP{J};
*=ERR_COLUMN_VIEW:IF{_DB_I_ERROR!='NOT_EXIST'}IF{_DB_ERROR!='L1142'}ERROR{?_DB_ERROR? ?_ERROR?};
*=JUMP{JJJ};
*=J:SQL_SET{}{?_TEXT1?}ERROR{ZZZZZZ_SIGNがZZZZZZ_I_OBJECT_TABLEに有りません}; 
*=SQL_SET{W0.ZZZZZZ_DEFAULT_LENGTH1}{SELECT ZZZZZZ_DEFAULT_LENGTH1 FROM ?W_M?ZZ_M_ZZZZ_COLUMN_VIEW WHERE 
*=  ZZZZZZ_NAME='ZZZZZZ_I_OBJECT_TABLE' AND ZZZZZZ_DATA_NAME='ZZZZZZ_OBJECT'}
*= ERROR{ZZZZZZ_OBJECTがZZZZZZ_I_OBJECT_TABLEに有りません}; 
*=IF{W0.ZZZZZZ_DEFAULT_LENGTH1<>59}
*=   ERROR{ZZZZZZ_OBJECT(ZZZZZZ_I_OBJECT_TABLE)が59文字ではありません。(?W0.ZZZZZZ_DEFAULT_LENGTH1?)};
=JJJ:
=DBO_GRANT{?W_M?ZZ_I_OBJECT_TABLE}{TABLE}{PUBLIC};
*** ZZZZZZ_I_ERROR_TABLE CREATE ***
=DBO_CREATE_TABLE{?W_M?ZZ_I_ERROR_TABLE}
*={ZZZZZZ_TIME,?_SQL_TIME?,ZZZZZZ_JOB,C,10,ZZZZZZ_COMPUTER,C,15}{ZZZZZZ_ERROR,NV,1500}
={ZZZZZZ_TIME,C,17,ZZZZZZ_JOB,C,10,ZZZZZZ_COMPUTER,C,15}{ZZZZZZ_ERROR,NV,1500}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_ERROR_TABLE}{TABLE}{PUBLIC};
*** ZZZZZZ_I_SQL_TABLE CREATE ***
*=DROP_TABLE{?W_M?ZZ_I_SQL_TABLE}NOP{};
=DBO_CREATE_TABLE{?W_M?ZZ_I_SQL_TABLE}
={ZZZZZZ_PERSON,C,8,ZZZZZZ_REAL,C,4,ZZZZZZ_SQL_KIND,C,4,ZZZZZZ_SEQ,INT}{ZZZZZZ_COM,C,1,ZZZZZZ_SQL_DATA,80}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_SQL_TABLE}{TABLE}{PUBLIC};
=TEST:
*****( REAL,TEST )*****
* I MS-SQLSERVER SETUP (REAL,TEST,OLD) ***
* BASE TABLE CREATE ***
* ZZZZZZ_PRINT_ID_TABLE CREATE ***
*=DBO_DROP_TABLE{?W_M?ZZ_PRINT_ID_TABLE};
=DBO_CREATE_TABLE{?W_M?ZZ_PRINT_ID_TABLE}
={ZZZZZZ_PRINT,20}{ZZZZZZ_TEST,C,4,ZZZZZZ_COMMENT,50}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_PRINT_ID_TABLE}{TABLE}{PUBLIC};
***( ZZZZZZ_PRINT_TABLE CREATE )
*=DBO_DROP_TABLE{?W_M?ZZ_PRINT_TABLE};
=DBO_CREATE_TABLE{?W_M?ZZ_PRINT_TABLE}
={ZZZZZZ_PRINT,20,ZZZZZZ_SEQ,INT}{ZZZZZZ_PRINT_DATA,60}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_PRINT_TABLE}{TABLE}{PUBLIC};
*****( REAL,TEST)***
* I MS-SQLSERVER SETUP (REAL,TEST) 
* BASE TABLE CREATE ***
*** ZZZZZZ_KEEP_TABLE CREATE ***
=DBO_CREATE_TABLE{?W_M?ZZ_KEEP_TABLE}
={ZZZZZZ_COMPUTER,C,15,ZZZZZZ_NAME,30}{ZZZZZZ_KEEP,80}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_KEEP_TABLE}{TABLE}{PUBLIC};
*** ?W_M?_HOLIDAY_TABLE CREATE ***
=DBO_CREATE_TABLE{?W_M?ZZ_HOLIDAY_TABLE}
={ZZZZZZ_COUNTRY,C,2,ZZZZZZ_MM,C,2,ZZZZZZ_MARK_CALENDAR,C,1,ZZZZZZ_DD,C,2}{}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_HOLIDAY_TABLE}{TABLE}{PUBLIC};
*** ?W_M?_CALENDAR_TABLE CREATE ***
=DBO_CREATE_TABLE{?W_M?ZZ_CALENDAR_TABLE}
={ZZZZZZ_DATE,C,8}{ZZZZZZ_HOLIDAY,C,1,ZZZZZZ_HOLIDAY_DEFAULT,C,1}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_CALENDAR_TABLE}{TABLE}{PUBLIC};
*** ?W_M?ZZ_ETC_TABLE CREATE 
=DBO_CREATE_TABLE{?W_M?ZZ_ETC_TABLE}
={ZZZZZZ_KEY1,C,20,ZZZZZZ_KEY2,C,30}{ZZZZZZ_ETC,50,ZZZZZZ_COMMENT,50}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_ETC_TABLE}{TABLE}{PUBLIC};
*** ?W_M?ZZ_ETC_ID_TABLE CREATE
=DBO_CREATE_TABLE{?W_M?ZZ_ETC_ID_TABLE}
={ZZZZZZ_KEY1,C,20}{ZZZZZZ_COMMENT,50}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_ETC_ID_TABLE}{TABLE}{PUBLIC};
*** ?W_M?ZZ_SAMPLE_TABLE CREATE
=DBO_CREATE_TABLE{?W_M?ZZ_SAMPLE_TABLE}
={ZZZZZZ_KEY1_SAMPLE,C,5,ZZZZZZ_KEY2_SAMPLE,C,5}{ZZZZZZ_CHAR,C,5,ZZZZZZ_INT,INT
=,ZZZZZZ_DECIMAL,DECIMAL,7,2,ZZZZZZ_DATE,C,8}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_SAMPLE_TABLE}{TABLE}{PUBLIC};
=SQL{INSERT INTO ?W_M?ZZ_SAMPLE_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1_SAMPLE,ZZZZZZ_KEY2_SAMPLE,ZZZZZZ_CHAR,ZZZZZZ_INT
=,ZZZZZZ_DECIMAL,ZZZZZZ_DATE)
=  VALUES(?_Z_INSERT_VALUE?,'AAAAA','AAAAA','AAAAA',12345,12345.67,'20040824')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_SAMPLE_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1_SAMPLE,ZZZZZZ_KEY2_SAMPLE,ZZZZZZ_CHAR,ZZZZZZ_INT
=,ZZZZZZ_DECIMAL,ZZZZZZ_DATE)
=  VALUES(?_Z_INSERT_VALUE?,'AAAAA','BBBBB','BBBBB',54321,76543.21,'20040831')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_SAMPLE_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1_SAMPLE,ZZZZZZ_KEY2_SAMPLE,ZZZZZZ_CHAR,ZZZZZZ_INT
=,ZZZZZZ_DECIMAL,ZZZZZZ_DATE)
=  VALUES(?_Z_INSERT_VALUE?,'BBBBB','BBBBB','BBBBB',0,0,'20041106')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
********( INSERT ?W_M?ZZ_ETC_ID_TABLE )****************************************
=SQL{INSERT INTO ?W_M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','FIXED DATA(@...)')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_%','SWITCH DATA(%...)')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_COPY','I COPY=@...')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_INSTALL','I INSTALL MENU')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_MENU0','I ZZZZZZ_MENU0')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_PERMISSION','I PREMISSION')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_SYSTEM','I SYSTEM CONTROL')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_BOJECT_SAMPLE','I OBJECT SAMPLE')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_PROGRAM','I PROGRAM MODEL')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_PART:ZZZY','NONPUBLIC SYSTEM')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_PART:ZZZZ','PUBLIC SYSTEM')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
*******'( INSERT ?W_M?ZZ_ETC_TABLE )***********************************
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_CHECK_LANG','JA,EN','JA=JAPAN,EN=ENGLISH')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_DATE_EN','D/','1:(Y=YMD,M=MDY,D=DMY)2:YMZZZZZZ_SEPARATION')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_DATE_JA','Y-','1:(Y=YMD,M=MDY,D=DMY)2:YMZZZZZZ_SEPARATION')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_PERMISSION_COUNT','2','PERMISSION COUNT')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_PERMISSION_NO1','ZZZZ','ZZZZ')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_PERMISSION_NO2','ZZZY','ZZZY')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_PROXY','　','X.X.X.X:X (IP:PORT) INTERNET PROXY')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_VERSION1','?W_VERSION1?','VERSION1(?W_VERSION1?) IXMENU,IXTIME')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{UPDATE ?W_M?ZZ_ETC_TABLE SET ZZZZZZ_ETC='?W_VERSION1?' WHERE ZZZZZZ_KEY1='ZZZZZZ_@'  AND ZZZZZZ_KEY2='ZZZZZZ_VERSION1'}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_VERSION2','?W_VERSION2?','VERSION2(?W_VERSION2?) IXMENU,IXTIME')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{UPDATE ?W_M?ZZ_ETC_TABLE SET ZZZZZZ_ETC='?W_VERSION2?' WHERE ZZZZZZ_KEY1='ZZZZZZ_@'  AND ZZZZZZ_KEY2='ZZZZZZ_VERSION2'}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_VERSION','?W_VERSION?','VERSION(?W_VERSION?) IPRINT')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_PART:ZZZY','AA','New system','New system')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{UPDATE ?W_M?ZZ_ETC_TABLE SET ZZZZZZ_ETC='?W_VERSION?' WHERE ZZZZZZ_KEY1='ZZZZZZ_@' AND ZZZZZZ_KEY2='ZZZZZZ_VERSION'};
***********************************************************************************
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_INSTALL','ZZZZ-?_LANG_SYSTEM?','?SYSTEM_NAME?','ZZZZ-?_LANG_SYSTEM? INSTALL')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_MENU0','ZZZZ',' ','DEFAULT INSTALL MENU')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_PERMISSION','ZZZY','NONPUBLIC SYSTEM','NONPUBLIC SYSTEM')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_PERMISSION','ZZZZ','PUBLIC SYSTEM','PUBLIC SYSTEM')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SET{W_ETC='INSERT INTO ?W_M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)VALUES(?_Z_INSERT_VALUE?,''ZZZZZZ_SYSTEM'''};
=SQL{?W_ETC?,'ZZZZZZ_DATE','00000101','TODAY [JOB=T999951]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_DATE_OLD','00000101','OLD DATE [JOB=T999951]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_BROWSE_U','NOTEPAD','BROWSE UNIX')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_BROWSE_W','NOTEPAD','BROWSE WINDOWS')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_CALENDAR_ADD','365*2','CALENDAR ADD +(DAY){365*2}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_CALENDAR_CANCEL','365*1','CALENDAR CANCEL -(DAY){365*1}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_COUNTRY','JP','JP=JAPAN{JP}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_DBBACKUP_COUNT_SAVE_R','1','REAL DB BACKUP SAVE COUNT(DAY){1}[1-9]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_DBBACKUP_COUNT_SAVE_T','1','TEST DB BACKUP SAVE COUNT(DAY){1}[1-9]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_DBBACKUP_REAL_MAST','YES','REAL DB BACKUP (YES,NO){YES}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_DBBACKUP_REAL_WORK','YES','REAL WORK DB BACKUP (YES,NO){YES}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_DBBACKUP_TEST_MAST','YES','TEST DB BACKUP (YES,NO){YES}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_DBBACKUP_TEST_WORK','YES','TEST WORK DB BACKUP (YES,NO){YES}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_DB_M','?_OS_DRIVE? MSSQL.1\MSSQL\LOG','DB 1,2=DRIVE 4..=PATH')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
*=SQL{?W_ETC?,'ZZZZZZ_LOG_ERASE','365*3','ERASE LOG(DAY){365*3}')}
*=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_I_ERROR_TABLE_CANCEL','365*2','ZZZZZZ_I_ERROR_TABLE CANCEL -(DAY){365*2}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_I_TIME_LOG_TABLE_CANCEL','365*5','ZZZZZZ_I_ERROR_TABLE CANCEL -(DAY){365*5}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_I_USE_TABLE_CANCEL','365*5','ZZZZZZ_I_USE_TABLE CANCEL -(DAY){365*5}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
W+=SET{W_CFG='?DRIVE1?,?DRIVE2?,?DRIVE3?,?DRIVE4?,?DRIVE5?,?DRIVE6?,?OS_LOGIN?,?SECRET?,?GUEST?'};
U+=SET{W_CFG='?DRIVE1?,,,?DRIVE4?,,,,,'};
=SQL{?W_ETC?,'ZZZZZZ_INSTALL_CFG','?W_CFG?','INSTALL CONFIGURATION{?W_CFG?}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SET{_UPPER=$JDBC};
=SQL{?W_ETC?,'ZZZZZZ_JDBC','?_UPPER?','JAVA JDBC')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_PASSWORD_LIMIT_DATE','0','PASSWORD LIMIT DATE (DAY){0}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_PASSWORD_MIN_ALPHABET','1','PASSWORD MIN ALPHABET{1}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_PASSWORD_MIN_LENGTH','7','PASSWORD MIN LENGTH{7}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_PASSWORD_MIN_NUMBER','1','PASSWORD MIN NUMBER{1}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_TIME_START','08:30','SYSTEM START TIME (HH:MM){08:30}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_TIME_LIMIT','17:30','SYSTEM TIME LIMIT (HH:MM){17:30}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_ETC?,'ZZZZZZ_Z_CANCEL_DELETE','31','Z_CANCEL DELETE -(DAY){31}')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
*** ?W_M?_HOLIDAY_TABLE INSERT  ***
=SET{W_CAL='INSERT INTO ?W_M?ZZ_HOLIDAY_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_COUNTRY,ZZZZZZ_MM,ZZZZZZ_MARK_CALENDAR,ZZZZZZ_DD) VALUES(?_Z_INSERT_VALUE?,'};
=SQL{?W_CAL?'JP','00','0','01')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','00','0','07')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','01','D','01')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','01','2','02')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','02','D','11')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','03','D','21')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','04','D','29')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','05','D','03')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','05','D','04')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','05','D','05')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','07','3','02')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','09','3','02')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','09','D','23')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','10','2','02')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','11','D','03')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','11','D','23')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{?W_CAL?'JP','12','D','23')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_PRINT_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_PRINT,ZZZZZZ_TEST,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_SAMPLE',' ','I PRINT SAMPLE')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_PRINT_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_PRINT,ZZZZZZ_TEST,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_SAMPLE_HATTYU',' ','HATYUSYO PRINT SAMPLE')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
************************************************************
******( CREATE VIEW NEW )***********************************
************************************************************
=IF{##=2}JUMP{TEST_VIEW_SKIP};
*(PERMISSION_BEGIN)*
=MESSAGE{CREATE TABLE};
=SET{WN.OBJECT_TABLE='?_MP_REAL_ZZZZ?ZZ_I_OBJECT_TABLE'};
=SQL_REPEAT{WC.PERMISSION}
={SELECT ZZZZZZ_KEY2 FROM ?_MP_REAL_ZZZZ?ZZ_ETC_TABLE
=  WHERE ZZZZZZ_KEY1='ZZZZZZ_PERMISSION'
= AND Z_CANCEL=' ' ORDER BY 1 DESC};
=SET{W0PER_COUNT=1,W0VC=1,W0PER_MAX=_SQL_REPEAT_COUNT};
=VIEW_PER_LOOP:
=SET{WC.PER=WC.PERMISSION?W0PER_COUNT?
=   ,WC.PER_L=WC.PER@LOWER};
=MESSAGE{CREATE VIEW};
REPEAT2=2 (M,W)
=SET{_LOWER='I_',W_I_L=_LOWER};
=SET{W_M_DB='?_Q?_DB_HEADER?_Q?_?W_M_W$$?_?WC.PER?'};
=SET{W_I_DB=W_M_DB,W_P_DB=W_M_DB,W_L_DB=W_M_DB};
=SET{W_H_DB='?_Q?_DB_HEADER?_Q??W_M_W$$??WC.PER?'};
=SET{W_D_DB='?_Q?_DB_HEADER?_Q??W_M_W$$??WC.PER?'};
$1+=SET{W_MAST_WORK='MAST'};
$2+=SET{W_MAST_WORK='WORK'};
$1+=SET{W_O_OWNER='''?_Q?_DB_HEADER?_Q?_D_?WC.PER?'''};
$2+=SET{W_O_OWNER='''?_Q?_DB_HEADER?_Q?_I_?WC.PER?'''
$2+=            +',''?_Q?_DB_HEADER?_Q?_O_?WC.PER?'''};
$1+=SET{W_H_OWNER='''?_Q?_DB_HEADER?_Q?D?WC.PER?'''};
$2+=SET{W_H_OWNER='''?_Q?_DB_HEADER?_Q?I?WC.PER?'''
$2+=            +',''?_Q?_DB_HEADER?_Q?O?WC.PER?'''};
$1+=SET{W_P_OWNER1=
$1+=' IN(LOWER(''?_Q?_DB_HEADER?_Q?_D_?WC.PER?''))'};
$1+=SET{W_P_OWNER2=};
$2+=SET{W_P_OWNER1=
$2+=' IN(LOWER(''?_Q?_DB_HEADER?_Q?_I_?WC.PER?'')'};
$2+=SET{W_P_OWNER2=
$2+=   ',LOWER(''?_Q?_DB_HEADER?_Q?_O_?WC.PER?''))'};
$1+=SET{W_D_OWNER1='?_Q?_DB_HEADER?_Q?D?WC.PER?'};
$1+=SET{W_D_OWNER2='?_Q?_DB_HEADER?_Q?D?WC.PER?'};
$2+=SET{W_D_OWNER1='?_Q?_DB_HEADER?_Q?I?WC.PER?'};
$2+=SET{W_D_OWNER2='?_Q?_DB_HEADER?_Q?O?WC.PER?'};
=IF{_JOB!='ZZZZ000000'}IF{WC.PER='ZZZZ'}
=        JUMP{ZZZ_OBJECT_COLUMN_INDEX_SKIP};
=SET{WC.VIEW?W0VC?='ZZZZZZ_?W_M_W$$?_?WC.PER?_OBJECT_VIEW'};
NAME=VIEW_BEGIN##$$
=SET{W0=0};
=SET{WN.ZZZZZZ_NAME=WC.VIEW?W0VC?};COMPUTE{W0VC+=1};
=DBO_SQL{DELETE FROM ?WN.OBJECT_TABLE? WHERE
= ?_VRE&WN.ZZZZZZ_NAME?};
=SET{W_INSERT='INSERT INTO ?WN.OBJECT_TABLE?'
=+'(?_Z_INSERT_NAME?,ZZZZZZ_KIND,ZZZZZZ_NAME'
=+',ZZZZZZ_SIGN,ZZZZZZ_COM,ZZZZZZ_SEQ'
=+',ZZZZZZ_OBJECT)VALUES(?_Z_INSERT_VALUE?,''VIEW'''
=+',?_N?''?WN.ZZZZZZ_NAME?'',''+'','};
NAME=     
COPY=D_OBJECT_VIEW
COPY=H_OBJECT_VIEW
COPY=I_OBJECT_VIEW
COPY=L_OBJECT_VIEW
COPY=M_OBJECT_VIEW
COPY=O_OBJECT_VIEW
COPY=P_OBJECT_VIEW
NAME=CREATE_VIEW##$$
=SET{WN.OBJECTS=};
=SQL1{SELECT ZZZZZZ_OBJECT FROM ?_MP_ZZZZ?ZZ_I_OBJECT_TABLE
= WHERE ZZZZZZ_KIND='VIEW' AND ZZZZZZ_NAME='?WN.ZZZZZZ_NAME?'
= AND(ZZZZZZ_COM=' '
= OR ZZZZZZ_COM='?_DB?' AND ZZZZZZ_SIGN='+'
= OR ZZZZZZ_COM NOT IN(' ','*','?_DB?') AND ZZZZZZ_SIGN='-')
= AND Z_CANCEL=' ' ORDER BY ZZZZZZ_SEQ};
=SQL1_NEXT{WN.OBJECT}ERROR{VIEW(?WN.ZZZZZZ_NAME?)NOT FOUND};
=B:SET{WN.OBJECTS+=WN.OBJECT};
=SQL1_NEXT{WN.OBJECT}JUMP{J};BACK{B};
=J:SET{_EDIT=WN.OBJECTS,WN.OBJECTS_REAL=_EDIT}
=  ERROR{VIEW(?WN.ZZZZZZ_NAME?)?_ERROR?};
=SET{_REAL_TEST='TEST'};
=SET{_EDIT=WN.OBJECTS,WN.OBJECTS_TEST=_EDIT}
=  ERROR{VIEW(?WN.ZZZZZZ_NAME?)?_ERROR?};
=SET{_REAL_TEST='REAL'};
=SET{W_XX=_MX_REAL_ZZZZ};
=DBO_DROP_OBJECT{?W_XX??WN.ZZZZZZ_NAME?}{VIEW}; 
=DBO_CREATE_OBJECT{?W_XX??WN.ZZZZZZ_NAME?}{VIEW}
=   {?WN.OBJECTS_REAL?}ERROR{};
=DBO_GRANT{?W_XX??WN.ZZZZZZ_NAME?}{SELECT}{PUBLIC};
D-=SET{_REAL_TEST='TEST'};
=SET{W_XX=_MX_TEST_ZZZZ};
=DBO_DROP_OBJECT{?W_XX??WN.ZZZZZZ_NAME?}{VIEW}; 
=DBO_CREATE_OBJECT{?W_XX??WN.ZZZZZZ_NAME?}{VIEW}
=   {?WN.OBJECTS_TEST?}ERROR{};
I+=SET{_REAL_TEST='REAL'};
=DBO_GRANT{?W_XX??WN.ZZZZZZ_NAME?}{SELECT}{PUBLIC};
=SET{_REAL_TEST='REAL'};
NAME=
=SET{WC.VIEW?W0VC?='ZZZZZZ_?W_M_W$$?_?WC.PER?_COLUMN_VIEW'};
COPY=VIEW_BEGIN##$$
COPY=D_COLUMN_VIEW
COPY=H_COLUMN_VIEW
COPY=I_COLUMN_VIEW
COPY=L_COLUMN_VIEW
COPY=M_COLUMN_VIEW
COPY=O_COLUMN_VIEW
COPY=P_COLUMN_VIEW
COPY=CREATE_VIEW##$$
=SET{WC.VIEW?W0VC?='ZZZZZZ_?W_M_W$$?_?WC.PER?_INDEX_VIEW'};
COPY=VIEW_BEGIN##$$
COPY=D_INDEX_VIEW
COPY=H_INDEX_VIEW
COPY=I_INDEX_VIEW
COPY=L_INDEX_VIEW
COPY=M_INDEX_VIEW
COPY=O_INDEX_VIEW
COPY=P_INDEX_VIEW
COPY=CREATE_VIEW##$$
=ZZZ_OBJECT_COLUMN_INDEX_SKIP:
=SET{WC.VIEW?W0VC?='ZZZZZZ_?W_M_W$$?_?WC.PER?_GRANT_VIEW'};
COPY=VIEW_BEGIN##$$
COPY=D_GRANT_VIEW
COPY=H_GRANT_VIEW
COPY=I_GRANT_VIEW
COPY=L_GRANT_VIEW
COPY=M_GRANT_VIEW
COPY=O_GRANT_VIEW
COPY=P_GRANT_VIEW
COPY=CREATE_VIEW##$$
REPEAT2=
=COMPUTE{W0PER_COUNT+=1};
=IF{W0PER_COUNT<=W0PER_MAX}BACK{VIEW_PER_LOOP};
=TEST_VIEW_SKIP:
*(PERMISSION_END)*
*=SET{_TRACE=0};
=if{##=2}JUMP{TEST_DICTIONARY_SKIP};
******( COPY DIRECTORY_TABLE NCHAR確定の為ここで実行する )******
=MESSAGE{LOAD (DICTIONARY)};
=DROP_TABLE{?_WORK_TABLE?A};
=COPY_TABLE{?_WORK_TABLE?A}{?W_M?ZZ_I_DICTIONARY_TABLE}{NOT};
=INSERT_FILE{?_WORK_TABLE?A}{ZZZZZZ_DATA_NAME,ZZZZZZ_LANG,ZZZZZZ_BASE_DATA_NAME,ZZZZZZ_TITLE
=,ZZZZZZ_MESSAGE,ZZZZZZ_COMMENT1,ZZZZZZ_COMMENT2
=,ZZZZZZ_TEST,ZZZZZZ_DEFAULT_TYPE,ZZZZZZ_DEFAULT_LENGTH1,ZZZZZZ_DEFAULT_LENGTH2
=,ZZZZZZ_TYPE1,ZZZZZZ_TYPE2,ZZZZZZ_LENGTH1,ZZZZZZ_LENGTH2
=,ZZZZZZ_CHECK,ZZZZZZ_CHECK61,ZZZZZZ_CHECK62,ZZZZZZ_CHECK63,ZZZZZZ_CHECK64,ZZZZZZ_CHECK65,ZZZZZZ_CHECK66}
={?_EXE_PATH??_P?I_SERVER?_P?SET_DICT.TXT}{/};
=REPLACE_PART{?W_M?ZZ_I_DICTIONARY_TABLE}{?_WORK_TABLE?A}{ZZZZZZ_DATA_NAME,ZZZZZZ_LANG}
={ZZZZZZ_BASE_DATA_NAME,ZZZZZZ_TITLE,ZZZZZZ_MESSAGE,ZZZZZZ_COMMENT1,ZZZZZZ_COMMENT2
=,ZZZZZZ_TEST,ZZZZZZ_DEFAULT_TYPE,ZZZZZZ_DEFAULT_LENGTH1,ZZZZZZ_DEFAULT_LENGTH2
=,ZZZZZZ_TYPE1,ZZZZZZ_TYPE2,ZZZZZZ_LENGTH1,ZZZZZZ_LENGTH2
=,ZZZZZZ_CHECK,ZZZZZZ_CHECK61,ZZZZZZ_CHECK62,ZZZZZZ_CHECK63,ZZZZZZ_CHECK64,ZZZZZZ_CHECK65,ZZZZZZ_CHECK66}
={}{};
D+=SQL{UPDATE ?W_M?ZZ_I_DICTIONARY_TABLE SET ZZZZZZ_TYPE1='M' WHERE 
D+= ZZZZZZ_DATA_NAME IN('ZZZZZZ_NAME','ZZZZZZ_BASE_NAME','ZZZZZZ_DATA_NAME')
D+= AND ZZZZZZ_TYPE1='N'};日本語NG化*
=TEST_DICTIONARY_SKIP:
******( COPY TABLE ETC_TABLE }
=MESSAGE{LOAD (ETC)};
=DROP_TABLE{?_WORK_TABLE?A};
=COPY_TABLE{?_WORK_TABLE?A}{?W_M?ZZ_ETC_TABLE}{NOT};
=INSERT_FILE{?_WORK_TABLE?A}{ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT}
={?_EXE_PATH??_P?I_SERVER?_P?SET_ETC.TXT}{/};
=REPLACE_ALL{?W_M?ZZ_ETC_TABLE}{?_WORK_TABLE?A}{ZZZZZZ_KEY1,ZZZZZZ_KEY2}{ZZZZZZ_ETC,ZZZZZZ_COMMENT}
={(?_O?ZZZZZZ_KEY1='ZZZZZZ_PROGRAM' OR ?_O?ZZZZZZ_KEY1='ZZZZZZ_OBJECT_SAMPLE'
= OR ?_O?ZZZZZZ_KEY1 IN('ZZZZZZ_PART:ZZZY','ZZZZZZ_PART:ZZZZ') AND ?_O?ZZZZZZ_KEY2 IN('ZY','ZZ')
= OR ?_O?ZZZZZZ_KEY1='ZZZZZZ_COPY' AND 
F-=RTRIM
F+=TRIM
=(?_SUBSTR?(?_O?ZZZZZZ_KEY2?_FROM?1?_FOR?10))='ZZZZZZ_SQL')}{};
******( COPY TABLE PRINT_TABLE }
=MESSAGE{LOAD (PRINT)};
=DROP_TABLE{?_WORK_TABLE?A};
=COPY_TABLE{?_WORK_TABLE?A}{?W_M?ZZ_PRINT_TABLE}{NOT};
=INSERT_FILE{?_WORK_TABLE?A}{ZZZZZZ_PRINT,ZZZZZZ_SEQ,ZZZZZZ_PRINT_DATA}
={?_EXE_PATH??_P?I_SERVER?_P?SET_PRIN.TXT}{/};
=REPLACE_ALL{?W_M?ZZ_PRINT_TABLE}{?_WORK_TABLE?A}{ZZZZZZ_PRINT,ZZZZZZ_SEQ}{ZZZZZZ_PRINT_DATA}
={?_O?ZZZZZZ_PRINT LIKE 'ZZZZZZ_SAMPLE%'}{};
****( PACKAGE TABLE )*****
*=DBO_DROP_TABLE{?W_M?ZZ_PACKAGE_DICTIONARY_TABLE};
*=DBO_CREATE_TABLE{?W_M?ZZ_PACKAGE_DICTIONARY_TABLE}{ZZZZZZ_PACKAGE,C,15,ZZZZZZ_DATA_NAME,30,ZZZZZZ_LANG,C,2}
*={ZZZZZZ_NAME,30,ZZZZZZ_TITLE,30,ZZZZZZ_MESSAGE,70,ZZZZZZ_COMMENT1,80,ZZZZZZ_COMMENT2,80,ZZZZZZ_TEST,C,4
*=,ZZZZZZ_DEFAULT_TYPE,C,9,ZZZZZZ_DEFAULT_LENGTH1,INT,ZZZZZZ_DEFAULT_LENGTH2,INT
*=,ZZZZZZ_TYPE1,1,ZZZZZZ_TYPE2,1,ZZZZZZ_LENGTH1,INT,ZZZZZZ_LENGTH2,INT,ZZZZZZ_CHECK,8
*=,ZZZZZZ_CHECK61,54,ZZZZZZ_CHECK62,54,ZZZZZZ_CHECK63,54,ZZZZZZ_CHECK64,54,ZZZZZZ_CHECK65,54,ZZZZZZ_CHECK66,54}
*=IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
*=DBO_GRANT{?W_M?ZZ_PACKAGE_DICTIONARY_TABLE}{TABLE}{PUBLIC};
*=DBO_DROP_TABLE{?W_M?ZZ_PACKAGE_DEFAULT_TABLE};
=DBO_CREATE_TABLE{?W_M?ZZ_PACKAGE_DEFAULT_TABLE}{ZZZZZZ_PACKAGE,C,15,ZZZZZZ_NAME,30,ZZZZZZ_LANG,C,2}
={ZZZZZZ_TITLE,30,ZZZZZZ_DEFAULT_TYPE,C,9,ZZZZZZ_DEFAULT_LENGTH1,INT,ZZZZZZ_DEFAULT_LENGTH2,INT
=,ZZZZZZ_TYPE1,C,1,ZZZZZZ_LENGTH1,INT,ZZZZZZ_LENGTH2,INT}
=IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_PACKAGE_DEFAULT_TABLE}{TABLE}{PUBLIC};
=J:
L-=SET{W_MF='ZZZZ'};
L+=SET{W_MF=W_M};
*P-I-H-D-=DBO_GRANT{?W_MF?ZZ_DAY_CHAR_FUNC} {FUNCTION}{PUBLIC};
*P-I-H-D-=DBO_GRANT{?W_MF?ZZ_DAY_DATE_FUNC} {FUNCTION}{PUBLIC};
*P-I-H-D-=DBO_GRANT{?W_MF?ZZ_WEEK_CHAR_FUNC}{FUNCTION}{PUBLIC};
*P-I-H-D-=DBO_GRANT{?W_MF?ZZ_WEEK_DATE_FUNC}{FUNCTION}{PUBLIC};
=IF{##!=1}JUMP{TEST_SKIP};
****( REAL, )*** 
* IPROFGRAM MS-SQLSERVER SETUP (REAL,WORK) ***
* GROUP CREATE **
=DBO_CREATE_TABLE{?W_M?ZZ_I_SECURITY_G_ID_TABLE}
={ZZZZZZ_GROUP,C,15}{ZZZZZZ_GROUP_NAME,30}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_SECURITY_G_ID_TABLE}{TABLE}{PUBLIC};
=DBO_CREATE_TABLE{?W_M?ZZ_I_SECURITY_G_TABLE}
={ZZZZZZ_PERSON,C,8,ZZZZZZ_GROUP,C,15}{ZZZZZZ_BEGIN_DATE,C,8,ZZZZZZ_END_DATE,C,8,ZZZZZZ_USE_DATE17,C,17,ZZZZZZ_USE_COMPUTER,C,15}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_SECURITY_G_TABLE}{TABLE}{PUBLIC};
=DBO_CREATE_TABLE{?W_M?ZZ_I_SECURITY_G_J_TABLE}
={ZZZZZZ_GROUP,C,15,ZZZZZZ_JOB,C,10}{}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_SECURITY_G_J_TABLE}{TABLE}{PUBLIC};
*** PASSWORD CREATE
=DBO_CREATE_TABLE{?W_M?ZZ_I_SECURITY_TABLE}
={ZZZZZZ_PERSON,C,8}{ZZZZZZ_PASSWORD,C,16,ZZZZZZ_SECURITY_MARK,C,6,ZZZZZZ_PERSON_NAME,16,ZZZZZZ_PERMISSION,C,4
=,ZZZZZZ_BEGIN_DATE,C,8,ZZZZZZ_END_DATE,C,8,ZZZZZZ_PASSWORD_LIMIT_DATE,C,8,ZZZZZZ_USE_DATE17,C,17,ZZZZZZ_USE_COMPUTER,C,15,ZZZZZZ_ERROR_COUNT,INT
=,ZZZZZZ_PASSWORD2,C,16,ZZZZZZ_PASSWORD3,C,16,ZZZZZZ_PASSWORD4,C,16}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_SECURITY_TABLE}{TABLE}{PUBLIC};
*** PASSWORD2 CREATE
=DBO_CREATE_TABLE{?W_M?ZZ_I_SECURITY_J_TABLE}
={ZZZZZZ_PERSON,C,8,ZZZZZZ_JOB,C,10}{ZZZZZZ_BEGIN_DATE,C,8,ZZZZZZ_END_DATE,C,8,ZZZZZZ_USE_DATE17,C,17,ZZZZZZ_USE_COMPUTER,C,15}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_SECURITY_J_TABLE}{TABLE}{PUBLIC};
*** TIME CREATE
=DBO_CREATE_TABLE{?W_M?ZZ_I_TIME_TABLE}
={ZZZZZZ_HH,C,2,ZZZZZZ_MIN,C,2}{ZZZZZZ_MENU0,C,4,ZZZZZZ_MENU1,C,2,ZZZZZZ_MENU2,C,2,ZZZZZZ_TIMING,C,2,ZZZZZZ_BEGIN_END,C,1
=,ZZZZZZ_SHIFT,C,2,ZZZZZZ_TEST,C,4,ZZZZZZ_DOC,51
**=,ZZZZZZ_BEGIN_TIME,DATETIME,ZZZZZZ_END_TIME,DATETIME,ZZZZZZ_REAL_STATUS,5,ZZZZZZ_TEST_STATUS,5}
=,ZZZZZZ_REAL_BEGIN_TIME,C,17,ZZZZZZ_REAL_BEGIN_JOB,C,10,ZZZZZZ_REAL_BEGIN_MENU,30
=,ZZZZZZ_REAL_END_TIME,C,17,ZZZZZZ_REAL_END_JOB,C,10,ZZZZZZ_REAL_END_MENU,30
=,ZZZZZZ_REAL_OPTION,C,5,ZZZZZZ_REAL_STATUS,C,5,ZZZZZZ_REAL_MESSAGE,NV,256
=,ZZZZZZ_TEST_BEGIN_TIME,C,17,ZZZZZZ_TEST_BEGIN_JOB,C,10,ZZZZZZ_TEST_BEGIN_MENU,30
=,ZZZZZZ_TEST_END_TIME,C,17,ZZZZZZ_TEST_END_JOB,C,10,ZZZZZZ_TEST_END_MENU,30
=,ZZZZZZ_TEST_OPTION,C,5,ZZZZZZ_TEST_STATUS,C,5,ZZZZZZ_TEST_MESSAGE,NV,256}
=IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_TIME_TABLE}{TABLE}{PUBLIC};
*** TIME_LOG CREATE
=DBO_CREATE_TABLE{?W_M?ZZ_I_TIME_LOG_TABLE}
={ZZZZZZ_NOW_TIME,C,17,ZZZZZZ_HH,C,2,ZZZZZZ_MIN,C,2,ZZZZZZ_MENU0,C,4,ZZZZZZ_COUNT,INT}
={ZZZZZZ_BEGIN_TIME,C,17,ZZZZZZ_START_TIME,C,17,ZZZZZZ_JOB,C,10,ZZZZZZ_MARK,C,5,ZZZZZZ_LOG,NV,256}
=IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_TIME_LOG_TABLE}{TABLE}{PUBLIC};
*** USE CREATE ***
=DBO_CREATE_TABLE{?W_M?ZZ_I_USE_TABLE}
={ZZZZZZ_YEAR_MONTH,C,6,ZZZZZZ_JOB,C,10,ZZZZZZ_COMPUTER,C,15,ZZZZZZ_PERSON,C,8}{ZZZZZZ_USE,INT}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_I_USE_TABLE}{TABLE}{PUBLIC};
*** I MS-SQLSERVER SETUP (REAL) ***
*** INSERT TIME_TABLE ***
=SQL{INSERT INTO ?W_M?ZZ_I_TIME_TABLE
=  (?_Z_INSERT_NAME?,ZZZZZZ_HH,ZZZZZZ_MIN,ZZZZZZ_MENU0,ZZZZZZ_MENU1,ZZZZZZ_MENU2,ZZZZZZ_TIMING,ZZZZZZ_BEGIN_END,ZZZZZZ_SHIFT,ZZZZZZ_TEST,ZZZZZZ_DOC)
=  VALUES(?_Z_INSERT_VALUE?,'99','97','ZZZZ','99','97',' ',' ',' ',' ','POST NUMBER')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_I_TIME_TABLE
=  (?_Z_INSERT_NAME?,ZZZZZZ_HH,ZZZZZZ_MIN,ZZZZZZ_MENU0,ZZZZZZ_MENU1,ZZZZZZ_MENU2,ZZZZZZ_TIMING,ZZZZZZ_BEGIN_END,ZZZZZZ_SHIFT,ZZZZZZ_TEST,ZZZZZZ_DOC)
=  VALUES(?_Z_INSERT_VALUE?,'12','00','ZZZZ','99','98','D',' ',' ',' ','DATABASE BACKUP(MSSQL ONLY)')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_I_TIME_TABLE
=  (?_Z_INSERT_NAME?,ZZZZZZ_HH,ZZZZZZ_MIN,ZZZZZZ_MENU0,ZZZZZZ_MENU1,ZZZZZZ_MENU2,ZZZZZZ_TIMING,ZZZZZZ_BEGIN_END,ZZZZZZ_SHIFT,ZZZZZZ_TEST,ZZZZZZ_DOC)
=  VALUES(?_Z_INSERT_VALUE?,'99','99','ZZZZ','99','99',' ',' ',' ',' ','SYSTEM START')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_I_MENU_TABLE
=  (?_Z_INSERT_NAME?,ZZZZZZ_LANG,ZZZZZZ_MENU0,ZZZZZZ_MENU1,ZZZZZZ_MENU2,ZZZZZZ_MENU3,ZZZZZZ_MENU,ZZZZZZ_PERMISSION)
=  VALUES(?_Z_INSERT_VALUE?,'JA','ZZZZ','00','00','00','?SYSTEM_NAME?','ZZZZ')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_I_MENU_TABLE
=  (?_Z_INSERT_NAME?,ZZZZZZ_LANG,ZZZZZZ_MENU0,ZZZZZZ_MENU1,ZZZZZZ_MENU2,ZZZZZZ_MENU3,ZZZZZZ_MENU,ZZZZZZ_PERMISSION)
=  VALUES(?_Z_INSERT_VALUE?,'EN','ZZZZ','00','00','00','?SYSTEM_NAME?','ZZZZ')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_I_MENU_TABLE
=  (?_Z_INSERT_NAME?,ZZZZZZ_LANG,ZZZZZZ_MENU0,ZZZZZZ_MENU1,ZZZZZZ_MENU2,ZZZZZZ_MENU3,ZZZZZZ_MENU,ZZZZZZ_PERMISSION)
=  VALUES(?_Z_INSERT_VALUE?,'JA','ZZZZ','00','00','98','Y88=HELP (ZZZZ000098,1=COLOR)','ZZZZ')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_I_MENU_TABLE
=  (?_Z_INSERT_NAME?,ZZZZZZ_LANG,ZZZZZZ_MENU0,ZZZZZZ_MENU1,ZZZZZZ_MENU2,ZZZZZZ_MENU3,ZZZZZZ_MENU,ZZZZZZ_PERMISSION)
=  VALUES(?_Z_INSERT_VALUE?,'JA','ZZZZ','00','00','99','Y   HELP2(ZZZZ000099,1=COLOR)','ZZZZ')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
*=SQL{INSERT INTO ?W_M?ZZ_I_MENU_TABLE
*=  (?_Z_INSERT_NAME?,ZZZZZZ_LANG,ZZZZZZ_MENU0,ZZZZZZ_MENU1,ZZZZZZ_MENU2,ZZZZZZ_MENU3,ZZZZZZ_MENU,ZZZZZZ_PERMISSION)
*=  VALUES(?_Z_INSERT_VALUE?,'EN','ZZZZ','00','00','98','Y88=HELP (ZZZZ000098,1=COLOR)','ZZZZ')}
*=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
*=SQL{INSERT INTO ?W_M?ZZ_I_MENU_TABLE
*=  (?_Z_INSERT_NAME?,ZZZZZZ_LANG,ZZZZZZ_MENU0,ZZZZZZ_MENU1,ZZZZZZ_MENU2,ZZZZZZ_MENU3,ZZZZZZ_MENU,ZZZZZZ_PERMISSION)
*=  VALUES(?_Z_INSERT_VALUE?,'EN','ZZZZ','00','00','99','YINFOMATION2 (ZZZ000099,1=COLOR)','ZZZZ')}
*=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_I_SECURITY_TABLE 
=  (?_Z_INSERT_NAME?,ZZZZZZ_PERSON,ZZZZZZ_PASSWORD,ZZZZZZ_SECURITY_MARK,ZZZZZZ_PERSON_NAME,ZZZZZZ_PERMISSION,ZZZZZZ_PASSWORD_LIMIT_DATE)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZZZ','?W_ZZZZ_PASSWORD?','ADMIN','ZZZZ ADMIN','ZZZZ','00000101')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SQL{INSERT INTO ?W_M?ZZ_I_SECURITY_TABLE 
=  (?_Z_INSERT_NAME?,ZZZZZZ_PERSON,ZZZZZZ_PASSWORD,ZZZZZZ_SECURITY_MARK,ZZZZZZ_PERSON_NAME,ZZZZZZ_PERMISSION,ZZZZZZ_PASSWORD_LIMIT_DATE)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZZY','?W_ZZZY_PASSWORD?','ADMIN','ZZZY ADMIN','ZZZY','00000101')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=TEST_SKIP:
REPEAT=
=SET{_REAL_TEST='REAL'};
=SET{W_M=_M_REAL};
********( INSERT ?W_M?ZZ_I_OBJECT_ID_TABLE I SYSTEM FUNC VIEW )************************************* 
REPEAT=4
=SQL{INSERT INTO ?W_M?ZZ_I_OBJECT_ID_TABLE 
=  (?_Z_INSERT_NAME?,ZZZZZZ_KIND,ZZZZZZ_NAME,ZZZZZZ_TEST,ZZZZZZ_CREATE,ZZZZZZ_PUBLIC,ZZZZZZ_COMMENT1,ZZZZZZ_COMMENT2)
=  VALUES(?_Z_INSERT_VALUE?,'FUNC','?WC.FUNC##?',' ',' ','PUBLIC','I SYSTEM FUNC',' ')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
REPEAT=
********************
*(PERMISSION_BEGIN*)
=MESSAGE{INSERT VIEW};
=SET{W0C=1};
=B:SET{WC.VIEW=WC.VIEW?W0C?};
=SQL{INSERT INTO ?W_M?ZZ_I_OBJECT_ID_TABLE 
=(?_Z_INSERT_NAME?,ZZZZZZ_KIND,ZZZZZZ_NAME
=,ZZZZZZ_TEST,ZZZZZZ_CREATE,ZZZZZZ_PUBLIC
=,ZZZZZZ_COMMENT1,ZZZZZZ_COMMENT2)
=VALUES(?_Z_INSERT_VALUE?,'VIEW','?WC.VIEW?',' '
=,' ','PUBLIC','I SYSTEM VIEW',' ')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}
=   ERROR{?_DB_ERROR? ?_ERROR?};
=COMPUTE{W0C+=1};
=IF{W0C<W0VC}BACK{B};
*(PERMISSION_END*)
************************************************************
=SET{LOAD='RUN'};EXIT3{LOAD};
DATA=LOAD{,1}{RUN,SKIP}
=IF{_DATA='SKIP'}EXIT{LOAD2};
************************************************************
=MESSAGE{LOAD (I_OBJECT)};
=DROP_TABLE{?_WORK_TABLE?A}ERROR{?_DB_ERROR?};
=COPY_TABLE{?_WORK_TABLE?A}{?W_M?ZZ_I_OBJECT_TABLE}{NOT};
=INSERT_FILE{?_WORK_TABLE?A}{ZZZZZZ_KIND,ZZZZZZ_NAME,ZZZZZZ_SEQ,ZZZZZZ_COM,ZZZZZZ_SIGN,ZZZZZZ_OBJECT}
={?_EXE_PATH??_P?I_SERVER?_P?SET_OBJE.TXT}{/};
=REPLACE_ALL{?W_M?ZZ_I_OBJECT_TABLE}{?_WORK_TABLE?A}{ZZZZZZ_KIND,ZZZZZZ_NAME,ZZZZZZ_SEQ}{ZZZZZZ_COM,ZZZZZZ_SIGN,ZZZZZZ_OBJECT}
={?_O?ZZZZZZ_KIND='FUNC'
= AND ?_O?ZZZZZZ_NAME IN('?WC.FUNC1?','?WC.FUNC2?','?WC.FUNC3?','?WC.FUNC4?')}{};
=MESSAGE{LOAD (I_MENU)};
=DROP_TABLE{?_WORK_TABLE?A}ERROR{?_DB_ERROR?};
=COPY_TABLE{?_WORK_TABLE?A}{?W_M?ZZ_I_MENU_TABLE}{NOT};
=INSERT_FILE{?_WORK_TABLE?A}{ZZZZZZ_LANG,ZZZZZZ_MENU0,ZZZZZZ_MENU1,ZZZZZZ_MENU2,ZZZZZZ_MENU3,ZZZZZZ_PROGRAM_KIND
=,ZZZZZZ_PERMISSION,ZZZZZZ_PART,ZZZZZZ_SECURITY,ZZZZZZ_TEST,ZZZZZZ_COPY1,ZZZZZZ_COPY2,ZZZZZZ_COPY3,ZZZZZZ_COPY4,ZZZZZZ_COPY5,ZZZZZZ_MENU}
={?_EXE_PATH??_P?I_SERVER?_P?SET_MENU.TXT}{/};
=REPLACE_ALL{?W_M?ZZ_I_MENU_TABLE}{?_WORK_TABLE?A}{ZZZZZZ_LANG,ZZZZZZ_MENU0,ZZZZZZ_MENU1,ZZZZZZ_MENU2,ZZZZZZ_MENU3}
={ZZZZZZ_PROGRAM_KIND,ZZZZZZ_PERMISSION,ZZZZZZ_PART,ZZZZZZ_SECURITY,ZZZZZZ_TEST,ZZZZZZ_COPY1,ZZZZZZ_COPY2,ZZZZZZ_COPY3,ZZZZZZ_COPY4,ZZZZZZ_COPY5,ZZZZZZ_MENU}
={?_O?ZZZZZZ_MENU0='ZZZZ' AND ( ?_O?ZZZZZZ_MENU1='99' AND ?_O?ZZZZZZ_MENU2 IN('97','98','99')
= AND ( ?_O?ZZZZZZ_MENU3 LIKE '5%' OR ?_O?ZZZZZZ_MENU3 LIKE '6%' ) OR ?_O?ZZZZZZ_MENU1='01' AND 
=  ?_O?ZZZZZZ_MENU2 IN('00','01','02','03','04','05','07') OR ?_O?ZZZZZZ_MENU1='40')}{};
=MESSAGE{LOAD (I_HELP)};
=DROP_TABLE{?_WORK_TABLE?A};
=COPY_TABLE{?_WORK_TABLE?A}{?W_M?ZZ_I_HELP_TABLE}{NOT};
=INSERT_FILE{?_WORK_TABLE?A}{ZZZZZZ_LANG,ZZZZZZ_JOB,ZZZZZZ_SEQ,ZZZZZZ_CALL,ZZZZZZ_HELP}
={?_EXE_PATH??_P?I_SERVER?_P?SET_HELP.TXT}{/};
=REPLACE_ALL{?W_M?ZZ_I_HELP_TABLE}{?_WORK_TABLE?A}{ZZZZZZ_LANG,ZZZZZZ_JOB,ZZZZZZ_SEQ}{ZZZZZZ_CALL,ZZZZZZ_HELP}
={?_O?ZZZZZZ_JOB LIKE 'ZZZZ99975%'  OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99976%' OR 
= ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99985%'  OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99986%' OR 
= ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99995%'  OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99996%' OR 
= ?_O?ZZZZZZ_JOB =    'ZZZZ000000'  OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0100%' OR 
= ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0101%'   OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0102%' OR 
= ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0103%'   OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0104%' OR 
= ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0105%'   OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0107%'  
= OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ40%'}{};
=SET{LOAD2='RUN'};EXIT3{LOAD2};
DATA=LOAD2{,1}{RUN,SKIP}
=IF{_DATA='SKIP'}EXIT{ETC};
*******************************************************************
=MESSAGE{LOAD (I_PROGRAM)};
=DROP_TABLE{?_WORK_TABLE?A};
=COPY_TABLE{?_WORK_TABLE?A}{?W_M?ZZ_I_PROGRAM_TABLE}{NOT};
=INSERT_FILE{?_WORK_TABLE?A}{ZZZZZZ_JOB,ZZZZZZ_SEQ,ZZZZZZ_PROGRAM}
={?_EXE_PATH??_P?I_SERVER?_P?SET_PROG.TXT}{/};
=REPLACE_ALL{?W_M?ZZ_I_PROGRAM_TABLE}{?_WORK_TABLE?A}{ZZZZZZ_JOB,ZZZZZZ_SEQ}{ZZZZZZ_PROGRAM}
={?_O?ZZZZZZ_JOB LIKE 'ZZZZ99975%' OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99976%' OR 
= ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99985%' OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99986%' OR 
= ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99995%' OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99996%' OR 
= ?_O?ZZZZZZ_JOB =    'ZZZZ000000' OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0100%' OR 
= ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0101%'  OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0102%' OR 
= ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0103%'  OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0104%' OR 
= ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0105%'  OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0107%' 
= OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ40%'}{};
F+=LOGIN_SQL{SET SYSTEM PARAMETER USER_CONTROL=NO};
****************************************************************************
********( CREATE FUNCTION (NEW) )*******************************************
****************************************************************************
*=SET{_TRACE=1};
D-=MESSAGE{CREATE FUNCTION};
D-REPEAT=4
D-=SET{WN.ZZZZZZ_OBJECT_REAL=,WN.ZZZZZZ_OBJECT_TEST=};
D-=SQL1{SELECT ZZZZZZ_OBJECT FROM ?_MP_REAL_ZZZZ?ZZ_I_OBJECT_TABLE
D-= WHERE ZZZZZZ_NAME='?WC.FUNC##?'
D-= AND (ZZZZZZ_COM=' ' OR ZZZZZZ_COM='?_DB?'  AND ZZZZZZ_SIGN='+'
D-= OR ZZZZZZ_COM NOT IN(' ','*','?_DB?') AND ZZZZZZ_SIGN='-')
D-= AND Z_CANCEL=' ' ORDER BY ZZZZZZ_SEQ};
D-=SQL1_NEXT{WN.ZZZZZZ_OBJECT}ERROR{_I_OBJECT_TABLE(?WC.FUNC##?) IS NOT FOUND};
D-=B:SET{_EDIT=WN.ZZZZZZ_OBJECT,WN.ZZZZZZ_OBJECT_REAL+=_EDIT}ERROR{EDIT(?WC.FUNC##?)};
D-=SET{_REAL_TEST='TEST'};
D-=SET{_EDIT_ERROR=WN.ZZZZZZ_OBJECT,WN.ZZZZZZ_OBJECT_TEST+=_EDIT_ERROR};
D-=SET{_REAL_TEST='REAL'};
D-=SQL1_NEXT{WN.ZZZZZZ_OBJECT}JUMP{J};
D-=BACK{B};
D-=J:
D-=SET{WN.ZZZZZZ_OBJECT_NAME=_MX_REAL_ZZZZ+WC.FUNC##};
D-=DBO_DROP_OBJECT{?WN.ZZZZZZ_OBJECT_NAME?}{FUNC}ERROR{DROP_OBJECT(?WC.FUNC##?)};
D-=DBO_CREATE_OBJECT{?WN.ZZZZZZ_OBJECT_NAME?}{FUNC}{?WN.ZZZZZZ_OBJECT_REAL?}
D-=      ERROR{CREATE_OBJECT(?WC.FUNC##?)};
D-=DBO_GRANT{?WN.ZZZZZZ_OBJECT_NAME?}{FUNC}{PUBLIC}ERROR{GRANT_OBJECT(?WC.FUNC##?)};
D-=SET{_REAL_TEST='TEST'};
D-=SET{WN.ZZZZZZ_OBJECT_NAME=_MX_TEST_ZZZZ+WC.FUNC##};
D-=DBO_DROP_OBJECT{?WN.ZZZZZZ_OBJECT_NAME?}{FUNC}JUMP{TEST_FUNC_ERROR};
D-=DBO_CREATE_OBJECT{?WN.ZZZZZZ_OBJECT_NAME?}{FUNC}{?WN.ZZZZZZ_OBJECT_TEST?}
D-=                                                   JUMP{TEST_FUNC_ERROR};
D-I+=SET{_REAL_TEST='REAL'};
D-=DBO_GRANT{?WN.ZZZZZZ_OBJECT_NAME?}{FUNC}{PUBLIC}JUMP{TEST_FUNC_ERROR};
D-=SET{_REAL_TEST='REAL'};
D-=JUMP{J};
D-=TEST_FUNC_ERROR:SET{_REAL_TEST='REAL'};ERROR{TEST CREATE FUNCTION(?WC.FUNC##?)?_ERROR?};
D-=J:
D-REPEAT=
*************************************************************************************** 
=SET{ETC='RUN'};EXIT3{ETC};
DATA=ETC{,1}{RUN,SKIP}
=IF{_DATA='SKIP'}EXIT{OK};
*******************************************************************
=MESSAGE{ETC};
=MESSAGE{?_EXE_PATH?};
W+=COMMAND{"?_EXE_PATH??_P?I_SERVER?_P?SET_END.BAT" ?_VERSION1? ?_SYSTEM? WINDOWS ?_LANG? 30/600 ?_SERVER_NAME?_?_SYSTEM?.I ?_EXE_PATH?};
U+=COMMAND{ ?_EXE_PATH??_P?I_SERVER?_P?SET_END.SH   ?_VERSION1? ?_SYSTEM? UNIX    ?_LANG? 30/600 ?_SERVER_NAME?_?_SYSTEM?.I ?_EXE_PATH? ?$JDBC?};
W+REPEAT=4
W+=IF{$W_NAME_FIRE##!=}COMMAND{"?_EXE_PATH??_P?I_SERVER?_P?SET_FIRE.BAT" ?$W_NAME_FIRE##? ?$W_PROGRAM_FIRE##?};
W+REPEAT=
********( DLL 転送　)**********************
W+REPEAT=3
W+=IF{$W_DLL##=}JUMP{SKIP};
W+=COPY_FILE{?_OS_DRIVE??_P?I?_P?FILE?_P??_SYSTEM?.I?_P?BIN?_P??$W_DLL##?}{?$W_DLL_IN##?};
W+REPEAT2=$W0FRAMEWORK_COUNT
W+=MAKE_DIR {?_OS_DRIVE??_P?I?_P?FILE?_P?SHARE?_P?WINDOWS?_P?BIN?_P?FRAMEWORK?$W_FRAMEWORK$$?};
W+=SET{W_IN=_OS_DRIVE+_P+'I'+_P+'BIN'+_P+'FRAMEWORK'+$W_FRAMEWORK$$+_P+$W_DLL##};
W+=IF_FILE{?W_IN?}
W+=  COPY_FILE{?_OS_DRIVE??_P?I?_P?FILE?_P?SHARE?_P??$W_OS_NAME??_P?BIN?_P?FRAMEWORK?$W_FRAMEWORK$$??_P??$W_DLL##?}{?W_IN?};
W+REPEAT2=
W+=SKIP:
W+REPEAT=
*****************************
=COMMAND{?_OS_DRIVE??_P?I?_P?FILE?_P??_SYSTEM?.I?_P?BAT?_P?ZZZZZZETC ?_IV? ?_LANG? REAL ?_SYSTEM? ZZZZ000000 SETUP_CLIENT ?_DB? ?_SERVER_NAME? ?_SYSTEM? ?_LANG? ?_EXE_PARAM? ZZZZ ?SYSTEM_NAME? ?$JDBC?};
*W+=CHANGE_DIR{?_OS_DRIVE??_P?I?_P?FILE?_P?SHARE?_P?WINDOWS};
*U+=CHANGE_DIR{?_OS_DRIVE??_P?I?_P?FILE?_P?SHARE?_P?UNIX};
W+=COMMAND{?_OS_DRIVE?&CD ?_P?I?_P?FILE?_P?SHARE?_P?WINDOWS&SETUP_?SYSTEM?_?_LANG?_ZZZZ};
U+=COMMAND{cd ?_OS_DRIVE??_P?I?_P?FILE?_P?SHARE?_P?UNIX;./SETUP_?SYSTEM?_?_LANG?_ZZZZ};
*=CHANGE_DIR{};
U+=READ1_OPEN{/tmp/I_SET_END_?SYSTEM?.TMP}{/}ERROR{/tmp/I_SET_END_?SYSTEM?.TMP is not found};
U+=READ1_NEXT{W0DIR_CNT}JUMP{F_ERR};READ1_CLOSE{};
U+=SET{WC.ZZZZZZ_KEY1='ZZZZZZ_SYSTEM'};
U+=SET{WC.ZZZZZZ_KEY2='ZZZZZZ_UNIX_AT_QUEUE_REAL',WN.ZZZZZZ_COMMENT='?SYSTEM? REAL{A}[A-M](Every system is unique)'};
U+NAME=AT_QUEUE
U+=SET{WN.ZZZZZZ_ETC=_A?W0DIR_CNT?};
U+=                       PROGRAM{?_MM_REAL?_ETC_TABLE}{WC.ZZZZZZ_KEY1,WC.ZZZZZZ_KEY2}{WN.ZZZZZZ_ETC,WN.ZZZZZZ_COMMENT}{2N};
U+=SET{_REAL_TEST='TEST'};PROGRAM{?_MM_TEST?_ETC_TABLE}{WC.ZZZZZZ_KEY1,WC.ZZZZZZ_KEY2}{WN.ZZZZZZ_ETC,WN.ZZZZZZ_COMMENT}{2N};SET{_REAL_TEST='REAL'};
U+NAME=
U+=COMPUTE{W0DIR_CNT+=13};
U+=SET{WC.ZZZZZZ_KEY2='ZZZZZZ_UNIX_AT_QUEUE_TEST',WN.ZZZZZZ_COMMENT='?SYSTEM? TEST{N}[N-Z](Every system is unique)'};
U+COPY=AT_QUEUE
U+=JUMP{J};
U+=F_ERR:READ1_CLOSE{};ERROR{/tmp/I_SET_END_?SYSTEM?.TMP is NULL};
U+=J:
U+=COPY_FILE{/home/I/FILE/?_SYSTEM?.I/BIN/?$JDBC?}{/home/I/BIN/?$JDBC?};
U+=COPY_FILE{/home/I/FILE/SHARE/UNIX/BIN/?$JDBC?}{/home/I/BIN/?$JDBC?};
*FORM1= 次 @@@ {Enter}
*******************************************************************
DATA=OK{,}{}
*******************************************************************
PROGRAM=NOT
CONTROL=PROGRAM,ERROR,SQL_DBO,HIGH
BEGIN
=SET{_TITLE='SETUP I SERVER 5/8'}; 
=SET{YES='YES',_PERSON='ZZZZZZZZ'};
JA+FORM1=◎ツール用管理者パスワード変更します。
JA-FORM1=*change a manager password for tools of it.
JA+FORM1=セキュリティ確保のためYESで画面を立ち上げ必ず変更してください。
JA-FORM1=You stand and put up a screen in YES for security security,
JA-FORM1=    and please change it by all means.
JA+FORM1=ツールの操作方法の勉強も兼ねて実際の画面で変更します。
JA-FORM1=serve and change the study of the operation method
JA-FORM1=    of the tool with a real screen.
JA+FORM1=(1)使用者に'ZZZZZZZZ'を入れます。
JA-FORM1=(1)put 'ZZZZZZZZ' in a PERSON.
JA+FORM1=(2)旧パスワードに'ZZZZZZZZZZZZZZZZ'を入れます。
JA-FORM1=(2)put 'ZZZZZZZZZZZZZZZZ' in a OLD PASSWORD.
JA+FORM1=(3)新パスワード1/2及び2/2に新しいパスワードを入れます。
JA-FORM1=(3)put New Password in a NEW PASSWORD 1/2 and NEW PASSWORD 2/2.
JA+FORM1=  (文字数は７文字以上にして下さい）
JA-FORM1=  (please do the number of the letters than 7 characters)
JA+FORM1=  (文字には英字と数字を含めて下さい）
JA-FORM1=  (please include an English letter and a number in a letter)
JA+FORM1=  (文字数の少ない場合は{Enter}キーで次に進みます）
JA-FORM1=  (when there is few it, a letter keeps numerical
JA-FORM1=        with a {Enter} key next)
JA+FORM1=  (戻る場合は{←}キーで戻ります）
JA-FORM1=  (when You come back,You come back with a {←} key)
JA+FORM1=(4)JUDJEで'3'を入れて{Enter}キーを押すと修正します。
JA-FORM1=(4)put '3' in JUDJE and revise it when push the {Enter} key.
JA+FORM1=同じ画面で一般管理者用のパスワードも変更します。
JA-FORM1=change the password for general managers with the same screen.
JA+FORM1=(5)使用者に'ZZZZZZZY'を入れます。
JA-FORM1=(5)put 'ZZZZZZZY' in a PERSON.
JA+FORM1=(6)旧パスワードに'ZZZZZZZZZZZZZZZY'を入れます。
JA-FORM1=(6)put 'ZZZZZZZZZZZZZZZY' in a OLD PASSWORD.
JA+FORM1=(7)新パスワード1/2及び2/2に新しいパスワードを入れます。
JA-FORM1=(7)put New Password in a NEW PASSWORD 1/2 and NEW PASSWORD 2/2.
JA+FORM1=(8)JUDJEで'3'入れて[Enter]キーお押すと修正します。
JA-FORM1=(8)put '3' in JUDJE and revise it when push the {Enter} key.
JA+FORM1=(9){Esc}キーを押すと終了します。
JA-FORM1=(9) It is finished when You push the {Esc} key.
JA+FORM1=ツール用管理者パスワード変更{YES,NO}  @@@
JA-FORM1=A manager password change for tools{YES,NO}  @@@
DATA=YES{,1}{YES,NO}
=IF{_DATA='YES'}EXE_I{ZZZZ010121}{};
JA+FORM1=  ツール用管理者パスワード変更完了  次 @@@ {Enter}
JA-FORM1=  Manager password change completion for tools,Next @@@ {Enter}
DATA=OK{,}{}
PROGRAM=NOT
CONTROL=PROGRAM,ERROR,SQL_DBO,HIGH
BEGIN
=SET{_TITLE='SETUP I SERVER 6/8'}; 
=SET{YES='YES'};
JA+FORM1=◎各種定義情報（混在テーブル）を更新します。
JA-FORM1=* update various definition information (a etc table).
JA+FORM1=(1)更新する場合YESと入れてEnterを押して下さい,別画面を表示します。
JA-FORM1=(1)When You update it,You can enter with YES,
JA-FORM1=         and please push Enter and display the other screen.
JA+FORM1=(2)使用者に"ZZZZZZZZ"でEnter,新パスワードを入れてEnterを押して下さい。
JA-FORM1=(2)You classify an Enter, new password into a user in "ZZZZZZZZ",
JA-FORM1=       and please overwhelm Enter.
JA+FORM1=(3)キー1でEnter,←と↓でキー1がZZZZZZ_SYSTEMの位置に移動し"0"を押して下さい。
JA-FORM1=(3)Key1 moves to the position of ZZZZZZ_SYSTEM,
JA-FORM1=        and please push '0' with [Enter],[←] and [↓] with key1.
JA+FORM1=(4)←と↓と↑で修正個所に移動し3を入れて下さい。
JA-FORM1=(4)Please push ← and ↓ and 3.       
JA+FORM1=(5)ZZZZZZ_CALENDAR_ADDは作成するカレンダーの先の日数です。(365*2)
JA-FORM1=(5)ZZZZZZ_CALENDAR_ADDZZZZZZ_CALENDAR_ADD is the days of the future of the calendar to make.(365*2)
JA+FORM1=(6)ZZZZZZ_CALENDAR_CANCELは論理削除するカレンダーの前の日数です。(365*1)
JA-FORM1=(6)ZZZZZZ_CALENDAR_CANCEL is the days before a calendar deleting the logic.(365*1)
JA+FORM1=(7)ZZZZZZ_COUNTRYは国コードですJP以外に変更しないで下さい。(JP)
JA-FORM1=(7)ZZZZZZ_COUNTRY is a country cord.(JP)
JA+FORM1=(8)ZZZZZZ_DATEは今日の日付ですシステムが使用するので触らないで下さい。
JA-FORM1=(8)ZZZZZZ_DATE is today's date, please do not touch it.
JA+FORM1=(9)ZZZZZZ_DATE_OLDは前回の日付ですシステムが使用するので触らないで下さい。
JA-FORM1=(9)ZZZZZZ_DATE_OLD is the date of the last time uses it,please do not touch it.
JA+FORM1=(10)ZZZZZZ_DB_MはMSDE200のインストールドライブ(1,2)とパス(4..)です。
JA+FORM1=(11)ZZZZZZ_DBBACKUP_REAL_MASTは本番マスタデータベースのバックアップです。(YES)
JA+FORM1=(12)ZZZZZZ_DBBACKUP_REAL_WORKは本番ワークデータベースのバックアップです。(YES)
JA+FORM1=(13)ZZZZZZ_DBBACKUP_TEST_MASTはテストマスタデータベースのバックアップです。(YES)
JA+FORM1=(14)ZZZZZZ_DBBACKUP_TEST_WORKはテストワークデータベースのバックアップです。(YES)
JA+FORM1=(15)ZZZZZZ_PASSWORD_LIMIT_DATEはパスワードの有効期間の日数です(0は無制限)。(0)
JA+FORM1=(16)ZZZZZZ_TIME_LIMITは時間起動できる最大時間です。(17:30)
JA+FORM1=(17)ZZZZZZ_TIME_STARTは朝の立ち上げ処理の開始時間です。(08:30)
JA+FORM1=(18)ZZZZZZ_USE_TABLE_CANCELはジョブ使用履歴の削除日の判定です。(365*5)
JA+FORM1=(19)ZZZZZZ_Z_CANCEL_DELETEは削除済みレコードの物理削除の日付け判定です。(31)
JA+FORM1=各種定義情報（混在テーブル）を更新{YES,NO}  @@@
DATA=YES{,1}{YES,NO}
=IF{_DATA='YES'}EXE_I{ZZZZ010137}{};
FORM1= 各種定義情報（混在テーブル）を更新完了  次 @@@ {Enter}
DATA=OK{,}{}
PROGRAM=NOT
CONTROL=PROGRAM,ERROR,SQL_DBO,HIGH
BEGIN
=SET{_TITLE='SETUP I SERVER 7/8'}; 
=SET{YES='YES'};
JA+FORM1= ◎カレンダー既定祭日を 更新します。
JA+FORM1=(1)更新する場合YESと入れてEnterを押して下さい,別画面を表示します。
JA+FORM1=(2)使用者に"ZZZZZZZZ"でEnter,新パスワードを入れてEnterを押して下さい。
JA+FORM1=(3)Enterと←と↓と↑で作成または削除個所に移動します。(1が削除で2が作成です)
JA+FORM1=(4)国はJP(日本）とします。
JA+FORM1=(5)月が00でマークが0のとき日に曜日を設定し休みとします(01=日曜日,07=土曜日)。
JA+FORM1=(6)月が01から12でマークが数字のとき第マーク(数字)の曜日(日)を休みとします。
JA+FORM1=(7)月が01から12でマークが'D'の時、日を休みとします。
JA+FORM1={YES,NO}  @@@
*******************************************************************
DATA=YES{,1}{YES,NO}
=IF{_DATA='YES'}EXE_I{ZZZZ010134}{};
*******************************************************************
JA+FORM1=◎必ずカレンダー既定祭日の更新を終わってから、次の処理を実行下さい。
PROGRAM=NOT
CONTROL=PROGRAM,ERROR,SQL_DBO,HIGH
BEGIN
=SET{YES2='YES',YES3='YES',CHECK1='YES',CHECK2='YES',MENU='YES'};
=SET{_TITLE='SETUP I SERVER 8/8'}; 
JA+FORM1= ◎インストールを終了しました。
JA+FORM1= ★クライアントインストールはネットワークから共有名I\WINDOWSの
W+JA+FORM1=  該当メニュー名の"SETUP_システム名_ZZZZ.BAT”のバッチファイルを起動します。
U+JA+FORM1=  該当メニュー名の"SETUP_システム名_ZZZZ”のシェルスクリプトを起動します。
JA+FORM1=(1)共有名I(\I\FILE\SHARE)の共有アクセス権はEvryoneを読み取りに変更下さい。
JA+FORM1=(2)共有名?_SYSTEM?.I(\I\FILE\?_SYSTEM?.I\TEST)もEvryoneを読み取りに変更下さい。
JA+FORM1=共有設定完了{YES,NO}  @@@@ 　時間起動最新状態表示 @@@@
JA+FORM1=(★セキュリティの警告画面が出た場合は、[この種類のファイルで有れば常に警告]の
JA+FORM1=レ印を消してから[実行]をクリックしてください）
JA+FORM1=システム起動状況 @@@@  注意：朝の立ち上げ処理を実行する場合は必ず実行下さい。 
JA+FORM1=       　メニュー表示 @@@@ 
*******************************************************************
DATA=YES3{,1}{YES,NO}
DATA=CHECK1{,1}{YES,NO}
=IF{_DATA='YES'}EXE_I{ZZZZ010501}{};
DATA=CHECK2{,1}{YES,NO}
=IF{_DATA='YES'}EXE_I{ZZZZ010502}{};
DATA=MENU{,1}{YES,NO}
=IF{_DATA='YES'}EXE_I{ZZZZ000000}{};
JA+FORM1=◎朝の立ち上げ処理をこれから実行します。（次の稼働日の朝にも起動予約されます）
JA+FORM1=(1)実行する場合YESと入れてEnterを押して下さい,別画面を表示します。
JA+FORM1=(2)使用者に"ZZZZZZZZ"でEnter,新パスワードを入れてEnterを押して下さい。
JA+FORM1=(3)時分に9999を入れてEnterを押して下さい。
JA+FORM1=(4)←と0で次の画面に行き"RUN"でEnterして下さい。
JA+FORM1=(5)←と0で次の画面に行き"ALL"でEnterで処理が開始します。
JA+FORM1={YES,NO}  @@@
*******************************************************************
DATA=YES2{,1}{YES,NO}
=IF{_DATA='YES'}EXE_I{ZZZZ010521}{};
=EXIT{0};
