<?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}">
		select
			 A1.SYSTEM_ID
			,A1.PGID
			,A1.NMSYORI
			,A1.SEQ
			,A1.CLM
			,A1.CLM AS CLM_NAME
			,A1.KBACCS
			,A1.MUST
			,A1.DEFAULT_VAL
			,A1.TABLE_NAME
			,A1.ZOKUSEI
			,A1.SETU
			,C1.NMSYS
			,C1.NMPG
			,C1.HPGID
			,A1.USE_ORDER
			,A1.AS_CLM
			,B1.JOINTYPE
			,A1.AS_TABLE
			,A1.CLS_NAME
		from ( GF92 A1 inner join GF91 B1
				on     A1.SYSTEM_ID  = B1.SYSTEM_ID
				and    A1.PGID       = B1.PGID
				and    A1.TABLE_NAME = B1.TABLE_NAME ) inner join GF90 C1
						on     A1.SYSTEM_ID  = C1.SYSTEM_ID
						and    A1.PGID       = C1.PGID
		where A1.SYSTEM_ID  = '{@SYSTEM_ID}'
		and    A1.PGID       = '{@PGID}'
	--	and    A1.FGJ        = '1'
		order by  A1.NMSYORI, A1.SEQ
</og:query>

<!-- CLM_NAME をリソースから取得します。 -->
<og:tableFilter classId="LABEL" keys="SYSTEM_ID,CLM,LBL" vals="{@SYSTEM_ID},CLM,CLM_NAME" />

<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>
