<jsp:directive.page pageEncoding="UTF-8" />
<!-- カラムリソース重複チェック -->
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	select
		CASE WHEN A.UNIQ < B.UNIQ THEN '0' ELSE '1' END AS WRITABLE ,
		B.SYSTEM_ID,B.CLM,
		CASE WHEN COALESCE(A.NAME_JA   ,'x') != COALESCE(B.NAME_JA   ,'x') THEN B.NAME_JA    ELSE '' END AS NAME_JA ,
		CASE WHEN COALESCE(A.CLS_NAME  ,'x') != COALESCE(B.CLS_NAME  ,'x') THEN B.CLS_NAME   ELSE '' END AS CLS_NAME ,
		CASE WHEN COALESCE(A.USE_LENGTH,'x') != COALESCE(B.USE_LENGTH,'x') THEN B.USE_LENGTH ELSE '' END AS USE_LENGTH ,
		CASE WHEN COALESCE(A.RENDERER  ,'x') != COALESCE(B.RENDERER  ,'x') THEN B.RENDERER   ELSE '' END AS RENDERER ,
		CASE WHEN COALESCE(A.EDITOR    ,'x') != COALESCE(B.EDITOR    ,'x') THEN B.EDITOR     ELSE '' END AS EDITOR ,
		CASE WHEN COALESCE(A.DBTYPE    ,'x') != COALESCE(B.DBTYPE    ,'x') THEN B.DBTYPE     ELSE '' END AS DBTYPE ,
		CASE WHEN COALESCE(A.KBSAKU    ,'x') != COALESCE(B.KBSAKU    ,'x') THEN B.KBSAKU     ELSE '' END AS KBSAKU ,
		B.KBSAKU , B.UNIQ
	from  GEA03 A inner join GEA03 B
			on    A.SYSTEM_ID = B.SYSTEM_ID
			and   A.CLM       = B.CLM
			and   A.UNIQ     != B.UNIQ
	where A.SYSTEM_ID IN ( '{@SYSTEM_ID}','{@BASE}','{@AST}' )
	<og:where startKey="and">
		<og:and value = "A.CLM like '{@CLM}'" />
	</og:where>
--	and   A.KBSAKU   != '0'
--	and   B.KBSAKU   != '0'
	and   A.FGJ       = '1'
	and   B.FGJ       = '1'
	order by B.SYSTEM_ID,B.CLM,B.UNIQ
</og:query>

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

<og:hidden name="SQL">
	DELETE FROM GEA03
	WHERE UNIQ      = [UNIQ]
	AND   SYSTEM_ID = [SYSTEM_ID]
	AND   CLM       = [CLM]
</og:hidden>

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