<?xml version="1.0" encoding="UTF-8"?>
<ROWSET tableName="GE70">
<EXEC_SQL>delete from GE70 where SYSTEM_ID='GE' and FGOMIT='0'</EXEC_SQL>











<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GE1009</ADDRESS>
<FILENAME>query.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GE1009\query.jsp</FILEPATH>
<MODIFIED>20070518112020</MODIFIED>
<TAGNAME>form</TAGNAME>
<MSGCD/>
<MSGTXT>テーブル登録時の form には、２度押し防止JavaScript( return oneClick(); )の使用を検討してください。</MSGTXT>
<TEXT>
<form xmlns:jsp="http://java.sun.com/JSP/Page" xmlns:og="hybs-taglib.tld" method="POST" action="forward.jsp" target="RESULT" onClick="timeSet();">
<table>
  <tr>
	<og:column name="DBID" size="10"/>
	<og:select name="TABLE_NAME" value="{@TABLE_NAME}" onChange="renew('query.jsp','QUERY');" must="true">
		<og:option value="" lbl=""/>
		<!-- 項目が一つの queryOption では、ラベルリソースが使用されます。 -->
		<og:queryOption dbid="{@DBID}" addKey="true">
			<jsp:text>
				select TABLE_NAME
				from USER_TABLES
				where  TABLE_NAME not like 'BIN$%'
				order by TABLE_NAME
			</jsp:text>
		</og:queryOption>
	</og:select>
  </tr>
</table>
<og:equals val1="{@TABLE_NAME}" val2="{@TABLE_NAME}">
<table>
  <tr>
<td colspan="2">
<og:view command="{@command}" scope="request" writable="true" selectedType="hidden" columnWritable="CLM,CONDITION,VALUE" noDisplay="NO" noMessage="true" useScrollBar="false"/>
  </td>
  <td rowspan="3">
	<!-- 検索結果に表示するカラム列を指定します。 -->
	<og:select name="NAMES" lbl="CLM" multiple="multiple" size="10" td="no">
		<og:option value="A.*" lbl="*" selected="selected"/>
		<!-- 項目が一つの queryOption では、ラベルリソースが使用されます。 -->
		<og:queryOption dbid="{@DBID}">
			<jsp:text>
				select COLUMN_NAME
				from USER_TAB_COLUMNS
				where  TABLE_NAME = '{@TABLE_NAME}'
				order by TABLE_NAME,COLUMN_ID
			</jsp:text>
		</og:queryOption>
	</og:select>
  </td>
  </tr>
  <tr>
<og:input name="AND" lbl="AND" maxlength="100" size="50"/>				</tr>
  <tr>
<og:input name="ORDER_BY" msg="ORDER_BY" maxlength="100" size="50"/>		</tr>
</table>
</og:equals>

<og:queryButton/>
</form>
</TEXT>
</ROW>

























<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GE1005</ADDRESS>
<FILENAME>tableSpace.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GE1005\tableSpace.jsp</FILEPATH>
<MODIFIED>20070417090222</MODIFIED>
<TAGNAME>og:query</TAGNAME>
<MSGCD/>
<MSGTXT>og:queryタグの設定文字数が多すぎます。QUERY文を見直してください。</MSGTXT>
<TEXT>
<og:query xmlns:og="hybs-taglib.tld" xmlns:jsp="http://java.sun.com/JSP/Page" command="{@command}" debug="{@debug}" dbid="{@DBID}">
	<jsp:text>
		select distinct
			df.TABLESPACE_NAME,
			df.FILE_NAME,
			round(df.USER_BYTES/(1024*1024))								"TOTAL(MB)",
			round(((df.USER_BYTES) - nvl(fs.FREE_EXTENTS,0))/(1024*1024),1)	"USED(MB)",
			round(nvl(fs.FREE_EXTENTS,0)/(1024*1024),1)						"FREE(MB)",
			round((nvl(fs.FREE_EXTENTS,0)/df.USER_BYTES)*100,1)				"FREE(%)",
			round(df.USER_BYTES/(1024*1024)*2)								NEW_MB,
			df.AUTOEXTENSIBLE												AUTO,
			case when round((nvl(fs.FREE_EXTENTS,0)/df.USER_BYTES)*100,1) &lt; 30 AND df.AUTOEXTENSIBLE = 'NO'
				then '1' ELSE '0' end FLAG
		from
			(select
				TABLESPACE_NAME,
				FILE_NAME,
				FILE_ID,
				AUTOEXTENSIBLE,
				sum(USER_BYTES) USER_BYTES
			from
				DBA_DATA_FILES
			group by TABLESPACE_NAME,FILE_NAME,FILE_ID,AUTOEXTENSIBLE
			) df,
			(select
				TABLESPACE_NAME,
				FILE_ID,
				sum(BYTES) FREE_EXTENTS
			from
				DBA_FREE_SPACE
			group by TABLESPACE_NAME,FILE_ID
			) fs
		where
			df.TABLESPACE_NAME = fs.TABLESPACE_NAME(+)
		and	df.FILE_ID         = fs.FILE_ID(+)
		and df.TABLESPACE_NAME like '{@OBJECT_NAME}%'
		order by TABLESPACE_NAME
	</jsp:text>
