<?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="query" />
<jsp:directive.include file="/jsp/custom/query_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GF6060"
	title	= "テーブル回転表示"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>
<form method="GET" action="forward.jsp" target="RESULT" onSubmit="timeSet();">
<table >
<tr>
	<og:column name="SYSTEM_ID" defaultVal="{@LAST.SYSTEM_ID}" />
	<og:column name="TBLSYU" defaultVal="D" addNoValue="true" />
	<og:orderBy columns="SYSTEM_ID,TABLESPACE_NAME,TBLSYU" lbls="TABLESPACE_NAME" checkedValue="{@ORDER_BY}" checked = "checked" />
</tr>
<tr>
	<og:column name="TABLESPACE_NAME"  aimai="V*" />
	<og:column name="NAME_JA" aimai="V*" />
	<og:orderBy columns="SYSTEM_ID,NAME_JA,TBLSYU" lbls="NAME_JA" checkedValue="{@ORDER_BY}" />
</tr>
<tr>
	<og:value command="SQL" action="ROW_APPEND">
		select TABLESPACE_NAME from GF01 where FGJ in ('0','1')
	</og:value>
	<og:column name="XXX" value="{@TABLESPACE_NAME}" maxlength="200" colspan="5" />
</tr>
</table>

<og:queryButton />
</form>

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