You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by tm...@apache.org on 2008/01/05 09:25:38 UTC
svn commit: r609101 [17/26] - in /db/derby/docs/trunk: ./ src/ja_JP/
src/ja_JP/ref/
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsistabssystableperms.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsistabssystableperms.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsistabssystableperms.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsistabssystableperms.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,142 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License,p Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+<reference id="rrefsistabssystableperms" xml:lang="ja">
+<title>SYSTABLEPERMS ã·ã¹ãã 表</title>
+<shortdesc>
+SYSTABLEPERMS表ã«ã¯æ¨©éãä»ä¸ããã¦ãããã¼ãã«ã®æ
å ±ãè¨é²ããã¾ãã</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>system tables<indexterm>SYSTABLEPERMS</indexterm></indexterm>
+<indexterm>permissions<indexterm>SYSTABLEPERMS system table</indexterm></indexterm>
+<indexterm>SYSTABLEPERMS system table</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section><p>å
¨ã¦ã®æ¨©éã«ã¤ãã¦ãGRANTEE, TABLEID, GRANTORã®çµã¿åãããã¨ã«ãSYSTABLEPERMS表ã«è¡ãä¸è¡ããã¾ããSYSTABLEPERMS表ã®ãã¼ã¯ä»¥ä¸ã®ã¨ããã§ãã<ul>
+<li>主ãã¼ (GRANTEE, TABLEID, GRANTOR)</li>
+<li>ä¸æãã¼ (TABLEPERMSID)</li>
+<li>å¤é¨ãã¼ (TABLEID references SYS.SYSTABLES)</li>
+</ul> </p><p>次ã«SYSTABLEPERMS表ã«ããååã®æ
å ±ãè¨ãã¾ãã</p><table frame="all" pgwide="1">
+<tgroup cols="5" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="27*"/>
+<colspec colname="2" colnum="2" colwidth="10*"/><colspec colname="3" colnum="3"
+colwidth="11*"/><colspec colname="4" colnum="4" colwidth="14*"/><colspec colname="5"
+colnum="5" colwidth="38*"/>
+<thead>
+<row>
+<entry align="left" colname="1" valign="bottom">åå</entry>
+<entry align="left" colname="2" valign="bottom">å</entry>
+<entry align="left" colname="3" valign="bottom">é·ã</entry>
+<entry align="left" colname="4" valign="bottom">Nullå¯</entry>
+<entry align="left" colname="5" valign="bottom">å
容</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="1">TABLEPERMSID</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">36</entry>
+<entry colname="4">ä¸å¯</entry>
+<entry colname="5">ä¾åé¢ä¿ç®¡çæ©è½ã«ããã¦ããã¥ã¼ãããªã¬ãå¶ç´ã®ããã¼ãã«åä½ã®æ¨©éã¸ã®ä¾åãå¦çããããã«ä½¿ãã¾ãã</entry>
+</row>
+<row>
+<entry colname="1">GRANTEE</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">30</entry>
+<entry colname="4">ä¸å¯</entry>
+<entry colname="5">権éãä¸ããããã¦ã¼ã¶ã®èªè¨¼èå¥åã§ãã</entry>
+</row>
+<row>
+<entry colname="1">GRANTOR</entry>
+<entry colname="2">VARCHAR</entry>
+<entry colname="3">30</entry>
+<entry colname="4">ä¸å¯</entry>
+<entry colname="5">権éãä¸ããã¦ã¼ã¶ã®èªè¨¼èå¥åã§ãããã¼ã¿ãã¼ã¹ä¸ã®æ
å ±ã®ææè
ã ãã権éãä¸ãããã¨ãã§ãã¾ãã</entry>
+</row>
+<row>
+<entry colname="1">TABLEID</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">36</entry>
+<entry colname="4">ä¸å¯</entry>
+<entry colname="5">権éãä¸ãããããã¼ãã«ã®ä¸æãªèå¥åã§ãã</entry>
+</row>
+<row>
+<entry colname="1">SELECTPRIV</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">ä¸å¯</entry>
+<entry colname="5">SELECT権éãä¸ãããã¦ããããããããã¾ããæå¹ãªå¤ã¯ã'y'(ä»ä¸ããããã®ã§ã¯ãªã権éãæã¤)
+'Y'(ä»ä¸ããã権éãæã¤)
+'N'(権éãæããªã)ã§ãã</entry>
+</row>
+<row>
+<entry colname="1">DELETEPRIV</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">ä¸å¯</entry>
+<entry colname="5">DELETE権éãä¸ãããã¦ããããããããã¾ãã
+æå¹ãªå¤ã¯ã'y'(ä»ä¸ããããã®ã§ã¯ãªã権éãæã¤)
+'Y'(ä»ä¸ããã権éãæã¤)
+'N'(権éãæããªã)ã§ãã</entry>
+</row>
+<row>
+<entry colname="1">INSERTPRIV</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">ä¸å¯</entry>
+<entry colname="5">INSERT権éãä¸ãããã¦ããããããããã¾ãã
+æå¹ãªå¤ã¯ã'y'(ä»ä¸ããããã®ã§ã¯ãªã権éãæã¤)
+'Y'(ä»ä¸ããã権éãæã¤)
+'N'(権éãæããªã)ã§ãã</entry>
+</row>
+<row>
+<entry colname="1">UPDATEPRIV</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">ä¸å¯</entry>
+<entry colname="5">UPDATE権éãä¸ãããã¦ããããããããã¾ãã
+æå¹ãªå¤ã¯ã'y'(ä»ä¸ããããã®ã§ã¯ãªã権éãæã¤)
+'Y'(ä»ä¸ããã権éãæã¤)
+'N'(権éãæããªã)ã§ãã</entry>
+</row>
+<row>
+<entry colname="1">REFERENCEPRIV</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">ä¸å¯</entry>
+<entry colname="5">REFERENCE権éãä¸ãããã¦ããããããããã¾ãã
+æå¹ãªå¤ã¯ã'y'(ä»ä¸ããããã®ã§ã¯ãªã権éãæã¤)
+'Y'(ä»ä¸ããã権éãæã¤)
+'N'(権éãæããªã)ã§ãã</entry>
+</row>
+<row>
+<entry colname="1">TRIGGERPRIV</entry>
+<entry colname="2">CHAR</entry>
+<entry colname="3">1</entry>
+<entry colname="4">ä¸å¯</entry>
+<entry colname="5">TRIGGER権éãä¸ãããã¦ããããããããã¾ããæå¹ãªå¤ã¯ã'y'(ä»ä¸ããããã®ã§ã¯ãªã権éãæã¤)
+'Y'(ä»ä¸ããã権éãæã¤)
+'N'(権éãæããªã)ã§ãã</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsistabssystableperms.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefso2.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefso2.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefso2.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefso2.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefso2" xml:lang="ja">
+<title>ResultSet ãªãã¸ã§ã¯ã</title>
+<prolog><metadata>
+<keywords><indexterm>ResultSets<indexterm>errors in statement affecting creation
+of</indexterm></indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section><p>å
ç«ã£ã¦SELECTæãå®è¡ãããæã«ä¾å¤ãçºçããã¨ã<i>ResultSet</i>ãéããã¨ãã§ãã¾ããã<i>ResultSet</i>ãéããå¾ã§ããã°ãåæ§ã®ã¨ã©ã¼ãçºçãã¦ãã<i>ResultSet</i>ãéãããããã¨ã¯ããã¾ããã</p></section>
+<section><p>ä¾ãã°ã<i>java.sql.Statement</i>ã<i>java.sql.PreparedStatement</i>ã®<i>executeQuery</i>ã¡ã½ããã«ã¦ãé¶é¤ç®ã¨ã©ã¼ãçºçããå ´åãä¾å¤ãæãã£ã¦çµæã»ããã¯è¿ãã¾ãããä¸æ¹ã§åæ§ã®ã¨ã©ã¼ã<i>ResultSet</i>ãªãã¸ã§ã¯ãã®<i>next</i>ã¡ã½ããã§çºçãã¦ãçµæã»ãããéãã¦ãã¾ããã¨ã¯ããã¾ããã</p></section>
+<section><p>æåã®è¡ãåãåºãããåã«ã·ã¹ãã ãé¨åçã«ååããå®è¡ããå ´åã<i>ResultSet</i>ãä½æãããã¨ãã«ã¨ã©ã¼ãçºçãããã¨ãããã¾ãã
+ãã®ã¨ã©ã¼ã¯ä¸ã¤ä»¥ä¸ã®è¡¨ã使ãååãããéç´ãGROUP BYãORDER BYãDISTINCTãINTERSECTãEXCEPTãUNIONã使ãååãã«ã¦çºçãããã¨ãããã¾ãã</p></section>
+<section><p><i>Statement</i>ãéããã¨ããã®æã§éããå
¨ã¦ã®<i>ResultSet</i>ãªãã¸ã§ã¯ããéãã¾ãã</p></section>
+<section><p><i>ResultSet</i>ã®ã«ã¼ã½ã«ã«ã¯ãæãå®è¡ãããåã«ã«ã¼ã½ã«åãä¸ãããã¨ãã§ãã¾ãããã ãä¸æ¦å®è¡ãããå¾ã§ã¯ãã«ã¼ã½ã«ã®ååãå¤æ´ãããã¨ã¯ã§ãã¾ããã</p></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefso2.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsql9241891.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsql9241891.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsql9241891.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsql9241891.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,1161 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<reference id="rrefsql9241891" xml:lang="ja">
+<title>Derbyã®ãµãã¼ãããSQL-92ã®æ©è½</title>
+<prolog><metadata>
+<keywords><indexterm>SQL-92<indexterm>features supported by Derby</indexterm><indexterm>features
+not supported by Derby</indexterm></indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section><p> SQL-92ã®ãµãã¼ãã«ã¯4ã¤ã®ã¬ãã«ãããã¾ãã <ul>
+<li>SQL92E <p>åæ©ç</p></li>
+<li>SQL92T <p>é渡çãFIPS 127-2ã¨ããçºè¡ç©ã«ã¦NISTãå®ç¾©</p></li>
+<li>SQL92I <p>ä¸ç´</p></li>
+<li>SQL92F <p>å®å
¨</p></li>
+</ul> </p></section>
+<section><title>åºæ¬ãã¼ã¿å</title>
+<p>次ã®è¡¨ã§ã¯Derbyã«ã¦å©ç¨å¯è½ãªSQL-92ã®åºæ¬ãã¼ã¿åã示ãã¾ãã
+<table pgwide="0"><title>å©ç¨å¯è½ãªSQL-92ã®æ©è½: åºæ¬ãã¼ã¿å</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">SMALLINT</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">INTEGER</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">DECIMAL(p,s)</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">NUMERIC(p,s)</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">REAL</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">FLOAT(p)</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">DOUBLE PRECISION</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">CHAR(n)</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+</p></section>
+<section><title>åºæ¬ç®è¡æ¼ç®</title>
+<table><title>SQL-92ã®æ©è½ã®ãµãã¼ã:åºæ¬çãªç®è¡æ¼ç®</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">+, *, -, /, unary +, unary -</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>åºæ¬çãªæ¯è¼</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã:åºæ¬çãªæ¯è¼</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1"><, >, <= ,>=, <>, =</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>åºæ¬çãªè¿°èª</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã:åºæ¬çãªè¿°èª</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">BETWEEN, LIKE, NULL</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>å®éçãªè¿°èª</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã:å®éçãªè¿°èª</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">IN, ALL/SOME, EXISTS</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>ã¹ãã¼ãã®å®ç¾©</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã:ã¹ãã¼ãã®å®ç¾©</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">表</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">ãã¥ã¼</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">権é</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>åã®å±æ§</title><table><title>SQL-92ã®æ©è½ã®ãµãã¼ã:åã®å±æ§</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">æ¢å®å¤</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">空å¤ãã¨ãããã®å®ç¾©</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>å¶ç´(延æã§ããªã)</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: å¶ç´(延æã§ããªã)</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">NOT NULL</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes (SYSCONSTRAINTSã«ã¯è¨é²ãããªã)</entry>
+</row>
+<row>
+<entry colname="col1">UNIQUE/PRIMARY KEY</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">FOREIGN KEY</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">CHECK</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">View WITH CHECK OPTION</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">No ãã¥ã¼ã®æ´æ°ã¯ã§ããªã</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>ã«ã¼ã½ã«</title><table><title>SQL-92ã®æ©è½ã®ãµãã¼ã:ã«ã¼ã½ã«</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">DECLARE, OPEN, FETCH, CLOSE</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes JDBCã®ã¡ã½ããå¼ã³åºãã該å½</entry>
+</row>
+<row>
+<entry colname="col1">UPDATE, DELETE CURRENT</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>åçãªSQL1</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: åçãªSQL1</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">ALLOCATE / DEALLOCATE / GET / SET DESCRIPTOR</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes JDBCã®ã¡ã½ããå¼ã³åºãã«ããå®ç¾</entry>
+</row>
+<row>
+<entry colname="col1">PREPARE / EXECUTE / EXECUTE IMMEDIATE</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes JDBCã®ã¡ã½ããå¼ã³åºãã«ããå®ç¾</entry>
+</row>
+<row>
+<entry colname="col1">DECLARE, OPEN, FETCH, CLOSE, UPDATE, DELETE dynamic
+cursor</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes JDBCã®ã¡ã½ããå¼ã³åºãã«ããå®ç¾</entry>
+</row>
+<row>
+<entry colname="col1">DESCRIBE output</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">JDBCã«ããå®ç¾</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>åºæ¬çãªæ
å ±ã¹ãã¼ã</title><table><title>SQL-92ã®æ©è½ã®ãµãã¼ã åºæ¬çãªæ
å ±ã¹ãã¼ã</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">TABLES</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3"><i>SYS.SYSTABLES, SYS.SYSVIEWS, SYS.SYSCOLUMNS</i></entry>
+</row>
+<row>
+<entry colname="col1">VIEWS</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3"><i>SYS.SYSTABLES, SYS.SYSVIEWS, SYS.SYSCOLUMNS</i></entry>
+</row>
+<row>
+<entry colname="col1">COLUMNS</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3"><i>SYS.SYSTABLES, SYS.SYSVIEWS, SYS.SYSCOLUMNS</i></entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>åºæ¬çãªã¹ãã¼ãã¸ã®æä½</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: åºæ¬çãªã¹ãã¼ãã¸ã®æä½</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">CREATE / DROP TABLE</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">CREATE / DROP VIEW</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">GRANT / REVOKE</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">ALTER TABLE ADD COLUMN</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">ALTER TABLE DROP COLUMN</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>表ã®çµå</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: 表ã®çµå</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">INNER JOIN</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">natural join</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">LEFT, RIGHT OUTER JOIN</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">join condition</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">named columns join</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>æ¥æã®ãã¼ã¿å</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: æ¥æã®ãã¼ã¿å</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">åç´ãªDATE, TIME, TIMESTAMP, INTERVAL</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes ãã ãINTERVALã¯ç¡ãã</entry>
+</row>
+<row>
+<entry colname="col1">æ¥æã®å®æ°</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">æ¥æã®æ¼ç®</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes Javaã®ã¡ã½ããã«ã¦å¯è½</entry>
+</row>
+<row>
+<entry colname="col1">æ¥æã®æ¯è¼</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">è¿°èª: OVERLAPS</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes Javaã®ã¡ã½ããã«ã¦å¯è½</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>VARCHAR ãã¼ã¿å</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: VARCHAR</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">LENGTH</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">é£çµ (||)</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>ãã©ã³ã¶ã¯ã·ã§ã³ã®åé¢</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: ãã©ã³ã¶ã¯ã·ã§ã³ã®åé¢</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">READ WRITE / READ ONLY</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">JDBCã®å©ç¨ããã¼ã¿ãã¼ã¹ã®å±æ§ãè¨é²åªä½ã«ãã</entry>
+</row>
+<row>
+<entry colname="col1">RU, RC, RR, SER</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>ã¦ã¼ã¶æ¯ã«è¤æ°ã¹ãã¼ããæã¤</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: ã¦ã¼ã¶æ¯ã«è¤æ°ã¹ãã¼ããæã¤</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">SCHEMATA ãã¥ã¼</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3"><i>SYS.SYSSCHEMAS</i></entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>権é表</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: 権é表</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">TABLE_PRIVILEGES</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">COLUMNS_PRIVILEGES</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">USAGE_PRIVILEGES</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">No</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>表ã¸ã®æä½</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: 表ã¸ã®æä½</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">UNION relaxation</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">EXCEPT</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">INTERSECT</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">CORRESPONDING</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">No</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>ã¹ãã¼ãã®å®ç¾©æ</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: ã¹ãã¼ãã®å®ç¾©æ</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">CREATE SCHEMA</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">é¨åçã«å®ç¾</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>ã¦ã¼ã¶èªè¨¼</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: ã¦ã¼ã¶èªè¨¼</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">SET SESSION AUTHORIZATION</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">SET SCHEMAã使ã</entry>
+</row>
+<row>
+<entry colname="col1">CURRENT_USER</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">SESSION_USER</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">SYSTEM_USER</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">No</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>表ã®å¶ç´</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã:表ã®å¶ç´</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">TABLE CONSTRAINTS</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3"><i>SYS.SYSCONSTRAINTS</i></entry>
+</row>
+<row>
+<entry colname="col1">REFERENTIAL CONSTRAINTS</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3"><i>SYS.SYSFOREIGNKEYS</i></entry>
+</row>
+<row>
+<entry colname="col1">CHECK CONSTRAINTS</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3"><i>SYS.SYSCHECKS</i></entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>ã¹ãã¼ãæ
å ±ã®æä¾</title><table><title>SQL-92ã®æ©è½ã®ãµãã¼ã: ã¹ãã¼ãæ
å ±ã®æä¾</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">SQL_FEATURES</entry>
+<entry colname="col2">SQL92I/FIPS 127-2</entry>
+<entry colname="col3">JDBCã®<i>DatabaseMetaData</i>ãå©ç¨</entry>
+</row>
+<row>
+<entry colname="col1">SQL_SIZING</entry>
+<entry colname="col2">SQL92I/FIPS 127-2</entry>
+<entry colname="col3">JDBCã®<i>DatabaseMetaData</i>ãå©ç¨</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>æ¥æã®å
¨æ©è½</title><table><title>SQL-92ã®æ©è½ã®ãµãã¼ã: æ¥æã®å
¨æ©è½</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">TIMEãTIMESTAMPã®ç²¾åº¦</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>å
¨ã¦ã®æååå¦ç</title><table>
+<title>SQL-92ã®æ©è½ã®ãµãã¼ã: å
¨ã¦ã®æååå¦ç</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">POSITIONå¼</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Javaã®ã¡ã½ãããããã¯LOCATEãå©ç¨</entry>
+</row>
+<row>
+<entry colname="col1">UPPER/LOWER é¢æ°</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Yes</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+<section><title>æ§ã
</title><table><title>SQL-92ã®æ©è½ã®ãµãã¼ã: æ§ã
</title>
+<tgroup cols="3"><colspec colname="col1"/><colspec colname="col2"/><colspec
+colname="col3"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">æ©è½</entry>
+<entry colname="col2">å®ç¾©ããä»æ§</entry>
+<entry colname="col3"><ph conref="../conrefs.dita#prod/productshortname"></ph></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">ããªãããããèå¥å</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">ç¸äºã«é¢é£ããå¯ååã</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">æ¿å
¥ã»æ´æ°ã»åé¤æ</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">çµå</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">Whereã«ããéå®</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">Group by</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">Having</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">éç´é¢æ°</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">Order by</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">é¸æå¼</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">Select *</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">SQLCODE</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">No SQL-92ã§ã¯æ¨å¥¨ãããªãã</entry>
+</row>
+<row>
+<entry colname="col1">SQLSTATE</entry>
+<entry colname="col2">SQL92E</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">ãã¥ã¼ã§ã®UNIONãINTERSECTããã³EXCEPT</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">æé»ã®æ°å¤åå¤æ</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">æé»ã®æåååå¤æ</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">診ææ
å ±ã®åå¾</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">JDBCã®<i>SQLExceptions</i>ãå©ç¨</entry>
+</row>
+<row>
+<entry colname="col1">ã°ã«ã¼ãã¸ã®å¦ç</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">selectã®é¸æé
ç®ä¸è¦§ã«ãããéå®ããã*</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">å°æåã®èå¥å</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">空å¤ã¨ãããã¨ã®ã§ãã主ãã¼</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">è¤æ°ã®ã¢ã¸ã¥ã¼ã«ãµãã¼ã</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">No (JDBCã®ä¸é¨ã§ã¯ãªããå¿
è¦ã§ã¯ãªãã)</entry>
+</row>
+<row>
+<entry colname="col1">åç
§æ§ã®åé¤å¦ç</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">CASCADEãSET NULLãRESTRICTãNO ACTION</entry>
+</row>
+<row>
+<entry colname="col1">CASTé¢æ°</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">INSERTå¼</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">æ示çãªæ¢å®å¤</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">ãã¼ã¯ã¼ãã®ç·©å</entry>
+<entry colname="col2">SQL92T</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">Domainã®å®ç¾©</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">CASEå¼</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">é¨åçã«ãµãã¼ã</entry>
+</row>
+<row>
+<entry colname="col1">åæãããæååã®å®æ°</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">é£çµãå©ç¨ã§ãã</entry>
+</row>
+<row>
+<entry colname="col1">LIKEã®æ©è½å¼·å</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">UNIQUEã®è¿°èª</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">表ã®å©ç¨æ
å ±</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3"><i>SYS.SYSDEPENDS</i> </entry>
+</row>
+<row>
+<entry colname="col1">ä¸éçãªæ
å ±ã¹ãã¼ã</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">JDBCã®<i>DatabaseMetaData</i>ããã³<ph conref="../conrefs.dita#prod/productshortname"></ph>ã®ã·ã¹ãã 表ãå©ç¨å¯</entry>
+</row>
+<row>
+<entry colname="col1">å¯ããã°ã©ã ã®ãµãã¼ã</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">ããæ©è½ãè±å¯ãªJDBCã§ã¯é¢ä¿ãç¡ãã</entry>
+</row>
+<row>
+<entry colname="col1">ä¸éçãªSQLã¸ã®ãã©ã°ä»ã</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">ã¹ãã¼ãã®æä½</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">é·ãèå¥å</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">両å´ã¸ã®å¤é¨çµå</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">ã¿ã¤ã ã¾ã¼ã³ã®æå®</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">ã¹ã¯ãã¼ã«å¯è½ãªã«ã¼ã½ã«</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">é¨åç (JDBC2.0ã§ã¯ã¹ã¯ãã¼ã«å¯è½ãªinsensitiveãªã«ã¼ã½ã«ã)</entry>
+</row>
+<row>
+<entry colname="col1">ä¸éçãªéåé¢æ°ã®ãµãã¼ã</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">é¨åçã«å®ç¾</entry>
+</row>
+<row>
+<entry colname="col1">æåã»ããã®å®ç¾©</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Javaã®ãã±ã¼ã«ããµãã¼ã</entry>
+</row>
+<row>
+<entry colname="col1">æåã»ããã¸ã®ååä»ã</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Javaã®ãã±ã¼ã«ããµãã¼ã</entry>
+</row>
+<row>
+<entry colname="col1">ã¹ã«ã©ã¼å¯ååãã®å¤</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">æ¡å¼µãããnullè¿°é¨</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">å¶ç´ã®ç®¡ç</entry>
+<entry colname="col2">SQL92I</entry>
+<entry colname="col3">Yes (ADD/DROP CONSTRAINT)</entry>
+</row>
+<row>
+<entry colname="col1">FOR BIT DATA å</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Yes </entry>
+</row>
+<row>
+<entry colname="col1">Assertion å¶ç´</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">ä¸æ表</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">DECLARE GLOBAL TEMPORARY TABLEã§ãé¨åçã«å®ç¾ã</entry>
+</row>
+<row>
+<entry colname="col1">å®å
¨ãªåçSQL</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">å®å
¨ãªvalueså¼</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">çã®å¤å¤å®</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">å°åºè¡¨ãFROMã«ããã</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">ã¢ã³ãã¼ã¹ã³ã¢ãå¾ã«ã¤ãããã¨ãã§ãã</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">Indicatorãã¼ã¿å</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">JDBCã¨ã¯é¢é£ããªãã</entry>
+</row>
+<row>
+<entry colname="col1">åç
§ããååã®é çª</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">å®å
¨ãªSQLã®ãã©ã°ä»ã</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">è¡ããã³è¡¨ã®æ§ç¯å</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">ã«ã¿ãã°åã®éå®å</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">åç´è¡¨</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">CHECKå¶ç´ã§ã®å¯ååã</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No ãã ãJavaã®ã¡ã½ããã§åçã®ãã¨ãã§ããã</entry>
+</row>
+<row>
+<entry colname="col1">Union join</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">Collationãtranslation</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Javaã®ãã±ã¼ã«ãå©ç¨å¯è½</entry>
+</row>
+<row>
+<entry colname="col1">åç
§æ§ã®æ´æ°å¦ç</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">RESTRICTããã³NO ACTIONã ããªã¬ã«ãããã®ä»ãå¯è½ã</entry>
+</row>
+<row>
+<entry colname="col1">ALTER domain</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">INSERT å権é</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">åç
§æ§ã®MATCHå</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">ãã¥ã¼ã®CHECKå¶ç´ã®æ©è½å¼·å</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Noããã¥ã¼ã¯æ´æ°ã§ããªãã</entry>
+</row>
+<row>
+<entry colname="col1">Session管ç</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">JDBCãå©ç¨</entry>
+</row>
+<row>
+<entry colname="col1">æ¥ç¶ç®¡ç</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">JDBCãå©ç¨</entry>
+</row>
+<row>
+<entry colname="col1">èªå·±åç
§çãªæä½</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Yes</entry>
+</row>
+<row>
+<entry colname="col1">insensitiveãªã«ã¼ã½ã«</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Yes JDBC 2.0ãéãã¦å¯è½</entry>
+</row>
+<row>
+<entry colname="col1">å®å
¨ãªéåé¢æ°</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">é¨åçãªå®ç¾</entry>
+</row>
+<row>
+<entry colname="col1">ã«ã¿ãã°ã¸ã®ãã©ã°ä»ã</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">å±æçãªè¡¨ã¸ã®åç
§</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+<row>
+<entry colname="col1">ã«ã¼ã½ã«å
¨ä½ã®æ´æ°</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">No</entry>
+</row>
+</tbody>
+</tgroup>
+</table></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsql9241891.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1055824.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1055824.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1055824.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1055824.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqlj1055824" xml:lang="ja">
+<title>CURRENT TIME</title>
+<prolog><metadata>
+<keywords><indexterm>CURRENT TIME é¢æ°</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>CURRENT TIME ã¯<xref href="rrefsqlj33772.dita#rrefsqlj33772">CURRENT_TIME</xref>ã®å¥åã§ãã</p></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1055824.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj10696.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj10696.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj10696.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj10696.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,40 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqlj10696" xml:lang="ja">
+<title>INTEGER ãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>INTEGER data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>INTEGERã¯æ´æ°ã4ãã¤ãã®é åã«è¨é²ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>{ INTEGER | INT }</b></codeblock> </refsyn>
+<section><title>対å¿ããã³ã³ãã¤ã«æã®Javaã®å</title> <p><i>java.lang.Integer</i></p> </section>
+<section><title>JDBCã®ã¡ã¿ãã¼ã¿å (java.sql.Types)</title> <p>INTEGER</p> </section>
+<section><title>æå°å¤</title> <p id="sqlj88368">-2147483648
+(<i>java.lang.Integer.MIN_VALUE</i>)</p> </section>
+<section><title>æ大å¤</title> <p id="sqlj81992">2147483647 (<i>java.lang.Integer.MAX_VALUE</i>)</p>
+<p>ä»ã®ãã¼ã¿åã¨æ··å¨ãã¦å¼ä¸ã§å©ç¨ãããå ´åãå¼ã®çµæã¨ãªãåã¯<xref href="rrefsqlj27767.dita#rrefsqlj27767"></xref>ã«è¨è¿°ãããè¦åã«ã®ã£ã¨ã£ã¦æ±ºã¾ãã¾ãã</p>
+<p><xref href="rrefsqlj20204.dita#rrefsqlj20204"></xref>ãåç
§ãã¦ãã ããã</p> </section>
+<example> <codeblock><b>3453
+425</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj10696.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1080779.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1080779.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1080779.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1080779.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,47 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqlj1080779" xml:lang="ja">
+<title>å¼ã«é¢ããåªå
é ä½</title>
+<prolog><metadata>
+<keywords><indexterm>Expressions<indexterm>hierarchy of</indexterm><indexterm>precedence
+of</indexterm></indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section><p>æ¼ç®åã®åªå
é ä½ãé«ããã®ããä½ããã®ã«ä¸¦ã¹ã¦ç¤ºãã¾ãã <ul>
+<li>(), ?, å®æ° (符å·ãå«ã), NULL, <i>ååç
§</i>, <i>ã¹ã«ã©ã¼å¯ååã</i>,
+CAST</li>
+<li>LENGTH, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, ãã®ä»ã®çµè¾¼ã¿é¢æ°</li>
+<li>åä¸ã®ãªãã©ã³ããã¨ã+ããã³-</li>
+<li>*, /, || (é£çµ)</li>
+<li>äºã¤ã®ãªãã©ã³ããã¨ã+ããã³-</li>
+<li>æ¯è¼ã å®éæ¯è¼ã EXISTS, IN, IS NULL, LIKE, BETWEEN,
+IS</li>
+<li>NOT</li>
+<li>AND</li>
+<li>OR</li>
+</ul></p></section>
+<section><p>æ¼ç®åãæ¬å¼§ã®ä¸ã«æ¸ããã¨ã«ãããåªå
é ä½ãæ示çã«æå®ãããã¨ãã§ãã¾ããæ¬å¼§ã®å¤ã«ããæ¼ç®åãæ¬å¼§ã®ä¸ã®å¼ã«é©ç¨ãããåã«ãæ¬å¼§ã®ä¸ã®æ¼ç®åã¯è©ä¾¡ããã¾ãã</p></section>
+<example><title>ä¾</title>
+<codeblock><b>(3+4)*9
+(age < 16 OR age > 65) AND employed = TRUE</b></codeblock></example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1080779.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1082953.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1082953.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1082953.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1082953.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,37 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqlj1082953" xml:lang="ja">
+<title>åçãã©ã¡ã¼ã¿ã®ä¾</title>
+<refbody>
+<example> <codeblock><b>PreparedStatement ps2 = conn.prepareStatement(
+ "UPDATE HotelAvailability SET rooms_available = " +
+ "(rooms_available - ?) WHERE hotel_id = ? " +
+ "AND booking_date BETWEEN ? AND ?");
+<ph>-- ãã®ã³ã¼ãä¾ã§ã¯åçãã©ã¡ã¼ã¿ã«
+-- ããã°ã©ã å¤æ°ã®å¤ã代å
¥ãã¾ãã</ph>
+ps2.setInt(1, numberRooms);
+ps2.setInt(2, theHotel.hotelId);
+ps2.setDate(3, arrival);
+ps2.setDate(4, departure);
+updateCount = ps2.executeUpdate();</b></codeblock></example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1082953.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1083019.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1083019.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1083019.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1083019.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,102 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<reference id="rrefsqlj1083019" xml:lang="ja">
+<title>åçãã©ã¡ã¼ã¿ãç½®ããå ´æ</title>
+<refbody>
+<section><p>ãã¼ã¿åãç°¡åã«æ±ºå®ãããå ´æã§ããã°ãå¼ã®ä½å¦ã«ã§ãåçãã©ã¡ã¼ã¿ãç½®ããã¨ãã§ãã¾ãã<ol>
+<li>BETWEENã§ã¯ãäºã¤ç®ã¨ä¸ã¤ç®ã®ãªãã©ã³ãã®ã©ã¡ãããåçãã©ã¡ã¼ã¿ã§ãªããã°ãæåã®ãªãã©ã³ããåçãã©ã¡ã¼ã¿ã¨ãããã¨ãã§ãã¾ãã
+ä¸ã¤ç®ã®ãªãã©ã³ãã®åã¯ãæ®ãã®äºã¤ãåçãã©ã¡ã¼ã¿ã§ãªããã°ããããåçã§ã¯ãªããã©ã¡ã¼ã¿ã®åãããã¯ããããçµ±åããåã¨ã¿ãªããã¾ãã
+<codeblock><b>WHERE ? BETWEEN DATE('1996-01-01') AND ?
+<ph>-- åã¯DATEã¨ã¿ãªããã¾ãã</ph></b></codeblock></li>
+<li>BETWEENã®äºã¤ç®ãä¸ã¤ç®ã®ãªãã©ã³ããåçãã©ã¡ã¼ã¿ã¨ãããã¨ãã§ãã¾ãã
+ãããã®åã¯å·¦è¾ºã®ãªãã©ã³ãã¨åãåã¨ã¿ãªããã¾ãã<codeblock><b>WHERE DATE('1996-01-01') BETWEEN ? AND ?
+<ph>-- åã¯DATEã¨ã¿ãªããã¾ãã</ph></b></codeblock></li>
+<li id="sqlj30695">INã§ã¯ä¸è¦§ã®ãã¡ä¸ã¤ã§ãåçãã©ã¡ã¼ã¿ã§ã¯ãªãé
ç®ãããã°ã左辺ã®ãªãã©ã³ããåçãã©ã¡ã¼ã¿ã¨ãããã¨ãã§ãã¾ãã
+左辺ã®ãªãã©ã³ãã®åã¯ä¸è¦§ã«ããåçã§ãªããã©ã¡ã¼ã¿ã®é
ç®ã®åãçµ±åããåã¨ã¿ãªããã¾ãã<codeblock><b>WHERE ? NOT IN (?, ?, 'Santiago')
+<ph>-- åã¯CHARã¨ã¿ãªããã¾ãã</ph></b></codeblock></li>
+<li>INã§ã¯ãæåã®ãªãã©ã³ããåçãã©ã¡ã¼ã¿ã§ã¯ãªããåæ²ã®ã«ã¼ã«ã«ãããã®åã決ã¾ãå ´åãINã®è¿°é¨ã®ä¸è¦§ã«åçãã©ã¡ã¼ã¿ãç½®ããã¨ãã§ãã¾ãã
+å¤ã®ä¸è¦§ã«ç½®ãããåçãã©ã¡ã¼ã¿ã®åã¯ã左辺ã®ãªãã©ã³ãã®åã¨åããã®ã¨ã¿ãªããã¾ãã
+<codeblock><b>WHERE <b><i>FloatColumn</i></b> IN (?, ?, ?)
+<ph>-- åã¯FLOATã¨ã¿ãªããã¾ãã</ph></b></codeblock></li>
+<li id="sqlj18960">ãªãã©ã³ãã2ã¤æã¤æ¼ç®åã®ã+ã»-ã»*ã»/ã»ANDã»ORã»<ã»>ã»
+=ã»<ã»>ã»<=ã¨>=ã§ã¯ãçæ¹ã®ãªãã©ã³ããåçãã©ã¡ã¼ã¿ã¨ãããã¨ãã§ãã¾ããã両æ¹ãåçãã©ã¡ã¼ã¿ã¨ãããã¨ã¯ã§ãã¾ããã
+åçãã©ã¡ã¼ã¿ã®åã¯ããçæ¹ã®ãªãã©ã³ãã®åã¨ãªãã¾ãã
+<codeblock><b>WHERE ? < CURRENT_TIMESTAMP
+<ph>-- åã¯TIMESTAMPã¨ã¿ãªããã¾ãã</ph></b></codeblock></li>
+<li>CASTã§ã¯å¸¸ã«åçãã©ã¡ã¼ã¿ãå©ç¨ã§ãã¾ããããã«ããåçãã©ã¡ã¼ã¿ã«åãä¸ãããã¨ãã§ãã¾ãã
+<codeblock><b>CALL valueOf(CAST (? AS VARCHAR(10)))</b></codeblock></li>
+<li>LIKEæ¼ç®åã®çæ¹ãããã¯ä¸¡æ¹ã®ãªãã©ã³ããåçãã©ã¡ã¼ã¿ã¨ãããã¨ãå¯è½ã§ãã
+左辺ãåçãã©ã¡ã¼ã¿ã¨ããå ´åããã®åã¯å³è¾ºã®ãªãã©ã³ãã¨åããã®ã¨ã¿ãªããã¾ãããªãæ大é·ã¯åã®æ大é·ã¨ãªãã¾ããå³è¾ºãåçãã©ã¡ã¼ã¿ã¨ããå ´åã左辺ã®ãªãã©ã³ãã®é·ãã¨åãé©ç¨ããã¾ãã
+(LIKEã§ã¯CHARã¨VARCHARã®åãå©ç¨ããäºãå¯è½ã§ãã詳細ã¯<xref href="rrefsqlj40899.dita#rrefsqlj40899"></xref>ãåç
§ãã¦ãã ããã)
+<codeblock><b>WHERE ? LIKE 'Santi%'
+<ph>--åã¯æ大é·ãjava.lang.Integer.MAX_VALUEã®
+--CHARã¨ã¿ãªããã¾ãã</ph></b></codeblock></li>
+<li>åçãã©ã¡ã¼ã¿ã®?ã¯ã||æ¼ç®åã®çæ¹ã®å´ã«ã®ã¿ç½®ããã¨ãã§ãã¾ãã
+ããªãã¡"? || ?"ã¯ä¸å¯è½ã§ãã||æ¼ç®åã®çå´ã«ãã?ãã©ã¡ã¼ã¿ã®åã¯ããã®å対å´ã«ãã||æ¼ç®åã®ãªãã©ã³ãã®å¼ã®åã«ãã£ã¦æ±ºã¾ãã¾ããããå対å´ã®å¼ã®åãCHARãããã¯VARCHARã§ããã°ãåçãã©ã¡ã¼ã¿ã®åã¯ãã®åã®æ大é·ã®VARCHARã§ãã
+ããå対å´ã®å¼ã®åãCHAR FOR BIT DATAãããã¯VARCHAR FOR BIT DATAã§ããã°ãåçãã©ã¡ã¼ã¿ã®åã¯ãã®æ¹ã®æ大é·ã®VARCHAR FOR BIT DATAã§ãã
+<codeblock><b>SELECT BITcolumn || ?
+FROM UserTable
+<ph>-- åã¯BITcolumnã¨åãæ大é·ã®CHAR FOR BIT DATAã¨ãªãã¾ãã</ph></b></codeblock></li>
+<li><indexterm>? (dynamic parameter)<indexterm>used in conditional expression</indexterm></indexterm>æ¡ä»¶å¼ã§ã¯?ã§è¡¨ãããåçãã©ã¡ã¼ã¿ã®å©ç¨ãå¯è½ã§ããå¼ã®æåã®ãªãã©ã³ãã«ç½®ãããåçãã©ã¡ã¼ã¿ã®åã¯çå½åã¨ã¿ãªããã¾ãã
+å¼ã®äºã¤ç®ãããã¯ä¸ã¤ç®ã®ãã¡ãçæ¹ã ããåçãã©ã¡ã¼ã¿ã¨ãããã¨ãã§ãã¾ããåçãã©ã¡ã¼ã¿ã®åã¯ãããçæ¹ã®åã¨åããã®ã¨ã¿ãªããã¾ãã(ã¤ã¾ã対å¿ããã®ã¯ä¸ã¤ç®ã¨äºã¤ç®ã®ãªãã©ã³ãã¨ãªãã¾ãã)
+ <codeblock><b>SELECT c1 IS NULL ? ? : c1
+<ph>-- ãã®ä¾ã§ã¯å®è¡æã«æ¢å®å¤ãä¸ãããã¨ãã§ãã¾ãã
+-- ãã®åçãã©ã¡ã¼ã¿ã®åã¯c1ã¨åãåã¨ã¿ãªããã¾ãã
+-- :ã®ä¸¡å´ã«åçãã©ã¡ã¼ã¿ãç½®ããã¨ã¯ã§ãã¾ããã
+</ph></b></codeblock></li>
+<li>INSERTæã®valuesã®ä¸è¦§ãselectã®ä¸è¦§ã«ãåçãã©ã¡ã¼ã¿ãç½®ããã¨ãã§ãã¾ãã
+åçãã©ã¡ã¼ã¿ã®åã¯å¯¾è±¡åã®åã¨åãåã¨ã¿ãªããã¾ãã
+<codeblock><b>INSERT INTO t VALUES (?)
+<ph>-- åçãã©ã¡ã¼ã¿ã®åã¯ã
+-- t表ã®å¯ä¸ã¤ã®åã¨åãåã¨ãªãã¾ãã</ph>
+INSERT INTO t SELECT ?
+FROM t2
+<ph>-- ããã¯ä¸å¯ã§ãã</ph></b></codeblock></li>
+<li>å¯ååãã¨æ¯è¼ããã?ãã©ã¡ã¼ã¿ã¯ãå¯ååãã§é¸æãããå¼ã®åãã¨ãã¾ãã
+ä¾ãæãã¾ãã
+<codeblock><b>SELECT *
+FROM tab1
+WHERE ? = (SELECT x FROM tab2)
+
+SELECT *
+FROM tab1
+WHERE ? = ANY (SELECT x FROM tab2)
+<ph>-- 両æ¹ã®å ´åã«ããã¦ãåçãã©ã¡ã¼ã¿ã®åã¯ã
+-- tab2.xã¨åãåã¨ã¿ãªããã¾ãã</ph></b></codeblock></li>
+<li>UPDATEæã®å¤ã«å¯¾ãã¦åçãã©ã¡ã¼ã¿ãç½®ããã¨ãã§ãã¾ããåçãã©ã¡ã¼ã¿ã®åã¯ã対ç
§è¡¨ã®åã®åã¨åããã®ã¨ã¿ãªããã¾ãã
+<codeblock><b>UPDATE t2 SET c2 =? <ph>-- c2ã¨åãåã¨ã¿ãªããã¾ãã</ph></b></codeblock></li>
+<li>åä¸ãªãã©ã³ããã¨ã-ã+ã®æ¼ç®åã«ã¦ãåçãã©ã¡ã¼ã¿ãå©ç¨å¯è½ã§ãã
+ä¾ãæãã¾ãã<codeblock><b>CREATE TABLE t1 (c11 INT, c12 SMALLINT, c13 DOUBLE, c14 CHAR(3))
+SELECT * FROM t1 WHERE c11 BETWEEN -? AND +?
+<ph>-â 両æ¹ã®åä¸ãªãã©ã³ããã¨ãæ¼ç®åã®åã¯ãæèã«æ²¿ã£ã¦INTã¨ãªãã¾ãã
+-- (ããªãã¡ãc11ãINTãªã®ã§ãåä¸ãªãã©ã³ããã¨ãæ¼ç®åãINTã®åãã¨ãã¾ãã)
+</ph></b></codeblock></li>
+<li>LENGTHã«ã¦ãåçãã©ã¡ã¼ã¿ãå©ç¨å¯è½ã§ãããã®åã¯æ大é·ã®VARCHARã¨ã¿ãªããã¾ãã
+<codeblock><b>SELECT LENGTH(?)</b></codeblock></li>
+<li>å®éæ¯è¼<codeblock><b>? = SOME (SELECT 1 FROM t)
+<ph>-- ããã¯æå¹ã§ããåçãªãã©ã¡ã¼ã¿ã®åã¯INTEGERã¨ã¿ãªããã¾ãã</ph>
+1 = SOME (SELECT ? FROM t)
+<ph>-- ããã¯æå¹ã§ããåçãªãã©ã¡ã¼ã¿ã®åã¯INTEGERã¨ã¿ãªããã¾ãã</ph></b></codeblock></li>
+<li>ISå¼ã®å·¦è¾ºã«åçãã©ã¡ã¼ã¿ãç½®ããã¨ãã§ãããã®åã¯çå½åã¨ã¿ãªããã¾ãã</li>
+</ol></p></section>
+<section><p>åçãªãã©ã¡ã¼ã¿ã®åã決ã¾ãå¼ã¯ä¸è¬çã«ããã®åçãã©ã¡ã¼ã¿ãå®æ°ã«ç½®ãæãã¦ãã©ã®ãããªå ´æã«ãç½®ããã¨ãã§ãã¾ãã</p></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj1083019.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj11277.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj11277.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj11277.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj11277.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,76 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqlj11277" xml:lang="ja">
+<title>VALUESå¼</title>
+<prolog><metadata>
+<keywords><indexterm>VALUES expression</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>VALUESå¼ã«ãããå¤ããè¡ã表ãæ§ç¯ã§ãã¾ãã
+VALUESå¼ã¯åãåãããç½®ããå ´æãªãã©ãã«ã§ãç½®ããã¨ãã§ãããããã£ã¦ä»¥ä¸ã®ãããã¨ãã¦ãå©ç¨ãå¯è½ã§ãã
+<ul>
+<li><i>ResultSet</i>ãè¿ãæ</li>
+<li>å¯åãåãããç½®ããå¼ãæ</li>
+<li>INSERTæã®å¤(INSERTæã§ã¯éä¾çã«<i><xref href="rrefselectexpression.dita#rrefselectexpression"></xref></i>ã§ã¯ãªãVALUESå¼ãç¨ãã¾ãã)</li>
+</ul>
+</p> </section>
+<refsyn><title>æ§æ</title>
+<codeblock><b>
+ VALUES ( <i>å¤</i> {, <i>å¤</i> }* )
+ [ , ( <i>å¤</i> {, <i>å¤</i> }* ) ]* |
+ VALUES <i>å¤</i> [ , <i>å¤</i> ]*
+ }</b></codeblock>
+<p><i>å¤</i>ã¯ä»¥ä¸ã®ããã«å®ç¾©ããã¾ãã</p>
+<codeblock><b><i>å¼</i> | DEFAULT</b></codeblock>
+<p>æåã®æ¸ãæ¹ã§ã¯è¤æ°åã®è¡ãæ§ç¯ãããäºã¤ç®ã®æ¸ãæ¹ã§ã¯ååã®è¡ããåã
ã®å¼ãè¡ã®åå¤ã¨ãã¦ãæ§ç¯ããã¾ãã</p>
+<p>VALUESå¼ãINSERTæã«ããå ´åã®ã¿ãDEFAULTã¨ãããã¼ã¯ã¼ãã使ããã¨ãã§ãã¾ãã
+åã«DEFAULTãæå®ããã¨ããã®åã«ã¯åã®æ¢å®å¤ãæ¿å
¥ããã¾ãã
+ããä¸ã¤åã«æ¢å®å¤ãæ¿å
¥ããæ¹æ³ããããããã¯INSERTæã«ã¦ä¸è¦§ãããã®åãé¤ãã¦ã表ã®ä»ã®åã®å¤ã®ã¿æ示çã«æ¿å
¥ãããã¨ã§ãã</p> </refsyn>
+<example><title>ä¾</title><codeblock><b><ph>-- 1å3è¡</ph>
+VALUES (1),(2),(3)
+<ph>-- 1å3è¡</ph>
+VALUES 1, 2, 3
+<ph>-- 3å1è¡</ph>
+VALUES (1, 2, 3)
+<ph>-- 2å3è¡</ph>
+VALUES (1,21),(2,22),(3,23)
+<ph>-- 表ãå°åºãã¦æ§ç¯</ph>
+VALUES ('orange', 'orange'), ('apple', 'red'),
+('banana', 'yellow')
+<ph>-- åæã§DEPARTMENTã¨ãã表ã«äºã¤ã®æ°ããé¨ç½²ãæ¿å
¥ããã
+-- ãã ãæ°ããé¨ç½²ã«ç®¡çè
ã¯å²ãå½ã¦ãªãã</ph>
+INSERT INTO DEPARTMENT (DEPTNO, DEPTNAME, ADMRDEPT)
+ VALUES ('B11', 'PURCHASING', 'B01'),
+ ('E41', 'DATABASE ADMINISTRATION', 'E01')
+<ph>-- MAJPROJåã«æ¢å®å¤ããã¦ã¦ãè¡ãæ¿å
¥ããã</ph>
+INSERT INTO PROJECT (PROJNO, PROJNAME, DEPTNO, RESPEMP, PRSTDATE, MAJPROJ)
+VALUES ('PL2101', 'ENSURE COMPAT PLAN', 'B01', '000020', CURRENT_DATE, DEFAULT)
+
+<ph>-- çµè¾¼ã¿ã®é¢æ°ã使ã</ph>
+VALUES CURRENT_DATE
+<ph>-- ä»»æã®å¼ã®å¤ãã¨ã</ph>
+VALUES (3*29, 26.0E0/3)
+<ph>-- çµè¾¼ã¿ã®é¢æ°ã®è¿ãå¤ãã¨ã</ph>
+values char(1)
+</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj11277.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj12362.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj12362.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj12362.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj12362.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqlj12362" xml:lang="ja">
+<title>NUMERICãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>NUMERIC data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>NUMERICã¯<xref href="rrefsqlj15260.dita#rrefsqlj15260">DECIMAL</xref>ã®å¥åã§ãåæ§ã«æ©è½ãã¾ãã
+<xref href="rrefsqlj15260.dita#rrefsqlj15260"></xref>ãåç
§ãã¦ãã ããã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>NUMERIC [(<i>精度</i> [, <i>ç®çã</i> ])]</b></codeblock> </refsyn>
+<section><title>対å¿ããã³ã³ãã¤ã«æã®Javaã®å</title> <p><i>java.math.BigDecimal</i></p> </section>
+<section><title>対å¿ããJDBCã®ã¡ã¿ãã¼ã¿å(java.sql.Types)</title> <p>NUMERIC</p> </section>
+<example> <codeblock><b>123.456
+.001</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj12362.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native