<?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	= "GF2140"
	title	= "DBスクリプト作成"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<og:columnCheck
	command   = "{@command}"
	nullCheck = "SYSTEM_ID,PGID"
/>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	<jsp:text>
		select
			GF92.SYSTEM_ID,
			GF92.PGID, 
			GF92.NMSYORI, 
			GF92.SEQ, 
			GF92.CLM, 
			GF92.KBACCS, 
			GF92.MUST, 
			GF92.DEFAULT_VAL, 
			GF92.TABLE_NAME, 
			GF92.ZOKUSEI, 
			GF92.SETU, 
			GF90.NMSYS, 
			GF90.NMPG, 
			GF90.HPGID,
			GF92.USE_ORDER,
			GF92.AS_CLM,
			GF92.JOINTYPE,
			GF91.AS_TABLE,
			GF92.CLS_NAME
		from GF92 , GF91, GF90
		where  GF92.SYSTEM_ID  = GF90.SYSTEM_ID
		and    GF92.PGID       = GF90.PGID
		and    GF92.SYSTEM_ID  = GF91.SYSTEM_ID
		and    GF92.PGID       = GF91.PGID
		and    GF92.TABLE_NAME = GF91.TABLE_NAME
		and    GF92.SYSTEM_ID  = '{@SYSTEM_ID}'
		and    GF92.PGID       = '{@PGID}'
	--	and    GF92.FGJ        = '1'
		order by  GF92.NMSYORI, GF92.SEQ
	</jsp:text>
</og:query>

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

<og:jspCreate
	outdir		= "{@SYS.REAL_PATH}jsp/"
	pgid		= "{@PGID}"
	hpgid		= "{@HPGID}"
	useUserDef	= "true"
/>


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