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

<og:head headType="query" />
<jsp:directive.include file="/jsp/custom/query_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GF6280"
	title	= "直接ファイル出力"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<form method="GET" action="forward.jsp" target="RESULT" onClick="timeSet();">
<table border="0" frame="border" summary="form" >
<tr><td>
	<og:textarea name="SQL" rows="5" cols="40" must="true">
		{@USER.LASTSQL}
	</og:textarea>
</td>
<td><table>
<tr>
	<og:column name="DBID"      value="{@DBID}"  codeKeyVal="{@DBID_INFO}" />
	<og:column name="filename"  value="test.xls" lbl="MSG0022" size="10" />
</tr>
<tr>
	<og:column name="separator" value="&#009;"   lbl="MSG0023" size="10" />
	<og:select name="encode" lbl="MSG0025">
		<!-- MSG0029.OPT=DEFAULT,MS932,SJIS,JIS,EUC_JP -->
		<og:option value="UnicodeLittle" lbl="UnicodeLittle" selected="selected" />
		<og:option value="MS932"         lbl="MS932"         />
		<og:option value="Windows-31J"   lbl="Windows-31J"   />
		<og:option value="UTF-8"         lbl="UTF-8"         />
		<og:option value="ISO-8859-1"    lbl="ISO-8859-1"    />
		<og:option value="GB2312"        lbl="GB2312"        />
		<og:option value="GB18030"       lbl="GB18030"       />
		<og:option value="Shift_JIS"     lbl="Shift_JIS"     />
		<og:option value="SJIS"          lbl="SJIS"          />
		<og:option value="JIS"           lbl="JIS"           />
		<og:option value="EUC_JP"        lbl="EUC_JP"        />
	</og:select>
</tr>
</table></td>
</tr></table>

  <fieldset style="display:inline;">
	<legend>
		<input name="TYPE" value="DirectWriteTable" lbl="" type="radio" checked="checked"
			onClick="form.SQL.value=''; form.names.value='';  form.queryType.value='' " />
		<strong>DirectWriteTable</strong>
	</legend>
	<table>
	<tr>
		<og:select name="fileAppend" lbl="MSG0026">
			<og:option value="true"  lbl="MSG0030.TRUE"   />
			<og:option value="false" lbl="MSG0030.FALSE"  selected="selected" />
		</og:select>
		<og:select name="zip" lbl="MSG0052" >
			<og:option value="true"  lbl="TRUE"  />
			<og:option value="false" lbl="FALSE" selected="selected"  />
		</og:select>
		<og:column name="zipFilename"  value="test.zip" lbl="MSG0022" size="10" />
		<og:select name="useHeader" lbl="useHeader" >
			<og:option value="true"  lbl="TRUE"  selected="selected"  />
			<og:option value="false" lbl="FALSE" />
		</og:select>
		<og:column name="fetchSize" value=""  lbl="FetchSize" size="5" />
	</tr>
	</table>
  </fieldset>

  <fieldset style="display:inline;">
	<legend>
		<input name="TYPE" value="DirectWriteTable" lbl="" type="radio"
			onClick="form.SQL.value='{ call TYPESB01.TYPESB01( ?,?,?,? ) }';
					 form.names.value='SYSTEM_ID,LANG,CLM,NAME_JA,LABEL_NAME,KBSAKU';
					 form.queryType.value='JDBCErrMsg' " />
		<strong>DirectWriteTable PLSQL</strong>
	</legend>
	<table>
	<tr>
		<og:column name="names" value=""
				 lbl="names" size="50" maxlength="200"  />
		<og:column name="queryType" value="" lbl="queryType" />
	</tr>
	</table>
  </fieldset>

  <fieldset style="display:inline;">
	<legend>
		<input name="TYPE" value="DirectTableInsert" lbl="" type="radio" />
		<strong>DirectTableInsert</strong>
	</legend>
	<table>
	<tr>
		<og:column name="columns"     lbl="Columns" size="50" maxlength="200" colspan="5" />
		<og:column name="commitBatch" lbl="CommitBatch" />
		<og:column name="stopZero"	codeName="BOOLEAN" />
	</tr>
	</table>
  </fieldset>

<og:queryButton />
</form>

<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
