<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:og="hybs-taglib.tld"
	xmlns:c="http://java.sun.com/jsp/jstl/core"
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />

<og:head headType="init" />

<!-- history.back() で戻るボタンを表示します。	-->
<jsp:directive.include file="/jsp/common/history_back.jsp" />

<og:columnCheck command="{@command}" />
<og:entry command="{@command}" />

<og:bizLogic logics="an.AN0004A" keys="CDANK" vals="{@MEM.CDANK}" />

<og:query command="NEW" scope="request">
	<jsp:text>
		select B.SEQNO,B.UNIQ,A.CDSITSU from AN02 A inner join AN03 B
		on A.CDANK = B.CDANK
		and A.CDSITSU = B.CDSITSU
		where A.CDANK = '{@MEM.CDANK}'
		and A.FGJ = '1'
		and B.FGJ = '1'
		order by A.SEQNO,B.SEQNO
	</jsp:text>
</og:query>
<og:tableFilter classId="SEQRESET" keys="SEQ_CLM,CLEAR_CLM" vals="SEQNO,CDSITSU" selectedAll="true" scope="request" />
<og:tableUpdate
	command		= "{@command}"
	selectedAll = "true"
	scope		= "request"
	queryType	= "JDBCTableUpdate">
	<jsp:text>
		update AN03 SET
			SEQNO  = [SEQNO]
		where UNIQ = [UNIQ]
		and SEQNO != [SEQNO]
	</jsp:text>
</og:tableUpdate>

<og:forward page="result.jsp" keys="command" vals="RENEW" />
<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
