<jsp:directive.page pageEncoding="UTF-8" />
<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" sqlType="INSERT" selectedAll="true" queryType="JDBCTableUpdate" debug="{@debug}" displayMsg="MSG0040">
	<og:tableUpdateParam
		constObjKey = "GF"
		sqlType		= "INSERT"
		table		= "GF07"
	/>
</og:tableUpdate>

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

<og:tableUpdate command="ENTRY" sqlType="MODIFY" selectedAll="true" queryType="JDBCTableUpdate" debug="{@debug}" displayMsg="MSG0040">
	<og:tableUpdateParam
		constObjKey = "GF"
		sqlType		= "MODIFY"
		table		= "GF06"
		names		= "BIKO"
		asNames		= "CLM"
		orgNames	= "BIKO"
		where		= "SYSTEM_ID='{@SYSTEM_ID}' AND TBLSYU='{@TBLSYU}' AND TABLE_NAME=[TABLE_NAME] AND INDEX_NAME=[INDEX_NAME]"
	/>
</og:tableUpdate>
