<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:og="hybs-taglib.tld"
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />

<og:head headType="result" />
<jsp:directive.include file="/jsp/custom/result_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GF2150"
	title	= "XML出力"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<og:columnCheck
	command   = "{@command}"
/>

<og:value command="SET" key="BASE_DIR" value="{@SYS.REAL_PATH}{@SYS.FILE_URL}{@USER.ID}/dbdef/{@SYSTEM_ID}" />

<table border="1" frame="box" rules="all" >

  <og:equals val1="{@GF01}" val2="true" >
	<!-- GF01 作成 -->
	<tr><td><og:text>{@LBL.GF01}</og:text></td><td>(GF01 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select SYSTEM_ID,TBLSYU,TABLESPACE_NAME,NAME_JA,
						FILE_NAME,SIZE_AUTO,SIZE_DATA,STATUS,
						FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF01
				where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}')
				and   TBLSYU = '{@TBLSYU}'
				and   FGJ    = '1'
				order by TABLESPACE_NAME,NAME_JA,TBLSYU
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF01.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF01" />
			<og:writeTableParam key="First" >
				delete from GF01 where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}') and TBLSYU = '{@TBLSYU}'
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>

  <og:equals val1="{@GF02}" val2="true" >
	<!-- GF02 作成 -->
	<tr><td><og:text>{@LBL.GF02}</og:text></td><td>(GF02 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select SYSTEM_ID,TBLSYU,TABLE_NAME,NAME_JA,SKENSU,JKENSU,TABLESPACE_NAME,
						COMMENTS,INITIAL_EXTENT,KBTBL,SEQNO,
						FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF02
				where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}')
				and   TBLSYU = '{@TBLSYU}'
				and   FGJ       = '1'
				order by TABLE_NAME,NAME_JA,TBLSYU
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF02.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF02" />
			<og:writeTableParam key="First" >
				delete from GF02 where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}') and TBLSYU = '{@TBLSYU}'
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>

  <og:equals val1="{@GF03}" val2="true" >
	<!-- GF03 作成 -->
	<tr><td><og:text>{@LBL.GF03}</og:text></td><td>(GF03 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select SYSTEM_ID,CLM,NAME_JA,CLS_NAME,
						USE_LENGTH,DATA_DEFAULT,FGIMP,RENDERER,EDITOR,DBTYPE,
						RENDERER_PARAM,EDITOR_PARAM,TYPE_PARAM,BIKO,SEQNO,CDKH,
						FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF03
				where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}')
				and   FGJ       = '1'
				order by SYSTEM_ID,CLM,SEQNO
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF03.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF03" />
			<og:writeTableParam key="First" >
				delete from GF03 where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}')
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>

  <og:equals val1="{@GF05}" val2="true" >
	<!-- GF05 作成 -->
	<tr><td><og:text>{@LBL.GF05}</og:text></td><td>(GF05 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select SYSTEM_ID,TBLSYU,TABLE_NAME,CLM,SEQNO,NAME_JA,CLS_NAME,
						USE_LENGTH,DATA_DEFAULT,NOT_NULL,KBCLM,RENDERER,EDITOR,DBTYPE,BIKO,
						FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF05
				where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}')
				and   TBLSYU = '{@TBLSYU}'
				and   FGJ       = '1'
				order by TABLE_NAME,CLM,SEQNO,TBLSYU
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF05.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF05" />
			<og:writeTableParam key="First" >
				delete from GF05 where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}') and TBLSYU = '{@TBLSYU}'
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>

  <og:equals val1="{@GF06}" val2="true" >
	<!-- GF06 作成 -->
	<tr><td><og:text>{@LBL.GF06}</og:text></td><td>(GF06 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select SYSTEM_ID,TBLSYU,TABLE_NAME,INDEX_NAME,NAME_JA,INDTYPE,
						TABLESPACE_NAME,BIKO,INITIAL_EXTENT,
						FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF06
				where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}')
				and   TBLSYU = '{@TBLSYU}'
				and   FGJ       = '1'
				order by TABLE_NAME,INDEX_NAME,TBLSYU
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF06.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF06" />
			<og:writeTableParam key="First" >
				delete from GF06 where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}') and TBLSYU = '{@TBLSYU}'
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>

  <og:equals val1="{@GF07}" val2="true" >
	<!-- GF07 作成 -->
	<tr><td><og:text>{@LBL.GF07}</og:text></td><td>(GF07 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select SYSTEM_ID,TBLSYU,TABLE_NAME,INDEX_NAME,CLM,SEQNO,
						FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF07
				where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}')
				and   TBLSYU = '{@TBLSYU}'
				and   FGJ       = '1'
				order by TABLE_NAME,INDEX_NAME,CLM,SEQNO,TBLSYU
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF07.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF07" />
			<og:writeTableParam key="First" >
				delete from GF07 where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}') and TBLSYU = '{@TBLSYU}'
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>

  <og:equals val1="{@GF09}" val2="true" >
	<!-- GF09 作成 -->
	<tr><td><og:text>{@LBL.GF09}</og:text></td><td>(GF09 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select SYSTEM_ID,TBLSYU,SEQNAME,INCREBY,STARTVAL,
						MINVAL,MAXVAL,FGCYCLE,SUCACHE,LAST_NUMBER,TABLE_NAME,CLM,
						FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF09
				where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}')
				and   TBLSYU = '{@TBLSYU}'
				and   FGJ       = '1'
				order by SEQNAME
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF09.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF09" />
			<og:writeTableParam key="First" >
				delete from GF09 where SYSTEM_ID in ('{@SYSTEM_ID}','{@AST_GE}') and TBLSYU = '{@TBLSYU}'
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>

  <og:equals val1="{@GF80}" val2="true" >
	<!-- GF80 作成 -->
	<tr><td><og:text>{@LBL.GF80}</og:text></td><td>(GF80 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select SYSTEM_ID,TBLSYU,KBTBL,TABLE_NAME,NAME_JA,SEQNO,CLM_NAME,CLM,CLS_NAME,
						PHY_LENGTH,USE_LENGTH,UK,LUK,IXA,IXB,IXC,IXD,IXE,IXF,IXG,IXH,IXI,IXJ,IXK,NOT_NULL,
						RENDERER,EDITOR,DBTYPE,DATA_DEFAULT,KBCLM,BIKO,COMMENTS,
						FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF80
				where SYSTEM_ID = '{@SYSTEM_ID}'
				and   TBLSYU = '{@TBLSYU}'
				and   FGJ       = '1'
				order by SYSTEM_ID,TBLSYU,TABLE_NAME,SEQNO
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF80.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF80" />
			<og:writeTableParam key="First" >
				delete from GF80 where SYSTEM_ID = '{@SYSTEM_ID}' and TBLSYU = '{@TBLSYU}'
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>

  <og:equals val1="{@GF81}" val2="true" >
	<!-- GF81 作成 -->
	<tr><td><og:text>{@LBL.GF81}</og:text></td><td>(GF81 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select SYSTEM_ID,TBLSYU,OBJ_NAME,SEQNO,CLM,CLS_NAME,
						USE_LENGTH,TABLE_NAME,MAX_LENGTH,CLM_NAME,CDKH,
						FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF81
				where SYSTEM_ID = '{@SYSTEM_ID}'
				and   TBLSYU = '{@TBLSYU}'
				and   FGJ       = '1'
				order by SEQNO
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF81.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF81" />
			<og:writeTableParam key="First" >
				delete from GF81 where SYSTEM_ID = '{@SYSTEM_ID}' and TBLSYU = '{@TBLSYU}'
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>

  <og:equals val1="{@GF82}" val2="true" >
	<!-- GF82 作成 -->
	<tr><td><og:text>{@LBL.GF82}</og:text></td><td>(GF82 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select SYSTEM_ID,TBLSYU,OBJ_TYPE,OBJ_NAME,NAME_JA,STTS,REF_TABLES,
						FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF82
				where SYSTEM_ID = '{@SYSTEM_ID}'
				and   TBLSYU = '{@TBLSYU}'
				and   FGJ       = '1'
				order by OBJ_NAME,OBJ_TYPE
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF82.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF82" />
			<og:writeTableParam key="First" >
				delete from GF82 where SYSTEM_ID = '{@SYSTEM_ID}' and TBLSYU = '{@TBLSYU}'
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>

  <og:equals val1="{@GF83}" val2="true" >
	<!-- GF83 作成 -->
	<tr><td><og:text>{@LBL.GF83}</og:text></td><td>(GF83 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select SYSTEM_ID,TBLSYU,OBJ_TYPE,OBJ_NAME,NOLINE,FGNG,SRC_TEXT,
						FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF83
				where SYSTEM_ID = '{@SYSTEM_ID}'
				and   TBLSYU = '{@TBLSYU}'
				and   FGJ       = '1'
				order by SYSTEM_ID,TBLSYU,OBJ_TYPE,OBJ_NAME,NOLINE
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF83.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF83" />
			<og:writeTableParam key="First" >
				delete from GF83 where SYSTEM_ID = '{@SYSTEM_ID}' and TBLSYU = '{@TBLSYU}'
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>

  <og:equals val1="{@GF84}" val2="true" >
	<!-- GF84 作成 -->
	<tr><td><og:text>{@LBL.GF84}</og:text></td><td>(GF84 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select SYSTEM_ID,TABLE_NAME,NAME_JA,NOJUN,CDIKOU
						, F_TABLE_NAME,F_NAME_JA,SUIKOU,F_FILEPATH,DESCRIPTION,
						FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF84
				where SYSTEM_ID = '{@SYSTEM_ID}'
				and   FGJ       = '1'
				order by SYSTEM_ID,NOJUN,TABLE_NAME
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF84.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF84" />
			<og:writeTableParam key="First" >
				delete from GF84 where SYSTEM_ID = '{@SYSTEM_ID}'
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>

  <og:equals val1="{@GF85}" val2="true" >
	<!-- GF85 作成 -->
	<tr><td><og:text>{@LBL.GF85}</og:text></td><td>(GF85 XML File)</td>
	  <td>
		<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
				select 	SYSTEM_ID,TABLE_NAME,SEQNO,CLM,NAME_JA,
					CLS_NAME,USE_LENGTH,DATA_DEFAULT,NOT_NULL,KBCLM,BIKO,
					NOJUN,CONV_FUNC,
					F_CLM,F_NAME_JA,
					F_CLS_NAME,F_USE_LENGTH,F_BIKO,DESCRIPTION,
					FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
				from GF85
				where SYSTEM_ID = '{@SYSTEM_ID}'
				and   FGJ       = '1'
				order by SYSTEM_ID,NOJUN,TABLE_NAME,SEQNO
		</og:query>
	  </td>
	  <td width="70px" class="S9">
		<og:value command="GET" key="DB.COUNT" />
	  </td>
		<og:writeTable
			fileURL        = "{@BASE_DIR}"
			filename       = "GF85.xml"
			writerClass    = "XML"
			encode         = "UTF-8" >
			<og:writeTableParam key="TableName" value="GF85" />
			<og:writeTableParam key="First" >
				delete from GF85 where SYSTEM_ID = '{@SYSTEM_ID}'
			</og:writeTableParam>
		</og:writeTable>
	</tr>
  </og:equals>
</table>

<br />
<og:text>{@LBL.OUT_DIR} : <br/>{@LBL.SPACE}{@BASE_DIR}</og:text>

<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
