<jsp:directive.page pageEncoding="UTF-8" />
<!-- 読込ﾌﾗｸﾞ更新 -->
<!-- SYSTEM_ID = '**' は、0:個別読込 にします。-->

<og:text> {@LBL.GEA08} : {@LBL.SYSTEM_ID}='**' and {@LBL.FGLOAD}='1' </og:text>
<og:query command="NEW" debug="{@debug}" maxRowCount="0">
	UPDATE	GEA08 SET FGLOAD='0'
	WHERE	SYSTEM_ID = '**'
	AND		FGJ       = '1'
	AND		FGLOAD    = '1'
</og:query>

<og:text> {@LBL.GEA03} : SYSTEM_ID='**' and FGLOAD='1' </og:text>
<og:query command="NEW" debug="{@debug}" maxRowCount="0">
	UPDATE	GEA03 SET FGLOAD='0'
	WHERE	SYSTEM_ID = '**'
	AND		FGJ       = '1'
	AND		FGLOAD    = '1'
</og:query>

<!-- ﾗﾍﾞﾙﾘｿｰｽのﾗﾍﾞﾙ区分(KBLBL)が、2:ﾃｰﾌﾞﾙ と、5:ﾌﾟﾛｸﾞﾗﾑ または、日本語(ja)以外は、読込ﾌﾗｸﾞ(FGLOAD)を 0:個別読込 にします。-->
<og:text> {@LBL.GEA08} : ( {@LBL.KBLBL} in ( {@LBL.KBLBL.2},{@LBL.KBLBL.5} ) or {@LBL.LANG} != {@LBL.LANG.ja} ) and {@LBL.FGLOAD}='1' </og:text>
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	select	SYSTEM_ID,CLM,LANG,UNIQ
	from	GEA08
	where	SYSTEM_ID IN ( '{@SYSTEM_ID}','{@BASE}' )
	<og:where startKey="and">
		<og:and value = "GUIKEY like '{@CLM}'" />
	</og:where>
	and		FGJ		= '1'
	and		FGLOAD	= '1'
	and		( KBLBL in ( '2','5' ) or LANG != 'ja' )
	order by SYSTEM_ID,CLM,LANG
</og:query>

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

<!-- UNIQ のみでユニークだが、安全の為、SYSTEM_IDとCLMも条件に入れておく -->
<og:hidden name="SQL">
	UPDATE GEA08 SET
			FGLOAD	= '0',
			DYUPD	= '{@USER.YMDH}',
			USRUPD	= '{@USER.ID}',
			PGUPD	= '{@GUI.KEY}'
	WHERE UNIQ		= [UNIQ]
	AND   SYSTEM_ID	= [SYSTEM_ID]
	AND   CLM		= [CLM]
	AND   LANG		= [LANG]
</og:hidden>
