﻿* SET_DB_P.TXT HARASAWA (PostgreSQL)
*********( CREATE DATABASE )*********************************************************
=IF{_DB!='P'}JUMP{P_SKIP};
*U+FORM1=☆お願い☆：実行開始後、端末画面側でエラー確認、Enterで続行下さい。};
W+=SET{WC='&'};
W+=SET{W_PARAM='-U ?_LOGIN_ID? i_?WLSYSTEM?'};
W+=SET{W_PATH='"'+$INSTALL_PATH+'\bin\createdb"'};
U+=SET{W_PATH='su -c ''createdb i_?WLSYSTEM?'' ?_LOGIN_ID?',W_PARAM=,WC=';'};
*U+=MESSAGE{☆お願い☆：起動画面側でパスワードを入力して下さい。};
=COMMAND{echo =========================================================================
=?WC?echo ☆お願い☆：パスワードを要求された場合は'?_LOGIN_ID?'のパスワードを入力下さい。
=?WC?echo ==============================================================================
=?WC?echo ?W_PATH? ?W_PARAM?
=?WC??W_PATH? ?W_PARAM?
=?WC?echo ===========================================};
*=?WC?echo ☆お願い☆：エラー確認後、Enterで続行下さい。
*=?WC?echo ===========================================
*W+=?WC?PAUSE};
*U+=?WC?read a};
*(PERMISSION_BEGIN)*
=IF{_DB!='P'}JUMP{P_SKIP};
*********( SET )*************************************
REPEAT0=$W0PERMISSION
=SET{_LOWER=W_PER$$,W_PER$$=_LOWER};
REPEAT0=4
=SET{_LOWER=W_DIOL$$,W_DIOL$$=_LOWER};
REPEAT0=3
=SET{_LOWER=W_RTT$$,W_RTT$$=_LOWER};
=SET{_LOWER=W_RRT$$,W_RRT$$=_LOWER};
REPEAT0=2
=SET{_LOWER=W_R_T$$,W_R_T$$=_LOWER};
=SET{_LOWER=W_M_W$$,W_M_W$$=_LOWER};
REPEAT0=
=SET{_LOWER=W_IS,W_IS=_LOWER};
*********( CREATE USER )*************************************
=MESSAGE{CREATE USER};
REPEAT0=$W0PERMISSION
REPEAT=2 (W_REAL_TEST##)
=SET{WPAS=W_PASSWORD_?W_REAL_TEST##?};
=SET{W_CU='CREATEDB CREATEUSER'};
=SET{W0REPEAT2CNT=0};
REPEAT2=4 (W_DIOL--)
=COMPUTE{W0REPEAT2CNT+=1};
=SET{W_DIOL=W_DIOL?W0REPEAT2CNT?};
=IF{W0REPEAT2CNT=4}SET{WPAS=W_PASSWORD_LINK};
=IF{W0REPEAT2CNT=2}SET{W_CU=};
=LOGIN_SQL{CREATE USER ?W_IS??W_R_T##?_?W_DIOL?_?W_PER$$?
=   WITH ?W_CU? PASSWORD '?WPAS?'}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{};
REPEAT0=
*********( REVOKE PUBLIC )***********************************
=LOGIN_SQL{REVOKE ALL ON SCHEMA public from public};
*********( CREATE SCEMA )************************************
=MESSAGE{CREATE SCHEMA};
=SET{_LOWER='D',W_D_L=_LOWER};
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?}; 
=LOGIN_SQL{CREATE SCHEMA ?W_IS??W_R_T##?_?W_M_W?_?W_PER$$?
=   AUTHORIZATION ?W_IS??W_R_T##?_?W_D_L?_?W_PER$$?}
=  IF{_DB_I_ERROR!='EXIST'}ERROR{?_DB_ERROR? ?_ERROR?};
=LOGIN_SQL{GRANT USAGE ON SCHEMA 
=  ?W_IS??W_R_T##?_?W_M_W?_?W_PER$$? TO PUBLIC};
REPEAT0=
*************( GRANT ALL )***********************************
=SET{_LOWER='R_D_ZZZZ',W_R_D_ZZZZ_L=_LOWER};
REPEAT0=$W0PERMISSION
=MESSAGE{GRANT ...(?W_PER$$?)};
REPEAT=3
=SET{_LOWER='ZZZZ',W_PERX=_LOWER,W_ZZZZ=_LOWER};
=SET{W0REPEAT2CNT=0};
REPEAT2=2 (W_PER--;ZZZZ;自分))
=COMPUTE{W0REPEAT2CNT+=1};
=IF{W0REPEAT2CNT=2}SET{_LOWER=W_PER$$,W_PERX=_LOWER};
=SET{W_G='GRANT ALL PRIVILEGES ON SCHEMA ?W_IS??W_RTT##?'};
=LOGIN_SQL{?W_G?_M_?W_PER$$? TO ?W_IS??W_R_D_ZZZZ_L?};
=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?}
=;
=IF{W_PER$$=W_ZZZZ}JUMP{J};
REPEAT2=
=J:
REPEAT0=
REPEAT0=2
=SET{_UPPER=W_R_T$$,W_R_T$$=_UPPER};
=SET{_UPPER=W_M_W$$,W_M_W$$=_UPPER};
REPEAT0=
=JUMP{P_SKIP};
********( CREATE VIEW )**************************************
*****( OBJECT_VIEW )*****************************************
NAME=P_OBJECT_VIEW
=SET{WI=W_INSERT+'''P'','};
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(UPPER(SUBSTR(TABLEOWNER')};
COPY=ADD10
=SQL{?W?',LENGTH(TABLEOWNER)-5,1)) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(UPPER(TABLENAME) AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS VARCHAR(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 PG_TABLES WHERE ')};
COPY=ADD10
=SQL{?W?' SCHEMANAME')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_P_DB?'')')};
COPY=ADD10
=SQL{?W?' UNION SELECT')};
COPY=ADD10
=SQL{?W?' 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(UPPER(SUBSTR(VIEWOWNER')};
COPY=ADD10
=SQL{?W?',LENGTH(VIEWOWNER)-5,1)) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(UPPER(VIEWNAME) AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(DEFINITION AS VARCHAR(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 PG_VIEWS WHERE')};
COPY=ADD10
=SQL{?W?' SCHEMANAME')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_P_DB?'')')};
COPY=ADD10
=SQL{?W?' UNION 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(UPPER(SUBSTR(USENAME')};
COPY=ADD10
=SQL{?W?',LENGTH(USENAME)-5,1)) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(UPPER(PRONAME) AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(PROSRC AS VARCHAR(4000))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST( UPPER(''(''||CASE')};
COPY=ADD10
=SQL{?W?' WHEN PRONARGS=0 THEN '''' ELSE')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[0])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<2 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[1])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<3 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[2])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<4 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE')};
COPY=ADD10
=SQL{?W?' WHERE OID=PROARGTYPES[3])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<5 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[4])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<6 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[5])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<7 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[6])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<8 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[7])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<9 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[8])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<10 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[9])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<11 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[10])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<12 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[11])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<13 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[12])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<14 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[13])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<15 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[14])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<16 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[15])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<17 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[16])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<18 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[17])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<19 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[18])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<20 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[19])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<21 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[20])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<22 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[21])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<23 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[22])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<24 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[23])END')};
COPY=ADD10
=SQL{?W?'||CASE WHEN PRONARGS<25 THEN ''''')};
COPY=ADD10
=SQL{?W?' ELSE '',''||')};
COPY=ADD10
=SQL{?W?'(SELECT TYPNAME FROM PG_TYPE WHERE')};
COPY=ADD10
=SQL{?W?' OID=PROARGTYPES[24])END')};
COPY=ADD10
=SQL{?W?'||'')'') AS VARCHAR(4000))')};
COPY=ADD10
=SQL{?W?' FROM PG_PROC P')};
COPY=ADD10
=SQL{?W?' ,PG_USER U WHERE PROOWNER=USESYSID')};
COPY=ADD10
=SQL{?W?' AND USENAME')};
COPY=ADD10
=SQL{?W?' ?W_P_OWNER1?')};
COPY=ADD10
=SQL{?W?' ?W_P_OWNER2?')};
*****( COLUMN_VIEW )*****************************************
NAME=P_COLUMN_VIEW
=SET{WI=W_INSERT+'''P'','};
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,ZZZZZZ_DEFAULT_LENGTH2')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DEFAULT,ZZZZZZ_NULL)')};
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(UPPER(SUBSTR(TABLEOWNER')};
COPY=ADD10
=SQL{?W?',LENGTH(TABLEOWNER)-5,1)) AS CHAR(1))')};
NAME2=P_COLUMN
COPY=ADD10
=SQL{?W?',CAST(UPPER(C.RELNAME) AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',A.ATTNUM,CAST(UPPER(A.ATTNAME) AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE UPPER(TYPNAME)')};
COPY=ADD10
=SQL{?W?' WHEN ''NUMERIC'' THEN CHAR ''DECIMAL''')};
COPY=ADD10
=SQL{?W?' WHEN ''INT4'' THEN CHAR ''INT''')};
COPY=ADD10
=SQL{?W?' WHEN ''INT2'' THEN CHAR ''INT''')};
COPY=ADD10
=SQL{?W?' WHEN ''FLOAT8'' THEN CHAR ''FLOAT''')};
COPY=ADD10
=SQL{?W?' WHEN ''TIMESTAMP'' THEN CHAR ''DATETIME''')};
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 ''VARCHAR'' END')};
COPY=ADD10
=SQL{?W?' ELSE')};
COPY=ADD10
=SQL{?W?' CASE WHEN  UPPER(TYPNAME)')};
COPY=ADD10
=SQL{?W?' IN(''BPCHAR'',''CHAR'') THEN')};
COPY=ADD10
=SQL{?W?' CASE ZZZZZZ_DEFAULT_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''NCHAR'' THEN ''NCHAR''')};
COPY=ADD10
=SQL{?W?' ELSE ''CHAR'' END')};
COPY=ADD10
=SQL{?W?' ELSE UPPER(TYPNAME) END')};
COPY=ADD10
=SQL{?W?' END AS CHAR(9))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN UPPER(TYPNAME)')};
COPY=ADD10
=SQL{?W?' IN(''BPCHAR'',''VARCHAR'')')};
COPY=ADD10
=SQL{?W?' THEN A.ATTTYPMOD-4 ')};
COPY=ADD10
=SQL{?W?' ELSE CASE UPPER(TYPNAME)')};
COPY=ADD10
=SQL{?W?' WHEN ''NUMERIC''')};
COPY=ADD10
=SQL{?W?' THEN (A.ATTTYPMOD-4)/65536 ')};
COPY=ADD10
=SQL{?W?' WHEN ''TIMESTAMP'' THEN 17')};
COPY=ADD10
=SQL{?W?' WHEN ''DATE'' THEN 8')};
COPY=ADD10
=SQL{?W?' WHEN ''TEXT'' THEN 4000')};
COPY=ADD10
=SQL{?W?' ELSE 9 END END AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(CASE UPPER(TYPNAME)')};
COPY=ADD10
=SQL{?W?' WHEN ''NUMERIC''')};
COPY=ADD10
=SQL{?W?' THEN (A.ATTTYPMOD-4)%65536')};
COPY=ADD10
=SQL{?W?' ELSE 0 END AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(REPLACE(REPLACE(REPLACE')};
COPY=ADD10
=SQL{?W?'(UPPER(D.ADSRC),''::BPCHAR'','''')')};
COPY=ADD10
=SQL{?W?',''::CHARACTER VARYING'','''')')};
COPY=ADD10
=SQL{?W?',''(''''NOW''''::TEXT)::DATE''')};
COPY=ADD10
=SQL{?W?',''CURRENT_DATE'') AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN A.ATTNOTNULL')};
COPY=ADD10
=SQL{?W?' THEN ''0'' ELSE ''1'' END')};
COPY=ADD10
=SQL{?W?' AS CHAR(1)) FROM PG_CLASS C JOIN ')};
NAME2=
COPY=ADD10
=SQL{?W?' PG_TABLES T')};
COPY=ADD10
=SQL{?W?' ON C.RELNAME=T.TABLENAME')};
COPY=ADD10
=SQL{?W?' AND C.RELKIND=LOWER(''R'') AND')};
COPY=ADD10
=SQL{?W?' T.SCHEMANAME')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_P_DB?'')')};
COPY=ADD10
=SQL{?W?' JOIN PG_USER U')};
COPY=ADD10
=SQL{?W?' ON U.USENAME=T.TABLEOWNER')};
NAME2=P_COLUMN_JOIN
COPY=ADD10
=SQL{?W?' AND C.RELOWNER=U.USESYSID')};
COPY=ADD10
=SQL{?W?' JOIN PG_ATTRIBUTE A')};
COPY=ADD10
=SQL{?W?' ON C.OID=A.ATTRELID')};
COPY=ADD10
=SQL{?W?' AND A.ATTNUM>0')};
COPY=ADD10
=SQL{?W?' JOIN PG_TYPE TY')};
COPY=ADD10
=SQL{?W?' ON A.ATTTYPID=TY.OID')};
COPY=ADD10
=SQL{?W?' LEFT JOIN PG_ATTRDEF D')};
COPY=ADD10
=SQL{?W?' ON C.OID=D.ADRELID')};
COPY=ADD10
=SQL{?W?' AND A.ATTNUM=D.ADNUM LEFT 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 UPPER(A.ATTNAME)')};
COPY=ADD10
=SQL{?W?'=ZZZZZZ_DATA_NAME')};
COPY=ADD10
=SQL{?W?' AND ZZZZZZ_LANG=''?_LANG_SYSTEM?''')};
NAME2=
COPY=ADD10
=SQL{?W?' UNION SELECT')};
COPY=ADD10
=SQL{?W?' CAST(''VIEW'' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?''')};
COPY=ADD10
=SQL{?W?' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(UPPER(SUBSTR(VIEWOWNER')};
COPY=ADD10
=SQL{?W?',LENGTH(VIEWOWNER)-5,1)) AS CHAR(1))')};
COPY=P_COLUMN
COPY=ADD10
=SQL{?W?' PG_VIEWS T')};
COPY=ADD10
=SQL{?W?' ON C.RELNAME=T.VIEWNAME')};
COPY=ADD10
=SQL{?W?' AND C.RELKIND=LOWER(''V'') AND')};
COPY=ADD10
=SQL{?W?' T.SCHEMANAME')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_P_DB?'')')};
COPY=ADD10
=SQL{?W?' JOIN PG_USER U')};
COPY=ADD10
=SQL{?W?' ON U.USENAME=T.VIEWOWNER')};
COPY=P_COLUMN_JOIN
*****( INDEX_VIEW )******************************************
NAME=P_INDEX_VIEW
=SET{WI=W_INSERT+'''P'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_REAL,ZZZZZZ_WORK')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_USER,ZZZZZZ_NAME')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DATA_NAME,ZZZZZZ_IX,ZZZZZZ_NO)')};
COPY=ADD10
=SQL{?W?'AS SELECT')};
NAME2=P_SQL1
COPY=ADD10
=SQL{?W?' CAST(''?_Q?_REAL_TEST?_Q?''')};
COPY=ADD10
=SQL{?W?' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(UPPER(SUBSTR(TABLEOWNER')};
COPY=ADD10
=SQL{?W?',LENGTH(TABLEOWNER)-5,1)) AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(UPPER(I.TABLENAME) AS CHAR(30)),')};
NAME2=P_SPLIT
COPY=ADD10
=SQL{?W?'CAST(TRIM(UPPER(TRIM(SPLIT_PART(')};
COPY=ADD10
=SQL{?W?'SUBSTRING(INDEXDEF')};
COPY=ADD10
=SQL{?W?',POSITION(''('' IN INDEXDEF)+1')};
COPY=ADD10
=SQL{?W?',POSITION('')'' IN INDEXDEF)')};
COPY=ADD10
=SQL{?W?'-POSITION(''('' IN INDEXDEF)-1)')};
COPY=ADD10
=SQL{?W?','','',')};
NAME2=
COPY=ADD10
=SQL{?W?' 1))),''"'') AS CHAR(30)),')};
NAME2=P_SQL2
COPY=ADD10
=SQL{?W?' CAST(SUBSTRING(INDEXNAME')};
COPY=ADD10
=SQL{?W?',LENGTH(TRIM(INDEXNAME)),1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN INDEXDEF LIKE')};
COPY=ADD10
=SQL{?W?' ''CREATE UNIQUE %'' THEN')};
NAME2=
COPY=ADD10
=SQL{?W?' ''0'' ELSE ''1''')};
NAME2=P_SQL3
COPY=ADD10
=SQL{?W?' END AS INT) FROM PG_INDEXES I')};
COPY=ADD10
=SQL{?W?',PG_TABLES T')};
COPY=ADD10
=SQL{?W?' WHERE I.TABLENAME=T.TABLENAME')};
COPY=ADD10
=SQL{?W?' AND I.SCHEMANAME=T.SCHEMANAME AND')};
COPY=ADD10
=SQL{?W?' I.SCHEMANAME')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_P_DB?'')')};
COPY=ADD10
=SQL{?W?' AND TRIM('' '')<>')};
NAME2=
COPY=P_SPLIT
COPY=ADD10
=SQL{?W?' 1))),''"'')')};
COPY=ADD10
=SQL{?W?' AS CHAR(30)) ')};
**************************************************
=SET{W0REPEAT2CNT=0}; 
*REPEAT2=8
=P_SQLX:
=COMPUTE{W0REPEAT2CNT+=1
=  ,W0REPEAT2CNT_P1=W0REPEAT2CNT+1};
**************************************************
COPY=ADD10
=SQL{?W?' UNION SELECT')};
COPY=P_SQL1
COPY=P_SPLIT
COPY=ADD10
=SQL{?W?' ?W0REPEAT2CNT_P1?))),''"'')')};
COPY=ADD10
=SQL{?W?' AS CHAR(30)),')};
COPY=P_SQL2
COPY=ADD10
=SQL{?W?' ''?W0REPEAT2CNT?''')};
COPY=ADD10
=SQL{?W?' ELSE ''?W0REPEAT2CNT_P1?''')};
COPY=P_SQL3
COPY=P_SPLIT
COPY=ADD10
=SQL{?W?' ?W0REPEAT2CNT_P1?))),''"'')')};
COPY=ADD10
=SQL{?W?' AS CHAR(30))')};
**************************************************
=IF{W0REPEAT2CNT<8}BACK{P_SQLX};
**************************************************
COPY=ADD10
=SQL{?W?' UNION SELECT')};
COPY=P_SQL1
COPY=P_SPLIT
COPY=ADD10
=SQL{?W?' 10))),''"'') AS CHAR(30)),')};
COPY=P_SQL2
COPY=ADD10
=SQL{?W?' ''9'' ELSE ''0''')};
COPY=P_SQL3
COPY=P_SPLIT
COPY=ADD10
=SQL{?W?' 10))),''"'') AS CHAR(30))')};
*****( GRANT_VIEW )******************************************
NAME=P_GRANT_VIEW
=SET{W_P_GRANT_SW=0};
=SET{WI=W_INSERT+'''P'','};
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,ZZZZZZ_UPDATE')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DELETE,ZZZZZZ_EXECUTE)AS')};
=SET{W0L8=WLSYSTEM@LENGTH};COMPUTE{W0L8+=8};
=SET{W_UNION=,W_SQL=};
=SET{W_GRANT='PUBLIC',W_GRANTX=};
=SET{W_DBD='/?_Q?_DB_HEADER?_Q?_D_'};
*=======NAME=GRANT$$===============================
=P_GRANT_LOOP:
COPY=ADD10
=SQL{?W?' ?W_UNION?')};
COPY=ADD10
=SQL{?W?' 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(UPPER(SUBSTR(TABLEOWNER')};
COPY=ADD10
=SQL{?W?',LENGTH(TABLEOWNER)-5,1)) AS CHAR(1))')};
******
NAME2=GRANT_SUB_A
COPY=ADD10
=SQL{?W?',CAST(UPPER(C.RELNAME) AS CHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_GRANT?'' AS CHAR(6))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN ACLCONTAINS(RELACL,LOWER(')};
COPY=ADD10
=SQL{?W?'''?W_GRANTX?=R?W_DBD?ZZZZ'')')};
COPY=ADD10
=SQL{?W?'::ACLITEM) OR ACLCONTAINS(RELACL,LOWER(')};
COPY=ADD10
=SQL{?W?'''?W_GRANTX?=R?W_DBD??WC.PER?'')')};
COPY=ADD10
=SQL{?W?'::ACLITEM) THEN CHAR ''S'' ELSE CHAR '' ''')};
COPY=ADD10
=SQL{?W?' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN ACLCONTAINS(RELACL,LOWER(')};
COPY=ADD10
=SQL{?W?'''?W_GRANTX?=A?W_DBD?ZZZZ'')')};
COPY=ADD10
=SQL{?W?'::ACLITEM) OR ACLCONTAINS(RELACL,LOWER(')};
COPY=ADD10
=SQL{?W?'''?W_GRANTX?=A?W_DBD??WC.PER?'')')};
COPY=ADD10
=SQL{?W?'::ACLITEM) THEN CHAR ''I'' ELSE CHAR '' ''')};
COPY=ADD10
=SQL{?W?' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN ACLCONTAINS(RELACL,LOWER(')};
COPY=ADD10
=SQL{?W?'''?W_GRANTX?=W?W_DBD?ZZZZ'')')};
COPY=ADD10
=SQL{?W?'::ACLITEM) OR ACLCONTAINS(RELACL,LOWER(')};
COPY=ADD10
=SQL{?W?'''?W_GRANTX?=W?W_DBD??WC.PER?'')')};
COPY=ADD10
=SQL{?W?'::ACLITEM) THEN CHAR ''U'' ELSE CHAR '' ''')};
COPY=ADD10
=SQL{?W?' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN ACLCONTAINS(RELACL,LOWER(')};
COPY=ADD10
=SQL{?W?'''?W_GRANTX?=D?W_DBD?ZZZZ'')')};
COPY=ADD10
=SQL{?W?'::ACLITEM) OR ACLCONTAINS(RELACL,LOWER(')};
COPY=ADD10
=SQL{?W?'''?W_GRANTX?=D?W_DBD??WC.PER?'')')};
COPY=ADD10
=SQL{?W?'::ACLITEM) THEN CHAR ''D'' ELSE CHAR '' ''')};
COPY=ADD10
=SQL{?W?' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST('' ''AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM PG_CLASS C,PG_USER U')};
NAME2=
COPY=ADD10
=SQL{?W?',PG_TABLES T WHERE')};
COPY=ADD10
=SQL{?W?' C.RELNAME=T.TABLENAME AND')};
COPY=ADD10
=SQL{?W?' T.SCHEMANAME')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_P_DB?'')')};
COPY=ADD10
=SQL{?W?' AND U.USENAME=T.TABLEOWNER')};
COPY=ADD10
=SQL{?W?' AND C.RELKIND=LOWER(''R'')')};
NAME2=GRANT_SUB_B
COPY=ADD10
=SQL{?W?' AND C.RELOWNER=U.USESYSID')};
COPY=ADD10
=SQL{?W?' AND(ACLCONTAINS(RELACL,LOWER(')};
COPY=ADD10
=SQL{?W?'''?W_GRANTX?=R?W_DBD?ZZZZ'')')};
COPY=ADD10
=SQL{?W?'::ACLITEM) OR  ACLCONTAINS(RELACL,LOWER(')};
COPY=ADD10
=SQL{?W?'''?W_GRANTX?=R?W_DBD??WC.PER?'')')};
COPY=ADD10
=SQL{?W?'::ACLITEM))')};
NAME2=
COPY=ADD10
=SQL{?W?' UNION SELECT ')};
COPY=ADD10
=SQL{?W?' 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(UPPER(SUBSTR(VIEWOWNER')};
COPY=ADD10
=SQL{?W?',LENGTH(VIEWOWNER)-5,1)) AS CHAR(1))')};
COPY=GRANT_SUB_A
COPY=ADD10
=SQL{?W?',PG_VIEWS V WHERE')};
COPY=ADD10
=SQL{?W?' C.RELNAME=V.VIEWNAME AND')};
COPY=ADD10
=SQL{?W?' V.SCHEMANAME')};
COPY=ADD10
=SQL{?W?'=LOWER(''?W_P_DB?'')')};
COPY=ADD10
=SQL{?W?' AND U.USENAME=V.VIEWOWNER')};
COPY=ADD10
=SQL{?W?' AND C.RELKIND=LOWER(''V'')')};
COPY=GRANT_SUB_B
=IF{W_P_GRANT_SW=1}JUMP{P_GRANT1};
=IF{W_P_GRANT_SW=2}JUMP{P_GRANT2};
=IF{W_P_GRANT_SW=3}JUMP{P_GRANT3};
=IF{W_P_GRANT_SW=4}JUMP{P_GRANT4};
*======================================================
=SET{W_UNION=' UNION'};
=SET{W0REPEAT2CNT=0};
=SET{W0_P_PER_COUNT=1};
=P_PER_LOOP:
=COMPUTE{W0REPEAT2CNT+=1};
=SET{W_PERX=WC.PERMISSION?W0REPEAT2CNT?};
=SET{W_GRANT='D_'+W_PERX};
=SET{W_GRANTX='?_Q?_DB_HEADER?_Q?_D_?W_PERX?'};
=SET{W_P_GRANT_SW=1};BACK{P_GRANT_LOOP};
=P_GRANT1:
=SET{_UPPER=W_PERX,W_GRANT='I_'+_UPPER};
=SET{W_GRANTX='?_Q?_DB_HEADER?_Q?_I_?W_PERX?'};
=SET{W_P_GRANT_SW=2};BACK{P_GRANT_LOOP};
=P_GRANT2:
=SET{_UPPER=W_PERX,W_GRANT='O_'+_UPPER};
=SET{W_GRANTX='?_Q?_DB_HEADER?_Q?_O_?W_PERX?'};
=SET{W_P_GRANT_SW=3};BACK{P_GRANT_LOOP};
=P_GRANT3:
=SET{_UPPER=W_PERX,W_GRANT='L_'+_UPPER};
=SET{W_GRANTX='?_Q?_DB_HEADER?_Q?_L_?W_PERX?'};
=SET{W_P_GRANT_SW=4};BACK{P_GRANT_LOOP};
=P_GRANT4:
=COMPUTE{W0_P_PER_COUNT+=1};
=IF{W0_P_PER_COUNT<=W0PER_MAX}BACK{P_PER_LOOP};
NAME=
*************************************************************
=P_SKIP:
=SET{_REAL_TEST='REAL'};
*(PERMISSION_END)*
