<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 = '{@SYSTEM_ID}'
	<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>