</og:query>
</TEXT>
</ROW>



















<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0113</ADDRESS>
<FILENAME>dbdefIn.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0113\dbdefIn.jsp</FILEPATH>
<MODIFIED>20070528094635</MODIFIED>
<TAGNAME>og:query</TAGNAME>
<MSGCD/>
<MSGTXT>og:queryタグの設定文字数が多すぎます。QUERY文を見直してください。</MSGTXT>
<TEXT>
<og:query xmlns:og="hybs-taglib.tld" xmlns:jsp="http://java.sun.com/JSP/Page" command="{@command}" debug="{@debug}" maxRowCount="100000">
	<jsp:text>
		select TABLE_NAME,TABLE_NAME || '_UQ' AS INDEX_NAME,'1' AS INDTYPE,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   UK = '1'
		union
		select TABLE_NAME,TABLE_NAME || '_SA' AS INDEX_NAME,'2' AS INDTYPE,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXA = '1'
		union
		select TABLE_NAME,TABLE_NAME || '_SB' AS INDEX_NAME,'2' AS INDTYPE,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXB = '1'
		union
		select TABLE_NAME,TABLE_NAME || '_SC' AS INDEX_NAME,'2' AS INDTYPE,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXC = '1'
		union
		select TABLE_NAME,TABLE_NAME || '_SD' AS INDEX_NAME,'2' AS INDTYPE,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXD = '1'
		union
		select TABLE_NAME,TABLE_NAME || '_SE' AS INDEX_NAME,'2' AS INDTYPE,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXE = '1'
		union
		select TABLE_NAME,TABLE_NAME || '_SF' AS INDEX_NAME,'2' AS INDTYPE,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXF = '1'
		union
		select TABLE_NAME,TABLE_NAME || '_SG' AS INDEX_NAME,'2' AS INDTYPE,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXG = '1'
		order by TABLE_NAME,INDTYPE,INDEX_NAME
  </jsp:text>
</og:query>
</TEXT>
</ROW>
<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0113</ADDRESS>
<FILENAME>dbdefIn.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0113\dbdefIn.jsp</FILEPATH>
<MODIFIED>20070528094635</MODIFIED>
<TAGNAME>og:query</TAGNAME>
<MSGCD/>
<MSGTXT>og:queryタグの設定文字数が多すぎます。QUERY文を見直してください。</MSGTXT>
<TEXT>
<og:query xmlns:og="hybs-taglib.tld" xmlns:jsp="http://java.sun.com/JSP/Page" command="{@command}" debug="{@debug}" maxRowCount="100000">
	<jsp:text>
		select TABLE_NAME,TABLE_NAME || '_UQ' AS INDEX_NAME,CLM,UK AS SEQNO,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   UK is not null
		union
		select TABLE_NAME,TABLE_NAME || '_SA' AS INDEX_NAME,CLM,IXA AS SEQNO,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXA is not null
		union
		select TABLE_NAME,TABLE_NAME || '_SB' AS INDEX_NAME,CLM,IXB AS SEQNO,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXB is not null
		union
		select TABLE_NAME,TABLE_NAME || '_SC' AS INDEX_NAME,CLM,IXC AS SEQNO,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXC is not null
		union
		select TABLE_NAME,TABLE_NAME || '_SD' AS INDEX_NAME,CLM,IXD AS SEQNO,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXD is not null
		union
		select TABLE_NAME,TABLE_NAME || '_SE' AS INDEX_NAME,CLM,IXE AS SEQNO,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXE is not null
		union
		select TABLE_NAME,TABLE_NAME || '_SF' AS INDEX_NAME,CLM,IXF AS SEQNO,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXF is not null
		union
		select TABLE_NAME,TABLE_NAME || '_SG' AS INDEX_NAME,CLM,IXG AS SEQNO,SYSTEM_ID
		from GF80
		where SYSTEM_ID  = '{@SYSTEM_ID}'
		and   TBLSYU = '3'
		and   FGJ in ('0','1')
		and   IXG is not null
		order by TABLE_NAME,INDEX_NAME,SEQNO
  </jsp:text>
