﻿* SET_END.TXT HARASAWA
***********************************************************************
****************( バージョン 変更 )************************************
****************( IPPRINT==> VERSION )*********************************
=SET{WC.VERSION_PRINT='10'};  IPRINT用*
****************( ICHART==> VERSION )*********************************
=SET{WC.VERSION_CHART='1'};  ICHART用*
************************************************************************
=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{WC.M=_M_REAL};
REPEAT=2
=IF{##!=2}JUMP{REAL};
=MESSAGE{TABLE (TEST)};
=SET{_REAL_TEST='TEST'};
=SET{WC.M=_M_TEST};
=JUMP{TEST};
=REAL:
*****( REAL)*****
************( I_DICTIONARY_TABLE  )********************************************
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_DICTIONARY_TABLE}{TABLE}{PUBLIC};
***(自分自身のNCHAR確定の為実行)**
=SET{WC.INSERT='INSERT INTO ?WC.M?ZZ_I_DICTIONARY_TABLE(ZZZZZZ_LANG,ZZZZZZ_DEFAULT_TYPE'
=+',ZZZZZZ_DATA_NAME,ZZZZZZ_DEFAULT_LENGTH1)VALUES(''?_LANG?'',''NCHAR'''};
=IF_ERROR_SQL{?WC.INSERT?,'ZZZZZZ_NAME',30)}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.INSERT?,'ZZZZZZ_DATA_NAME',30)}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.INSERT?,'ZZZZZZ_MESSAGE',70)}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.INSERT?,'ZZZZZZ_COMMENT1',80)}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.INSERT?,'ZZZZZZ_COMMENT2',80)}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
REPEAT2=6
=IF_ERROR_SQL{?WC.INSERT?,'ZZZZZZ_CHECK6$$',54)}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
REPEAT2=
****************************************************************
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_PERMISSION_TABLE}{TABLE}{PUBLIC};
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_MENU_TABLE}{TABLE}{PUBLIC};
*** PROGRAM CREATE ***
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_PROGRAM_TABLE}{TABLE}{PUBLIC};
*** HELP CREATE ***
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_HELP_TABLE}{TABLE}{PUBLIC};
*** TABLE CREATE ***
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_TABLE_TABLE}{TABLE}{PUBLIC};
*** TABLE CREATE ***
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_COLUMN_TABLE}{TABLE}{PUBLIC};
*** OBJECT CREATE ***
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_OBJECT_ID_TABLE}{TABLE}{PUBLIC};
*** OBJECT CREATE ***
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{SKIP};
=ERROR_OBJECT:IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=SKIP:
=DBO_GRANT{?WC.M?ZZ_I_OBJECT_TABLE}{TABLE}{PUBLIC};
*** ZZZZZZ_I_ERROR_TABLE CREATE ***
=IF_ERROR_DBO_CREATE_TABLE{?WC.M?ZZ_I_ERROR_TABLE}
={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{?WC.M?ZZ_I_ERROR_TABLE}{TABLE}{PUBLIC};
*** ZZZZZZ_I_SQL_TABLE CREATE ***
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_SQL_TABLE}{TABLE}{PUBLIC};
=TEST:
*****( REAL,TEST )*****
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_PRINT_ID_TABLE}{TABLE}{PUBLIC};
***( ZZZZZZ_PRINT_TABLE CREATE )
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_PRINT_TABLE}{TABLE}{PUBLIC};
*********************************************************
=IF_ERROR_DBO_CREATE_TABLE{?WC.M?ZZ_CHART_ID_TABLE}
={ZZZZZZ_CHART,20}{ZZZZZZ_TEST,C,4,ZZZZZZ_COMMENT,50}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?WC.M?ZZ_CHART_ID_TABLE}{TABLE}{PUBLIC};
***( ZZZZZZ_CHART_TABLE CREATE )
=IF_ERROR_DBO_CREATE_TABLE{?WC.M?ZZ_CHART_TABLE}
={ZZZZZZ_CHART,20,ZZZZZZ_CHART_NO,INT,ZZZZZZ_CHART_KEY1,C,2,ZZZZZZ_CHART_KEY2,C,37
=,ZZZZZZ_CHART_KEY3,C,37,ZZZZZZ_CHART_CUSTOM_PROPERTIES,C,29}
={ZZZZZZ_CHART_DATA,29,ZZZZZZ_CHART_CODE,C,1,ZZZZZZ_CHART_KIND,C,7
=,ZZZZZZ_CHART_DATA1,25,ZZZZZZ_CHART_DATA2,C,20,ZZZZZZ_CHART_DATA3,C,9,ZZZZZZ_CHART_DATA4,C,9
=,ZZZZZZ_COMMENT,50}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?WC.M?ZZ_CHART_TABLE}{TABLE}{PUBLIC};
***( ZZZZZZ_CHART_SETTING_TABLE CREATE )
=IF_ERROR_DBO_CREATE_TABLE{?WC.M?ZZ_CHART_SETTING_TABLE}
={ZZZZZZ_CHART_SET_NO,C,1,ZZZZZZ_CHART_SET1,C,29,ZZZZZZ_CHART_SET2,37}
={ZZZZZZ_CHART_DATA,29,ZZZZZZ_CHART_CODE,C,1,ZZZZZZ_CHART_COMMENT,NV,95}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?WC.M?ZZ_CHART_SETTING_TABLE}{TABLE}{PUBLIC};
*****( REAL,TEST)***
* I MS-SQLSERVER SETUP (REAL,TEST) 
* BASE TABLE CREATE ***
*** ZZZZZZ_KEEP_TABLE CREATE ***
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_KEEP_TABLE}{TABLE}{PUBLIC};
*** ?WC.M?_HOLIDAY_TABLE CREATE ***
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_HOLIDAY_TABLE}{TABLE}{PUBLIC};
*** ?WC.M?_CALENDAR_TABLE CREATE ***
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_CALENDAR_TABLE}{TABLE}{PUBLIC};
*** ?WC.M?ZZ_ETC_TABLE CREATE 
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_ETC_TABLE}{TABLE}{PUBLIC};
*** ?WC.M?ZZ_ETC_ID_TABLE CREATE
=IF_ERROR_DBO_CREATE_TABLE{?WC.M?ZZ_ETC_ID_TABLE}
={ZZZZZZ_KEY1,C,20}{ZZZZZZ_COMMENT,50}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?WC.M?ZZ_ETC_ID_TABLE}{TABLE}{PUBLIC};
*** ?WC.M?ZZ_SAMPLE_TABLE CREATE
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_SAMPLE_TABLE}{TABLE}{PUBLIC};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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 ?WC.M?ZZ_ETC_ID_TABLE )****************************************
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_OBJECT_SAMPLE','I OBJECT SAMPLE')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_RESTORE','I RESTORE')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.M?ZZ_ETC_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_URL_VERSION','I URL VERSION')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
*******'( INSERT ?WC.M?ZZ_ETC_TABLE )***********************************
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_VERSION1','?_VERSION1?','VERSION1(?_VERSION1?) IXMENU,IXTIME')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{UPDATE ?WC.M?ZZ_ETC_TABLE SET ZZZZZZ_ETC='?_VERSION1?' WHERE ZZZZZZ_KEY1='ZZZZZZ_@'  AND ZZZZZZ_KEY2='ZZZZZZ_VERSION1'}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{INSERT INTO ?WC.M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_VERSION2','?_VERSION2?','VERSION2(?_VERSION2?) IXMENU,IXTIME')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{UPDATE ?WC.M?ZZ_ETC_TABLE SET ZZZZZZ_ETC='?_VERSION2?' WHERE ZZZZZZ_KEY1='ZZZZZZ_@'  AND ZZZZZZ_KEY2='ZZZZZZ_VERSION2'}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{INSERT INTO ?WC.M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_VERSION_PRINT','?WC.VERSION_PRINT?','VERSION(?WC.VERSION_PRINT?) IPRINT')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{INSERT INTO ?WC.M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_@','ZZZZZZ_VERSION_CHART','?WC.VERSION_CHART?','VERSION(?WC.VERSION_CHART?) ICHART')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{INSERT INTO ?WC.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 ?WC.M?ZZ_ETC_TABLE SET ZZZZZZ_ETC='?WC.VERSION_PRINT?' WHERE ZZZZZZ_KEY1='ZZZZZZ_@' AND ZZZZZZ_KEY2='ZZZZZZ_VERSION_PRINT'};
=SQL{UPDATE ?WC.M?ZZ_ETC_TABLE SET ZZZZZZ_ETC='?WC.VERSION_CHART?' WHERE ZZZZZZ_KEY1='ZZZZZZ_@' AND ZZZZZZ_KEY2='ZZZZZZ_VERSION_CHART'};
***********************************************************************************
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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{WC.ETC='INSERT INTO ?WC.M?ZZ_ETC_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_KEY1,ZZZZZZ_KEY2,ZZZZZZ_ETC,ZZZZZZ_COMMENT)VALUES(?_Z_INSERT_VALUE?,''ZZZZZZ_SYSTEM'''};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_DATE','00000101','TODAY (JOB=ZZZZZZ999951)')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_DATE_OLD','00000101','OLD DATE (JOB=ZZZZZZ999951)')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_BACKUP_DAY','50','BACKUP DATE -(DAY)[50]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_BACKUP_SAVE',' ','BACKUP SAVE W-DRIVE OR U-PATH (SPACE IS NOT SAVE)')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_BROWSE_U','GEDIT','BROWSE UNIX')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_BROWSE_W','NOTEPAD','BROWSE WINDOWS')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_CALENDAR_ADD','365*2','CALENDAR ADD +(DAY)[365*2]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_CALENDAR_CANCEL','365*1','CALENDAR CANCEL -(DAY)[365*1]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_COUNTRY','JP','JP=JAPAN[JP]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.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?};
=IF_ERROR_SQL{?WC.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?};
=IF_ERROR_SQL{?WC.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?};
=IF_ERROR_SQL{?WC.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?};
=SET{WC.CFG1='?DRIVE1?,?DRIVE2?,?DRIVE3?,?DRIVE4?,?DRIVE5?'};
=SET{WC.CFG2='?WC.WOS_LOGIN?,?WC.WSECRET?,?WC.WGUEST?,?$ARCHIVE?,?_IV?,?$WC.JAVA_MONO?'};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_INSTALL_CFG1','?WC.CFG1?','CFG1[?WC.CFG1?]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_INSTALL_CFG2','?WC.CFG2?','CFG2[?WC.CFG2?]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
D-=SET{_UPPER=$INSTALL_PATH};
D+=SET{_UPPER=$INSTALL_PATH+$WC.D_BIN};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_INSTALL_PATH','?_UPPER?','INSTALL PATH')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
P+=SET{_UPPER=$WC.DATABASE_PATH};
P+=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_DATABASE_PATH','?_UPPER?','DATABASE PATH')}
P+=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=SET{_UPPER=$JDBC};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_JDBC','?_UPPER?','JAVA JDBC')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_PASSWORD_LIMIT_DATE','0','PASSWORD LIMIT DATE (DAY)[0]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_PASSWORD_MIN_ALPHABET','1','PASSWORD MIN ALPHABET[1]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_PASSWORD_MIN_LENGTH','7','PASSWORD MIN LENGTH[7]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_PASSWORD_MIN_NUMBER','1','PASSWORD MIN NUMBER[1]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_TIME_START','08:30','SYSTEM START TIME (HH:MM)[08:30]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_TIME_LIMIT','17:30','SYSTEM TIME LIMIT (HH:MM)[17:30]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.ETC?,'ZZZZZZ_Z_CANCEL_DELETE','31','Z_CANCEL DELETE -(DAY)[31]')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
*** ?WC.M?_HOLIDAY_TABLE INSERT  ***
=SET{WC.CAL='INSERT INTO ?WC.M?ZZ_HOLIDAY_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_COUNTRY,ZZZZZZ_MM,ZZZZZZ_MARK_CALENDAR,ZZZZZZ_DD) VALUES(?_Z_INSERT_VALUE?,'};
=IF_ERROR_SQL{?WC.CAL?'JP','00','0','01')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','00','0','07')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','01','D','01')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','01','2','02')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','02','D','11')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','03','D','21')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','04','D','29')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','05','D','03')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','05','D','04')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','05','D','05')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','07','3','02')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','09','3','02')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','09','D','23')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','10','2','02')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','11','D','03')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','11','D','23')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{?WC.CAL?'JP','12','D','23')}IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.M?ZZ_CHART_ID_TABLE(?_Z_INSERT_NAME?,ZZZZZZ_CHART,ZZZZZZ_TEST,ZZZZZZ_COMMENT)
=  VALUES(?_Z_INSERT_VALUE?,'ZZZZZZ_SAMPLE',' ','I CHART 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{W0.PER_COUNT=1,W0.VC=1,W0.PER_MAX=_SQL_REPEAT_COUNT};
=VIEW_PER_LOOP:
=SET{WC.PER=WC.PERMISSION?W0.PER_COUNT?
=   ,WC.PER_L=WC.PER@LOWER};
=MESSAGE{CREATE VIEW};
REPEAT2=2 (M,W)
=SET{_LOWER='I_',WC.I_L=_LOWER};
=SET{WC.M_DB='?_Q?_DB_HEADER?_Q?_?WC.M_W$$?_?WC.PER?'};
=SET{WC.I_DB=WC.M_DB,WC.P_DB=WC.M_DB,WC.L_DB=WC.M_DB};
=SET{WC.H_DB='?_Q?_DB_HEADER?_Q??WC.M_W$$??WC.PER?'};
=SET{WC.D_DB='?_Q?_DB_HEADER?_Q??WC.M_W$$??WC.PER?'};
$1+=SET{WC.MAST_WORK='MAST'};
$2+=SET{WC.MAST_WORK='WORK'};
$1+=SET{WC.O_OWNER='''?_Q?_DB_HEADER?_Q?_D_?WC.PER?'''};
$2+=SET{WC.O_OWNER='''?_Q?_DB_HEADER?_Q?_I_?WC.PER?'''
$2+=            +',''?_Q?_DB_HEADER?_Q?_O_?WC.PER?'''};
$1+=SET{WC.H_OWNER='''?_Q?_DB_HEADER?_Q?D?WC.PER?'''};
$2+=SET{WC.H_OWNER='''?_Q?_DB_HEADER?_Q?I?WC.PER?'''
$2+=            +',''?_Q?_DB_HEADER?_Q?O?WC.PER?'''};
$1+=SET{WC.P_OWNER1=
$1+=' IN(LOWER(''?_Q?_DB_HEADER?_Q?_D_?WC.PER?''))'};
$1+=SET{WC.P_OWNER2=};
$2+=SET{WC.P_OWNER1=
$2+=' IN(LOWER(''?_Q?_DB_HEADER?_Q?_I_?WC.PER?'')'};
$2+=SET{WC.P_OWNER2=
$2+=   ',LOWER(''?_Q?_DB_HEADER?_Q?_O_?WC.PER?''))'};
$1+=SET{WC.D_OWNER1='?_Q?_DB_HEADER?_Q?D?WC.PER?'};
$1+=SET{WC.D_OWNER2='?_Q?_DB_HEADER?_Q?D?WC.PER?'};
$2+=SET{WC.D_OWNER1='?_Q?_DB_HEADER?_Q?I?WC.PER?'};
$2+=SET{WC.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?W0.VC?
= ='ZZZZZZ_?WC.M_W$$?_?WC.PER?_OBJECT_VIEW'};
NAME=VIEW_BEGIN##$$
=SET{W0=0};
=SET{WN.ZZZZZZ_NAME=WC.VIEW?W0.VC?};COMPUTE{W0.VC+=1};
=DBO_SQL{DELETE FROM ?WN.OBJECT_TABLE? WHERE
= ?_VRE&WN.ZZZZZZ_NAME?};
=SET{WC.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};
=LOOP:SET{WN.OBJECTS+=WN.OBJECT};
=SQL1_NEXT{WN.OBJECT}JUMP{FIN};BACK{LOOP};
=FIN:IF_ERROR_SET{_EDIT=WN.OBJECTS,WN.OBJECTS_REAL=_EDIT}
=  ERROR{VIEW(?WN.ZZZZZZ_NAME?)?_ERROR?};
=SET{_REAL_TEST='TEST'};
=IF_ERROR_SET{_EDIT=WN.OBJECTS,WN.OBJECTS_TEST=_EDIT}
=  ERROR{VIEW(?WN.ZZZZZZ_NAME?)?_ERROR?};
=SET{_REAL_TEST='REAL'};
=SET{WC.XX=_MX_REAL_ZZZZ};
***P+=SQL{BEGIN TRANSACTION};
=DBO_DROP_OBJECT{?WC.XX??WN.ZZZZZZ_NAME?}{VIEW}; 
***P+=SQL{COMMIT TRANSACTION};
=IF_ERROR_DBO_CREATE_OBJECT{?WC.XX??WN.ZZZZZZ_NAME?}{VIEW}
=   {?WN.OBJECTS_REAL?}ERROR{};
=DBO_GRANT{?WC.XX??WN.ZZZZZZ_NAME?}{SELECT}{PUBLIC};
D-=SET{_REAL_TEST='TEST'};
=SET{WC.XX=_MX_TEST_ZZZZ};
***P+=SQL{BEGIN TRANSACTION};
=DBO_DROP_OBJECT{?WC.XX??WN.ZZZZZZ_NAME?}{VIEW}; 
***P+=SQL{COMMIT TRANSACTION};
=IF_ERROR_DBO_CREATE_OBJECT{?WC.XX??WN.ZZZZZZ_NAME?}{VIEW}
=   {?WN.OBJECTS_TEST?}ERROR{};
I+=SET{_REAL_TEST='REAL'};
=DBO_GRANT{?WC.XX??WN.ZZZZZZ_NAME?}{SELECT}{PUBLIC};
=SET{_REAL_TEST='REAL'};
NAME=
=SET{WC.VIEW?W0.VC?
= ='ZZZZZZ_?WC.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?W0.VC?='ZZZZZZ_?WC.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?W0.VC?='ZZZZZZ_?WC.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{W0.PER_COUNT+=1};
=IF{W0.PER_COUNT<=W0.PER_MAX}BACK{VIEW_PER_LOOP};
=TEST_VIEW_SKIP:
*(PERMISSION_END)*
*=SET{_TRACE=0};
=if{##=2}JUMP{TEST_DICTIONARY_SKIP};
******( COPY DIRECTORY_TABLE NCHAR確定の為ここで実行する )******
*=SET{_TRACE=1};
=MESSAGE{LOAD (DICTIONARY)};
=DROP_TABLE{?_WORK_TABLE?A};
=COPY_TABLE{?_WORK_TABLE?A}{?WC.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{?WC.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 ?WC.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}{?WC.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{?WC.M?ZZ_ETC_TABLE}{?_WORK_TABLE?A}{ZZZZZZ_KEY1,ZZZZZZ_KEY2}{ZZZZZZ_ETC,ZZZZZZ_COMMENT}
={(?_O?ZZZZZZ_KEY1 IN('ZZZZZZ_PROGRAM','ZZZZZZ_OBJECT_SAMPLE','ZZZZZZ_URL_VERSION')
= 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}{?WC.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{?WC.M?ZZ_PRINT_TABLE}{?_WORK_TABLE?A}{ZZZZZZ_PRINT,ZZZZZZ_SEQ}{ZZZZZZ_PRINT_DATA}
={?_O?ZZZZZZ_PRINT LIKE 'ZZZZZZ_SAMPLE%'}{};
******( COPY TABLE CHART_TABLE }
=MESSAGE{LOAD (CHART)};
=DROP_TABLE{?_WORK_TABLE?A};
=COPY_TABLE{?_WORK_TABLE?A}{?WC.M?ZZ_CHART_TABLE}{NOT};
=INSERT_FILE{?_WORK_TABLE?A}{ZZZZZZ_CHART,ZZZZZZ_CHART_NO,ZZZZZZ_CHART_KEY1,ZZZZZZ_CHART_KEY2,ZZZZZZ_CHART_KEY3
=,ZZZZZZ_CHART_CUSTOM_PROPERTIES,ZZZZZZ_CHART_DATA,ZZZZZZ_CHART_CODE,ZZZZZZ_CHART_KIND,ZZZZZZ_CHART_DATA1
=,ZZZZZZ_CHART_DATA2,ZZZZZZ_CHART_DATA3,ZZZZZZ_CHART_DATA4,ZZZZZZ_COMMENT}
={?_EXE_PATH??_P?I_SERVER?_P?SET_CHAR.TXT}{};
=REPLACE_ALL{?WC.M?ZZ_CHART_TABLE}{?_WORK_TABLE?A}{ZZZZZZ_CHART,ZZZZZZ_CHART_NO,ZZZZZZ_CHART_KEY1,ZZZZZZ_CHART_KEY2,ZZZZZZ_CHART_KEY3
=,ZZZZZZ_CHART_CUSTOM_PROPERTIES}{ZZZZZZ_CHART_DATA,ZZZZZZ_CHART_CODE,ZZZZZZ_CHART_KIND,ZZZZZZ_CHART_DATA1
=,ZZZZZZ_CHART_DATA2,ZZZZZZ_CHART_DATA3,ZZZZZZ_CHART_DATA4,ZZZZZZ_COMMENT}
={?_O?ZZZZZZ_CHART LIKE 'ZZZZZZ_SAMPLE%'}{};
****( PACKAGE TABLE )*****
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_PACKAGE_DEFAULT_TABLE}{TABLE}{PUBLIC};
=J:
L-=SET{WC.MF='ZZZZ'};
L+=SET{WC.MF=WC.M};
=IF{##!=1}JUMP{TEST_SKIP};
****( REAL, )*** 
* IPROFGRAM MS-SQLSERVER SETUP (REAL,WORK) ***
* GROUP CREATE **
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_SECURITY_G_ID_TABLE}{TABLE}{PUBLIC};
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_SECURITY_G_TABLE}{TABLE}{PUBLIC};
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_SECURITY_G_J_TABLE}{TABLE}{PUBLIC};
*** PASSWORD CREATE
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_SECURITY_TABLE}{TABLE}{PUBLIC};
*** PASSWORD2 CREATE
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_SECURITY_J_TABLE}{TABLE}{PUBLIC};
*** TIME CREATE
=IF_ERROR_DBO_CREATE_TABLE{?WC.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_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{?WC.M?ZZ_I_TIME_TABLE}{TABLE}{PUBLIC};
*** TIME_LOG CREATE
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_TIME_LOG_TABLE}{TABLE}{PUBLIC};
*** USE CREATE ***
=IF_ERROR_DBO_CREATE_TABLE{?WC.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{?WC.M?ZZ_I_USE_TABLE}{TABLE}{PUBLIC};
*** I MS-SQLSERVER SETUP (REAL) ***
*** INSERT TIME_TABLE ***
=IF_ERROR_SQL{INSERT INTO ?WC.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',' ',' ',' ','BACKUP DATABASE AND SYSTEM')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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?};
=IF_ERROR_SQL{INSERT INTO ?WC.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','?WC.ZZZZ_PASSWORD?','ADMIN','ZZZZ ADMIN','ZZZZ','00000101')}
=  IF{_DB_I_ERROR!='DUPLICATE_KEY'}ERROR{?_DB_ERROR? ?_ERROR?};
=IF_ERROR_SQL{INSERT INTO ?WC.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','?WC.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{WC.M=_M_REAL};
********( INSERT ?WC.M?ZZ_I_OBJECT_ID_TABLE I SYSTEM FUNC VIEW )************************************* 
REPEAT=4
=IF_ERROR_SQL{INSERT INTO ?WC.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{W0.C=1};
=LOOP:SET{WC.VIEW=WC.VIEW?W0.C?};
=IF_ERROR_SQL{INSERT INTO ?WC.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{W0.C+=1};
=IF{W0.C<W0.VC}BACK{LOOP};
*(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};
=COPY_TABLE{?_WORK_TABLE?A}{?WC.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{?WC.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};
=COPY_TABLE{?_WORK_TABLE?A}{?WC.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{?WC.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 ='98' AND ?_O?ZZZZZZ_MENU3 LIKE '5%' 
=  OR ?_O?ZZZZZZ_MENU2='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','06','07')
= OR ?_O?ZZZZZZ_MENU1='40')}{};
=MESSAGE{LOAD (I_HELP)};
=DROP_TABLE{?_WORK_TABLE?A};
=COPY_TABLE{?_WORK_TABLE?A}{?WC.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{?WC.M?ZZ_I_HELP_TABLE}{?_WORK_TABLE?A}{ZZZZZZ_LANG,ZZZZZZ_JOB,ZZZZZZ_SEQ}{ZZZZZZ_CALL,ZZZZZZ_HELP}
NAME=WHERE_JOB
={?_O?ZZZZZZ_JOB =    'ZZZZ000000' OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99985%' OR 
= ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99995%' OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ99996%' 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 'ZZZZ0106%'  OR 
= ?_O?ZZZZZZ_JOB LIKE 'ZZZZ0107%'  OR ?_O?ZZZZZZ_JOB LIKE 'ZZZZ40%'}{};
NAME=
=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}{?WC.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{?WC.M?ZZ_I_PROGRAM_TABLE}{?_WORK_TABLE?A}{ZZZZZZ_JOB,ZZZZZZ_SEQ}{ZZZZZZ_PROGRAM}
COPY=WHERE_JOB
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##?) not found};
D-=LOOP:IF_ERROR_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{FIN};
D-=BACK{LOOP};
D-=FIN:
D-=SET{WN.ZZZZZZ_OBJECT_NAME=_MX_REAL_ZZZZ+WC.FUNC##};
D-=IF_ERROR_DBO_DROP_OBJECT{?WN.ZZZZZZ_OBJECT_NAME?}{FUNC}ERROR{DROP_OBJECT(?WC.FUNC##?)};
D-=IF_ERROR_DBO_CREATE_OBJECT{?WN.ZZZZZZ_OBJECT_NAME?}{FUNC}{?WN.ZZZZZZ_OBJECT_REAL?}
D-=      ERROR{CREATE_OBJECT(?WC.FUNC##?)};
D-=IF_ERROR_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-=IF_ERROR_DBO_DROP_OBJECT{?WN.ZZZZZZ_OBJECT_NAME?}{FUNC}JUMP{TEST_FUNC_ERROR};
D-=IF_ERROR_DBO_CREATE_OBJECT{?WN.ZZZZZZ_OBJECT_NAME?}{FUNC}{?WN.ZZZZZZ_OBJECT_TEST?}
D-=                                                   JUMP{TEST_FUNC_ERROR};
D-I+=SET{_REAL_TEST='REAL'};
D-=IF_ERROR_DBO_GRANT{?WN.ZZZZZZ_OBJECT_NAME?}{FUNC}{PUBLIC}JUMP{TEST_FUNC_ERROR};
D-=SET{_REAL_TEST='REAL'};
D-=JUMP{SKIP};
D-=TEST_FUNC_ERROR:SET{_REAL_TEST='REAL'};ERROR{TEST CREATE FUNCTION(?WC.FUNC##?)?_ERROR?};
D-=SKIP:
D-REPEAT=
*************************************************************************************** 
=SET{ETC='RUN'};EXIT3{ETC};
DATA=ETC{,1}{RUN,SKIP}
=IF{_DATA='SKIP'}EXIT{OK};
*******************************************************************
=MESSAGE{ETC};
=MESSAGE{?_EXE_PATH?};
=SET{WC.PASS='/'}; パスワードファイル不要*
D+|L+|I+=SET{WC.PASS=$PASSWORD_ADMIN};パスワードファイル必要*
W+=COMMAND{"?_EXE_PATH??_P?I_SERVER?_P?SET_END.BAT" ?_VERSION1? ?_SYSTEM? WINDOWS ?_LANG? 30/600 ?_SERVER_NAME?_?_SYSTEM?.I ?WC.PASS? ?_EXE_PATH?};
W-=COMMAND{ ?_EXE_PATH??_P?I_SERVER?_P?SET_END.SH   ?_VERSION1? ?_SYSTEM? UNIX    ?_LANG? 30/600 ?_SERVER_NAME?_?_SYSTEM?.I ?WC.PASS? ?_EXE_PATH? ?_FRAMEWORK? ?$JDBC?};
W+REPEAT=4
W+=IF{$WC.NAME_FIRE##!=}COMMAND{"?_EXE_PATH??_P?I_SERVER?_P?SET_FIRE.BAT" ?$WC.NAME_FIRE##? ?$WC.PROGRAM_FIRE##?};
W+REPEAT=
********( DLL 転送 )**********************
REPEAT=3
=IF{$WC.DLL##=}JUMP{SKIP};
=IF_FILE_NOT{?$WC.BIN??_P??$WC.DLL##?}JUMP{SKIP};
=IF_ERROR_COPY_FILE{?_OS_DRIVE??_P?I?_P?SHARE?_P?UNIX?_P?BINI?_VERSION1??_P??$WC.DLL##?}   {?$WC.BIN??_P??$WC.DLL##?}ERROR{};
=IF_ERROR_COPY_FILE{?_OS_DRIVE??_P?I?_P?SHARE?_P?WINDOWS?_P?BINI?_VERSION1??_P??$WC.DLL##?}{?$WC.BIN??_P??$WC.DLL##?}ERROR{};
=IF{_FRAMEWORK!='J'}
=   IF_ERROR_COPY_FILE{?_OS_DRIVE??_P?I?_P?I.?_SYSTEM??_P?BIN?_P??$WC.DLL##?}{?$WC.BIN??_P??$WC.DLL##?}ERROR{};
=SKIP:
REPEAT=
********( VAR 転送 )**********************
=IF_FILE{?$WC.BIN??_P??$JDBC?}
=   IF_ERROR_COPY_FILE{?_OS_DRIVE??_P?I?_P?SHARE?_P?UNIX?_P?BINI?_VERSION1??_P??$JDBC?}{?$WC.BIN??_P??$JDBC?}ERROR{};
=IF{_FRAMEWORK='J'}
=   IF_ERROR_COPY_FILE{?_OS_DRIVE??_P?I?_P?I.?_SYSTEM??_P?BIN?_P??$JDBC?}{?$WC.BIN??_P??$JDBC?}ERROR{};
*******( クライアント環境 設定 )**********************
=COMMAND{?_OS_DRIVE??_P?I?_P?I.?_SYSTEM??_P?BAT?_P?ZZZZZZETC ?_IV? ?_LANG? REAL ?_SYSTEM? ZZZZ000000 SETUP_CLIENT ?_DB? ?_SERVER_NAME? ?_SYSTEM? ?_LANG? ?_EXE_PARAM? ZZZZ ?SYSTEM_NAME? ?$JDBC?};
W+=SET{WC.FILE='SETUP_?_SYSTEM?.BAT'};
W-=SET{WC.FILE='SETUP_?_SYSTEM?.SH'};
=WRITE1_OPEN{?_TMP??WC.FILE?}{OT}{/};
W+=WRITE1{'?_OS_DRIVE?'};
W+=SET{WC.WRITE='CD '+_P+'I'+_P+'SHARE'+_P+'WINDOWS'};
W-=SET{WC.WRITE='cd '+_OS_DRIVE+_P+'I'+_P+'SHARE'+_P+'UNIX'};
=WRITE1{WC.WRITE};
W+=  WRITE1{'SETUP_?SYSTEM?_?_LANG?_ZZZZ'};
W-=IF{_FRAMEWORK='J'} WRITE1{'./SETUP_?SYSTEM?_?_LANG?_ZZZZ_JAVA'};
W-=IF{_FRAMEWORK!='J'}WRITE1{'./SETUP_?SYSTEM?_?_LANG?_ZZZZ_MONO'};
=WRITE1_CLOSE{};
W-=COMMAND{chmod 777 ?_TMP??WC.FILE?};
=COMMAND{?_TMP??WC.FILE?};
W-=IF_ERROR_READ1_OPEN{?_TMP?SET_END_?SYSTEM?.TMP}{/}ERROR{?_TMP?SET_END_?SYSTEM?.TMP not found};
W-=READ1_NEXT{W0.DIR_CNT}JUMP{F_ERR};READ1_CLOSE{};
W-=SET{WC.ZZZZZZ_KEY1='ZZZZZZ_SYSTEM'};
W-=SET{WC.ZZZZZZ_KEY2='ZZZZZZ_UNIX_AT_QUEUE_REAL',WN.ZZZZZZ_COMMENT='?SYSTEM? REAL{A}[A-M](Every system is unique)'};
W-NAME=AT_QUEUE
W-=SET{WN.ZZZZZZ_ETC=_A?W0.DIR_CNT?};
W-=                       PROGRAM{?_MM_REAL?_ETC_TABLE}{WC.ZZZZZZ_KEY1,WC.ZZZZZZ_KEY2}{WN.ZZZZZZ_ETC,WN.ZZZZZZ_COMMENT}{2N};
W-=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'};
W-NAME=
W-=COMPUTE{W0.DIR_CNT+=13};
W-=SET{WC.ZZZZZZ_KEY2='ZZZZZZ_UNIX_AT_QUEUE_TEST',WN.ZZZZZZ_COMMENT='?SYSTEM? TEST{N}[N-Z](Every system is unique)'};
W-COPY=AT_QUEUE
W-=JUMP{SKIP};
W-=F_ERR:READ1_CLOSE{};ERROR{?_TMP?SET_END_?SYSTEM?.TMP is NULL};
W-=SKIP:
*W-=COPY_FILE{/home/I/FILE/?_SYSTEM?.I/BIN/?$JDBC?}           {/home/I/BINI?_VERSION1?/?$JDBC?};
*W-=COPY_FILE{/home/I/FILE/SHARE/UNIX/BINI?_VERSION1?/?$JDBC?}{/home/I/BINI?_VERSION1?/?$JDBC?};
*FORM= 次 @@@ {Enter}
*******************************************************************
DATA=OK{,}{}
*******************************************************************
PROGRAM=NOT
CONTROL=PROGRAM,ERROR,SQL_DBO,HIGH
BEGIN
=SET{_TITLE='SETUP I SERVER 6/9'}; 
=SET{YES='YES',_PERSON='ZZZZZZZZ'};
JA+FORM=◎ツール用管理者パスワード変更します。
JA-FORM=*change a manager password for tools of it.
JA+FORM=セキュリティ確保のためYESで画面を立ち上げ必ず変更してください。
JA-FORM=You stand and put up a screen in YES for security security,
JA-FORM=    and please change it by all means.
JA+FORM=ツールの操作方法の勉強も兼ねて実際の画面で変更します。
JA-FORM=serve and change the study of the operation method
JA-FORM=    of the tool with a real screen.
JA+FORM=(1)使用者に'ZZZZZZZZ'を入れます。
JA-FORM=(1)put 'ZZZZZZZZ' in a PERSON.
JA+FORM=(2)旧パスワードに'ZZZZZZZZZZZZZZZZ'を入れます。
JA-FORM=(2)put 'ZZZZZZZZZZZZZZZZ' in a OLD PASSWORD.
JA+FORM=(3)新パスワード1/2及び2/2に新しいパスワードを入れます。
JA-FORM=(3)put New Password in a NEW PASSWORD 1/2 and NEW PASSWORD 2/2.
JA+FORM=  (文字数は７文字以上にして下さい）
JA-FORM=  (please do the number of the letters than 7 characters)
JA+FORM=  (文字には英字と数字を含めて下さい）
JA-FORM=  (please include an English letter and a number in a letter)
JA+FORM=  ({Enter}キーで次に進みます）
JA-FORM=  (when there is few it, a letter keeps numerical
JA-FORM=        with a {Enter} key next)
JA+FORM=  (戻る場合は{←}キーで戻ります）
JA-FORM=  (when You come back,You come back with a {←} key)
JA+FORM=(4)JUDJEで'3'を入れて{Enter}キーを押すと修正します。
JA-FORM=(4)put '3' in JUDJE and revise it when push the {Enter} key.
JA+FORM=同じ画面で一般管理者用のパスワードも変更します。
JA-FORM=change the password for general managers with the same screen.
JA+FORM=(5)使用者に'ZZZZZZZY'を入れます。
JA-FORM=(5)put 'ZZZZZZZY' in a PERSON.
JA+FORM=(6)旧パスワードに'ZZZZZZZZZZZZZZZY'を入れます。
JA-FORM=(6)put 'ZZZZZZZZZZZZZZZY' in a OLD PASSWORD.
JA+FORM=(7)新パスワード1/2及び2/2に新しいパスワードを入れます。
JA-FORM=(7)put New Password in a NEW PASSWORD 1/2 and NEW PASSWORD 2/2.
JA+FORM=(8)JUDJEで'3'入れて[Enter]キーお押すと修正します。
JA-FORM=(8)put '3' in JUDJE and revise it when push the {Enter} key.
JA+FORM=(9){Esc}キーを押すと終了します。
JA-FORM=(9) It is finished when You push the {Esc} key.
JA+FORM=ツール用管理者パスワード変更{YES,NO}  @@@
JA-FORM=A manager password change for tools{YES,NO}  @@@
DATA=YES{,1}{YES,NO}
=IF{_DATA='YES'}EXE_I{ZZZZ010121}{};
JA+FORM=  ツール用管理者パスワード変更完了  次 @@@ {Enter}
JA-FORM=  Manager password change completion for tools,Next @@@ {Enter}
DATA=OK{,}{}
PROGRAM=NOT
CONTROL=PROGRAM,ERROR,SQL_DBO,HIGH
BEGIN
=SET{_TITLE='SETUP I SERVER 7/9'}; 
=SET{YES='YES'};
JA+FORM=◎各種定義情報（混在テーブル）を更新します。
JA-FORM=* update various definition information (a etc table).
JA+FORM=#更新する場合YESと入れてEnterを押して下さい,別画面を表示します。
JA-FORM=#When You update it,You can enter with YES,
JA-FORM=         and please push Enter and display the other screen.
JA+FORM=#使用者に"ZZZZZZZZ"でEnter,新パスワードを入れてEnterを押して下さい。
JA-FORM=#You classify an Enter, new password into a user in "ZZZZZZZZ",
JA-FORM=       and please overwhelm Enter.
JA+FORM=#キー1でEnter,←と↓でキー1がZZZZZZ_SYSTEMの位置に移動し"0"を押して下さい。
JA-FORM=#Key1 moves to the position of ZZZZZZ_SYSTEM,
JA-FORM=        and please push '0' with [Enter],[←] and [↓] with key1.
JA+FORM=#←と↓と↑で修正個所に移動し3を入れて下さい。
JA-FORM=#Please push ← and ↓ and 3.       
JA+FORM=#ZZZZZZ_BACKUP_DAYはバックアップファイルの保管日数です。(50)
JA+FORM=#ZZZZZZ_BACKUP_SAVEはバックアップを別媒体にセーブして火災等に備えます。()
JA+FORM=#ZZZZZZ_CALENDAR_ADDは作成するカレンダーの未来の日数です。(365*2)
JA-FORM=#ZZZZZZ_CALENDAR_ADD ZZZZZZ_CALENDAR_ADD is the days of the future of the calendar to make.(365*2)
JA+FORM=#ZZZZZZ_CALENDAR_CANCELは論理削除するカレンダーの過去の日数です。(365*1)
JA-FORM=#ZZZZZZ_CALENDAR_CANCEL is the days before a calendar deleting the logic.(365*1)
JA+FORM=#ZZZZZZ_COUNTRYは国コードですJP以外に変更しないで下さい。(JP)
JA-FORM=#ZZZZZZ_COUNTRY is a country cord.(JP)
JA+FORM=#ZZZZZZ_DATEは今日の日付ですシステムが使用するので触らないで下さい。
JA-FORM=#ZZZZZZ_DATE is today's date, please do not touch it.
JA+FORM=#ZZZZZZ_DATE_OLDは前回の日付ですシステムが使用するので触らないで下さい。
JA-FORM=#ZZZZZZ_DATE_OLD is the date of the last time uses it,please do not touch it.
M+JA+FORM=#ZZZZZZ_DB_MはMSSQLのインストールドライブ(1,2)とパス(4..)です。
JA+FORM=#ZZZZZZ_I_ERROR_TABLE_CANCELはクライアントエラー履歴の削除日の判定です。(365*2)
JA+FORM=#ZZZZZZ_I_TIME_LOG_TABLE_CANCELは時間起動ジョブ使用履歴の削除日の判定です。(365*5)
JA+FORM=#ZZZZZZ_I_USE_TABLE_CANCELはジョブ使用履歴の削除日の判定です。(365*5)
JA+FORM=#ZZZZZZ_PASSWORD_LIMIT_DATEはパスワードの有効期間の日数です(0は無制限)。(0)
JA+FORM=#ZZZZZZ_PASSWORD_MIN_ALPHABETはパスワードの英字の最小文字数です。(1)
JA+FORM=#ZZZZZZ_PASSWORD_MIN_LENGTHはパスワードの全体の最小文字数です。(7)
JA+FORM=#ZZZZZZ_PASSWORD_MIN_NUMERICはパスワードの数字の最小文字数です。(1)
JA+FORM=#ZZZZZZ_TIME_LIMITは時間起動できる最大時間です。(17:30)
JA+FORM=#ZZZZZZ_TIME_STARTは朝の立ち上げ処理の開始時間です。(08:30)
JA+FORM=#ZZZZZZ_Z_CANCEL_DELETEは削除済みレコードの物理削除の日付け判定です。(31)
JA+FORM=各種定義情報（混在テーブル）を更新{YES,NO}  @@@
DATA=YES{,1}{YES,NO}
=IF{_DATA='YES'}EXE_I{ZZZZ010137}{};
FORM= 各種定義情報（混在テーブル）を更新完了  次 @@@ {Enter}
DATA=OK{,}{}
PROGRAM=NOT
CONTROL=PROGRAM,ERROR,SQL_DBO,HIGH
BEGIN
=SET{_TITLE='SETUP I SERVER 8/9'}; 
=SET{YES='YES'};
JA+FORM= ◎カレンダー既定祭日を 更新します。
JA+FORM=(1)更新する場合YESと入れてEnterを押して下さい,別画面を表示します。
JA+FORM=(2)使用者に"ZZZZZZZZ"でEnter,新パスワードを入れてEnterを押して下さい。
JA+FORM=(3)Enterと←と↓と↑で作成または削除個所に移動します。(1が削除で2が作成です)
JA+FORM=(4)国はJP(日本）とします。
JA+FORM=(5)月が00でマークが0のとき日に曜日を設定し休みとします(01=日曜日,07=土曜日)。
JA+FORM=(6)月が01から12でマークが数字のとき第マーク(数字)の曜日(日)を休みとします。
JA+FORM=(7)月が01から12でマークが'D'の時、日を休みとします。
JA+FORM={YES,NO}  @@@
*******************************************************************
DATA=YES{,1}{YES,NO}
=IF{_DATA='YES'}EXE_I{ZZZZ010134}{};
*******************************************************************
JA+FORM=◎必ずカレンダー既定祭日の更新を終わってから、次の処理を実行下さい。
PROGRAM=NOT
CONTROL=PROGRAM,ERROR,SQL_DBO,HIGH
BEGIN
=SET{YES2='YES',CHECK1='YES',CHECK2='YES',MENU='YES'};
=SET{_TITLE='SETUP I SERVER 9/9'}; 
JA+FORM= ◎インストールを終了しました。
JA+FORM= ★クライアントインストールはネットワークから共有名I_SHAREの?$WC.OS_NAME?をコピー後
W+JA+FORM=  該当メニュー名の"SETUP_システム名_ZZZZ.BAT”のバッチファイルを起動します。
W-JA+FORM=  該当メニュー名の"SETUP_システム名_ZZZZ_....”のシェルスクリプトを起動します。
JA+FORM=   時間起動最新状態表示 @@@@
JA+FORM=(★セキュリティの警告画面が出た場合は、[この種類のファイルで有れば常に警告]の
JA+FORM=レ印を消してから[実行]をクリックしてください）
JA+FORM=システム起動状況 @@@@  注意：朝の立ち上げ処理を実行する場合は必ず実行下さい。 
JA+FORM=         メニュー表示 @@@@ 
*******************************************************************
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+FORM=◎朝の立ち上げ処理をこれから実行します。（次の稼働日の朝にも起動予約されます）
JA+FORM=(1)実行する場合YESと入れてEnterを押して下さい,別画面を表示します。
JA+FORM=(2)使用者に"ZZZZZZZZ"でEnter,新パスワードを入れてEnterを押して下さい。
JA+FORM=(3)時分に9999を入れてEnterを押して下さい。
JA+FORM=(4)←と0で時が99分が99の行に行き次の画面で"RUN"でEnterして下さい。
JA+FORM=(5)←と↓と0でZZZZ999951の行に行き次の画面で"ALL"でEnterで処理が開始します。
JA+FORM=＊注意* ZZZZ999950[AT JOB (TODAY)]はカレンダを使って起動処理をしますが
JA+FORM=        最初の起動ではまだ、カレンダーが出来ていないので
JA+FORM=        ZZZZ999951[SET DATE,DATE_OLD]から実行します。
JA+FORM=     （本日の起動は無しで、次回稼働日の朝一の処理の起動予約が実施されます）
JA+FORM={YES,NO}  @@@
*******************************************************************
DATA=YES2{,1}{YES,NO}
=IF{_DATA='YES'}EXE_I{ZZZZ010521}{};
=EXIT{0};
