<jsp:directive.page pageEncoding="UTF-8" />
[<og:text>{@writable}</og:text>]<br />

<og:query command = "{@command}">
		select A.TABLE_NAME,A.INDEX_NAME,A.CLM,A.SEQNO,
			B.NAME_JA,B.DBTYPE,A.FGJ,A.SYSTEM_ID,A.TBLSYU,A.UNIQ
		from GF07 A left outer join GF05 B
		on		A.SYSTEM_ID    = B.SYSTEM_ID
		and		A.TBLSYU       = B.TBLSYU
		and		A.TABLE_NAME   = B.TABLE_NAME
		and		A.CLM          = B.CLM
		and		A.FGJ          = B.FGJ
	<og:where>
		<og:and value = "A.FGJ          in   ('0','1')"           />
		<og:and value = "A.SYSTEM_ID    =  '{@SYSTEM_ID}'"     />
		<og:and value = "A.TBLSYU       =    '{@TBLSYU}'"         />
		<og:and value = "A.TABLE_NAME   like '{@TABLE_NAME}%'"    />
		<og:and value = "A.CLM          like '{@CLM}%'"   />
		<og:and value = "A.INDEX_NAME   in  ( {@INDEX_NAME} )" multi="true" />
	</og:where>
	<og:appear startKey = "order by" value = "{@ORDER_BY}" 
				defaultVal = "A.SYSTEM_ID,A.TBLSYU,A.TABLE_NAME,A.INDEX_NAME,A.SEQNO" />
</og:query>

<form onSubmit="return oneClick();" method="POST" action="forward.jsp" target="RESULT">
<og:writeCheck writable="{@writable}">
	<og:submit  value="copy"     lbl="COPY"    accesskey="C" />
	<og:submit  value="modify"   lbl="MODIFY"  accesskey="M" />
	<og:submit  value="delete"   lbl="DELETE"  accesskey="Z" />
	<br />
</og:writeCheck>

<og:view
	viewFormType = "HTMLTable" 
	command    = "{@command}" 
	noDisplay  = "UNIQ"
	checked    = "{@checked}"
	startNo    = "{@startNo}" 
	pageSize      = "{@pageSize}"
	useScrollBar  = "false"
	writable      = "{@writable}"
/>
</form>
