<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,NAME_JA,FGCOM,SEQNO,NOT_NULL,RENDERER,UNIQ,'1' AS FGJ
	from  GF05
	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 (	SEQNO < 50
		or	(CLS_NAME != 'NUMBER' and NOT_NULL is not null)
		or	RENDERER in ( 'MENU','DBMENU','CHBOX' )
		or	EDITOR   in ( 'MENU','DBMENU','CHBOX' )
		or	instr( NAME_JA , '名' ) > 0
	)
	and   FGJ       = '1'
--	and   FGCOM     = '0'				-- 0:初期 のみ対象
	and   FGCOM    != '1'
	and   FGCOM    != '2'				-- 1:UK 2:LUK 対象外
	order by SYSTEM_ID,TBLSYU,TABLE_NAME,SEQNO
</og:query>

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

<og:hidden name="names" value=",," />
<!-- 2:LUK を設定する。 -->
<og:hidden name="SQL">
	UPDATE GF05 SET
			FGCOM		= '2',
			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>
