<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,KBCLM,UNIQ,'1' AS FGJ
	from  GF80
	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   ( UK  is not null OR
			LUK is not null OR
			IXA is not null OR
			IXB is not null OR
			IXC is not null OR
			IXD is not null OR
			IXE is not null OR
			IXF is not null OR
			IXG is not null OR
			IXH is not null OR
			IXI is not null OR
			IXJ is not null OR
			IXK is not null )
	and   FGJ       = '1'
	and   KBCLM in ( '0','2' )			-- 0:初期 , 2:一般 を対象にする
	order by SYSTEM_ID,TBLSYU,TABLE_NAME,SEQNO
</og:query>

<og:value key="lblKey" value="C" />

<og:hidden name="names" value=",," />
<!-- 1:重要 を設定する。 -->
<og:hidden name="SQL">
	UPDATE GF80 SET
			KBCLM		= '1',
			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>
