<jsp:directive.page pageEncoding="UTF-8" />
<!-- GFM0050 ﾘｿｰｽ不一致ｶﾗﾑ除外設定(KBCLM=6) -->

<!-- KBCLM 8:有閑 9:削除 は対象外 -->
<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
	select	UPPER(TABLE_NAME) AS TABLE_NAME,UPPER(CLM) AS CLM,NAME_JA,CLS_NAME,
			RENDERER,EDITOR,DBTYPE,
			VIEW_LENGTH,USE_LENGTH,UNIQ,SYSTEM_ID,KBSAKU
	from GE82
	where SYSTEM_ID = '{@SYSTEM_ID_D}'
	and   TBLSYU    = '{@TBLSYU}'
	<og:where startKey="and">
		<og:and value="TABLE_NAME like '{@TABLE_NAME}'"	/>
		<og:and value="CLM        like '{@CLM}'"			/>
		<og:and value="KBSAKU		=    '{@KBSAKU}'"	/>
		<og:and value="SUBSYS		like '{@SUBSYS}'"	/>
	</og:where>
	and   KBCLM		<= '7'
	and   FGJ       = '1'
	order by CLM,KBSAKU DESC
</og:query>

<og:query command="{@command}" debug="{@debug}" dbid="{@DBID_R}" maxRowCount="0" scope="request">
	select '' as TABLE_NAME,CLM,NAME_JA,CLS_NAME,RENDERER,EDITOR,DBTYPE,
			VIEW_LENGTH,USE_LENGTH,UNIQ,SYSTEM_ID,KBSAKU
	from GEA03
	where SYSTEM_ID in ( '{@SYSTEM_ID_R}','**' )
	<og:where startKey="and">
		<og:and value="CLM like '{@CLM}'" />
	</og:where>
	and   FGJ       = '1'
	ORDER BY SYSTEM_ID DESC, KBSAKU DESC, CLM
</og:query>

<!-- グループ処理では、先行優先 -->
<og:tableMerge
	action        = "MINUS"
	masterScope   = "session"
	masterKeys    = "CLM"
	slaveScope    = "request"
	display       = "true"
/>

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

<!-- KBCLM を、＜＝ '5' とすると、xxsCheck エラーになるため、in で対応 （暫定処置） -->
<!-- 6:除外(-) を設定します。 -->
<og:hidden name="SQL">
	UPDATE GF05 SET
		KBCLM		= '6',
		DYUPD		= '{@USER.YMDH}',
		USRUPD		= '{@USER.ID}',
		PGUPD		= '{@GUI.KEY}'
	WHERE	SYSTEM_ID	= '{@SYSTEM_ID_D}'
	AND		TBLSYU		= '{@TBLSYU}'
	<og:where startKey="and">
		<og:and value="TABLE_NAME like '{@TABLE_NAME}'"	/>
	</og:where>
	AND		CLM		= [CLM]
	AND		KBCLM	in ( '0','1','2','3','4','5' )
	AND		FGJ		= '1'
</og:hidden>