</og:query>
</TEXT>
</ROW>














<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0112</ADDRESS>
<FILENAME>result.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0112\result.jsp</FILEPATH>
<MODIFIED>20070528102822</MODIFIED>
<TAGNAME>og:submit</TAGNAME>
<MSGCD/>
<MSGTXT>window_open の代わりに、og:popup タグの使用を検討してください。</MSGTXT>
<TEXT>
<og:submit xmlns:og="hybs-taglib.tld" xmlns:jsp="http://java.sun.com/JSP/Page" value="fileIn" command="VIEW" lbl="File In" accesskey="I" onClick="window_open( '{@SYS.JSP}/common/filePopup.jsp?callBack={@GUI.KEY}/fileIn.jsp',event,null,'width=200px,height=50px,resizable=no',false);"/>
</TEXT>
</ROW>
<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0112</ADDRESS>
<FILENAME>result.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0112\result.jsp</FILEPATH>
<MODIFIED>20070528102822</MODIFIED>
<TAGNAME>og:submit</TAGNAME>
<MSGCD/>
<MSGTXT>window_open の代わりに、og:popup タグの使用を検討してください。</MSGTXT>
<TEXT>
<og:submit xmlns:og="hybs-taglib.tld" xmlns:jsp="http://java.sun.com/JSP/Page" value="fileIn" command="VIEW" lbl="File In" accesskey="I" onClick="window_open( '{@SYS.JSP}/common/filePopup.jsp?callBack={@GUI.KEY}/fileIn.jsp',event,null,'width=200px,height=50px,resizable=no',false);"/>
</TEXT>
</ROW>






























































































<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0014</ADDRESS>
<FILENAME>query.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0014\query.jsp</FILEPATH>
<MODIFIED>20070521151321</MODIFIED>
<TAGNAME>img</TAGNAME>
<MSGCD/>
<MSGTXT>window_open の代わりに、og:popup タグの使用を検討してください。</MSGTXT>
<TEXT>
<img xmlns:jsp="http://java.sun.com/JSP/Page" xmlns:og="hybs-taglib.tld" src="{@SYS.JSP}/image/multiChoose.gif" onClick="window_open('multiChoose.jsp', event,'PARAM','width=500,height=200,resizable=no' );"/>
</TEXT>
</ROW>









<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0012</ADDRESS>
<FILENAME>result.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0012\result.jsp</FILEPATH>
<MODIFIED>20070417090225</MODIFIED>
<TAGNAME>og:equals</TAGNAME>
<MSGCD/>
<MSGTXT>og:equals を使いすぎです。ソースを見直してください。</MSGTXT>
<TEXT>
<og:equals xmlns:og="hybs-taglib.tld" xmlns:jsp="http://java.sun.com/JSP/Page" val1="{@msgKey}" val2="D">
<og:message msg="MSG0047"/>
</og:equals>
</TEXT>
</ROW>




<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0011</ADDRESS>
<FILENAME>result.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0011\result.jsp</FILEPATH>
<MODIFIED>20070417090226</MODIFIED>
<TAGNAME>og:equals</TAGNAME>
<MSGCD/>
<MSGTXT>og:equals を使いすぎです。ソースを見直してください。</MSGTXT>
<TEXT>
<og:equals xmlns:og="hybs-taglib.tld" xmlns:jsp="http://java.sun.com/JSP/Page" val1="{@msgKey}" val2="D">
<og:message msg="MSG0047"/>
</og:equals>
</TEXT>
</ROW>


