<jsp:directive.page pageEncoding="UTF-8" />
<!-- 日本語ﾘｿｰｽの存在しない、外国語ﾘｿｰｽの削除 -->
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	select A.SYSTEM_ID,A.CLM,A.NAME_JA,A.LNAME,A.LANG,A.UNIQ
	from  GEA08 A
	where A.SYSTEM_ID IN ( '{@SYSTEM_ID}','{@BASE}','{@AST}' )
	and   A.LANG != 'ja'
	and  not exists ( select 1 from GEA08 B where B.SYSTEM_ID = A.SYSTEM_ID and A.CLM=B.CLM and B.LANG='ja' )
	order by A.SYSTEM_ID,A.CLM,A.UNIQ
</og:query>

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

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