<og:query command="NEW" debug="{@debug}" notfoundMsg="">
		DELETE FROM GF07
		WHERE SYSTEM_ID = '{@SYSTEM_ID}'
		AND   TBLSYU    = '{@TBLSYU}'
	<og:where startKey="and">
		<og:and value = "TABLE_NAME like '{@TABLE_NAME}%'" />
	</og:where>
</og:query>

<jsp:directive.include file="/jsp/GF2040/sqlGF07.jsp" />

<og:tableUpdate
	command		= "ENTRY"
	queryType	= "JDBCTableUpdate"
	selectedAll = "true"
	displayMsg  = "MSG0040"
>
	INSERT INTO GF07
		(TABLE_NAME,INDEX_NAME,CLM,SEQNO,SYSTEM_ID,TBLSYU,
		 FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD)
	VALUES
		([TABLE_NAME],[INDEX_NAME],[CLM],[SEQNO],[SYSTEM_ID],[TBLSYU],
		 '1','{@USER.YMDH}','{@USER.YMDH}','{@USER.ID}','{@USER.ID}','{@GUI.KEY}')
</og:tableUpdate>

<!-- SYSTEM_ID,TBLSYU,TABLE_NAME,INDEX_NAME でユニークになるように、データをマージします。 -->
<og:tableMerge action="GROUP" masterKeys="SYSTEM_ID,TBLSYU,TABLE_NAME,INDEX_NAME" groupAddClms="CLM" />

<og:tableUpdate
	command		= "ENTRY"
	queryType	= "JDBCTableUpdate"
	selectedAll = "true"
>
	UPDATE GF06
	SET BIKO = [CLM]
	WHERE SYSTEM_ID  = '{@SYSTEM_ID}'
	AND   TBLSYU     = '{@TBLSYU}'
	AND   TABLE_NAME = [TABLE_NAME]
	AND   INDEX_NAME = [INDEX_NAME]
</og:tableUpdate>