<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0010</ADDRESS>
<FILENAME>entry.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0010\entry.jsp</FILEPATH>
<MODIFIED>20070417090226</MODIFIED>
<TAGNAME>og:update</TAGNAME>
<MSGCD/>
<MSGTXT>og:updateタグは廃止クラスです。</MSGTXT>
<TEXT>
<og:update xmlns:og="hybs-taglib.tld" xmlns:jsp="http://java.sun.com/JSP/Page" command="{@command}" queryType="JDBCPrepared" names="{@names}">
<jsp:text>{@SQL}</jsp:text>
</og:update>
</TEXT>
</ROW>





<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0010</ADDRESS>
<FILENAME>result.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0010\result.jsp</FILEPATH>
<MODIFIED>20070417090226</MODIFIED>
<TAGNAME>input</TAGNAME>
<MSGCD/>
<MSGTXT>input タグが、form の中にありません。これはエラーの可能性があります。</MSGTXT>
<TEXT>
<input xmlns:jsp="http://java.sun.com/JSP/Page" xmlns:og="hybs-taglib.tld" type="button" value="[FGPROG]" onClick="if(oneClick()) { location.href='deliver.jsp?SYSTEM_ID=[SYSTEM_ID]&amp;amp;RDC_CODE=[RDC_CODE]'; } return false;"/>
</TEXT>
</ROW>













































































<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0002</ADDRESS>
<FILENAME>query.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0002\query.jsp</FILEPATH>
<MODIFIED>20070521150617</MODIFIED>
<TAGNAME>img</TAGNAME>
<MSGCD/>
<MSGTXT>window_open の代わりに、og:popup タグの使用を検討してください。</MSGTXT>
<TEXT>
<img xmlns:jsp="http://java.sun.com/JSP/Page" xmlns:og="hybs-taglib.tld" style="cursor:pointer;" src="{@SYS.JSP}/image/multiChoose.gif" onClick="window_open('{@SYS.JSP}/custom/multiChoose.jsp?name=ROLE', event,'ROLES','width=500,height=200,resizable=no' );"/>
</TEXT>
</ROW>
<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0002</ADDRESS>
<FILENAME>result.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0002\result.jsp</FILEPATH>
<MODIFIED>20070521150624</MODIFIED>
<TAGNAME>og:columnEditor</TAGNAME>
<MSGCD/>
<MSGTXT>window_open の代わりに、og:popup タグの使用を検討してください。</MSGTXT>
<TEXT>
<og:columnEditor xmlns:og="hybs-taglib.tld" xmlns:jsp="http://java.sun.com/JSP/Page" column="ROLES" onClick="window_open('{@SYS.JSP}/custom/multiChoose.jsp?name=ROLE', event,'ROLES__[I]','width=500,height=200,resizable=no' );"/>
</TEXT>
</ROW>









<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0001</ADDRESS>
<FILENAME>query.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0001\query.jsp</FILEPATH>
<MODIFIED>20070521150555</MODIFIED>
<TAGNAME>img</TAGNAME>
<MSGCD/>
<MSGTXT>window_open の代わりに、og:popup タグの使用を検討してください。</MSGTXT>
<TEXT>
<img xmlns:jsp="http://java.sun.com/JSP/Page" xmlns:og="hybs-taglib.tld" src="{@SYS.JSP}/image/multiChoose.gif" onClick="window_open('{@SYS.JSP}/custom/multiChoose.jsp?name=ROLE', event,'ROLES','width=500,height=200,resizable=no' );"/>
</TEXT>
</ROW>
<ROW>
<SYSTEM_ID>GE</SYSTEM_ID>
<ADDRESS>GF0001</ADDRESS>
<FILENAME>result.jsp</FILENAME>
<FILEPATH>g:\webapps\ge\jsp\GF0001\result.jsp</FILEPATH>
<MODIFIED>20070521150605</MODIFIED>
<TAGNAME>og:columnEditor</TAGNAME>
<MSGCD/>
<MSGTXT>window_open の代わりに、og:popup タグの使用を検討してください。</MSGTXT>
<TEXT>
<og:columnEditor xmlns:og="hybs-taglib.tld" xmlns:jsp="http://java.sun.com/JSP/Page" column="ROLES" onClick="window_open('{@SYS.JSP}/custom/multiChoose.jsp?name=ROLE', event,'ROLES__[I]','width=500,height=200,resizable=no' );"/>
</TEXT>
</ROW>








</ROWSET>
