﻿* SET_DB_I.TXT HARASAWA (IBM DB2)
=IF{_DB!='I'}JUMP{I_SKIP};
=WRITE1_OPEN{?_SYSTEM?_INSTALL.TXT}{OT}{/};
*=SET{W='CREATE DATABASE I_?_SYSTEM? ON ?WI_DRIVE? USING CODESET IBM-943 TERRITORY JP COLLATE  USING SYSTEM USER'
=SET{W='CREATE DATABASE I_?_SYSTEM? ON ?WI_DRIVE? USING CODESET UTF-8 TERRITORY JP COLLATE USING UCA400_NO USER'
=+' TABLESPACE MANAGED BY SYSTEM USING(''?W_D1??_P??W_IS?USER'')'
=+'EXTENTSIZE 16 PREFETCHSIZE 16 OVERHEAD 14.06 TRANSFERRATE 0.33 CATALOG TABLESPACE MANAGED BY SYSTEM  USING'
=+'(''?W_D1??_P??W_IS?CATALOG'')'
=+'EXTENTSIZE 16 PREFETCHSIZE 16 OVERHEAD 14.06 TRANSFERRATE 0.33 TEMPORARY TABLESPACE MANAGED BY SYSTEM USING'
=+'(''?W_D1??_P??W_IS?TEMPORARY'')'
=+' EXTENTSIZE 16 PREFETCHSIZE 16 OVERHEAD 14.06 TRANSFERRATE 0.33'};
=WRITE1{W};WRITE1_CLOSE{};
*(PERMISSION_BEGIN)*
=WRITE1_OPEN{?_TMP??_SYSTEM?_INSTALL.BAT}{OT}{/};
=SET{WREAL_TEST='REAL'};
*(PERMISSION_END)*
=SET{W='DB2CMD -I -C -W DB2 -F ?_SYSTEM?_INSTALL.TXT >?_TMP?I_LOG.TXT'};
=WRITE1{W};
*(PERMISSION_BEGIN)*
**************( NET USER )***********************************
=IF{_DB!='I'}JUMP{I_SKIP};
REPEAT0=$W0PERMISSION
REPEAT=2 (W_M_W##)
=SET{WPAS=W_PASSWORD_?W_REAL_TEST##?};
=SET{W0REPEAT2CNT=0};
REPEAT2=4 (W_DIOL--)
=COMPUTE{W0REPEAT2CNT+=1};
=MESSAGE{NET USER (?W_REAL_TEST##?,?W_PER$$?)}; 
=IF{W0REPEAT2CNT=4}SET{WPAS=W_PASSWORD_LINK};
=SET{W_DIOL=W_DIOL?W0REPEAT2CNT?};
=SET{W_USER='?W_IS??W_R_T##?_?W_DIOL?_?W_PER$$?'};
=SET{W='NET USER ?W_USER? ?WPAS? /ADD /EXPIRES:NEVER'
=     +' /PASSWORDCHG:NO'};
=WRITE1{W};
=SET{W='NET LOCALGROUP DB2USERS ?W_USER? /ADD'};
=WRITE1{W};
=SET{W='NET LOCALGROUP USERS ?W_USER? /DELETE'};
=WRITE1{W};
=SET{W='WMIC USERACCOUNT WHERE (NAME="?W_USER?")'
=     +' SET PASSWORDEXPIRES=FALSE'};
=WRITE1{W};
REPEAT0=
*(PERMISSION_END)*
*****( DB2CMD )**********************************************
=SET{W='DB2CMD -I -C -W DB2 TERMINATE >>?_TMP?I_LOG.TXT'};WRITE1{W};
=SET{W='DB2CMD -I -C -W DB2 CATALOG TCPIP NODE IN?_SYSTEM? REMOTE ?_SERVER_NAME? SERVER 50000 REMOTE_INSTANCE DB2 SYSTEM ?_SERVER_NAME? OSTYPE WIN >>?_TMP?I_LOG.TXT'};WRITE1{W};
=SET{W='DB2CMD -I -C -W DB2 TERMINATE >>?_TMP?I_LOG.TXT'};WRITE1{W};
=SET{W='DB2CMD -I -C -W DB2 CATALOG DATABASE   I_?_SYSTEM? AS IA?_SYSTEM? AT NODE IN?_SYSTEM? >>?_TMP?I_LOG.TXT'};WRITE1{W};
=SET{W='DB2CMD -I -C -W DB2 TERMINATE >>?_TMP?I_LOG.TXT'};WRITE1{W};
*=SET{W='DB2CMD -I -C -W DB2 DB2STOP >>?_TMP?I_LOG.TXT'};WRITE1{W};
=SET{W='NET STOP DB2 >>?_TMP?I_LOG.TXT'};WRITE1{W};
*=SET{W='DB2CMD -I -C -W DB2 DB2START >>?_TMP?I_LOG.TXT'};WRITE1{W};
=SET{W='NET START DB2 >>?_TMP?I_LOG.TXT'};WRITE1{W};
=SET{W='@ECHO OFF'};WRITE1{W};
=WRITE1_CLOSE{};
=COMMAND{?_TMP??_SYSTEM?_INSTALL.BAT};
=MESSAGE{GRANT ...};
=LOGIN_SQL{GRANT DBADM,CREATE_NOT_FENCED,IMPLICIT_SCHEMA ON
=DATABASE TO USER ?W_IS?R_D_ZZZZ}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{GRANT SELECT ON SYSIBM.SYSDUMMY1 TO PUBLIC}
=  IF{_DB_ERROR!='I-601'}ERROR{?_DB_ERROR??_ERROR?};
=JUMP{SKIP};
*(PERMISSION_BEGIN)*
=SET{W='@ECHO OFF'};WRITE1{W};
=WRITE1_CLOSE{};
=EXE_WAIT{
=?_OS_DRIVE??_P?I?_P?BIN?_P??_IV?ROOT?_OS??_FRAMEWORK?.EXE
=       }{?_TMP??_SYSTEM?_INSTALL.BAT};
=SKIP:
=ERASE_FILE{?_SYSTEM?_INSTALL.BAT};
=MESSAGE{CREATE SCHEMA};
****( CREATE SCHEMA )****************************************
REPEAT0=$W0PERMISSION
REPEAT=2  (W_R_T##=R;T)
=SET{W0REPEAT2CNT=0};
REPEAT2=2 (W_M_W=M;W) 
=COMPUTE{W0REPEAT2CNT+=1};
=SET{W_M_W=W_M_W?W0REPEAT2CNT?};
=SET{W_SCHEMA='?W_IS??W_R_T##?_?W_M_W?_?W_PER$$?'};
=SET{W_AUTH  ='?W_IS??W_R_T##?_D_?W_PER$$?'};
=LOGIN_SQL{CREATE SCHEMA ?W_SCHEMA? AUTHORIZATION ?W_AUTH?}
=  IF{_DB_ERROR!='I-601'}ERROR{?_DB_ERROR? ?_ERROR?};
REPEAT0=
*************************************************************
=MESSAGE{GRANT ...};
REPEAT0=$W0PERMISSION
REPEAT=3
=SET{W0REPEAT2CNT=0}; 
REPEAT2=2 (W_PER--(ZZZZ;自分))
=COMPUTE{W0REPEAT2CNT+=1};
=SET{W_PERX=W_PER?W0REPEAT2CNT?};
=SET{W_G='GRANT ALTERIN,CREATEIN,DROPIN ON SCHEMA'
=        +' ?W_IS??W_RTT##?_'};
=LOGIN_SQL{?W_G?M_?W_PER$$? TO ?W_IS?R_D_ZZZZ};
=LOGIN_SQL{?W_G?M_?W_PER$$? TO ?W_IS??W_RRT##?_D_?W_PERX?};
=LOGIN_SQL{?W_G?W_?W_PER$$? TO ?W_IS??W_RRT##?_D_?W_PERX?};
=LOGIN_SQL{?W_G?W_?W_PER$$? TO ?W_IS??W_RRT##?_I_?W_PERX?};
=LOGIN_SQL{?W_G?W_?W_PER$$? TO ?W_IS??W_RRT##?_O_?W_PERX?};
=SET{W_G='GRANT CONNECT ON DATABASE TO USER'};
=LOGIN_SQL{?W_G? ?W_IS??W_RRT##?_L_?W_PERX?};
=IF{W_PER$$='ZZZZ'}JUMP{J};
REPEAT2=
=J:
REPEAT0=
=JUMP{I_SKIP};
********( OBJECT_VIEW )**************************************
NAME=I_OBJECT_VIEW
=SET{WI=W_INSERT+'''I'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_KIND,ZZZZZZ_REAL,ZZZZZZ_WORK')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_USER,ZZZZZZ_NAME,ZZZZZZ_TEXT')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_ADD_DATE17,ZZZZZZ_CHANGE_DATE17)')};
COPY=ADD10
=SQL{?W?' AS SELECT CAST(''TABLE'' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(DEFINER,LENGTH(DEFINER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(NAME AS CHAR(90))')};
COPY=ADD10
=SQL{?W?',CAST(NULL AS VARCHAR(12000))')};
COPY=ADD10
=SQL{?W?',CAST(REPLACE(REPLACE(CHAR(CTIME)')};
COPY=ADD10
=SQL{?W?',''-'',''''),''.'','''') AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?' FROM SYSIBM.SYSTABLES')};
COPY=ADD10
=SQL{?W?' WHERE CREATOR=''?W_I_DB?''')};
COPY=ADD10
=SQL{?W?' AND TYPE=''T''')};
COPY=ADD10
=SQL{?W?' UNION ALL SELECT CAST(''VIEW'' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(T.DEFINER,LENGTH(T.DEFINER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(V.NAME AS CHAR(90))')};
COPY=ADD10
=SQL{?W?',CAST(V.TEXT AS VARCHAR(12000))')};
COPY=ADD10
=SQL{?W?',CAST(REPLACE(REPLACE(CHAR(T.CTIME)')};
COPY=ADD10
=SQL{?W?',''-'',''''),''.'','''') AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?' FROM SYSIBM.SYSVIEWS V')};
COPY=ADD10
=SQL{?W?',SYSIBM.SYSTABLES T WHERE')};
COPY=ADD10
=SQL{?W?' V.CREATOR=''?W_I_DB?''')};
COPY=ADD10
=SQL{?W?' AND V.NAME=T.NAME')};
COPY=ADD10
=SQL{?W?' AND T.CREATOR=''?W_I_DB?''')};
COPY=ADD10
=SQL{?W?' UNION ALL SELECT CAST(''FUNC'' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(DEFINER,LENGTH(DEFINER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(NAME AS CHAR(90))')};
COPY=ADD10
=SQL{?W?',CAST(BODY AS VARCHAR(12000))')};
COPY=ADD10
=SQL{?W?',CAST(REPLACE(REPLACE(CHAR(CREATE_TIME)')};
COPY=ADD10
=SQL{?W?',''-'',''''),''.'','''') AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?' FROM SYSIBM.SYSFUNCTIONS')};
COPY=ADD10
=SQL{?W?' WHERE SCHEMA=''?W_I_DB?''')};
COPY=ADD10
=SQL{?W?' UNION ALL SELECT CAST(''PROC'' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(DEFINER,LENGTH(DEFINER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(PROCNAME AS CHAR(90))')};
COPY=ADD10
=SQL{?W?',CAST(TEXT AS VARCHAR(12000))')};
COPY=ADD10
=SQL{?W?',CAST(REPLACE(REPLACE(CHAR(CREATE_TIME)')};
COPY=ADD10
=SQL{?W?',''-'',''''),''.'','''') AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?' FROM  SYSIBM.SYSPROCEDURES')};
COPY=ADD10
=SQL{?W?' WHERE PROCSCHEMA=''?W_I_DB?'' ')};
COPY=ADD10
=SQL{?W?' UNION ALL SELECT CAST(''TRIG'' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(DEFINER,LENGTH(DEFINER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(NAME AS CHAR(90))')};
COPY=ADD10
=SQL{?W?',CAST(TEXT AS VARCHAR(12000))')};
COPY=ADD10
=SQL{?W?',CAST(REPLACE(REPLACE(CHAR(CREATE_TIME)')};
COPY=ADD10
=SQL{?W?',''-'',''''),''.'','''') AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?' FROM SYSIBM.SYSTRIGGERS')};
COPY=ADD10
=SQL{?W?' WHERE SCHEMA=''?W_I_DB?'' ')};
*****( COLUMN_VIEW )*****************************************
NAME=I_COLUMN_VIEW
=SET{WI=W_INSERT+'''I'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_KIND,ZZZZZZ_REAL,ZZZZZZ_WORK')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_USER,ZZZZZZ_NAME,ZZZZZZ_SEQ')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DATA_NAME,ZZZZZZ_DEFAULT_TYPE')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DEFAULT_LENGTH1')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DEFAULT_LENGTH2,ZZZZZZ_DEFAULT')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_NULL)AS SELECT')};
COPY=ADD10
=SQL{?W?' CAST(CASE T.TYPE WHEN ''V''')};
COPY=ADD10
=SQL{?W?' THEN ''VIEW'' ELSE ''TABLE'' END AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(DEFINER,LENGTH(DEFINER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(C.TBNAME AS CHAR(90))')};
COPY=ADD10
=SQL{?W?',COLNO+1,CAST(C.NAME AS CHAR(90))')};
COPY=ADD10
=SQL{?W?',CAST(CASE C.COLTYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''INTEGER'' THEN ''INT''')};
COPY=ADD10
=SQL{?W?' WHEN ''SMALLINT'' THEN ''INT''')};
COPY=ADD10
=SQL{?W?' WHEN ''TIMESTMP'' THEN ''DATETIME''')};
COPY=ADD10
=SQL{?W?' WHEN ''DOUBLE'' THEN ''FLOAT''')};
COPY=ADD10
=SQL{?W?' WHEN ''CHAR''    THEN')};
COPY=ADD10
=SQL{?W?' CASE ZZZZZZ_DEFAULT_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''NCHAR''    THEN ''NCHAR''')};
COPY=ADD10
=SQL{?W?' ELSE C.COLTYPE END')};
COPY=ADD10
=SQL{?W?' WHEN ''VARCHAR''  THEN ')};
COPY=ADD10
=SQL{?W?' CASE ZZZZZZ_DEFAULT_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''NVARCHAR'' THEN ''NVARCHAR''')};
COPY=ADD10
=SQL{?W?' ELSE C.COLTYPE END')};
COPY=ADD10
=SQL{?W?' ELSE C.COLTYPE END AS CHAR(9))')};
COPY=ADD10
=SQL{?W?',CAST(CASE C.COLTYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''DECIMAL'' THEN C.LENGTH ')};
COPY=ADD10
=SQL{?W?' WHEN ''CHAR''    THEN')};
COPY=ADD10
=SQL{?W?' CASE ZZZZZZ_DEFAULT_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''NCHAR''')};
COPY=ADD10
=SQL{?W?' THEN C.LENGTH/?_UTF8_GET?')};
COPY=ADD10
=SQL{?W?' ELSE C.LENGTH END')};
COPY=ADD10
=SQL{?W?' WHEN ''VARCHAR'' THEN')};
COPY=ADD10
=SQL{?W?' CASE ZZZZZZ_DEFAULT_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''NVARCHAR''')};
COPY=ADD10
=SQL{?W?' THEN C.LENGTH/?_UTF8_GET?')};
COPY=ADD10
=SQL{?W?' ELSE C.LENGTH END')};
COPY=ADD10
=SQL{?W?' WHEN ''TEXT'' THEN 4000')};
COPY=ADD10
=SQL{?W?' WHEN ''CLOB'' THEN 4000 ')};
COPY=ADD10
=SQL{?W?' WHEN ''TIMESTMP'' THEN 17')};
COPY=ADD10
=SQL{?W?' WHEN ''DATE'' THEN 8')};
COPY=ADD10
=SQL{?W?' ELSE 9 END AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(CASE C.COLTYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''DECIMAL'' THEN C.SCALE')};
COPY=ADD10
=SQL{?W?' ELSE 0 END AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(C.DEFAULT AS CHAR(90))')};
COPY=ADD10
=SQL{?W?',CAST(CASE C.NULLS WHEN ''N'' ')};
COPY=ADD10
=SQL{?W?' THEN ''0'' ELSE ''1'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM SYSIBM.SYSCOLUMNS C')};
COPY=ADD10
=SQL{?W?' INNER JOIN SYSIBM.SYSTABLES T')};
COPY=ADD10
=SQL{?W?' ON C.TBNAME=T.NAME')};
COPY=ADD10
=SQL{?W?' AND C.TBCREATOR=T.CREATOR')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN')};
COPY=ADD10
=SQL{?W?' I_?_Q?_SYSTEM?_Q?_R_M_ZZZZ')};
COPY=ADD10
=SQL{?W?'.ZZZZZZ_I_DICTIONARY_TABLE')};
COPY=ADD10
=SQL{?W?' ON C.NAME=ZZZZZZ_DATA_NAME')};
COPY=ADD10
=SQL{?W?' AND ZZZZZZ_LANG=''?_LANG_SYSTEM?''')};
COPY=ADD10
=SQL{?W?' WHERE C.TBCREATOR=''?W_I_DB?''')};
*****( INDEX_VIEW )***************************************
NAME=I_INDEX_VIEW
=SET{WI=W_INSERT+'''I'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_REAL,ZZZZZZ_WORK,ZZZZZZ_USER')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_NAME,ZZZZZZ_DATA_NAME')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_IX,ZZZZZZ_NO)AS SELECT')};
COPY=ADD10
=SQL{?W?' CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(DEFINER,LENGTH(DEFINER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(TBNAME AS CHAR(90))')};
COPY=ADD10
=SQL{?W?',CAST(COLNAME AS CHAR(90))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(NAME,2,1) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(COLSEQ-CASE WHEN UNIQUERULE<>''D''')};
COPY=ADD10
=SQL{?W?' THEN 1 ELSE 0 END AS INT)')};
COPY=ADD10
=SQL{?W?' FROM SYSIBM.SYSINDEXES')};
COPY=ADD10
=SQL{?W?' INNER JOIN SYSIBM.SYSINDEXCOLUSE')};
COPY=ADD10
=SQL{?W?' ON NAME=INDNAME')};
COPY=ADD10
=SQL{?W?' AND CREATOR=INDSCHEMA')};
COPY=ADD10
=SQL{?W?' LEFT JOIN SYSIBM.SYSCONSTDEP')};
COPY=ADD10
=SQL{?W?' ON NAME=BNAME')};
COPY=ADD10
=SQL{?W?' AND CREATOR=BCREATOR')};
COPY=ADD10
=SQL{?W?' AND DTBCREATOR=''?W_I_DB?''')};
COPY=ADD10
=SQL{?W?' WHERE SUBSTR(NAME,1,2)')};
COPY=ADD10
=SQL{?W?' IN(''X0'',''X1'',''X2'',''X3'',''X4''')};
COPY=ADD10
=SQL{?W?',''X5'',''X6'',''X7'',''X8'',''X9'')')};
COPY=ADD10
=SQL{?W?' AND TBCREATOR=''?W_I_DB?''')};
*****( GRANT_VIEW )***************************************
NAME=I_GRANT_VIEW
=SET{WI=W_INSERT+'''I'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_KIND,ZZZZZZ_REAL,ZZZZZZ_WORK')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_USER,ZZZZZZ_NAME,ZZZZZZ_GRANT')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_SELECT,ZZZZZZ_INSERT')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_UPDATE,ZZZZZZ_DELETE')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_EXECUTE)AS SELECT')};
COPY=ADD10
=SQL{?W?' CAST(CASE T.TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''V'' THEN ''VIEW''')};
COPY=ADD10
=SQL{?W?' ELSE ''TABLE'' END AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(DEFINER,LENGTH(DEFINER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(T.NAME AS CHAR(90))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN LENGTH(RTRIM(G.GRANTEE))')};
COPY=ADD10
=SQL{?W?' >6 THEN SUBSTR(G.GRANTEE')};
COPY=ADD10
=SQL{?W?',LENGTH(RTRIM(G.GRANTEE))-5)')};
COPY=ADD10
=SQL{?W?' ELSE G.GRANTEE END AS CHAR(6))')};
COPY=ADD10
=SQL{?W?',CAST(CASE G.SELECTAUTH WHEN ''N''')};
COPY=ADD10
=SQL{?W?' THEN '' '' ELSE ''S'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE G.INSERTAUTH WHEN ''N''')};
COPY=ADD10
=SQL{?W?' THEN '' '' ELSE ''I'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE G.UPDATEAUTH WHEN ''N''')};
COPY=ADD10
=SQL{?W?' THEN '' '' ELSE ''U'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE G.DELETEAUTH WHEN ''N''')};
COPY=ADD10
=SQL{?W?' THEN '' '' ELSE ''D'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM SYSIBM.SYSTABLES T')};
COPY=ADD10
=SQL{?W?',SYSIBM.SYSTABAUTH G')};
COPY=ADD10
=SQL{?W?' WHERE T.CREATOR=''?W_I_DB?''')};
COPY=ADD10
=SQL{?W?' AND (G.GRANTEE LIKE')};
COPY=ADD10
=SQL{?W?' ''?_Q?_DB_HEADER?_Q?%''')};
COPY=ADD10
=SQL{?W?' OR G.GRANTEE=''PUBLIC'')')};
COPY=ADD10
=SQL{?W?' AND G.TCREATOR=''?W_I_DB?''')};
COPY=ADD10
=SQL{?W?' AND T.NAME=G.TTNAME')};
NAME=
*************************************************************
=I_SKIP:
*(PERMISSION_END)*
