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 [19/26] - in /db/derby/docs/trunk: ./ src/ja_JP/
src/ja_JP/ref/
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16357.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16357.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16357.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16357.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,34 @@
+<?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="rrefsqlj16357" xml:lang="ja">
+<title>åç
§å®ç¾©</title>
+<refbody>
+<example> <codeblock><b>REFERENCES <i><xref href="rreftablename.dita#rreftablename">表å</xref></i> [ ( <i><xref
+href="rrefsimplecolumnname.dita#rrefsimplecolumnname">åç´åå</xref></i> [ , <i><xref
+href="rrefsimplecolumnname.dita#rrefsimplecolumnname">åç´åå</xref></i> ]* ) ]
+[ ON DELETE {NO ACTION | RESTRICT | CASCADE | SET NULL}]
+ [ ON UPDATE {NO ACTION | RESTRICT }]
+|
+[ ON UPDATE {NO ACTION | RESTRICT }] [ ON DELETE
+ {NO ACTION | RESTRICT | CASCADE | SET NULL}] </b></codeblock></example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16357.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16762.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16762.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16762.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16762.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,38 @@
+<?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="rrefsqlj16762" xml:lang="en-us">
+<title>LENGTHé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>LENGTH function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>LENGTHã¯æååå¼ãããã¯ãããåå¼ã«é©ç¨ãã¦ãæåã®é·ããçµæã¨ãã¦è¿ãã¾ãã</p>
+<p>ããããçµè¾¼ã¿ã®ãã¼ã¿åã¯æé»ã®ãã¡ã«æååã«å¤æã§ããã®ã§ããã®é¢æ°ã¯ãããããã¼ã¿åã«é©ç¨ãããã¨ãã§ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>LENGTH ( { <i>æååå¼</i> | <i>ãããåå¼</i> } )</b></codeblock> </refsyn>
+<example> <codeblock><b><ph>-- 20ãè¿ãã</ph>
+VALUES LENGTH('supercalifragilistic')
+<ph>-- 1ãè¿ãã</ph>
+VALUES LENGTH(X'FF')
+-- 4ãè¿ã
+VALUES LENGTH(1234567890)</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16762.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj18730.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj18730.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj18730.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj18730.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,41 @@
+<?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="rrefsqlj18730" xml:lang="ja">
+<title>DATEãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>DATE data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>DATEã«ããã<i>java.sql.Date</i>ã®ç¯å²ã§å¹´ææ¥ãè¨é²ã§ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>DATE</b></codeblock> </refsyn>
+<section><title>対å¿ããå®è¡æã®Javaã®å</title> <p><i>java.sql.Date</i></p> </section>
+<section><title>JDBCã¡ã¿ãã¼ã¿å(java.sql.Types)</title><p>DATE</p>
+<p>ä¸ã¤ã®å¼ã«æ¥ä»ãæå»ãã¿ã¤ã ã¹ã¿ã³ããæ··å¨ããã¦ã¯ãªãã¾ããã</p>
+<p><i>java.sql.Date</i>ã®ã¡ã½ããã«ããæ±ããã¨ã®ã§ããå
¨ã¦ã®å¤ãã対å¿ããSQLã®æ¥ä»ãæå»ã®ãã¼ã¿åã®åã«ã¦è¨±ããã¦ãã¾ãã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯DATEã®å¤ã«å¯¾ãã¦æ¬¡ã®æ¸å¼ãç¨æãã¦ãã¾ãã<codeblock>yyyy-mm-dd
+mm/dd/yyyy
+dd.mm.yyyy</codeblock>ä¸ã«ç¤ºããä¸ã¤ã®æ¸å¼ã®ãã¡ãæåã®ãã®ã¯<i>java.sql.Date</i>ã®æ¸å¼ã§ãã</p>
+<p>å¹´ã¯å¸¸ã«4æ¡ã®æ°åã§è¡¨ãããªããã°ãªãã¾ãããããã«å¯¾ãã¦æãæ¥ã¯ä¸æ¡ãããã¯äºæ¡ã®æ°åã§è¡¨ããã¨ãã§ãã¾ãã</p>
+<p>ããã«ã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯DB2ãµã¼ãã®ãã±ã¼ã«ã«ç¹æãªæ¥æã®æ¸å¼ãåãä»ãã¾ããããã¨ãã¹ãæ¸å¼ãããã¾ãã§ããå ´åã¯ãä¸ã§ç¤ºããçµè¾¼ã¿ã®æ¸å¼ãåªå
ããã¾ãã</p> </section>
+<example> <title>ä¾</title><codeblock><b>VALUES DATE('1994-02-23')
+
+VALUES '1993-09-01'</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj18730.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj18922.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj18922.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj18922.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj18922.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,75 @@
+<?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="rrefsqlj18922" xml:lang="ja">
+<title>LEFT OUTER JOINæ¼ç®</title>
+<prolog><metadata>
+<keywords><indexterm>LEFT OUTER JOIN operation</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section>
+<p>LEFT OUTER JOINæ¼ç®ã¯ãjoinç¯ãè¨è¿°ã§ãã<xref href="rrefsqlj29840.dita#rrefsqlj29840">JOINæ¼ç®</xref>ã®ä¸ã¤ã§ãã
+ãã®æ¼ç®ã§ã¯æåã®(å·¦ã®)表ã«ã¦ãä¸è´ããè¡ãäºã¤ç®ã®(å³ã®)表ã«ãªãè¡ã¯ãäºã¤ç®ã®è¡¨ã®NULLã®è¡ã«çµåããããã®ã¨ãã¦ãçµæã«æ®ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title>
+<codeblock>
+<b><i><xref href="rreftableexpression.dita#rreftableexpression">表å¼</xref></i> LEFT [ OUTER ] JOIN <i
+><xref href="rreftableexpression.dita#rreftableexpression">表å¼</xref></i>
+{
+ ON <i>çå½å¼</i>
+ }</b></codeblock>
+<p>ONç¯ã«ãããããã®çå½å¼ããç´æ¥ã®è¡¨ã¨ç´æ¥ã®åãåããæã«ãããããªã表ãåç
§ãããã¨ãã§ãã¾ãã
+ONç¯ã¯çµåããã¦ããªã表ãåç
§ãããã¨ãã§ãã¾ãããçµåããã¦ãã表ãåç
§ããªãã¨ããã¾ãã¾ããã(ãã ãä¸è¬çã«ã¯åç
§ãã¾ãã)</p> </refsyn>
+<example><title>ä¾ 1</title><codeblock><b>--é½å¸ã«å¯¾å¿ããã¢ã¸ã¢ã®å½</b>
+
+SELECT CITIES.COUNTRY, CITIES.CITY_NAME, REGION
+FROM Countries
+LEFT OUTER JOIN Cities
+ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE
+WHERE REGION = 'Asia'
+
+<b>-- LEFT JOINã¨ããå¥ã®æ¸ãæ¹ã«ãããåä¾ã¨åãçµæã
+-- å®ç¾ããã
+</b>
+SELECT COUNTRIES.COUNTRY, CITIES.CITY_NAME,REGION
+FROM COUNTRIES
+LEFT JOIN CITIES
+ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE
+WHERE REGION = 'Asia'
+</codeblock></example>
+<example><title>ä¾ 2</title><codeblock><b>
+-- EMPLOYEEã¨DEPAETMENTã¨ãã表ãçµåãã¦ã
+-- 1930ããåã«çã¾ãã(BIRTHDATE)å
¨ã¦ã®ç¤¾å¡ã®ã
+-- 社å¡çªå·(EMPNO)ã¨ã
+-- 社å¡ã®èå(LASTNAME)ã¨ã
+-- é¨ç½²çªå·(EMPLOYEEã¨ãã表ã®WORKDEPTã¨ãDEPARTMENTã¨ãã表ã®DEPTNO)ã¨ã
+-- é¨ç½²å(DEPTNAME)ãé¸æããã
+</b>
+SELECT EMPNO, LASTNAME, WORKDEPT, DEPTNAME
+ FROM SAMP.EMPLOYEE LEFT OUTER JOIN SAMP.DEPARTMENT
+ ON WORKDEPT = DEPTNO
+ AND YEAR(BIRTHDATE) < 1930
+
+<b>-- 管çè
ã®ããªãé¨ç½²ãå«ãå
¨ã¦ã®é¨ç½²ãã
+-- é¨ç½²ã®ç®¡çè
ã®ç¤¾å¡çªå·ã¨èåã¨å
±ã«ä¸è¦§ããã
+</b>
+SELECT DEPTNO, DEPTNAME, EMPNO, LASTNAME
+ FROM DEPARTMENT LEFT OUTER JOIN EMPLOYEE
+ ON MGRNO = EMPNO</codeblock> </example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj18922.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj19433.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj19433.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj19433.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj19433.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,256 @@
+<?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="rrefsqlj19433" xml:lang="ja">
+<title>SQLå¼</title>
+<shortdesc>å¤ãã®æãå¼ã®æ§æã®èªå¥ã«ã<i>å¼</i>ã<i>表å¯ååã</i>ã®ãããªå¼ã®ä¸ç¨®ãããã¾ãã
+å¼ã¯æã®å®ããããå ´æã«ç½®ããã¨ãã§ãã¾ãã</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>SQL expressions<indexterm>column reference</indexterm></indexterm>
+<indexterm>SQL expressions<indexterm>constant</indexterm></indexterm><indexterm>SQL
+expressions<indexterm>NULL</indexterm></indexterm><indexterm>SQL expressions<indexterm>dynamic
+parameter</indexterm></indexterm><indexterm>SQL expressions<indexterm>CAST</indexterm></indexterm>
+<indexterm>SQL expressions<indexterm>scalar subquery</indexterm></indexterm>
+<indexterm>SQL expressions<indexterm>table subquery</indexterm></indexterm>
+<indexterm>SQL expressions<indexterm>conditional</indexterm></indexterm><indexterm>SQL
+expressions<indexterm>numeric</indexterm></indexterm><indexterm>SQL expressions<indexterm>character</indexterm></indexterm>
+<indexterm>SQL expressions<indexterm>string with wildcards</indexterm></indexterm>
+<indexterm>SQL expressions<indexterm>concatenation function</indexterm></indexterm>
+<indexterm>SQL expressions<indexterm>CURRENT_DATE function</indexterm></indexterm>
+<indexterm>SQL expressions<indexterm>CURRENT_TIME function</indexterm></indexterm>
+<indexterm>SQL expressions<indexterm>CURRENT_TIMESTAMP function</indexterm></indexterm>
+<indexterm>SQL expressions<indexterm>mathematical (+ -, *, /, unary + and
+- )</indexterm></indexterm><indexterm>SQL expressions<indexterm>LENGTH function</indexterm></indexterm>
+<indexterm>expressions<indexterm>column reference</indexterm></indexterm>
+<indexterm>expressions<indexterm>constant</indexterm></indexterm><indexterm>expressions<indexterm>NULL</indexterm></indexterm>
+<indexterm>expressions<indexterm>dynamic parameter</indexterm></indexterm>
+<indexterm>expressions<indexterm>CAST</indexterm></indexterm><indexterm>expressions<indexterm>scalar
+subquery</indexterm></indexterm><indexterm>expressions<indexterm>table subquery</indexterm></indexterm>
+<indexterm>expressions<indexterm>conditional</indexterm></indexterm><indexterm>expressions<indexterm>numeric</indexterm></indexterm>
+<indexterm>expressions<indexterm>character</indexterm></indexterm><indexterm>expressions<indexterm>string
+with wildcards</indexterm></indexterm><indexterm>expressions<indexterm>concatenation
+function</indexterm></indexterm><indexterm>expressions<indexterm>CURRENT_DATE
+function</indexterm></indexterm><indexterm>expressions<indexterm>CURRENT_TIME
+function</indexterm></indexterm><indexterm>expressions<indexterm>CURRENT_TIMESTAMP
+function</indexterm></indexterm><indexterm>expressions<indexterm>mathematical
+(+ -, *, /, unary + and - )</indexterm></indexterm><indexterm>expressions<indexterm>LENGTH
+function</indexterm></indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section><p>å ´æã«ãã£ã¦ã¯æ±ºãããã種é¡ã®å¼ã決ããããå±æ§ãæã¤å¼ã®ã¿ç½®ããã¨ãã§ãã¾ãã</p></section>
+<section><p>ç¹å¥ãªæå®ããªããã°ãæ§æã«ã¦<i>å¼</i>ã¨æ¸ããã¦ããå
¨ã¦ã®å ´æã«å¼ãç½®ããã¨ãã§ãã¾ãã
+ããã«ã¯ä»¥ä¸ãå«ã¾ãã¾ãã<ul>
+<li><xref href="rrefsqlj13658.dita#rrefsqlj13658">ORDER BY ç¯</xref></li>
+<li><i><xref href="rrefselectexpression.dita#rrefselectexpression">é¸æå¼</xref></i></li>
+<li><xref href="rrefsqlj26498.dita#rrefsqlj26498">UPDATEæ</xref> (SETã®é¨å)</li>
+<li><xref href="rrefsqlj11277.dita#rrefsqlj11277">VALUESå¼</xref></li>
+<li><xref href="rrefsqlj33602.dita#rrefsqlj33602">WHEREç¯</xref></li>
+</ul></p></section>
+<section><p>ãã¡ããä»ã«ãããããã®è¦ç´ ãæ§æã®ä¸é¨ã¨ããæã¯ããã®ã§ããã®ä¸é¨ã¨ãã¦å¼ãç½®ããã¨ãã§ãã¾ãã</p>
+<p>以ä¸ã®è¡¨ã§ã¯SQLå¼ã¨å¼ãç½®ããã¨ã®ã§ããå ´æã示ãã¾ãã</p></section>
+<section><title>ä¸è¬çãªå¼</title>
+<p>
+ä¸è¬çãªå¼ã¨ã¯ä½ããã®åã®å¤ã¨ãªãå¼ã®ãã¨ã§ãã<table frame="all"
+id="sqlj18370" pgwide="0"><title>ä¸è¬çãªå¼ã®è¡¨</title>
+<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="2" colnum="1" colwidth="30*"/>
+<colspec colname="3" colnum="2" colwidth="60*"/><colspec colname="3" colnum="3"
+colwidth="52*"/>
+<thead>
+<row>
+<entry align="left" colname="2" valign="bottom">å¼ã®ç¨®é¡</entry>
+<entry align="left" colname="3" valign="bottom">説æ</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="2"> ååç
§å¼</entry>
+<entry colname="3">åã¸ã®åç
§ãããå¼ã§ã¯ã<xref href="rrefcolumnname.dita#rrefcolumnname"><varname>åå</varname></xref>ã§åã®å¤ãåç
§ãã¦ãå¼ã®ä¸ã§å¤ãæ±ããã¨ãã§ãã¾ãã
+<p>åãææ§ãªå ´åã¯ã<varname>åå</varname>ã表åãããã¯ç¸é¢åã§éå®ããå¿
è¦ãããã¾ãã</p>
+<p><xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM
+ç¯</xref>ã«ã¦è¡¨ã«ç¸é¢åãä¸ãããã¦ããå ´åã<varname>åå</varname>ã¯ç¸é¢åã§éå®ãããå¿
è¦ãããã¾ããå¥åã¨ãã¦ç¸é¢åãä¸ãããã¦ããå ´åã表åã§åãéå®ãããã¨ã¯ã§ãã¾ããã</p>
+<p>ããã¯<i><xref
+href="rrefselectexpression.dita#rrefselectexpression">é¸æå¼</xref>s</i>ãUPDATEæãDMLæã®WHEREç¯ã«ãããã¨ãã§ãã¾ãã</p></entry>
+
+</row>
+<row>
+<entry colname="2">å®æ°</entry>
+<entry colname="3">å¤ãã®çµè¾¼ã¿ã®ãã¼ã¿åã«ã¯é¢é£ããå®æ°ãããã¾ãã(ããã¯<xref href="crefsqlj31068.dita#crefsqlj31068"></xref>ã«è¨è¿°ããã¾ãã)</entry>
+</row>
+<row>
+<entry colname="2">NULL</entry>
+<entry colname="3">NULLã¯ä¸æãªå¤ã表ããåã®ãªãå®æ°ã§ãã<p>CASTå¼ãINSERTã®VALUESä¸è¦§ããã³UPDATEã®SETç¯ã«ãããã¨ãã§ãã¾ããCASTå¼ã§å©ç¨ãããã¨ã§ãæå®ãããã¼ã¿åãä¸ãããã¨ãã§ãã¾ãã</p></entry>
+</row>
+<row>
+<entry colname="1"></entry>
+<entry colname="2">åçãã©ã¡ã¼ã¿</entry>
+<entry colname="3">
+åçãã©ã¡ã¼ã¿ã¯ãSQLæãä½æãããæã«ã¯æªã 決ã¾ã£ã¦ããªãå¤ã¸ã®ãã©ã¡ã¼ã¿ã§ãããã®å¤ã®å¤ããã«çå符(?)ãããããã®åçãªãã©ã¡ã¼ã¿ã®ãã¬ã¼ã¹ãã«ãã¨ãã¦ãããã¾ãã
+<xref href="crefsqlj29911.dita#crefsqlj29911"></xref>ãåç
§ãã¦ãã ããã
+<p>åçãã©ã¡ã¼ã¿ã¯æºåãããæã«ããã¦ã®ã¿ã使ããã¨ãã§ãã¾ããæºåãããæãå®è¡ãããåã«ãåçãã©ã¡ã¼ã¿ã®å¤ã¯æ±ºããããªããã°ãªãã¾ããã
+ã¾ã決ããå¤ã¯æèã«æ²¿ã£ãåã§ãªããã°ãªãã¾ããã</p>
+<p>ãã¼ã¿åãåé¡ãªãæ¨å®ã§ããå ´æã§ã¯ãã©ãã§ãå©ç¨ãããã¨ãã§ãã¾ãã<xref href="crefsqlj29911.dita#crefsqlj29911"></xref>ãåç
§ãã¦ãã ããã</p>
+</entry>
+</row>
+<row>
+<entry colname="2">CAST å¼</entry>
+<entry colname="3">NULLãåçãã©ã¡ã¼ã¿ã®åãç¹å®ããããå¤ãä»ã®åã«å¤æãããã¨ãã§ãã¾ãã
+<xref href="rrefsqlj33562.dita#rrefsqlj33562"></xref>ãåç
§ãã¦ãã ããã</entry>
+</row>
+<row>
+<entry colname="2">ã¹ã«ã©ã¼å¯ååã</entry>
+<entry colname="3">ä¸åã®ã¿ã®ä¸è¡ã ããè¿ãå¯ååãã§ãã
+<i><xref href="rrefscalarsubquery.dita#rrefscalarsubquery"></xref>ãåç
§ãã¦ãã ããã</i></entry>
+</row>
+<row>
+<entry colname="2">表å¯ååã</entry>
+<entry colname="3">å¯ååãããã¯ãä¸å以ä¸ãä¸è¡ä»¥ä¸ãè¿ããã¨ãã§ãã¾ãã
+<i><xref href="rreftablesubquery.dita#rreftablesubquery">表å¯ååã</xref></i>ãåç
§ãã¦ãã ããã
+<p>FROMå¥ãEXISTSãINãå®éæ¯è¼ã®è¡¨å¼ã¨ãã¦ç½®ããã¨ãã§ãã¾ãã</p>
+</entry>
+</row>
+</tbody>
+</tgroup>
+</table></p></section>
+
+<section><title>Booleanå¼</title>
+<p>ãã¼ãªã¢ã³å¼ã¯ãã¼ãªã¢ã³å¤ã«ãªãå¼ã§ããå¤ãã®å¼ã¯ããã¼ãªã¢ã³å¤ã¨ãªãã¾ãã
+ä¸è¬çã«WHEREå¥ã§ç¨ãããããã¼ãªã¢ã³å¼ã¯ãSQLæ¼ç®åã§å¦çããããªãã©ã³ããããªãã¾ãã<xref href="rrefsqlj23075.dita#rrefsqlj23075/sqlj34517"></xref>ãåç
§ãã¦ãã ããã</p></section>
+<section><title>æ°å¼</title>
+<p>æ°å¼ã¯æ°å¤ã«ãªãå¼ã§ããå¤ãã®å¼ã¯ãæ°å¤ã¨ãªãã¾ãã
+æ°å¤ã¯ä»¥ä¸ã®åã®ããããã§ãã<ul>
+<li>BIGINT</li>
+<li>DECIMAL</li>
+<li>DOUBLE PRECISION</li>
+<li>INTEGER</li>
+<li>REAL</li>
+<li>SMALLINT</li>
+</ul><table frame="all" pgwide="0"><title>æ°å¼ã®è¡¨</title>
+<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="2" colnum="1" colwidth="40*"/>
+<colspec colname="3" colnum="2" colwidth="60*"/>
+<thead>
+
+<row>
+<entry colname="2">æ¡ä»¶å¼</entry>
+<entry colname="3">æ¡ä»¶å¼ã§ã¯ããã¼ãªã¢ã³å¤ã«åºã¥ãã¦è©ä¾¡ããå¼ãé¸ã¶ãã¨ãã§ãã¾ãã</entry>
+</row>
+<row>
+<entry align="left" colname="2" valign="bottom">å¼ã®ç¨®é¡</entry>
+<entry align="left" colname="3" valign="bottom">説æ</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="2">-ã*ã/ãåä¸ã®+ã¨-ã®å¼</entry>
+<entry colname="3">
+<p>è©ä¾¡ãããã¨ããªãã©ã³ãã«å¯¾ãã¦æå¾
ãããæ¼ç®å¦çãè¡ããã¾ãããã両æ¹ã®ãªãã©ã³ããåãåã§ããã°ãçµæã®åãææ ¼ããããã¨ã¯ããã¾ãããå¾ã£ã¦æ´æ°ã«é¤ç®æ¼ç®åãé©ç¨ãããã¨ãå®éã®è¨ç®çµæã«åæ¨ã¦å¦çãè¡ããã¦æ´æ°ã¨ãªã£ãå¤ãçµæã¨ãªãã¾ãã
+ããåãæ··å¨ãã¦ããå ´åã¯ã<xref href="crefsqlj31068.dita#crefsqlj31068"></xref>ã®è¨è¿°ã«å¾ããåã®ææ ¼ãè¡ããã¾ãã</p>
+<p>åä¸ã®+ã§è¡ãããå¦çã¯ããã¾ããã(ä¾ãã°+4ã¯4ã¨åãã§ãã)åä¸ã®-ã¯ã-1ãããããã¨ã¨åãã§ããã®çµæ符å·ãå転ãã¾ãã</p></entry>
+</row>
+<row>
+<entry colname="2">AVG</entry>
+<entry colname="3">æ°å¤ã®éåããå¹³åãè¿ãã¾ãã<xref href="rrefsqlj32693.dita#rrefsqlj32693"></xref></entry>
+</row>
+<row>
+<entry colname="2">SUM</entry>
+<entry colname="3">æ°å¤ã®éåããåè¨ãè¿ãã¾ãã<xref href="rrefsqlj13083.dita#rrefsqlj13083"></xref></entry>
+</row>
+<row>
+<entry colname="2">LENGTH</entry>
+<entry colname="3">æååããããåãããæåæ°ãè¿ãã¾ãã
+<xref href="rrefsqlj16762.dita#rrefsqlj16762"></xref>ãåç
§ãã¦ãã ããã</entry>
+</row>
+<row>
+<entry colname="2">LOWER</entry>
+<entry colname="3"><xref href="rrefsqlj42049.dita#rrefsqlj42049"></xref>ãåç
§ãã¦ãã ããã</entry>
+</row>
+<row>
+<entry colname="2">COUNT</entry>
+<entry colname="3">å¤éåã®åæ°ãè¿ãã¾ãã<xref href="rrefsqlj38716.dita#rrefsqlj38716"></xref>ã<xref
+href="rrefsqlj66113.dita#rrefsqlj66113"></xref>ãåç
§ãã¦ãã ããã</entry>
+</row>
+</tbody>
+</tgroup>
+</table></p></section>
+<section><title>æåå¼</title><p>
+æåå¼ã¯çµæãCHARããã³VARCHARã®å¤ã¨ãªãå¼ã§ããå¤ãã®å¼ã®çµæãCHARããã³VARCHARã®å¤ã¨ãªãã¾ãã<table frame="all" pgwide="0"><title>æåå¼ã®è¡¨</title>
+<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="2" colnum="1" colwidth="40*"/>
+<colspec colname="3" colnum="2" colwidth="60*"/>
+<thead>
+<row>
+<entry align="left" colname="2" valign="bottom">å¼ã®ç¨®é¡</entry>
+<entry align="left" colname="3" valign="bottom">説æ</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="2">ã¯ã¤ã«ãã«ã¼ãã®ããCHARãVARCHARã®å¤</entry>
+<entry colname="3">ã¯ã¤ã«ãã«ã¼ãã®%ã_ã使ã£ã¦ãLIKEæ¼ç®åãä¸è´ããæ
å ±ãæ¢ããã¿ã¼ã³æååãä½ãã¾ãã</entry>
+</row>
+<row>
+<entry colname="2">é£çµå¼</entry>
+<entry colname="3">é£çµå¼ã«ã¦ãé£çµæ¼ç®åã®"||"ã¯ãå³è¾ºã®ãªãã©ã³ãã左辺ã®ãªãã©ã³ãã®æ«å°¾ã«é£çµãã¾ããããã¯æååããããåã«å¯¾ãã¦å©ç¨ã§ãã¾ãã
+<xref href="rrefsqlj40899.dita#rrefsqlj40899"></xref>ãåç
§ãã¦ãã ããã
+</entry>
+</row>
+<row>
+<entry colname="2">çµè¾¼ã¿ã®æååé¢æ°</entry>
+<entry colname="3">çµè¾¼ã¿ã®æååé¢æ°ã¯æååã«ä½ç¨ãã¦ãæååãè¿ãã¾ãã
+<xref href="rrefsqlj97870.dita#rrefsqlj97870"></xref>ã<xref href="rrefsqlj42049.dita#rrefsqlj42049"></xref>ã<xref
+href="rrefsqlj32613.dita#rrefsqlj32613"></xref>ã<xref href="rreftrimfunc.dita#rreftrimfunc"></xref>ã<xref href="rrefsqlj93082.dita#rrefsqlj93082"></xref>ããã¨<xref href="rrefsqlj29930.dita#rrefsqlj29930.dita"></xref>ãåç
§ãã¦ãã ããã</entry>
+</row>
+<row>
+<entry colname="2">USERé¢æ°</entry>
+<entry colname="3">Useré¢æ°ã¯ç¾å¨ã®ã¦ã¼ã¶ã«é¢ããæ
å ±ãæååã§è¿ãã¾ãã<xref href="rrefsqlj42324.dita#rrefsqlj42324"></xref>ã<xref href="rrefsqlj25228.dita#rrefsqlj25228"></xref>ããã¨
+<xref href="rrefsqlj42476.dita#rrefsqlj42476"></xref>ãåç
§ãã¦ãã ããã</entry>
+</row>
+</tbody>
+</tgroup>
+</table></p></section>
+<section><title>æ¥ä»/æå»å¼</title>
+<p>
+æ¥ä»/æå»å¼ã¯ãçµæãDATEãTIMEãTIMESTAMPã®å¤ã¨ãªãå¼ã§ãã
+å¤ãã®å¼ã®çµæãæ¥ä»/æå»ã®å¤ã¨ãªãã¾ãã
+<table frame="all" pgwide="0">
+<title>æ¥ä»/æå»å¼ã®è¡¨</title>
+<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="2" colnum="1" colwidth="30*"/>
+<colspec colname="3" colnum="2" colwidth="50*"/>
+<thead>
+<row>
+<entry align="left" colname="2" valign="bottom">å¼ã®ç¨®é¡</entry>
+<entry align="left" colname="3" valign="bottom">説æ</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="2">CURRENT_DATE</entry>
+<entry colname="3">ç¾å¨ã®æ¥ä»ãè¿ãã¾ãã<xref href="rrefsqlj34177.dita#rrefsqlj34177"></xref>ãåç
§ãã¦ãã ããã</entry>
+</row>
+<row>
+<entry colname="2">CURRENT_TIME</entry>
+<entry colname="3">ç¾å¨ã®æå»ãè¿ãã¾ãã<xref href="rrefsqlj33772.dita#rrefsqlj33772"></xref>ãåç
§ãã¦ãã ããã</entry>
+</row>
+<row>
+<entry colname="2">CURRENT_TIMESTAMP</entry>
+<entry colname="3">ç¾å¨ã®ã¿ã¤ã ã¹ã¿ã³ããè¿ãã¾ãã<xref href="rrefsqlj15866.dita#rrefsqlj15866"></xref>ãåç
§ãã¦ãã ããã</entry>
+</row>
+</tbody>
+</tgroup>
+</table></p></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj19433.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj20204.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj20204.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj20204.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj20204.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,50 @@
+<?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="rrefsqlj20204" xml:lang="ja">
+<title>æ°å¤ãç°ãªãæ°å¤åã®åã«è¨é²ãã</title>
+<refbody>
+<section><p>大ããªè¨æ¶é åãå ããæµ®åå°æ°ç¹åã®å¤ããå°ããªè¨æ¶é åã®å ´æã«ä»£å
¥ããã¨ãããã®å¤ãå°ããªè¨æ¶é åã®å ´æã«è¨é²ã§ããªãå¤ã§ããã°ã¨ã©ã¼ã¨ãªãã¾ãã
+次ã«ä¾ã示ãã¾ãã<codeblock><b>create table mytable (r REAL, d DOUBLE PRECISION);</b>
+0 rows inserted/updated/deleted
+<b>INSERT INTO mytable (r, d) values (3.4028236E38, 3.4028235E38);</b>
+ERROR X0X41: The number '3.4028236E38' is outside the range for
+the data type REAL.</codeblock></p></section>
+
+<section><p>æµ®åå°æ°ç¹åã®å¤ããINTEGERã®åã«è¨é²ã§ãã¾ããå°æ°ç¹ä»¥ä¸ã®é¨åã¯åãæ¨ã¦ããã¾ãã次ã«ä¾ã示ãã¾ãã<codeblock><b><ph>INSERT INTO mytable(integer_column) values (1.09e0);</ph>
+1 row inserted/updated/deleted
+<ph>SELECT integer_column
+FROM mytable;</ph>
+I
+---------------
+1</b></codeblock></p></section>
+<section><p>æ´æ°åã«ã¯ããã®ç¯å²å
ã§å°æ°ã®ããæ°å¤ãç½®ããã¨ãã§ãã¾ããã精度ã¯å¤±ããã¾ãã</p></section>
+<section><p>å°æ°ã®ããæ°å¤åã«ã¯ããã®ç²¾åº¦ã®ç¯å²å
ã«ããæ´æ°ãç½®ããã¨ãã§ãã¾ããä¾ãæãã¾ãã<codeblock><b>ij> <ph>insert into mytable (decimal_column)
+VALUES (55555555556666666666);</ph>
+ERROR X0Y21: The number '55555555556666666666' is outside the
+range of the target DECIMAL/NUMERIC(5,2) datatype.</b></codeblock></p></section>
+<section><p>大ããªè¨æ¶é åãå ããæ´æ°ã®å¤ããå°ããªè¨æ¶é åã«ä»£å
¥ããã¨ãããã®å¤ãå°ããªè¨æ¶é åã§ã¯è¨é²ã§ããªãã¨ããã¨ã©ã¼ã¨ãªãã¾ãã以ä¸ã«ä¾ãæãã¾ãã<codeblock><b><ph>INSERT INTO mytable (int_column) values 2147483648;</ph>
+ERROR 22003: The resulting value is outside the range for the
+data type INTEGER.</b></codeblock></p></section>
+<section> <note>NUMERICã®å¤ããå°æ°ä»¥ä¸ãåãé¤ãå ´åã<ph
+conref="../conrefs.dita#prod/productshortname"></ph>ã¯åæ¨ã¦ãè¡ãã¾ãã</note></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj20204.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj20937.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj20937.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj20937.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj20937.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,65 @@
+<?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="rrefsqlj20937" xml:lang="ja">
+<title>CREATE INDEX æ</title>
+<prolog><metadata>
+<keywords><indexterm>CREATE INDEX statement</indexterm><indexterm>Descending
+indexes</indexterm><indexterm>Indexes<indexterm>created in descending order</indexterm></indexterm>
+<indexterm>Backing indexes<indexterm>created automatically to enforce primary
+key, unique, and foreign key constraints</indexterm></indexterm><indexterm>Indexes<indexterm>automatic
+creation of for primary key, unique, and foreign key constraints</indexterm></indexterm>
+<indexterm>Indexes<indexterm>specifying page size for</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section id="i1013640"> <p id="sqlj31027">CREATE INDEXæã«ãã表ã«ç´¢å¼ãä½æã§ãã¾ãã
+ç´¢å¼ã¯è¡¨ã®ã²ã¨ã¤ä»¥ä¸ã®åã«ä½æã§ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title><codeblock><b>CREATE [UNIQUE] INDEX <i><xref
+href="rrefindexname.dita#rrefindexname">ç´¢å¼å</xref></i>
+ON <i><xref href="rreftablename.dita#rreftablename">表å</xref></i> ( <i><xref
+href="rrefsimplecolumnname.dita#rrefsimplecolumnname">åç´åå</xref></i> [ ASC | DESC ]
+ [ , <i><xref href="rrefsimplecolumnname.dita#rrefsimplecolumnname">åç´åå</xref></i> [ ASC | DESC ]] * )</b></codeblock><p>The
+<ph conref="../conrefs.dita#prod/productshortname"></ph>ã«ã¦ç´¢å¼ã«å¯è½ãªåã®æ大æ°ã¯16ã§ãã</p><p>ç´¢å¼åã¯128æåãè¶
ãã¦ã¯ãªãã¾ããã</p><p>åãåãåä¸ã®CREATE INDEXæã«2ã¤ä»¥ä¸ãã£ã¦ã¯ãªãã¾ããããªãç°ãªãç´¢å¼ã§ããã°ãåãåããã£ã¦ãã¾ãã¾ããã</p><p><ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ç´¢å¼ã使ã£ã¦ãæ
å ±ã®æä½ãè¡ãæã®å¹çãåä¸ãã¾ãã(<cite><ph
+conref="../conrefs.dita#pub/cittuning"></ph></cite>ãåç
§ãã¦ãã ããã)ã ããã«UNIQUEã®ç´¢å¼ã«ãããæ
å ±ãæ´åæ§ãä¿ã£ã¦ãããæ¤è¨¼ããäºãã§ãã¾ãã</p><p>ç´¢å¼åã¯ã¹ãã¼ãã«ã¦ä¸æã§ãã(ãã¼ã¿ãã¼ã¹ã·ã¹ãã ã«ãã£ã¦ã¯ãåãã¹ãã¼ãã®ç°ãªããã¼ãã«ã«åãååã®ç´¢å¼ãæã¤ãã¨ãã§ãã¾ããã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯éãã¾ãã)
+ç´¢å¼ã¨è¡¨ã®çæ¹ã«ã¹ãã¼ãåãæ示ããã¦ãããçæ¹ã«æ示ãããªãã£ãå ´åãç´¢å¼ã¨è¡¨ã¯åãã¹ãã¼ãã«ãããã®ã¨ããã¾ããç´¢å¼ã¨è¡¨ã®ä¸¡æ¹ã«ã¹ãã¼ãåãæ示ããã¦ãããããã®ã¹ãã¼ãåãç°ãªã£ã¦ããå ´åãä¾å¤ãçºçãã¾ãã表ã«ãç´¢å¼ã«ãã¹ãã¼ãåãæ示ãããªãã£ãå ´åãç¾å¨ã®ã¹ãã¼ãã使ããã¾ãã</p>
+<p>æ¢å®ã§<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ç´¢å¼ãããããã®åã«å¯¾ãã¦æé ã§ä½æãã¾ããååã®å¾ã«ASCã¨æ¸ãã¦ãæ¢å®ã®æ¯ãèãã¨åãããã«åä½ãã¾ãã
+ååã®å¾ã«DESCã¨æ¸ãã¨ãç´¢å¼ãä½ãã¨ãã«<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ãã®åãéé ã§æ±ãã¾ãã
+éé ãåã«æå®ãããã¨ã§ãæé ã¨éé ãæ··ãã£ã並ã³é ãããã¯éé ã®åãåããããç´¢å¼ã®ããåã®æ大å¤ãæå°å¤ãé¸æããåãåããããå¹çããå®è¡ããããã¨ãæå¾
ã§ãã¾ãã</p>
+<p>éå®ãããç´¢å¼åãæå®ããå ´åãã¹ãã¼ãåã¯<codeph>SYS</codeph>ã§å§ã¾ã£ã¦ã¯ãªãã¾ããã</p> </refsyn>
+<section id="sqlj27363"><title>ç´¢å¼ã¨å¶ç´</title><p>ä¸ææ§ã»ä¸»ãã¼ã»å¤é¨ãã¼å¶ç´ãä½æããã¨ãå¶ç´ãé©ç¨ã¾ãã¯æ¯æ´ããç´¢å¼ãä½æããã¾ãã(ãã®ãããªç´¢å¼ã®ãã¨ãæ¯æ´ç´¢å¼ã¨å¼ã³ã¾ãã)ããåãåã®éåã«ãUNIQUEãªããPRIMARY KEYã®å¶ç´ãåå¨ãã¦ããå ´åããããã®åã«ç´¢å¼ãä½æãããã¨ã¯ã§ãã¾ããã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯æ¢ã«ãã®ç´¢å¼ãã·ã¹ãã ã決ããååã§ä½æãã¦ãã¾ããå¶ç
´ãæ¯æ´ããç´¢å¼ã«ã·ã¹ãã ãä¸ããååã¯ãç´¢å¼ã®ååã§ã·ã¹ãã 表ã«åãåãããã°ãç°¡åã«è¦ã¤ãããã¨ãã§ããã§ãããã
+æ¢ã«UNIQUEã®ç´¢å¼ãåå¨ãã¦ããåã®éåã«ã主ãã¼ã¾ãã¯ä¸ææ§å¶ç´ã追å ããã¨ãåãåã®éåã«è¤æ°ã®ç´¢å¼ãé ããããã¨ã¨ãªãã¾ããä¸ã¤ããã¨ãã¨ãã£ãUNIQUEã®å¶ç´ã§ããä¸ã¤ããå¶ç´ã«ä½µãã¦ä½æãããæ¯æ´ç´¢å¼ã§ãã</p>
+<p>FLIGHTS_PKã¨ããååã®å¶ç´ãæ¯æ´ããç´¢å¼ãè¦ã¤ããã«ã¯æ¬¡ã®ããã«ãã¾ãã</p><codeblock><b>SELECT CONGLOMERATENAME FROM SYS.SYSCONGLOMERATES,
+SYS.SYSCONSTRAINTS WHERE
+SYS.SYSCONGLOMERATES.TABLEID = SYSCONSTRAINTS.TABLEID
+AND CONSTRAINTNAME = 'FLIGHTS_PK'</b></codeblock> </section>
+<example> <codeblock><b>CREATE INDEX OrigIndex ON Flights(orig_airport);
+<b>-- éé¡ã¯é常大ããªå¤ããå°ããªå¤ã®é ã§ä¸¦ã¹ãããã®ã§ã
+-- ç´¢å¼ãéé ã§ä½æãã¾ãã</b>
+CREATE INDEX PAY_DESC ON SAMP.EMPLOYEE (SALARY);
+<ph>-- ç´¢å¼ããã大ãããã¼ã¸ãµã¤ãºã§ä½æãã¾ãã</ph>
+call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize','8192');
+CREATE INDEX IXSALE ON SAMP.SALES (SALES);
+call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize',NULL);
+</b></codeblock> </example>
+<section><title>ãã¼ã¸ãµã¤ãºã¨ãã¼ãµã¤ãº</title>
+<note>ç´¢å¼ã«ãããã¼ã®åãµã¤ãºã®åè¨ã¯ããã¼ã¸ãµã¤ãºã®åå以ä¸ã§ç¡ããã°ãªãã¾ãããããæ¢åè¡ã«ä½æãããã¨ãã¦ããç´¢å¼ã®ãã¼åã®åè¨ãç´¢å¼ã®ãã¼ã¸ãµã¤ãºã®ååãã大ããªè¡ããããªãã°ãç´¢å¼ã®ä½æã¯å¤±æãã¾ãããã®ã¨ã©ã¼ã¯ç´¢å¼ãä½æããã¨ãã表ã®æ¢åè¡ãåºæºã«åããªãã¨ãã®ã¿çºçãã¾ããç´¢å¼ãä½æãããå¾ã¯ãåºæºã®ãã¼ãµã¤ãºãè¶
ãã�
�è¡ã®æ¿å
¥ã失æãã¾ãã</note> </section>
+<section><title>æã®ä¾å</title><p>SELECTãINSERTãUPDATEãUPDATE WHERE CURRENTãDELETEãDELETEã®æºåæ¸ã¿æã¯ããã®è¡¨ãCREATE INDEXæã®å¯¾è±¡ã¨ãªã£ãå ´åãç´¢å¼ã®ä½æã¨ã¨ãã«ç¡å¹ã«ãªãã¾ããä¸æ¹è¡¨ã«ã¤ãã¦éãã¦ããã«ã¼ã½ã«ã¯å½±é¿ãåãã¾ããã</p> </section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj20937.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21571.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21571.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21571.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21571.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,113 @@
+<?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="rrefsqlj21571" xml:lang="en-us">
+<title>ååã</title>
+<prolog><metadata>
+<keywords><indexterm>UNION</indexterm><indexterm>UNION ALL</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>ååãã«ãããæ¢å表ã表ã«çµè¾¼ã¿ã®å®æ°ãåºã«ãã¦ãä»®æ³çãªè¡¨ãä½ããã¾ãã</p></section>
+<refsyn><title>Syntax</title><codeblock><b>{
+ ( <i>Query</i> ) |
+<i> Query</i> INTERSECT [ ALL | DISTINCT ] <i>Query</i> |
+<i> Query</i> EXCEPT [ ALL | DISTINCT ] <i>Query</i> |
+<i> Query</i> UNION [ ALL | DISTINCT ] <i>Query</i> |
+<i> <xref href="rrefselectexpression.dita#rrefselectexpression">é¸æå¼</xref></i> | <i><xref
+href="rrefsqlj11277.dita#rrefsqlj11277">VALUESå¼</xref></i>
+}</b></codeblock>
+<p>ååãã®åå¾ã«ä»»æã§æ¬å¼§ãç½®ããã¨ãã§ãã¾ããã¾ããINTERSECTãEXCEPTãUNIONæ¼ç®åã®è©ä¾¡é ãæ¬å¼§ã使ã£ã¦å¤ãããã¨ãã§ãã¾ããINTERSECTãé¤ããããã®æ¼ç®åã¯ãæ¬å¼§ããªããã°å·¦ããå³ã«è©ä¾¡ããã¾ããINTERSECTã¯UNIONãããã¯EXCEPTããåã«è©ä¾¡ããã¾ãã</p></refsyn>
+<section><title>UNIONãINTERSECTãEXCEPT ALLã«ãããçµæã®éè¤</title>
+<p>ALLã¨DISTINCTã¨ãããã¼ã¯ã¼ãã«ããå¦ççµæããéè¤ãåãé¤ããå¦ãã決ã¾ãã¾ãã
+DISTINCTã¨ãããã¼ã¯ã¼ããããã°ãçµæã«éè¤è¡ã¯ããã¾ãããALLã¨ãããã¼ã¯ã¼ããããã°ãå
¥åã«ãã£ã¦çµæã«éè¤è¡ãããå ´åãããã¾ããæ¢å®ã¯DISTINCTãªã®ã§ãALLãDISTINCTãæå®ããªããã°éè¤ã¯åãé¤ããã¾ããä¾ãã°UNIONã®å ´åã¯ã両æ¹ã®ååãã®å
¨è¡ãå
ã«ä¸æçãª<i>ResultSet</i>ãçæããã®ã¡ãéè¤è¡ãåãé¤ãã¦ããçµæãè¿ãã¾ãããããUNION ALLãªãã°ã両æ¹ã®ååãã®å
�
�è¡ãè¿ããã¾ãã</p>
+<p> 左表ã«ããéè¤ããè¡ã®æ°ãLãå³è¡¨ã«ãã左表ã¨åãå
容ã§éè¤ããè¡ã®æ°ãRã¨ããã¨ãã©ã®æä½ãè¡ããã«ãããçµæ表ã«ããéè¤ããè¡ã®æ°ã¯æ¬¡ã®ããã«ãã¾ãã¾ãã(ALLãæå®ãããã¨ãã¾ãã)
+<ul>
+<li>UNION: ( L + R )ã</li>
+<li>EXCEPT: ( L â R )ã¨0(é¶)ã®ãã¡å¤§ããã»ã</li>
+<li>INTERSECT: Lã¨Rã®ãã¡å°ããã»ã</li>
+</ul></p></section>
+<example><title>ä¾</title><codeblock><b><ph>-- é¸æå¼ </ph>
+SELECT *
+FROM ORG
+
+<ph>-- å¯ååã </ph>
+SELECT *
+FROM (SELECT CLASS_CODE FROM CL_SCHED) AS CS
+
+-- å¯ååã
+SELECT *
+FROM (SELECT CLASS_CODE FROM CL_SCHED) AS CS (CLASS_CODE)
+
+<ph>-- UNIONã«ãã
+-- ORGã¨ãã表ã«ããå
¨è¡ã®
+-- DEPTNUMBã¨MANAGERã¨ããåã«å ãã
+-- (1,2)ã¨(3,4)ãè¿ãã
+-- ãªããDEPTNUMBã¨MANAGERã¯smallintåã®åã§ããã</ph>
+SELECT DEPTNUMB, MANAGER
+FROM ORG
+UNION ALL
+VALUES (1,2), (3,4)
+
+<ph>-- å¤ã®å¼</ph>
+VALUES (1,2,3)</b>
+<b>
+-- EMPLOYEEã¨ãã表ã«ã¦é¨ç½²çªå·(WORKDEPT)ã'E'ã§å§ã¾ã社å¡ããã³ã
+-- EMP_ACTã¨ãã表ã«ã¦ããã¸ã§ã¯ãçªå·(PROJNO)ã
+-- 'MA2100'ã'MA2110'ãããã¯'MA2112'ã®ããã¸ã§ã¯ãã«ã¢ãµã¤ã³ããã¦ãã社å¡ã®
+-- 社å¡çªå·(EMPNO)ãä¸è¦§ããã
+SELECT EMPNO
+ FROM EMPLOYEE
+ WHERE WORKDEPT LIKE 'E%'
+ UNION
+ SELECT EMPNO
+ FROM EMP_ACT
+ WHERE PROJNO IN('MA2100', 'MA2110', 'MA2112')</b>
+<b>-- åã®ä¾ã¨åãå
容ã®ååããè¡ããEMPLOYEEã¨ãã表ããå¾ãè¡ã«ã¯'emp'ã
+-- EMP_ACTã¨ãã表ããå¾ãè¡ã«ã¯'emp_act'ã¨ãã"ã¿ã°"ãã¤ããã
+-- ã©ã¡ãã®è¡¨ããæ¥ããããããã"ã¿ã°"ãããã®ã§ã
+-- ãã®ååãã¯åã®ååãã¨ã¯éããåãEMPNOãä¸åããå¤ãè¿ããã¨ãããã
+SELECT EMPNO, 'emp'
+ FROM EMPLOYEE
+ WHERE WORKDEPT LIKE 'E%'
+ UNION
+ SELECT EMPNO, 'emp_act' FROM EMP_ACT
+ WHERE PROJNO IN('MA2100', 'MA2110', 'MA2112')</b>
+<b>-- åã®ä¾ã¨ã»ã¼åãå
容ã®ååãã§ããã
+-- UNION ALLãæå®ãããã®ã§éè¤ã¯åãé¤ãããªããªãã
+SELECT EMPNO
+ FROM EMPLOYEE
+ WHERE WORKDEPT LIKE 'E%'
+ UNION ALL
+ SELECT EMPNO
+ FROM EMP_ACT
+ WHERE PROJNO IN('MA2100', 'MA2110', 'MA2112')</b>
+<b>-- åã®ä¾ã¨ã»ã¼åãå
容ã®ååãã§ããã
+-- ãããã®è¡¨ã«ãããªãäºäººã®ç¤¾å¡ãå ãã¦ã
+-- ãã®è¡ã«"new"ã¨ããã¿ã°ãã¤ããã
+ SELECT EMPNO, 'emp'
+ FROM EMPLOYEE
+ WHERE WORKDEPT LIKE 'E%'
+ UNION
+ SELECT EMPNO, 'emp_act'
+ FROM EMP_ACT
+ WHERE PROJNO IN('MA2100', 'MA2110', 'MA2112')
+ UNION
+ VALUES ('NEWAAA', 'new'), ('NEWBBB', 'new')</b></codeblock> </example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21571.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21583.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21583.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21583.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21583.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,54 @@
+<?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="rrefsqlj21583" xml:lang="ja">
+<title>FROM ç¯</title>
+<prolog><metadata>
+<keywords><indexterm>FROM clause</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section>
+<p>FROMç¯ã¯<i><xref href="rrefselectexpression.dita#rrefselectexpression">é¸æå¼</xref></i>ã«å¿
è¦ã§ãããã®ç¯ã«ãããåãåããæã«ããä»ç¯ã®å¼ã«ã¦ãå©ç¨å¯è½ãªåã®ãã表ãåç
§ãã¾ãã</p></section>
+
+<refsyn><title>æ§æ</title> <codeblock><b>FROM è¡¨å¼ [ , è¡¨å¼ ] *</b></codeblock> </refsyn>
+<example> <codeblock><b>SELECT Cities.city_id
+FROM Cities
+WHERE city_id < 5
+<ph>-- ä»ç¨®ã®è¡¨å¼</ph>
+SELECT TABLENAME, ISINDEX
+FROM SYS.SYSTABLES T, SYS.SYSCONGLOMERATES C
+WHERE T.TABLEID = C.TABLEID
+ORDER BY TABLENAME, ISINDEX
+<ph>-- çµåé ãæå®ãã</ph>
+SELECT *
+FROM Flights, FlightAvailability
+WHERE FlightAvailability.flight_id = Flights.flight_id
+AND FlightAvailability.segment_number = Flights.segment_number
+AND Flights.flight_id < 'AA1115'
+<ph>-- 表å¼ã¯çµåå¼ã¨ãããã¨ãã§ãã¾ãã
+--ãããã£ã¦ãFROMå¥ã«ã¯è¤æ°ã®çµåå¼ãç½®ãäºãã§ãã¾ãã</ph>
+SELECT COUNTRIES.COUNTRY, CITIES.CITY_NAME, FLIGHTS.DEST_AIRPORT
+FROM COUNTRIES LEFT OUTER JOIN CITIES
+ON COUNTRIES.COUNTRY_ISO_CODE = CITIES.COUNTRY_ISO_CODE
+LEFT OUTER JOIN FLIGHTS
+ON Cities.AIRPORT = FLIGHTS.DEST_AIRPORT</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21583.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21908.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21908.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21908.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21908.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,41 @@
+<?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="rrefsqlj21908" xml:lang="ja">
+<title>TIMEãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>TIME data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>TIMEã§ã¯æå»ãè¨é²ããé åãæä¾ããã¾ãã</p></section>
+<refsyn><title>æ§æ</title><codeblock><b>TIME</b></codeblock> </refsyn>
+<section><title>対å¿ããã³ã³ãã¤ã«æã®Javaã®å</title><p><i>java.sql.Time</i></p> </section>
+<section><title>JDBC ã¡ã¿ãã¼ã¿å (java.sql.Types)</title><p>TIME</p>
+<p>æ¥ä»ã»æå»ã»ã¿ã¤ã ã¹ã¿ã³ããCASTãªãã§å¼ã«æ··å¨ããããã¨ã¯ã§ãã¾ããã</p>
+<p>SQLã®æ¥ä»/æå»ã®ãã¼ã¿åã§ã¯ã<i>java.sql.Time</i>ã®ã¡ã½ããã§èªèã§ããå¤ãå
¨ã¦è¨±ããã¾ãã<ph
+conref="../conrefs.dita#prod/productshortname"></ph>ã¯æå»ã«ã¤ãã¦ã以ä¸ã®æ¸å¼ãç¨æãã¾ãã<codeblock>hh:mm[:ss]
+hh.mm[.ss]
+hh[:mm] {AM | PM}</codeblock>ä¸è¨ã®ä¸ã¤ã®ãã¡æåã®æ¸å¼ã¯<i>java.sql.Time</i>ã®æ¸å¼ã§ãã</p>
+<p>æã¯ä¸æåãããã¯äºæåã®æ°åã§ããåã¨ç§ããããªãããããã¯äºæåã®æ°åã§è¡¨ãããªããã°ãªãã¾ããã</p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ããã¼ã¿ãã¼ã¹ãµã¼ãã®ãã±ã¼ã«ã«ç¹æãªæ¥æã®æ¸å¼ãåãä»ãã¾ããããæèãææ§ã«ãªãå ´åãçµè¾¼ã¿ã®æ¸å¼ãåªå
ããã¾ãã</p> </section>
+<example> <title>ä¾</title><codeblock><b>VALUES TIME('15:09:02')
+VALUES '15:09:02'</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj21908.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj23075.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj23075.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj23075.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj23075.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,169 @@
+<?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="rrefsqlj23075" xml:lang="ja">
+<title>çå½å¼</title>
+<prolog><metadata>
+<keywords><indexterm>Boolean expressions</indexterm><indexterm>Boolean operators<indexterm>part
+of WHERE clause</indexterm></indexterm><indexterm>AND boolean operator</indexterm>
+<indexterm>OR boolean operator</indexterm><indexterm>NOT boolean operator</indexterm>
+<indexterm>Comparison boolean operators</indexterm><indexterm>IS NULL boolean
+operator</indexterm><indexterm>IS NOT NULL boolean operator</indexterm><indexterm>LIKE
+boolean operator</indexterm><indexterm>LIKE<indexterm>escape character for</indexterm></indexterm>
+<indexterm>BETWEEN boolean operator</indexterm><indexterm>IN boolean operator</indexterm>
+<indexterm>EXISTS boolean operator</indexterm><indexterm>Quantified comparison
+boolean operator</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section><p>çå½å¼ã¯WHEREç¯ããã§ãã¯å¶ç´ã«ç½®ããã¨ãã§ãã¾ãã
+ãã§ãã¯å¶ç´ã«ç½®ãçå½å¼ã«ã¯ãããã§è¨è¿°ããã¦ããªãå¶éãããã¾ãã
+詳細ã¯<xref href="rrefsqlj13590.dita#rrefsqlj13590"></xref>ãåç
§ãã¦ãã ããã
+WHEREç¯ã«ç½®ãçå½å¼ã®æ§æã¯æè»ãªãã®ã¨ãªã£ã¦ãã¾ããå
·ä½çãªä¾ã¯ã<xref
+href="rrefsqlj33602.dita#rrefsqlj33602">WHEREç¯</xref>ãåç
§ãã¦ãã ããã
+</p></section>
+<section><p>çå½å¼ã«ã¯ãã¼ãªã¢ã³æ¼ç®åãä¸ã¤ä»¥ä¸ç½®ããã¨ãã§ãã¾ãã
+ãã®æ¼ç®åã¯<xref href="rrefsqlj23075.dita#rrefsqlj23075/sqlj34517"></xref>ã«ä¸è¦§ããã¦ãã¾ãã
+<table frame="all" id="sqlj34517" pgwide="1">
+<title>SQL ã®ãã¼ãªã¢ã³æ¼ç®å</title>
+<tgroup cols="3" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="24*"/>
+<colspec colname="2" colnum="2" colwidth="45*"/><colspec colname="3" colnum="3"
+colwidth="30*"/>
+<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>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="1">AND, OR, NOT</entry>
+<entry colname="2">ãªãã©ã³ãã«ã¨ãçå½å¼ãè©ä¾¡ãã¾ãã <codeblock><b>(orig_airport = 'SFO') OR
+ (dest_airport = 'GRU')
+<ph> -- çãè¿ãã</ph></b></codeblock></entry>
+<entry colname="3"> <codeblock><b>{
+<b><i> å¼</i></b> AND
+<b><i> å¼</i></b>|
+<b><i> å¼</i></b> OR
+<b><i> å¼</i></b> |
+ NOT <b><i>å¼</i></b>
+}</b></codeblock></entry>
+</row>
+<row>
+<entry colname="1">æ¯è¼æ¼ç®å</entry>
+<entry colname="2"><, =, >, <=, >=, <> ã¯ãå
¨ã¦ã®çµã¿è¾¼ã¿ã®åã«é©ç¨ãããã¨ãã§ãã¾ãã <codeblock><b>DATE('1998-02-26') <
+ DATE('1998-03-01')
+<ph>-- çãè¿ãã</ph></b></codeblock></entry>
+<entry colname="3"> <codeblock><b><b><i>å¼</i></b>
+{
+ < |
+ = |
+ > |
+ <= |
+ >= |
+ <>
+}
+<b><i>å¼</i></b></b></codeblock></entry>
+</row>
+<row>
+<entry colname="1">IS NULL, IS NOT NULL</entry>
+<entry colname="2">å¼ã®çµæã空ãããã§ãªãããå¤å®ãã¾ãã
+ <codeblock><b>WHERE MiddleName IS NULL</b></codeblock></entry>
+<entry colname="3"> <codeblock><b><b><i>å¼</i></b> IS [ NOT ]
+ NULL</b></codeblock></entry>
+</row>
+<row>
+<entry colname="1">LIKE</entry>
+<entry colname="2">æåå¼ãæåãã¿ã¼ã³ã¨ä¸è´ããããå¤å®ãã¾ããæåãã¿ã¼ã³ã«ã¯ä¸ã¤ä»¥ä¸ã®ã¯ã¤ã«ãã«ã¼ããå«ã¾ãã¾ãã
+ <p>%ã¯æåã®æåå¼ã«ã¦ã該å½ããä½ç½®ã®ä»»æã®æåæ°(0æå以ä¸)ã®æååã«ä¸è´ãã¾ãã</p>
+<p>_ã¯æåå¼ã«ã¦ã該å½ããä½ç½®ã®ä¸æåã«ä¸è´ãã¾ãã</p>
+<p>ãã以å¤ã®æåã¯ãæåå¼ã«ã¦è©²å½ããä½ç½®ã®åãæåã«ä¸è´ãã¾ãã<codeblock><b>city LIKE 'Sant_'</b></codeblock></p>
+<p>%ã_ãã¯ã¤ã«ãã«ã¼ãã§ã¯ãªãæåã¨ããã«ã¯ãESCAPEç¯ã§æå®ããã¨ã¹ã±ã¼ãæåã使ã£ã¦æåãã¨ã¹ã±ã¼ããã¾ãã
+<codeblock><b>SELECT a FROM tabA WHERE a
+LIKE '%=_' ESCAPE '='</b></codeblock></p>
+<note>
+LIKEã«ããæ¯è¼ã§ã¯<?Pub Caret?><ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ãåã
ã®æåãéã¡ã¿æåã¨æ¯è¼ãã¾ããããã¯<ph conref="../conrefs.dita#prod/productshortname"></ph>ã=ã«ããæ¯è¼ã®ã¨ãè¡ãå¦çã¨ã¯éãã¾ãã=ã«ããæ¯è¼ã§ã¯å·¦è¾ºã®æååå
¨ä½ãã=æ¼ç®åã®å³è¾ºã®æååå
¨ä½ã¨æ¯è¼ããã¾ãããã詳細ãªæ
å ±ã«ã¤ãã¦ã¯ã<ph conref="../conrefs.dita#pub/citdevelop"></ph>ã®<b><ph conref="../conrefs.dita#prod/productshortname"></ph>ã«ãããæåã®ç
§å</b>ãåç
§ãã¦ãã ããã</note>
+</entry>
+<entry colname="3"> <codeblock><b><b><i>æåå¼</i></b>
+ [ NOT ] LIKE
+<b><i> ã¯ã¤ã«ãã«ã¼ãã®ããæåå¼</i></b>
+ [ ESCAPE
+
+'<b><i>ã¨ã¹ã±ã¼ãæå</i></b>']</b></codeblock></entry>
+</row>
+<row>
+<entry colname="1">BETWEEN</entry>
+<entry colname="2">æåã®ãªãã©ã³ããäºã¤ç®ã¨ä¸ã¤ç®ã®ãªãã©ã³ãã®éã®å¤ã§ããããå¤å®ãã¾ããäºã¤ç®ã®ãªãã©ã³ãã¯ä¸ã¤ç®ã®ãªãã©ã³ãããå°ããªå¤ã§ãªããã°ãªãã¾ããã
+ãã®æ¼ç®åã¯<=ã¨>=ãé©ç¨ã§ããåã«å¯¾ãã¦ã®ã¿é©ç¨ã§ãã¾ãã
+<codeblock><b>WHERE booking_date BETWEEN
+ DATE('1998-02-26') AND
+ DATE('1998-03-01')</b></codeblock></entry>
+<entry colname="3"> <codeblock><b><b><i>å¼</i></b> [ NOT ]
+BETWEEN <b><i>å¼</i></b>
+ AND <b><i>å¼</i></b></b></codeblock></entry>
+</row>
+<row>
+<entry colname="1">IN</entry>
+<entry colname="2">表å¯ååããå¤ã®ä¸¦ã³ã«ä½ç¨ãã¾ãã左辺ã®å¼ã®å¤ã表å¯ååããå¤ã®ä¸¦ã³ã«å«ã¾ãããªãã°ãçãè¿ãã¾ãããªãã表å¯ååãã¯è¤æ°è¡ãè¿ãã¦ãã¾ãã¾ããããåã¯ä¸ã¤ã§ãªããã°ãªãã¾ããã<codeblock><b>WHERE booking_date NOT IN
+ (SELECT booking_date FROM
+HotelBookings WHERE rooms_available = 0)</b></codeblock></entry>
+<entry colname="3"> <codeblock><b>{
+<b><i> å¼</i></b> [ NOT ]
+ IN
+ <b><i><xref href="rreftablesubquery.dita#rreftablesubquery">表å¯ååã</xref></i></b> |
+<b><i> å¼</i></b> [ NOT ]
+ IN ( <b><i>å¼</i></b>
+ [, <b><i>å¼</i></b> ]* )
+}</b></codeblock></entry>
+</row>
+<row>
+<entry colname="1">EXISTS</entry>
+<entry colname="2">表å¯ååãã«ä½ç¨ãã¦ããã®è¡¨å¯ååããè¡ãè¿ããªãã°çãè¿ããè¡ãè¿ããªããªãã°å½ãè¿ãã¾ãã表å¯ååãã¯è¤æ°ã®å(*ã使ã£ãå ´åã«éãã¾ãã)ãè¡ãè¿ããã¨ãã§ãã¾ãã<codeblock><b>WHERE EXISTS
+ (SELECT *
+ FROM Flights
+ WHERE dest_airport = 'SFO'
+ AND orig_airport = 'GRU')</b></codeblock></entry>
+<entry colname="3"> <codeblock><b>[NOT] EXISTS <b><i><xref href="rreftablesubquery.dita#rreftablesubquery">表å¯ååã</xref></i></b></b></codeblock></entry>
+</row>
+<row>
+<entry colname="1">å®éæ¯è¼</entry>
+<entry colname="2">å®éæ¯è¼ã¯ALLãANYãSOMEã®ä½ãããé©ç¨ãããæ¯è¼æ¼ç®å
+(<,=, >, <=, >=, <>)ã¨ãªãã¾ãã
+<p>
+ããã¯è¡¨å¯ååãã«ä½ç¨ãã¾ãã表å¯ååãã¯è¤æ°ã®è¡ãè¿ããã¨ãã§ãã¾ãããåä¸ã®åããè¿ãã¾ããã</p>
+<p>ALLãæå®ãããå ´åã表å¯ååããè¿ãå
¨ã¦ã®å¤ã«å¯¾ãã¦ãæ¯è¼ã®çµæãçã§ãªããã°ãªãã¾ãããANYãªããSOMEãæå®ãããå ´åã表å¯ååããè¿ãä½ããã®å¤ã«å¯¾ãã¦ãæ¯è¼ã®çµæãçã§ããå¿
è¦ãããã¾ããANYã¨SOMEã¯åãæå³ã§ãã
+ <codeblock><b>WHERE normal_rate < ALL
+(SELECT budget/550 FROM Groups) </b></codeblock></p></entry>
+<entry colname="3"> <codeblock><b><b><i>å¼</i></b>
+ æ¯è¼æ¼ç®å
+ {
+ ALL |
+ ANY |
+ SOME
+ }
+ <b><i><xref href="rreftablesubquery.dita#rreftablesubquery">表å¯ååã</xref></i></b></b></codeblock></entry>
+</row>
+</tbody>
+</tgroup>
+</table></p></section>
+</refbody>
+</reference>
+<?Pub *0000008541?>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj23075.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native