<jsp:directive.page pageEncoding="UTF-8" />
<!-- 画面リソース⇒ラベルリソース差分追加 -->
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	select SYSTEM_ID,GUIKEY AS CLM,NAME_JA,NAME_JA AS SNAME, NAME_JA AS LNAME,KBSAKU
	from  GEA11
	where SYSTEM_ID = '{@SYSTEM_ID}'
	<og:where startKey="and">
		<og:and value = "GUIKEY like '{@CLM}'" />
	</og:where>
	and   KBSAKU   != '0'
	and   FGJ       = '1'
	and not exists (
			select * from GEA08
			where GEA08.SYSTEM_ID = '{@SYSTEM_ID}'
			and   GEA08.CLM       = GEA11.GUIKEY
			and   KBSAKU   != '0'
			and   FGJ       = '1'
		)
	order by SYSTEM_ID,GUIKEY
</og:query>

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

<og:hidden name="SQL" >
	INSERT INTO GEA08
		(CLM,NAME_JA,SNAME,LNAME,COMMENTS,KBSAKU,SYSTEM_ID,LANG,
		 FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD)
	VALUES
		([CLM],[NAME_JA],[SNAME],[LNAME],'',[KBSAKU],[SYSTEM_ID],'ja',
		 '1','{@USER.YMDH}','{@USER.YMDH}','{@USER.ID}','{@USER.ID}','{@GUI.KEY}')
</og:hidden>

<og:viewLink command="{@command}">
	<og:link column="CLM" gamenId="GE0005" href="index.jsp" target="CONTENTS"
		keys="command,SYSTEM_ID,CLM,KBSAKU,LANG"
		vals="NEW,[SYSTEM_ID],[CLM],[KBSAKU],ja" />
</og:viewLink>
