<jsp:directive.page pageEncoding="UTF-8" />
<!-- ラベルリソース名称⇒表示名称セット -->
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	select B.SYSTEM_ID,B.CLM,B.LANG,
			B.NAME_JA AS "BEFORE",'{@ARROW}',A.NAME_JA AS "AFTER"
	from  GEA08 A inner join GEA08 B
		on	A.CLM		= B.CLM
		and	A.LANG		= B.LANG
--		and	(  A.NAME_JA != B.NAME_JA OR B.NAME_JA is null )
		and	A.NAME_JA != B.NAME_JA
	where A.SYSTEM_ID IN ( '{@SYSTEM_ID}','{@BASE}','{@AST}' )
	and   B.SYSTEM_ID IN ( '{@SYSTEM_ID}','{@BASE}','{@AST}' )
	<og:where startKey="and">
		<og:and value = "A.CLM like '{@CLM}'" />
		<og:and value = "A.NAME_JA {@ISNN}" />
	</og:where>
	and		A.LANG	= 'ja'
	and		A.FGJ	= '1'
	and		B.FGJ	= '1'
	order by SYSTEM_ID,CLM,LANG
</og:query>

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

<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		LANG	= 'ja'
	AND		CLM		= [CLM]
</og:hidden>
