<?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:query displayMsg="" notfoundMsg="" dbid="{@SYS.DEV_DBID}">
	select case NMSYORI when 'RESULT' then 0 else 1 end ORDER_BY
			,'{group:"'{@DBF.CON}NMSYORI{@DBF.CON}'",tableId:"'{@DBF.CON}TABLE_NAME{@DBF.CON}'",asTable:"'{@DBF.CON}AS_TABLE{@DBF.CON}'"'
			{@DBF.CON}',column:"'{@DBF.CON}CLM{@DBF.CON}'",seq:"'{@DBF.CON}SEQ{@DBF.CON}'"'
			{@DBF.CON}',USE_ORDER:"'{@DBF.CON}coalesce(USE_ORDER,''){@DBF.CON}'",AS_CLM:"'{@DBF.CON}coalesce(AS_CLM,''){@DBF.CON}'"'
			{@DBF.CON}',MUST:"'{@DBF.CON}coalesce(MUST,''){@DBF.CON}'",DEFAULT_VAL:"'{@DBF.CON}coalesce(DEFAULT_VAL,''){@DBF.CON}'"'
			{@DBF.CON}',ZOKUSEI:"'{@DBF.CON}coalesce(ZOKUSEI,''){@DBF.CON}'"}' VAL,SEQ
	from GF92
	where SYSTEM_ID = '{@systemId}'
	and PGID = '{@pgId}'
	and NMSYORI in ('RESULT','QUERY','CONST')
	order by SEQ,ORDER_BY
</og:query>

<og:value command="SETTBL" key="VAL" action="ALL_APPEND" />

<og:text>[{@VAL}]</og:text>

</jsp:root>
