<jsp:directive.page pageEncoding="UTF-8" />
<!-- カラムリソース⇒ラベルリソース名称更新 -->
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	select B.SYSTEM_ID,B.CLM,B.NAME_JA AS "BEFORE",'{@ARROW}',A.NAME_JA AS "AFTER"
	from GEA03 A inner join GEA08 B
	on    A.CLM        = B.CLM
	and   A.NAME_JA  !=  B.NAME_JA
	where A.SYSTEM_ID = '{@SYSTEM_ID}'
	and   B.SYSTEM_ID = '{@SYSTEM_ID}'
	<og:where startKey="and">
		<og:and value = "A.CLM like '{@CLM}'" />
	</og:where>
--	and   B.LANG      = 'ja'
	and   A.KBSAKU   != '0'
	and   B.KBSAKU   != '0'
	and   A.FGJ       = '1'
	and   B.FGJ       = '1'
	order by A.SYSTEM_ID,A.CLM
</og:query>

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

<og:hidden name="names" value="," />
<og:hidden name="SQL">
	UPDATE GEA08 SET
			NAME_JA   = [AFTER],
			DYUPD     = '{@USER.YMDH}',
			USRUPD    = '{@USER.ID}',
			PGUPD    = '{@GUI.KEY}'
	WHERE SYSTEM_ID = [SYSTEM_ID]
	AND   CLM       = [CLM]
</og:hidden>
