<jsp:directive.page pageEncoding="UTF-8" />
<og:query command="{@command}" debug="{@debug}" maxRowCount="0" stopZero="true" quotCheck="false" >
	select SYSTEM_ID,TBLSYU,TABLE_NAME,CLM,
			UK,LUK,IXA,IXB,IXC,IXD,IXE,IXF,IXG,IXH,IXI,IXJ,IXK,NOT_NULL,KBCLM,UNIQ,'1' AS FGJ
	from  GE82
	where SYSTEM_ID = '{@SYSTEM_ID}'
	and   TBLSYU    = '{@TBLSYU}'
	<og:where startKey="and">
		<og:and value="TABLE_NAME like '{@TABLE_NAME}'" />
		<og:and value="CLM        like '{@CLM}'" />
	</og:where>
	and   FGJ       = '1'
	order by SYSTEM_ID,TBLSYU,TABLE_NAME,SEQNO
</og:query>

<!-- ｶﾗﾑ区分(KBCLM)を設定する テーブルフィルターです。 -->
<og:tableFilter classId="KBCLM" keys="COM_CLMS" vals="{@COM_CLMS}" />

<og:equals val1="{@DB.COUNT}" val2="0" useStop="true" >
	<og:message lbl="MSG0077" />
</og:equals>

<og:value key="lblKey"    value="C" />
<og:value key="noDisplay" value="UK,LUK,IXA,IXB,IXC,IXD,IXE,IXF,IXG,IXH,IXI,IXJ,IXK,NOT_NULL" />

<og:hidden name="names" value=",," />

<!-- 1:UK 2:LUK 4:NN を設定する。 -->
<og:hidden name="SQL">
	UPDATE GE82 SET
			KBCLM		= [KBCLM],
			COMMENTS	= '{@DATE.YMDF} {@LBL.@ACTION}',
			CDKH		= 'C',
			FGJ			= '1',
			DYUPD		= '{@USER.YMDH}',
			USRUPD		= '{@USER.ID}',
			PGUPD		= '{@GUI.KEY}'
	WHERE SYSTEM_ID	= '{@SYSTEM_ID}'
	AND   TBLSYU	= '{@TBLSYU}'
	AND   UNIQ		= [UNIQ]
</og:hidden>
