<jsp:directive.page pageEncoding="UTF-8" />
<!-- GE ⇔ ** 相互変換 -->
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	select B.SYSTEM_ID,B.CLM,B.NAME_JA,B.LANG, B.SYSTEM_ID AS BEFORE,'{@ARROW}','**' AS AFTER1,'0' AS AFTER2
	from	GEA08 B
	where	B.SYSTEM_ID='GE' and B.FGJ='1'
	and		B.CLM in (select A.CLM from GEA03 A where A.SYSTEM_ID='**' and A.FGJ='1' )
	union all
	select B.SYSTEM_ID,B.CLM,B.NAME_JA,B.LANG, B.SYSTEM_ID AS BEFORE,'{@ARROW}','**' AS AFTER1,'0' AS AFTER2
	from	GEA08 B
	where	B.SYSTEM_ID='GE' and B.FGJ='1'
	and		B.CLM in (select A.CLM || '.' || CODE from GEA04 A where A.SYSTEM_ID='**' and A.FGJ='1' )
	union all
	select B.SYSTEM_ID,B.CLM,B.NAME_JA,B.LANG, B.SYSTEM_ID AS BEFORE,'{@ARROW}','GE' AS AFTER1,'1' AS AFTER2
	from	GEA08 B
	where	B.SYSTEM_ID='**' and B.FGJ='1'
	and		B.CLM like 'GE%'
	union all
	select B.SYSTEM_ID,B.CLM,B.NAME_JA,B.LANG, B.SYSTEM_ID AS BEFORE,'{@ARROW}','**' AS AFTER1,'0' AS AFTER2
	from	GEA08 B
	where	B.SYSTEM_ID='GE' and B.FGJ='1'
	and		( B.CLM like 'MSG%' or B.CLM like 'ERR%' )
	order by SYSTEM_ID,CLM
</og:query>

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

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