<jsp:directive.page pageEncoding="UTF-8" />
<og:query command="{@command}" debug="{@debug}" maxRowCount="0" stopZero="true">
	select	TABLE_NAME,CLM,NAME_JA,
			REPLACE(REPLACE(BIKO,'　',' '),'：',':') as BIKO,
			BIKO AS OLDBIKO,
			UNIQ,FGJ
	from GF05
	where SYSTEM_ID  = '{@SYSTEM_ID}'
	and   TBLSYU     = '{@TBLSYU}'
	<og:where startKey="and">
		<og:and value="TABLE_NAME like '{@TABLE_NAME}%'" />
		<og:and value="CLM        like '{@CLM}%'" />
	</og:where>
	and   ( instr( BIKO, '　' ) > 0 or instr( BIKO, '：' ) > 0 )
	and   FGCOM		<= '5'
	and   FGJ		= '1'
	order by TABLE_NAME,CLM,NAME_JA
</og:query>

<og:viewLink command="{@command}">
	<og:link column="CLM" href="result.jsp" target="RESULT"
		keys="command,ACTION,SYSTEM_ID,TBLSYU,TABLE_NAME,CLM"
		vals="NEW,GFM0045B,{@SYSTEM_ID},{@TBLSYU},[TABLE_NAME],[CLM]" />
</og:viewLink>

<og:hidden name="SQL" >
	UPDATE GF05 SET
			BIKO	 	= [BIKO],
			CDKH		= 'C',
			DYUPD		= '{@USER.YMDH}',
			USRUPD		= '{@USER.ID}',
			PGUPD		= '{@GUI.KEY}'
	WHERE SYSTEM_ID	= '{@SYSTEM_ID}'
	AND   TBLSYU	= '{@TBLSYU}'
	AND   UNIQ		= [UNIQ]
</og:hidden>

<og:hidden name="noWritable">TABLE_NAME,CLM,NAME_JA,OLDBIKO</og:hidden>