<?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:仕様書DB"
	pgid	= "GF2200"
	title	= "画面項目定義テーブル登録"
	date	= "2009/07/08"
	author	= "K.Hasegawa"
	text	= ""
	version	= "001"
/>

<form method="GET" action="forward.jsp" target="RESULT" onClick="timeSet();">

<!-- 変更はここから -->
<table summary="layout" >
<tr>
	<!-- システムID -->
	<og:column name="SYSTEM_ID" defaultVal="{@SYS.SYSTEM_ID}" />
	<!-- プログラムID -->
	<og:select name="PGID">
		<og:option lbl="" value="" />
		<og:queryOption>
			<jsp:text>
				SELECT	PGID,PGID || ':' || NMPG
				FROM	GF90
				WHERE SYSTEM_ID='{@SYS.SYSTEM_ID}'
				AND   FGJ in ('0','1')
				ORDER BY SYSTEM_ID,SEQ
			</jsp:text>
		</og:queryOption>
	</og:select>
	<!-- 処理グループ名 -->
	<og:select name="NMSYORI">
		<og:option lbl="" value="" />
		<og:option lbl="QUERY"		value="QUERY"	 />
		<og:option lbl="RESULT"	value="RESULT"	 />
		<og:option lbl="JOIN"		value="JOIN"	 />
		<og:option lbl="CONST"		value="CONST"	 />
		<og:option lbl="GROUP_BY"	value="GROUP_BY" />
		<og:option lbl="HAVING"	value="HAVING"	 />
		<og:option lbl="ORDER"		value="ORDER"	 />
	</og:select>
	<!-- カラム名 -->
	<og:column name="CLM" />
</tr>
</table>

<og:queryButton>
	<!-- 表示順 -->
	<og:select name="ORDER_BY" lbl="ORDER_BY">
		<og:option value="SYSTEM_ID,PGID,NMSYORI,SEQ"		lbls="SYSTEM_ID,PGID" selected="selected" />
		<og:option value="SYSTEM_ID,CLM,PGID"				lbls="SYSTEM_ID,CLM"		/>
	</og:select>
</og:queryButton>

</form>

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