﻿* SET_DB_H.TXT HARASAWA (HiRDB)
*(PERMISSION_BEGIN)*
=IF{_DB!='H'}JUMP{H_SKIP};
*********( CREATE USER )*************************************
=SET{W_CONNECT='DBA'};
REPEAT0=$W0PERMISSION
=MESSAGE{CREATE USER};
REPEAT=2 (W_REAL_TEST##)
=SET{WPAS=W_PASSWORD_?W_REAL_TEST##?};
=SET{W0REPEAT2CNT=0};
REPEAT2=4 (W_DIOL--)
=COMPUTE{W0REPEAT2CNT+=1};
=SET{W_DIOL=W_DIOL?W0REPEAT2CNT?};
=IF{W0REPEAT2CNT=4}SET{WPAS=W_PASSWORD_LINK};
=LOGIN_SQL{GRANT ?W_CONNECT? TO 
=  ?W_IS??W_R_T##??W_DIOL??W_PER$$? IDENTIFIED BY "?WPAS?"};
=SET{W_CONNECT='CONNECT'};
REPEAT0=
*********( CREATE SCEMA )************************************
=MESSAGE{CREATE SCHEMA};
REPEAT0=$W0PERMISSION
REPEAT=2  (W_REAL_TEST##=REAL;TEST)
=SET{W0REPEAT2CNT=0};
REPEAT2=3 (W_DIOL--=D;I;O) 
=COMPUTE{W0REPEAT2CNT+=1};
=SET{W_DIOL=W_DIOL?W0REPEAT2CNT?};
=SET{W_SCHEMA='?W_IS??W_R_T##??W_DIOL??W_PER$$?'};
=LOGIN_SQL{CREATE SCHEMA AUTHORIZATION ?W_SCHEMA?}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
REPEAT0=
*(PERMISSION_END)*
********( CREATE DUAL_TABLE )********************************
REPEAT=2 (W_REAL_TEST##)
=SET{W_M=_M_?W_REAL_TEST##?,_REAL_TEST=W_REAL_TEST##};
=DBO_DROP_TABLE{?W_M?ZZ_DUAL_TABLE};
=DBO_CREATE_TABLE{?W_M?ZZ_DUAL_TABLE}{ZZZZZZ_ONE,INT}{}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=DBO_GRANT{?W_M?ZZ_DUAL_TABLE}{TABLE}{PUBLIC};
=DBO_SQL{INSERT INTO ?W_M?ZZ_DUAL_TABLE(ZZZZZZ_ONE)VALUES(1)};
REPEAT=
****************************************
*(PERMISSION_BEGIN)*
=JUMP{H_SKIP};
*****( OBJECT_VIEW )********************************
NAME=H_OBJECT_VIEW
=SET{WI=W_INSERT+'''H'','};
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?',ZZZZZZ_TYPES)AS SELECT')};
COPY=ADD10
=SQL{?W?' 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(TABLE_SCHEMA')};
COPY=ADD10
=SQL{?W?',LENGTH(TABLE_SCHEMA)-4,1) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(TABLE_NAME AS MCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS MVARCHAR(4000))')};
COPY=ADD10
=SQL{?W?',CAST(CREATE_TIME AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST(CHANGE_TIME AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS VARCHAR(4000))')};
COPY=ADD10
=SQL{?W?' FROM MASTER.SQL_TABLES WHERE ')};
COPY=ADD10
=SQL{?W?' TABLE_SCHEMA IN')};
COPY=ADD10
=SQL{?W?'(?W_H_OWNER?)')};
COPY=ADD10
=SQL{?W?' AND TABLE_TYPE=''BASE TABLE''')};
COPY=ADD10
=SQL{?W?' UNION 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(VIEW_SCHEMA')};
COPY=ADD10
=SQL{?W?',LENGTH(VIEW_SCHEMA)-4,1)AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(VIEW_NAME AS MCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(VIEW_DEFINITION AS MVARCHAR(4000))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS VARCHAR(4000))')};
COPY=ADD10
=SQL{?W?' FROM MASTER.SQL_VIEWS')};
COPY=ADD10
=SQL{?W?' WHERE VIEW_SCHEMA IN')};
COPY=ADD10
=SQL{?W?'(?W_H_OWNER?) ')};
COPY=ADD10
=SQL{?W?' UNION SELECT')};
COPY=ADD10
=SQL{?W?' CAST(CASE R.ROUTINE_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''F'' THEN ''FUNC'' ')};
COPY=ADD10
=SQL{?W?' ELSE ''PROC'' 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(R.ROUTINE_SCHEMA')};
COPY=ADD10
=SQL{?W?',LENGTH(R.ROUTINE_SCHEMA)-4,1)AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(R.ROUTINE_NAME AS MCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS MVARCHAR(4000))')};
COPY=ADD10
=SQL{?W?',CAST(R.CREATE_TIME AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17)),CAST(''(''||')};
COPY=ADD10
=SQL{?W?' CASE WHEN  P1.DATA_TYPE IS NULL THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE  RTRIM(P1.DATA_TYPE) END||')};
COPY=ADD10
=SQL{?W?' CASE  WHEN P2.DATA_TYPE IS NULL THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||RTRIM(P2.DATA_TYPE) END||')};
COPY=ADD10
=SQL{?W?' CASE WHEN  P3.DATA_TYPE IS NULL THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||RTRIM(P3.DATA_TYPE) END||')};
COPY=ADD10
=SQL{?W?' CASE WHEN  P4.DATA_TYPE IS NULL THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||RTRIM(P4.DATA_TYPE) END||')};
COPY=ADD10
=SQL{?W?' CASE WHEN  P5.DATA_TYPE IS NULL THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||RTRIM(P5.DATA_TYPE) END||')};
COPY=ADD10
=SQL{?W?' CASE WHEN  P6.DATA_TYPE IS NULL THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||RTRIM(P6.DATA_TYPE) END||')};
COPY=ADD10
=SQL{?W?' CASE WHEN  P7.DATA_TYPE IS NULL THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||RTRIM(P7.DATA_TYPE) END||')};
COPY=ADD10
=SQL{?W?' CASE WHEN  P8.DATA_TYPE IS NULL THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||RTRIM(P8.DATA_TYPE) END||')};
COPY=ADD10
=SQL{?W?' CASE WHEN  P9.DATA_TYPE IS NULL THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||RTRIM(P9.DATA_TYPE) END||')};
COPY=ADD10
=SQL{?W?' CASE WHEN  P10.DATA_TYPE IS NULL THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||RTRIM(P10.DATA_TYPE) END||')};
COPY=ADD10
=SQL{?W?''')'' AS VARCHAR(4000))')};
COPY=ADD10
=SQL{?W?' FROM MASTER.SQL_ROUTINES R LEFT OUTER JOIN')};
COPY=ADD10
=SQL{?W?' MASTER.SQL_ROUTINE_PARAMS P1')};
COPY=ADD10
=SQL{?W?' ON R.ROUTINE_NAME=P1.ROUTINE_NAME')};
COPY=ADD10
=SQL{?W?' AND P1.PARAMETER_NO=1 ')};
COPY=ADD10
=SQL{?W?' AND R.ROUTINE_SCHEMA=P1.ROUTINE_SCHEMA')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN MASTER.SQL_ROUTINE_PARAMS P2')};
COPY=ADD10
=SQL{?W?' ON  R.ROUTINE_NAME=P2.ROUTINE_NAME')};
COPY=ADD10
=SQL{?W?' AND P2.PARAMETER_NO=2')};
COPY=ADD10
=SQL{?W?' AND R.ROUTINE_SCHEMA=P2.ROUTINE_SCHEMA ')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN MASTER.SQL_ROUTINE_PARAMS P3')};
COPY=ADD10
=SQL{?W?' ON  R.ROUTINE_NAME=P3.ROUTINE_NAME')};
COPY=ADD10
=SQL{?W?' AND P3.PARAMETER_NO=3')};
COPY=ADD10
=SQL{?W?' AND R.ROUTINE_SCHEMA=P3.ROUTINE_SCHEMA ')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN MASTER.SQL_ROUTINE_PARAMS P4')};
COPY=ADD10
=SQL{?W?' ON  R.ROUTINE_NAME=P4.ROUTINE_NAME')};
COPY=ADD10
=SQL{?W?' AND P4.PARAMETER_NO=4')};
COPY=ADD10
=SQL{?W?' AND R.ROUTINE_SCHEMA=P4.ROUTINE_SCHEMA ')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN MASTER.SQL_ROUTINE_PARAMS P5')};
COPY=ADD10
=SQL{?W?' ON R.ROUTINE_NAME=P5.ROUTINE_NAME')};
COPY=ADD10
=SQL{?W?' AND P5.PARAMETER_NO=5')};
COPY=ADD10
=SQL{?W?' AND R.ROUTINE_SCHEMA=P5.ROUTINE_SCHEMA ')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN MASTER.SQL_ROUTINE_PARAMS P6')};
COPY=ADD10
=SQL{?W?' ON R.ROUTINE_NAME=P6.ROUTINE_NAME')};
COPY=ADD10
=SQL{?W?' AND P6.PARAMETER_NO=6')};
COPY=ADD10
=SQL{?W?' AND R.ROUTINE_SCHEMA=P6.ROUTINE_SCHEMA ')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN MASTER.SQL_ROUTINE_PARAMS P7')};
COPY=ADD10
=SQL{?W?' ON R.ROUTINE_NAME=P7.ROUTINE_NAME')};
COPY=ADD10
=SQL{?W?' AND P7.PARAMETER_NO=7')};
COPY=ADD10
=SQL{?W?' AND R.ROUTINE_SCHEMA=P7.ROUTINE_SCHEMA ')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN MASTER.SQL_ROUTINE_PARAMS P8')};
COPY=ADD10
=SQL{?W?' ON  R.ROUTINE_NAME=P8.ROUTINE_NAME')};
COPY=ADD10
=SQL{?W?' AND  P8.PARAMETER_NO=8')};
COPY=ADD10
=SQL{?W?' AND R.ROUTINE_SCHEMA=P8.ROUTINE_SCHEMA ')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN MASTER.SQL_ROUTINE_PARAMS P9')};
COPY=ADD10
=SQL{?W?' ON R.ROUTINE_NAME=P9.ROUTINE_NAME')};
COPY=ADD10
=SQL{?W?' AND  P9.PARAMETER_NO=9')};
COPY=ADD10
=SQL{?W?' AND R.ROUTINE_SCHEMA=P9.ROUTINE_SCHEMA')};
COPY=ADD10
=SQL{?W?' LEFT OUTER JOIN MASTER.SQL_ROUTINE_PARAMS P10')};
COPY=ADD10
=SQL{?W?' ON R.ROUTINE_NAME=P10.ROUTINE_NAME')};
COPY=ADD10
=SQL{?W?' AND P10.PARAMETER_NO=10 ')};
COPY=ADD10
=SQL{?W?' AND R.ROUTINE_SCHEMA=P10.ROUTINE_SCHEMA')};
COPY=ADD10
=SQL{?W?' WHERE R.ROUTINE_SCHEMA IN')};
COPY=ADD10
=SQL{?W?'(?W_H_OWNER?) ')};
COPY=ADD10
=SQL{?W?' UNION 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(T.TRIGGER_SCHEMA')};
COPY=ADD10
=SQL{?W?',LENGTH(T.TRIGGER_SCHEMA)-4,1) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(T.TRIGGER_NAME AS MCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(D.DEF_SOURCE,1,4000)')};
COPY=ADD10
=SQL{?W?' AS MVARCHAR(4000))')};
COPY=ADD10
=SQL{?W?',CAST(T.CREATE_TIME AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS VARCHAR(4000))')};
COPY=ADD10
=SQL{?W?' FROM MASTER.SQL_TRIGGERS T')};
COPY=ADD10
=SQL{?W?' INNER JOIN MASTER.SQL_TRIGGER_DEF_SOURCE D')};
COPY=ADD10
=SQL{?W?' ON T.TRIGGER_SCHEMA=D.TRIGGER_SCHEMA')};
COPY=ADD10
=SQL{?W?' AND T.TRIGGER_NAME=D.TRIGGER_NAME')};
COPY=ADD10
=SQL{?W?' WHERE T.TRIGGER_SCHEMA IN')};
COPY=ADD10
=SQL{?W?'(?W_H_OWNER?) ')};
*****( COLUMN_VIEW )**************************************
NAME=H_COLUMN_VIEW
=SET{WI=W_INSERT+'''H'','};
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')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DEFAULT,ZZZZZZ_NULL)AS SELECT')};
COPY=ADD10
=SQL{?W?' CAST(CASE WHEN C.TABLE_NAME IS NULL')};
COPY=ADD10
=SQL{?W?' 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(C.TABLE_SCHEMA')};
COPY=ADD10
=SQL{?W?',LENGTH(C.TABLE_SCHEMA)-4,1) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(C.TABLE_NAME AS MCHAR(30))')};
COPY=ADD10
=SQL{?W?',C.COLUMN_ID')};
COPY=ADD10
=SQL{?W?',CAST(C.COLUMN_NAME AS MCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE C.DATA_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''MCHAR'' THEN ''NCHAR''')};
COPY=ADD10
=SQL{?W?' WHEN ''MVARCHAR'' THEN ''NVARCHAR''')};
COPY=ADD10
=SQL{?W?' WHEN ''TIMESTAMP'' THEN ''DATETIME'' ')};
COPY=ADD10
=SQL{?W?' WHEN ''INTEGER'' THEN ''INT''')};
COPY=ADD10
=SQL{?W?' WHEN ''SMALLINT'' THEN ''INT''')};
COPY=ADD10
=SQL{?W?' ELSE C.DATA_TYPE END AS CHAR(9))')};
COPY=ADD10
=SQL{?W?',CAST(CASE C.DATA_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''DECIMAL'' THEN ')};
COPY=ADD10
=SQL{?W?' SUBSTR(C.DATA_LENGTH,2,2)')};
COPY=ADD10
=SQL{?W?' WHEN ''FLOAT'' THEN ''9'' ')};
COPY=ADD10
=SQL{?W?' WHEN ''INTEGER'' THEN ''9''')};
COPY=ADD10
=SQL{?W?' WHEN ''SMALLINT'' THEN ''9''')};
COPY=ADD10
=SQL{?W?' WHEN ''TIMESTAMP'' THEN ''17''')};
COPY=ADD10
=SQL{?W?' WHEN ''DATE'' THEN ''8''')};
COPY=ADD10
=SQL{?W?' ELSE C.DATA_LENGTH END AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(CASE C.DATA_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''DECIMAL'' THEN ')};
COPY=ADD10
=SQL{?W?' SUBSTR(C.DATA_LENGTH,5,2)')};
COPY=ADD10
=SQL{?W?' ELSE ''0'' END AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(C.DEFAULT_VALUE AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE C.IS_NULLABLE')};
COPY=ADD10
=SQL{?W?' WHEN ''NO'' THEN ''0''')};
COPY=ADD10
=SQL{?W?' ELSE ''1'' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM MASTER.SQL_COLUMNS C ')};
COPY=ADD10
=SQL{?W?' LEFT JOIN MASTER.SQL_TABLES T ')};
COPY=ADD10
=SQL{?W?' ON C.TABLE_SCHEMA=T.TABLE_SCHEMA')};
COPY=ADD10
=SQL{?W?' AND C.TABLE_NAME=T.TABLE_NAME ')};
COPY=ADD10
=SQL{?W?' WHERE C.TABLE_SCHEMA IN')};
COPY=ADD10
=SQL{?W?'(?W_H_OWNER?)')};
*****( INDEX_VIEW )******************************************
NAME=H_INDEX_VIEW
=SET{WI=W_INSERT+'''H'','};
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(C.TABLE_SCHEMA')};
COPY=ADD10
=SQL{?W?',LENGTH(C.TABLE_SCHEMA)-4,1) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(C.TABLE_NAME AS MCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(C.COLUMN_NAME AS MCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE SUBSTR(I.INDEX_NAME')};
COPY=ADD10
=SQL{?W?',LENGTH(I.INDEX_NAME),1) ')};
COPY=ADD10
=SQL{?W?' WHEN '')'' THEN ''0'' ELSE ')};
COPY=ADD10
=SQL{?W?' SUBSTR(I.INDEX_NAME')};
COPY=ADD10
=SQL{?W?',LENGTH(I.INDEX_NAME),1) END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(C.INDEX_ORDER-CASE I.UNIQUE_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''U'' THEN 1')};
COPY=ADD10
=SQL{?W?' ELSE 0 END AS INT)')};
COPY=ADD10
=SQL{?W?' FROM MASTER.SQL_INDEX_COLINF C ')};
COPY=ADD10
=SQL{?W?' INNER JOIN MASTER.SQL_INDEXES I')};
COPY=ADD10
=SQL{?W?' ON C.TABLE_SCHEMA=I.TABLE_SCHEMA')};
COPY=ADD10
=SQL{?W?' AND C.TABLE_NAME=I.TABLE_NAME')};
COPY=ADD10
=SQL{?W?' AND C.INDEX_NAME=I.INDEX_NAME')};
COPY=ADD10
=SQL{?W?' WHERE C.TABLE_SCHEMA IN')};
COPY=ADD10
=SQL{?W?'(?W_H_OWNER?)')};
*****( GRANT_VIEW )******************************************
NAME=H_GRANT_VIEW
=SET{WI=W_INSERT+'''H'','};
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(''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(TABLE_SCHEMA')};
COPY=ADD10
=SQL{?W?',LENGTH(TABLE_SCHEMA)-4,1) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(TABLE_NAME AS MCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE GRANTEE')};
COPY=ADD10
=SQL{?W?' WHEN ''PUBLIC'' THEN GRANTEE ELSE')};
COPY=ADD10
=SQL{?W?' SUBSTR(GRANTEE,4,1)||''_''')};
COPY=ADD10
=SQL{?W?'||SUBSTR(GRANTEE,5,4)  END AS CHAR(6))')};
COPY=ADD10
=SQL{?W?',CAST(CASE SELECT_PRIVILEGE')};
COPY=ADD10
=SQL{?W?' WHEN ''Y'' THEN ''S''')};
COPY=ADD10
=SQL{?W?' ELSE '' '' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE INSERT_PRIVILEGE')};
COPY=ADD10
=SQL{?W?' WHEN ''Y'' THEN ''I''')};
COPY=ADD10
=SQL{?W?' ELSE '' '' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE UPDATE_PRIVILEGE')};
COPY=ADD10
=SQL{?W?' WHEN ''Y'' THEN ''U''')};
COPY=ADD10
=SQL{?W?' ELSE '' '' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE DELETE_PRIVILEGE')};
COPY=ADD10
=SQL{?W?' WHEN ''Y'' THEN ''D''')};
COPY=ADD10
=SQL{?W?' ELSE '' '' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM MASTER.SQL_TABLE_PRIVILEGES ')};
COPY=ADD10
=SQL{?W?' WHERE TABLE_SCHEMA IN')};
COPY=ADD10
=SQL{?W?'(?W_H_OWNER?)')};
COPY=ADD10
=SQL{?W?' AND (SUBSTR(TABLE_SCHEMA,1,3)')};
COPY=ADD10
=SQL{?W?'=SUBSTR(GRANTEE,1,3)')};
COPY=ADD10
=SQL{?W?' OR GRANTEE=''PUBLIC'') 　')};
NAME=
***********************
=SET{_REAL_TEST='REAL'};
=H_SKIP:
*(PERMISSION_END)*
