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 [18/26] - in /db/derby/docs/trunk: ./ src/ja_JP/
src/ja_JP/ref/
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13083.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13083.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13083.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13083.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,45 @@
+<?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="rrefsqlj13083" xml:lang="ja">
+<title>SUMé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>SUM aggregate function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>SUM ã¯è¡ã®éåã«æ¸¡ã£ã¦åè¨å¤ãè¨ç®ããéç´é¢æ°ã§ãã(<xref href="rrefsqlj33923.dita#rrefsqlj33923"></xref>ãåç
§ãã¦ãã ããã)
+SUMã¯æ°å¤åã®å¼ã«å¯¾ãã¦ã®ã¿ãé©ç¨ãããã¨ãã§ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>SUM ( [ DISTINCT | ALL ] <i>å¼</i> )</b></codeblock>
+<p>DISTINCTããã³ALLã«ãããéè¤ãåãé¤ããããçãããã§ãã¾ããããALLãDISTINCTãããããªãã£ãå ´åãALLãæå®ããããã®ã¨ã¿ãªãã¾ããä¾ãã°ãåã«1ã1ã1ã1ã2ã¨ããå¤ãããã¨ãã¦ãSUM(col)ã¯SUM(DISTINCT col)ãã大ããªå¤ãè¿ãã¾ãã</p>
+<p><i><xref href="rrefselectexpression.dita#rrefselectexpression">é¸æå¼</xref></i>ã«ã¯ãDISTINCTãå¯ä¸ã¤ç½®ããã¨ãã§ãã¾ããä¾ãã°æ¬¡ã®ååãã¯ä¸å¯ã§ãã<codeblock><b>SELECT AVG (DISTINCT flying_time), SUM (DISTINCT miles)
+FROM Flights</b></codeblock></p>
+<p><i>å¼</i>ã«ã¯è¤æ°ã®åã¸ã®åç
§ãå¼ãç½®ããã¨ãã§ãã¾ãããä»ã®éç´ãå¯ååããç½®ããã¨ã¯ã§ãã¾ãããã¾ãè©ä¾¡ããçµæã¯çµè¾¼ã¿ã®æ°å¤åã§ãªããã°ãªãã¾ãããããå¼ãNULLã¨è©ä¾¡ãããå ´åãéç´ã¯ãã®å¤ãç¡è¦ãã¾ãã</p>
+<p>é¢æ°ã®çµæã®åã¯ãé¢æ°ãä½ç¨ãã¦ããå¼ã®åã¨åãã§ãã(ãªã¼ãã¼ããã¼ããå¯è½æ§ãããã¾ãã)</p> </refsyn>
+<example> <codeblock><b>-- å
¨ã¦ã®ã¨ã³ããã¼ã·ã¼ããæ°ãã¾ãã
+SELECT SUM (economy_seats) FROM Airlines;
+
+-- SUMãè¤æ°ã®åã¸ã®åç
§ã«ä½¿ãã¾ãã
+-- (è³¼å
¥ãããå¼ã®åè¨ãè¨ç®ãã¾ãã)
+SELECT SUM (economy_seats_taken + business_seats_taken + firstclass_seats_taken)
+as seats_taken FROM FLIGHTAVAILABILITY;
+</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13083.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13590.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13590.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13590.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13590.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,219 @@
+<?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="rrefsqlj13590" xml:lang="ja">
+<title>CONSTRAINT ç¯</title>
+<prolog><metadata>
+<keywords><indexterm>CONSTRAINT clause</indexterm><indexterm>Constraints</indexterm><indexterm>Storage
+properties<indexterm>for indexes backing constraints</indexterm></indexterm><indexterm>Backing
+indexes<indexterm>specifying storage properties for</indexterm></indexterm><indexterm>Tables<indexterm>specifying
+page size for</indexterm><indexterm>specifying properties for</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>CONSTRAINTç¯ã¯ã<xref href="rrefsqlj24513.dita#rrefsqlj24513">CREATE TABLE æ</xref>ã<xref
+href="rrefsqlj81859.dita#rrefsqlj81859">ALTER TABLE æ</xref>ã«ä»»æã«è¨è¿°ã§ããæ§é ã§ããå¶ç´ã¨ã¯ãã¼ã¿ãå¾ããªããã°ãªããªãè¦åã§ããå¶ç´ã«ã¯å¿
è¦ã«å¿ãã¦ååãä¸ãããã¨ãã§ãã¾ãã</p>
+<p>å¶ç´ã¯ä»¥ä¸ã®ããããã§ãã<ul>
+<li><indexterm>Column-level constraints</indexterm><indexterm>Constraints<indexterm>column-level</indexterm></indexterm>åã¬ãã«ã®å¶ç´<p>åã¬ãã«ã®å¶ç´ã¯è¡¨ã«ããåä¸ã®åãåç
§ãã¾ããååãæå®ããããã§ã¯ãªãã¾ããã(ãã ããã§ãã¯å¶ç´ã¯é¤ãã¾ãã)ãã®å¶ç´ã¯å¯¾è±¡ã®åãåç
§ãã¦ãã¾ãã</p></li>
+<li><indexterm>Table-level constraints</indexterm><indexterm>Constraints<indexterm>table-level</indexterm></indexterm>表ã¬ãã«ã®å¶ç´ <p>表ã¬ãã«ã®å¶ç´ã¯è¡¨ã«ããä¸ã¤ãããã¯ãã以ä¸ã®åãåç
§ãã¾ãã表ã¬ãã«ã®å¶ç´ã¯é©ç¨ããåã®ååãåç
§ãã¾ãã表ã¬ãã«ã®ãã§ãã¯å¶ç´ã¯0以ä¸ã®åãåç
§ãã¾ãã</p></li>
+</ul></p>
+<p><indexterm>Column-level constraints<indexterm>used in CREATE
+TABLE statement</indexterm></indexterm><indexterm>Constraints<indexterm>column-level</indexterm></indexterm>åå¶ç´ã«ã¯ä»¥ä¸ãããã¾ãã
+<ul>
+<li>NOT NULL <p>ãã®åã®å¤ã¯NULLã«ã§ããªããã¨ãæå®ãã¾ãã(ãã®ç¨®é¡ã®å¶ç´ã«ã¯ååãä¸ãããã¨ãã§ãã¾ããã)</p></li>
+<li>PRIMARY KEY<indexterm>Primary keys<indexterm>creating</indexterm><indexterm>adding</indexterm></indexterm>
+ <p>åã«ãã表ä¸ã®è¡ãä¸æã«èå¥ããããã¨ãæå®ãã¾ããåã®å¤ã¯NOT NULLã¨å®ç¾©ãããªããã°ãªãã¾ããã</p>
+<note>ALTER TABLEã«ãã主ãã¼ã追å ãããã¨ãã¦ã空ã®å¤ãæã¤åããã®ä¸»ãã¼ã«å«ãããã¨ããå ´åãã¨ã©ã¼ã¨ãªã£ã¦ä¸»ãã¼ã¯è¿½å ããã¾ããããã詳細ãªæ
å ±ã¯ã<xref href="rrefsqlj81859.dita#rrefsqlj81859"></xref>ãåç
§ãã¦ãã ããã</note></li>
+<li>UNIQUE <p>åã®å¤ãä¸æã§ãªããã°ãªããªãã¨æå®ãã¾ããNULLã®å¤ã¯ä¸å¯ã§ãã</p></li>
+<li>FOREIGN KEY <p>åã®å¤ããåç
§å
ã®ä¸»ãã¼ãä¸æãã¼ãããã¯NULLã§ãªããã°ãªããªããã¨ãæå®ãã¾ãã</p></li>
+<li>CHECK <p>åã®å¤ã®è¦åãæå®ãã¾ãã</p></li>
+</ul></p> <p><indexterm>Table constraints<indexterm>used in CREATE TABLE statement</indexterm></indexterm><indexterm>Constraints<indexterm>table-level</indexterm
+></indexterm>
+表å¶ç´ã«ã¯ä»¥ä¸ãããã¾ãã<ul>
+<li>PRIMARY KEY<indexterm>Primary keys<indexterm>creating</indexterm><indexterm>adding</indexterm></indexterm>
+<p>
+ä¸ã¤ä»¥ä¸ã®åã«ãã表ã®è¡ãä¸æã«èå¥ããããã¨ã表ãã¾ããNULLã®å¤ã¯ä¸å¯ã§ãã</p></li>
+<li>UNIQUE <p>å群ã®å¤ãä¸æã§ããã¨æå®ãã¾ããåã¯NOT NULLã¨å®ç¾©ãããªããã°ãªãã¾ããã</p></li>
+<li>FOREIGN KEY <p>å群ã®å¤ãåç
§å
ã®ä¸»ãã¼ãä¸æåãããã¯NULLã§ãªããã°ãªããªããã¨ãæå®ãã¾ãã</p>
+<note>å¤é¨ãã¼ãè¤æ°ã®åããæ§æããã¦ããå ´åã<i>ä½ããã®</i>åãNULLã§ãããªããã¼ã¯NULLã¨è¦ãªããã¾ããNULLã§ãªãåã«ã©ã®ãããªå¤ããã£ã¦ããæ¿å
¥ãããã¨ãã§ãã¾ãã</note></li>
+<li>CHECK <p>表ã®å¤ã«é©ç¨ãããæ§ã
ãªè¦åãæå®ãã¾ãã</p></li>
+</ul></p> <p><indexterm>Constraints<indexterm>differences between column-level
+and table-level</indexterm></indexterm>
+åå¶ç´ã¨è¡¨å¶ç´ã¯åãæ©è½ãæã¡ã¾ãããä½ã«å¯¾ãã¦æå®ã§ããããéãã¾ãã表å¶ç´ã§ã¯ä¸ã¤ä»¥ä¸ã®åã«å¯¾ãã¦ãPRIMARY KEYãUNIQUEãCHECKãFOREIGN KEYå¶ç´ãå®ç¾©ã§ãã¾ããåã¬ãã«ã®å¶ç´ã§ã¯(ãã§ãã¯å¶ç´ãé¤ãã¦)ãä¸ã¤ã®åã¸ã®åç
§ããå®ç¾©ã§ãã¾ããã</p></section>
+<refsyn><title>æ§æ</title> </refsyn>
+<section><title>主ãã¼ã¨ä¸ææ§å¶ç´</title>
+<p><indexterm>Primary
+key constraints</indexterm><indexterm>Unique constraints</indexterm>
+主ãã¼ã§ã¯è¡¨ã®è¡ãä¸æã«æå®ããåã®éåãå®ç¾©ããã¾ãã</p>
+<p>主ãã¼å¶ç´ãå®ç¾©ãããå ´åã主ãã¼ã«å«ã¾ããä½ãã®åã®å¤ãNULLã§ãã£ã¦ã¯ãªãã¾ãããã¤ã¾ãä½ãã®åãNULLå¤ãã¨ããã¨ãã§ããªããªãã¾ãã</p>
+<p>ãããããNOT NULLã¨å®ç¾©ããã¦ãããªããæ¢åã®åãALTER
+TABLE ADD PRIMARY KEY ã¨ããæã§ä¸»ãã¼ã«å ãããã¨ãã§ãã¾ããNULLã®å¤ã¯ä¸å¯ã§ããããåã«NULLå¤ãããã°ãã·ã¹ãã ã¯ä¸»ãã¼å¶ç´ã®è¿½å ãè¡ãã¾ããã詳細ãªæ
å ±ã¯<xref href="rrefsqlj81859.dita#rrefsqlj81859"></xref>ãåç
§ãã¦ãã ããã</p>
+<p>表ã«ã¯PRIMARY KEYå¶ç´ãä¸ã¤ã¾ã§ããå®ç¾©ã§ãã¾ããããããè¤æ°ã®UNIQUEå¶ç´ãå®ç¾©ãããã¨ã¯ã§ãã¾ãã</p> </section>
+<section><title>å¤é¨ãã¼å¶ç´</title> <p><indexterm>Foreign keys</indexterm><indexterm>Referential
+integrity<indexterm>via foreign keys</indexterm></indexterm>
+å¤é¨ãã¼å¶ç´ã«ããããã¼ã¿ãã¼ã¹ã®åç
§æ´åæ§ãå¼·å¶ãããã¨ãã§ãã¾ããå¤é¨ãã¼ã¨ã¯ä»ã®è¡¨ã®ãã¼ãåç
§ããåãããã¯å群ã§ãã(æã«ãã£ã¦ã¯ãã¾ãå¤ããã¨ã§ã¯ããã¾ããããåã表ãåç
§ãããã¨ãããã¾ãã)å¤é¨ãã¼ã¯åç
§å
ã®ä¸»ãã¼å¶ç´ã»å¤é¨ãã¼å¶ç´ã«ä¸è´ãããã¼ã¿åãæã¤åãæããªããã°ãªãã¾ããã</p>
+<p>表ã¬ãã«ã®å¤é¨ãã¼å¶ç´ã§ã¯ã表ã®åãæå®ãã¦å¶ç´ãå®ç¾©ãã¾ãããã®ã¨ãåãåãä¸åããå¤ã使ããã¨ã¯ã§ãã¾ããã</p>
+<p><i>åç
§å®ç¾©</i>(åç
§ããã表ã®åã®ä¸è¦§ã§ãã)ã«åãå®ç¾©ãããå ´åãããã¯åç
§å
ã®è¡¨ã«ããä¸ææ§å¶ç´ãããã¯ä¸»ãã¼å¶ç´ã«å¯¾å¿ãã¦ããªããã°ãªãã¾ããã
+ãã表ã«ä¸ææ§å¶ç´ããããªãã<i>åç
§å®ç¾©</i>ã§ã¯åã®ä¸è¦§ãçããã¨ãã§ãã¾ãã</p>
+<p>ãã<i>åç
§å®ç¾©</i>ã«ã¦åã®ä¸è¦§ãæå®ããã¦ããããåç
§å
ã®è¡¨ã«ä¸»ãã¼ãå®ç¾©ããã¦ããªããªãã°ãä¾å¤ãæããã¾ãã(ãã®ä¾å¤ã¯ãããåç
§å
ã®è¡¨ã«ä¸ææ§å¶ç´ãããªããªãã°ããã®åã®ä¸è¦§ã<i>åç
§å®ç¾©</i>ã«å«ããªããã°ãªããªããã¨ããæå³ã§ãã)</p>
+<p>åç
§å
ã®ä¸ææ§å¶ç´ãããã¯ä¸»ãã¼å¶ç´ã«ä¸è´ããå¤ãããã°ãå¤é¨ãã¼å¶ç´ã¯å®ããã¦ãããã®ã¨ããã¾ããããå¤é¨ãã¼å¶ç´ãè¤æ°ã®åã§å®ç¾©ããã¦ãããããããã®åãNULLã§ãããªããå¤é¨ãã¼ã®å¤ã¯NULLã¨ã¿ãªããã¾ãã
+ <note>SQL-92æ¨æºã«ã¦è¨åãããããã«ãè¤æ°ã®åã§å®ç¾©ãããå¤é¨ãã¼å¶ç´ã§ã¯ãå¶ç´ãããåãåç
§å
ã®åã«ãªãå¤ãã¨ããã¨ãå¯è½ãªå ´åãããã¾ãããã®ç¶æ³ãåé¿ããããã«å¤é¨ãã¼ã®å
¨åã«ã¯NOT NULLå¶ç´ãå®ç¾©ããã¹ãã§ãã</note></p> </section>
+<section><title>å¤é¨ãã¼å¶ç´ã¨DML</title>
+<p>æå¹ã«ãªã£ã¦ããå¤é¨ãã¼å¶ç´ãå®ç¾©ããã表ã«æ¿å
¥ãæ´æ°ãè¡ãããã¨ãã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ãã®è¡ãå¤é¨ãã¼å¶ç´ãç ´ã£ã¦ããªããç¥ãããã«ãåç
§å
ã®è¡¨ã§å¯¾å¿ããåç
§ãã¼ã®å¤ã調æ»ãã¾ãã
+ããå¶ç´ãå®ããã¦ããªããã°ã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ä¾å¤ãæãã¦ãæ¿å
¥ãªããæ´æ°ãå´ä¸ãã¾ãã</p>
+<p>åç
§ããããã¼(å¤é¨ãã¼ã«ããåç
§ãããã主ãã¼å¶ç´ãããã¯ä¸æå¶ç´)ã®ãã表ã®è¡ããæ´æ°ã¾ãã¯åé¤ããå ´åã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ãã®ãã¼ãåç
§ãããã¹ã¦ã®å¤é¨ãã¼å¶ç´ã調ã¹ã¦ãè¡ã®åé¤ãå¤æ´ãå¶ç´éåãå¼ãèµ·ãããªãã調æ»ãã¾ãã
+ããè¡ã¸ã®åé¤ãå¤æ´ãå¶ç´éåãå¼ãèµ·ããã®ã§ããã°ãå¤æ´ãåé¤ã¯è¨±å¯ããã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ä¾å¤ãæãã¾ãã</p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph>ãå¶ç´ã®ãã§ãã¯ãè¡ãã®ã¯æãå®è¡ãããæã§ãããã©ã³ã¶ã¯ã·ã§ã³ãã³ããããããæã§ã¯ããã¾ããã</p> </section>
+<section><title>æ¯æ´ããç´¢å¼</title> <p><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>
+UNIQUEãPRIMARY KEYãFOREIGN KEYã®åå¶ç´ã¯å¶ç´ãå¼·å¶ãããã¯æ¯æ´ããããã®ç´¢å¼ãçæãã¾ãã(ããã¯<i>æ¯æ´ç´¢å¼</i>ã¨å¼ã°ãããã¨ãããã¾ãã)
+UNIQUEå¶ç´ã¨PRIMARY KEYå¶ç´ã¯ä¸æç´¢å¼ãçæãã¾ããFOREIGN KEYç´¢å¼ã¯éä¸æãªç´¢å¼ãä½æããã¾ãããããã£ã¦ãåãåã®éåã«UNIQUEå¶ç´ãPRIMARY KEYå¶ç´ãFOREIGN KEYç´¢å¼ãå®ç¾©ããã¦ããå ´åã¯ãããã©ã¼ãã³ã¹åä¸ã®ããã®ç´¢å¼ããããã®åã«ä½æããå¿
è¦ã¯ããã¾ããã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã代ããã«ä½æãã¦ããã¦ãã¾ãã<xref href="rrefsqlj20937.dita#rrefsqlj20937/sqlj27363"></xref>ãåç
§ãã¦ãã ããã</p>
+<p>åãåãããæé©åãããæã«ãªããã£ãã¤ã¶ã¯ãããã®ç´¢å¼ãå©ç¨ã§ãã¾ãã(<xref href="rrefsqlj20937.dita#rrefsqlj20937"></xref>ãåç
§ãã¦ãã ããã)ã¾ããããã®ç´¢å¼ã¯ã·ã¹ãã ãèªåçã«çæããååãæã¡ã¾ãã</p> <p>æ¯æ´ç´¢å¼ã¯DROP INDEXæã§ã¯ç ´æ£ã§ãã¾ãããå¶ç´ãç ´æ£ãããã表ãç ´æ£ããå¿
è¦ãããã¾ãã</p> </section>
+<section><title>ãã§ãã¯å¶ç´</title> <p><indexterm>Check constraints</indexterm>
+ãã§ãã¯å¶ç´ã¯è¡¨ã®å
容ã«é¢ããæ§ã
ãªè¦åãæå®ããããã«å©ç¨ãããã¨ãã§ãã¾ãããã§ãã¯å¶ç´ã«ã¯(çå½å¼ã§è¨è¿°ããã)æ¤ç´¢æ¡ä»¶ãæå®ã§ãã¾ãã表ä¸ã®å
¨è¡ã«ã¤ãã¦ããã®æ¤ç´¢æ¡ä»¶ã¯æºãããã¦ããªããã°ãªãã¾ãããINSERTãUPDATEã«ããè¡ãå¤æ´ãããæãæ¤ç´¢æ¡ä»¶ã¯å¤æ´ãããè¡ã«å¯¾ãã¦é©ç¨ããã¾ããä½ããã®ãã§ãã¯å¶ç´ã«éåããã¨ãæå
¨ä½ãä¸æããã�
�¾ãã</p> </section>
+<section id="sqlj57077"><title>æ¤ç´¢æ¡ä»¶ã®è¦ä»¶</title>
+<p>ãã§ãã¯å¶ç´ãåå®ç¾©ã®ä¸é¨ã¨ãã¦æå®ãããå ´åãå¶ç´ã¯åãåã®ã¿åç
§ã§ãã¾ãã
+表ã®å®ç¾©ã®ä¸é¨ã¨ãã¦æå®ããããã§ãã¯å¶ç´ã¯ãCREATE TABLEæã«ã¦å
ç«ã£ã¦å®ç¾©ãããåãåç
§ãããã¨ãã§ãã¾ãã</p>
+<p>æ¤ç´¢æ¡ä»¶ã¯åãå¤ã«é©ç¨ãããå ´åã常ã«åãå¤ãè¿ãå¿
è¦ãããã¾ãããããã£ã¦ã以ä¸ã®ããããæ¤ç´¢æ¡ä»¶ã«ã¯ç½®ããã¨ãã§ãã¾ããã<ul>
+<li>åçãªãã©ã¡ã¼ã¿ (?)</li>
+<li>æ¥æé¢æ° (CURRENT_DATEãCURRENT_TIMEãCURRENT_TIMESTAMP)</li>
+<li>å¯åãåãã</li>
+<li>ã¦ã¼ã¶ã¼é¢æ° (ä¾ãã°USERãSESSION_USERãCURRENT_USER)</li>
+</ul></p> </section>
+<section><title>åç
§å
ã«å¾ãåä½</title> <p><indexterm>Referential actions</indexterm><indexterm>Constraint
+clause<indexterm>referential actions in</indexterm></indexterm>
+å¤é¨ãã¼ã®å®ç¾©ã«ã¦ãåä½(CASCADEãRESTRICTãSET NULLããã³NO ACTION)ãé©åã«æ¸ãããON DELETEç¯ã/ã¨ON UPDATEç¯ãè¨è¿°ã§ãã¾ãã
+ãããã®ç¯ã¯ã表ã®ä¸»ãã¼ãæ´æ°ãªããåé¤ãããã¨ãã«ãå¤é¨ãã¼ã®é¢ä¿ãæãªãããªãããã«ã対å¿ããå¤é¨ãã¼ãå¤æ´ããããæä½ãæ絶ãããããäºãè¨è¿°ãã¾ãã</p>
+<p>åç
§æ§ã®å¶ç´ã®å®ç¾©ãè¡ãã¨ããä½µãã¦æ´æ°ã¾ãã¯åé¤ã®è¦åãå®ç¾©ã§ãã¾ãã</p>
+<p>æ´æ°ã®è¦åã¯ã親ãããã¯ä¾åãã表ã®è¡ãæ´æ°ãããã¨ãã«é©ç¨ããã¾ããæå®ã§ããã®ã¯ãNO ACTIONãããã¯RESTRICTã§ãã</p>
+<p>親表ã®ä¸»ãã¼ã®å¤ãæ´æ°ãããæ´æ°ã®è¦åãRESTRICTã§ãã£ãå ´åã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ä¾åãã表ã®å¤é¨ãã¼å¶ç´ã調ã¹ã¾ããããä¾å表ã®ä½ããã®è¡ãå¤é¨ãã¼å¶ç´éåã¨ãªããªãããã©ã³ã¶ã¯ã·ã§ã³ã¯å·»ãæ»ããã¾ãã</p>
+<p>ããæ´æ°ã®è¦åãNO ACTIONã§ãã£ããªãã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯æ´æ°ãå
¨ã¦çµãã£ã<i>å¾</i>ããããªã¬ãå®è¡ããã<i>å</i>ã«ãä¾åãã表ã®å¤é¨ãã¼å¶ç´ããã§ãã¯ãã¾ããããä½ããã®è¡ãå¤é¨ãã¼å¶ç´éåã§ãããªããæã®å®è¡ã¯å´ä¸ããã¾ãã</p>
+<p>ä¾åãã表ã«ããåã®å¤ãå¤æ´ããããã®å¤ãå¤é¨ãã¼ã®ä¸é¨ã§ãã£ãå ´åãæ´æ°ã®è¦åã¯æé»è£¡ã«NO ACTIONã¨ãªãã¾ããNO ACTIONã§ããã¨ãããã¨ã¯ãå¤é¨ãã¼ã空ã§ã¯ãªãå¤ã«æ´æ°ãããæãæ´æ°å¾ã®å¤ã¯è¦ªè¡¨ã®ä¸»ãã¼ã¨ä¸è´ããªããã°ãªããªããã¨ãæå³ãã¾ãããã親表ã®ä¸»ãã¼ã¨ä¸è´ããªãã®ã§ããã°ãæã¯å´ä¸ããã¾ãã</p>
+<p>åé¤ã®è¦åã¯è¦ªè¡¨ã®è¡ãåé¤ããããã®è¡ã«ä¾åããè¡ãåç
§æ§å¶ç´ã®ä¾å表ã«ããå ´åã«é©ç¨ããã¾ãããã®ã¨ãä¾å表ã®è¡ãåé¤ããããã¨ããããããã親表ã®åé¤ãä¾å表ã«<i>ä¼æãã</i>ã¨ããã¾ããããä¾å表ã親表ã§ããããªãã°ãä»åº¦ã¯ããã«å®ç¾©ãããåä½ããã®ä¾å表ã«é©ç¨ããã¾ãã</p>
+<p>æå®ã§ããå¤ã¯ãNO ACTIONãRESTRICTãCASCADEãããã¨SET NULLã§ããSET NULLã¯å¤é¨ãã¼ã®ä½ããã®åãnullã®å¤ãæã¤ãã¨ãã§ããå ´åã®ã¿æå®ã§ãã¾ãã</p>
+<p>ããåé¤ã®è¦åãã</p> <p>NO ACTIONãªã<ph
+conref="../conrefs.dita#prod/productshortname"></ph>ã¯ä¾å表ã®å¤é¨ãã¼å¶ç´ããåé¤ãå
¨ã¦çµãã£ã<i>å¾</i>ããããªã¬ãå®è¡ããã<i>å</i>ã«ãã§ãã¯ãã¾ããããä¾å表ã®ä½ããã®è¡ãå¤é¨ãã¼å¶ç´ã«éåãããªãæã¯å´ä¸ããã¾ãã</p>
+<p>RESTRICTãªãã<ph
+conref="../conrefs.dita#prod/productshortname"></ph>ã¯ä¾å表ã®å¤é¨å¶ç´ã調ã¹ãä¾å表ã®ä½ããã®è¡ãå¤é¨ãã¼å¶ç´ã«éåããå ´åããã©ã³ã¶ã¯ã·ã§ã³ãå·»ãæ»ãã¾ãã</p>
+<p>CASCADEãªããåé¤ãä¾å表ã«ä¼æããã¾ãã(é©ç¨å¯è½ãªä¼æå
ã®ä¾å表ã«ãä¼æãã¾ãã)</p>
+<p>SET NULLãªããä¾å表ã®å¤é¨ãã¼ã«ã¦ç©ºã«ã§ããåã®å¤ã空ã«ãªãã¾ãã(ãã®å ´åããä¾å表ã«ä¾åãã表ã«ããå¤é¨ãã¼ã®ç©ºã«ã§ããåã®å¤ã¯ç©ºã«ãªãã¾ãã)</p>
+<p>表ã親ã¨ããåç
§æ§ã®å¶ç´ã«ã¯ãåã
ã®åé¤ã®è¦åãããã¾ããããã¦é©ç¨ãããå
¨ã¦ã®åé¤ã®è¦åã«ãã£ã¦ãåé¤å¦çã®çµæã決ã¾ãã¾ãã
+ãããã£ã¦ä¾åå
ãRESTRICTãNO ACTIONã®åç
§æ§å¶ç´ããã¤ãªããè¡ã¯åé¤ã§ãã¾ããã
+åæ§ã«åé¤ãä¼æãã¦ããå ´åã§ããä¼æå
ã®ä¾åè¡ã®åç
§æ§å¶ç´ã«ã¦åé¤ã®è¦åãRESTRICTãNO ACTIONã§å®ç¾©ããã¦ããã°ãè¡ãåé¤ã§ãã¾ããã</p>
+<p>親ã®è¡¨ããè¡ãåé¤ããã¨ãã»ãã®è¡¨ã¸ã®å½±é¿ãããã¾ãã親表ã®åé¤ã«ããå½±é¿ãåãããã¹ã¦ã®è¡¨ãã親表ã¨åé¤ã®é¢ä¿ãããã¨ããã¾ããåé¤ã«ãããããã®è¡¨ã®è¡ã«å¯¾ãã¦æ¬¡ã®ãããªå½±é¿ãåã³ã¾ãã
+<ul>
+<li>ããåé¤ã®è¦åãRESTRICTãããã¯NO ACTIONã§ããã°ãä¾å表ã¯å¦çã«é¢é£ãã¾ãããå¦çã®å½±é¿ã¯åãã¾ããã(ã¤ã¾ã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯è¡¨ã®å¤ãæ¤è¨¼ãã¾ãããåé¤ã¯ãã¾ããã) </li>
+<li>ããåé¤ã®è¦åãSET NULLã§ããã°ã親表ã®è¡ãåé¤ãããããåé¤ãä¼æãããå ´åãä¾å表ã®è¡ã®å¤ã¯æ´æ°ã®å¯¾è±¡ã¨ãªãã¾ãã</li>
+<li>ããåé¤ã®è¦åãCASCADEã§ããã°ã親表ã«ã¦åé¤ãè¡ãããå ´åãä¾å表ã®è¡ãåé¤ããã¾ãã</li>
+<li>ããä¾å表ã親表ã§ãããå ´åãããã«æ¸ãããå¦çãä»åº¦ã¯ãã®ä¾å表ã«è¡ããã¾ãã</li>
+</ul></p> </section>
+<example id="sqljidx6080"><title>ä¾</title>
+<codeblock><b>-- OUT_TRAY_PKã¨ããååã®åã¬ãã«ã®ä¸»ãã¼å¶ç´:
+CREATE TABLE SAMP.OUT_TRAY
+ (
+ SENT TIMESTAMP,
+ DESTINATION CHAR(8),
+ SUBJECT CHAR(64) NOT NULL CONSTRAINT OUT_TRAY_PK PRIMARY KEY,
+ NOTE_TEXT VARCHAR(3000)
+ );
+
+-- 表ã¬ãã«ã®ä¸»ãã¼å¶ç´ã§ã¯äºã¤ã®åã
+-- ãã¼ã®å®ç¾©ã«è¨è¿°ã§ãã¾ãã
+CREATE TABLE SAMP.SCHED
+ (
+ CLASS_CODE CHAR(7) NOT NULL,
+ DAY SMALLINT NOT NULL,
+ STARTING TIME,
+ ENDING TIME,
+ PRIMARY KEY (CLASS_CODE, DAY)
+ );
+
+-- åã¬ãã«ã®å¶ç´ãç®è¡ãã§ãã¯ã®ããã«ä½¿ãã¾ãã
+-- 表ã¬ãã«ã®å¶ç´ãå¾æ¥å¡ã¸ã®ç¨éãè³ä¸ãè¶
ããªãããã«ãããã
+-- 使ãã¾ãã
+CREATE TABLE SAMP.EMP
+ (
+ EMPNO CHAR(6) NOT NULL CONSTRAINT EMP_PK PRIMARY KEY,
+ FIRSTNME CHAR(12) NOT NULL,
+ MIDINIT vARCHAR(12) NOT NULL,
+ LASTNAME VARCHAR(15) NOT NULL,
+ SALARY DECIMAL(9,2) CONSTRAINT SAL_CK CHECK (SALARY >= 10000),
+ BONUS DECIMAL(9,2),
+ TAX DECIMAL(9,2),
+ CONSTRAINT BONUS_CK CHECK (BONUS > TAX)
+ );
+
+-- MEALåãé©åãªç¥åã®ã¿ã¨ãããããã§ãã¯å¶ç´ã使ãã¾ãã
+CREATE TABLE FLIGHTS
+ (
+ FLIGHT_ID CHAR(6) NOT NULL ,
+ SEGMENT_NUMBER INTEGER NOT NULL ,
+ ORIG_AIRPORT CHAR(3),
+ DEPART_TIME TIME,
+ DEST_AIRPORT CHAR(3),
+ ARRIVE_TIME TIME,
+ MEAL CHAR(1) CONSTRAINT MEAL_CONSTRAINT
+ CHECK (MEAL IN ('B', 'L', 'D', 'S')),
+ PRIMARY KEY (FLIGHT_ID, SEGMENT_NUMBER)
+ );
+
+CREATE TABLE METROPOLITAN
+ (
+ HOTEL_ID INT NOT NULL CONSTRAINT HOTELS_PK PRIMARY KEY,
+ HOTEL_NAME VARCHAR(40) NOT NULL,
+ CITY_ID INT CONSTRAINT METRO_FK REFERENCES CITIES
+ );
+
+-- 表ã¬ãã«ã®ä¸»ãã¼å¶ç´ã¨è¡¨ã¬ãã«ã®å¤é¨ãã¼å¶ç´ãæå®ãã¦ã
+-- 表ãä½æãã¾ãã
+CREATE TABLE FLTAVAIL
+ (
+ FLIGHT_ID CHAR(6) NOT NULL,
+ SEGMENT_NUMBER INT NOT NULL,
+ FLIGHT_DATE DATE NOT NULL,
+ ECONOMY_SEATS_TAKEN INT,
+ BUSINESS_SEATS_TAKEN INT,
+ FIRSTCLASS_SEATS_TAKEN INT,
+ CONSTRAINT FLTAVAIL_PK PRIMARY KEY (FLIGHT_ID, SEGMENT_NUMBER),
+ CONSTRAINT FLTS_FK
+ FOREIGN KEY (FLIGHT_ID, SEGMENT_NUMBER)
+ REFERENCES Flights (FLIGHT_ID, SEGMENT_NUMBER)
+ );
+<ph>-- åã«ä¸ææ§å¶ç´ãå ããã</ph>
+ALTER TABLE SAMP.PROJECT
+ADD CONSTRAINT P_UC UNIQUE (PROJNAME);
+
+-- åã¬ãã«ã®å¤é¨ãã¼å¶ç´ãå©ç¨ãã¦ã
+-- city_idåãCities表ã®ä¸»ãã¼ãåç
§ãã表ãä½æããã
+CREATE TABLE CONDOS
+ (
+ CONDO_ID INT NOT NULL CONSTRAINT hotels_PK PRIMARY KEY,
+ CONDO_NAME VARCHAR(40) NOT NULL,
+ CITY_ID INT CONSTRAINT city_foreign_key
+ REFERENCES Cities ON DELETE CASCADE ON UPDATE RESTRICT
+ );</b></codeblock> </example>
+<section><title>æã®ä¾å追跡ã·ã¹ãã </title>
+<p>INSERTæãUPDATEæã¯å¯¾è±¡è¡¨ã«ããå
¨å¶ç´ã®å½±é¿ãåãã¾ãã
+DELETEæã¯ä¸ææ§å¶ç´ã»ä¸»ãã¼å¶ç´ã»å¤é¨ãã¼å¶ç´ã®å½±é¿ãåãã¾ãã
+対象表ã«ãããã®å¶ç´ã追å ããããåé¤ããããããå ´åããããã®æã¯ç¡å¹ã¨ãªãã¾ãã</p> </section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13590.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13658.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13658.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13658.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13658.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"
+ "../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="rrefsqlj13658" xml:lang="ja" >
+<title>ORDER BY ç¯</title>
+<shortdesc>ORDER BYç¯ã¯SELECTæã®çç¥å¯è½ãªè¦ç´ ã§ãã
+ORDER BYç¯ã«ã¦<varname>ResultSet</varname>ã«ããè¡ã®é çªãæå®ã§ãã¾ãã</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>ORDER BY clause<indexterm>syntax</indexterm></indexterm>
+<indexterm>ASC<indexterm>implied in ORDER BY clause</indexterm></indexterm>
+<indexterm>DESC<indexterm>optional element of ORDER BY clause</indexterm></indexterm>
+<indexterm>ORDER BY clause<indexterm>affecting cursors</indexterm></indexterm>
+<indexterm>ORDER BY clause<indexterm>specifying expressions</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<refsyn><title>Syntax</title><codeblock><b>ORDER BY { <i><xref href="rrefcolumnname.dita#rrefcolumnname"></xref></i> | <i>ColumnPosition</i> | <i>Expression</i> }
+ [ ASC | DESC ]
+ [ , <i><xref href="rrefcolumnname.dita#rrefcolumnname">åå</xref></i> | <i>åä½ç½®</i> | <i>å¼</i>
+ [ ASC | DESC ] ] * </b></codeblock><dl><dlentry>
+<dt>åå</dt>
+<dd>åãåããã®<xref href="rrefsqlj41360.dita#rrefsqlj41360"></xref>ã®<varname>é¸æé
ç®</varname>ã«ã¦ãå¯è¦ã§ããååãåç
§ãã¾ãã
+ORDER BYã§æå®ããååã¯SELECTãããé
ç®ã«ãªãã¨ãæ§ãã¾ããã</dd>
+</dlentry><dlentry>
+<dt>åä½ç½®</dt>
+<dd><xref href="rrefsqlj41360.dita#rrefsqlj41360"></xref>ã®<varname>é¸æé
ç®</varname>ã®ãåã®çªå·ãæå®ããæ´æ°ã§ãã
+<parmname>åä½ç½®</parmname>ã¯ã0ãã大ãããã¤çµæ表ã®åæ°ä»¥ä¸ã§ãªããã°ãªãã¾ãããè¨ãæããã°ãåã§ä¸¦ã³å¤ããããã«ããã®åãSELECTãããé
ç®ã«ããå¿
è¦ãããã¾ãã</dd>
+</dlentry><dlentry>
+<dt>å¼</dt>
+<dd>並ã³å¤ããè¡ããã¼ã®å¼ã§ãæ°å¤ãæååãæ¥ä»ãªã©ã®å¼ã¨ãããã¨ãã§ãã¾ãã
+<i>å¼</i>ã¯ã¹ã«ã©ã¼å¯åãåãããCASEå¼ãªã©ã®ãè¡ã®å¤ã«ãããå¼ã¨ãããã¨ãã§ãã¾ãã
+</dd>
+</dlentry><dlentry>
+<dt>ASC</dt>
+<dd>çµæãæé ã§è¿ããã¨ãæå®ãã¾ããæ¹åãæå®ãããªãå ´åãASCãæ¢å®ã§ãã</dd>
+</dlentry><dlentry>
+<dt>DESC</dt>
+<dd>çµæãéé ã§è¿ããã¨ãæå®ãã¾ãã</dd>
+</dlentry></dl> </refsyn>
+<section><title>ä½ãæ¸ã</title><ul>
+<li>SELECT DISTINCTãæå®ãããããSELECTæã«GROUP BYç¯ããã£ãå ´åãORDER BYããåã¯SELECTãããé
ç®ã«ãªããã°ãªãã¾ããã</li>
+<li>ORDER BYç¯ãããã¨ãSELECTæãæ´æ°å¯è½ã«ã¼ã½ã«ã¨ãããã¨ãã§ãã¾ããããã詳細ãªæ
å ±ã¯ã<xref href="rrefsqlj41360.dita#rrefsqlj41360/sqlj15384"></xref>ãåç
§ãã¦ãã ããã
+ä¾ãã°ãããINTEGERã®åã«æ´æ°ãããã¨ãã½ã¼ãã®ã¨ãNULLã¯1ãã大ããã¨è¦ãªããã¾ããè¨ãæããã°ãNULLã®å¤ã¯ãããä¸ã®ä½ç½®ã«ã½ã¼ãããã¾ãã</li>
+</ul></section>
+<example><title>ç¸é¢åã使ãä¾</title>
+<p>ç¸é¢åãé¸æé
ç®ã«ã¦æå®ããã¦ããã°ãçµæã»ãããç¸é¢åã§ä¸¦ã³å¤ãã§ãã¾ãã
+ãã¨ãã°CITIESãã¼ã¿ãã¼ã¹ãããCOUNTRYåã«NATIONã¨ããç¸é¢åãä¸ãã¦ãCITY_NAMEåã¨COUNTRYåã«æ ¼ç´ããã¦ãããã¹ã¦ã®æ
å ±ãè¿ãå ´åã次ã®ãããªSELECTæãæ¸ãã¾ãã</p>
+<codeblock>SELECT CITY_NAME, COUNTRY AS NATION
+ FROM CITIES
+ ORDER BY NATION
+</codeblock> </example>
+<example><title>æ°å¼ã使ãä¾</title>
+<p>çµæã»ãããæ°å¼ã§ä¸¦ã³å¤ãããã¨ãã§ãã¾ããä¾ãæãã¾ãã<codeblock>SELECT name, salary, bonus FROM employee
+ ORDER BY salary+bonus</codeblock>ãã®ä¾ã§ã¯ãsalaryã¨bonusåã¯DECIMALãã¼ã¿åã§ãã</p></example>
+<example><title>é¢æ°ã使ãä¾</title><p>çµæã»ãããé¢æ°ã®å¼ã³åºãçµæãå
ã«ä¸¦ã³å¤ãããã¨ãã§ãã¾ããä¾ãæãã¾ãã<codeblock>SELECT i, len FROM measures
+ ORDER BY sin(i)
+</codeblock></p></example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13658.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13733.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13733.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13733.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13733.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,42 @@
+<?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="rrefsqlj13733" xml:lang="ja">
+<title>CHAR ãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>CHAR data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>CHARã¯åºå®é·ã®é åã§æååãè¨é²ãã¾ãã</p></section>
+<refsyn><title>Syntax</title> <codeblock><b>CHAR[ACTER] [(<i>é·ã</i>)] </b></codeblock> <p><i>é·ã</i> ã¯ç¬¦å·ã®ãªãå®æ°ã®æ´æ°å¤ã§ããé·ãã®æ¢å®å¤ã¯1ã§ãã</p> </refsyn>
+<section><title>å®è¡æã®å¯¾å¿ããJavaã®å</title> <p><i>java.lang.String</i></p> </section>
+<section><title>JDBCã®ã¡ã¿ãã¼ã¿å(java.sql.Types)</title>
+<p>CHAR</p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯æååå¤ãåã®é·ãããçãå ´åã空ç½ã§ç©ºããè©°ãã¾ãã<ph conref="../conrefs.dita#prod/productshortname"></ph> ã¯æååå¤ãåã®é·ãããé·ãå ´åã空ç½ãåãæ¨ã¦ã¾ãã空ç½ä»¥å¤ã®æåãæ®ããæååãé·ãããå ´åãä¾å¤ãæããã¾ãã<xref href="rrefsqlj23075.dita#rrefsqlj23075">æ¯è¼æ¼ç®å</xref>ãCHARã«é©ç¨ãããå ´åãæååé·ã®çãå¤ã«ã¯ç©ºç½ãã¤ãããã¦ãæååé·ã®é·ãå¤ã¨åãé·ãã«ãªã
ããã«å¦çããã¾ãã</p>
+<p>CHARã¨VARCHARã®å¤ãå¼ã«ã¦æ··å¨ãã¦å©ç¨ããã¦ããå ´åãé·ãã®çãå¤ã¯ã¹ãã¼ã¹ã§è©°ãããã¦ãæååé·ã®é·ãå¤ã¨åãé·ãã«ãªãããå¦çããã¾ãã</p>
+<p>æååã®å®æ°ã®åã¯CHARã§ãã</p> </section>
+<section><title>å®è£
ã¬ãã«ã§å®ç¾©ããã¦ããäº</title>
+<p>CHARãã¼ã¿åã®æ大é·ã¯<i>java.lang.Integer.MAX_VALUE</i>ã§ãã</p> </section>
+<example> <codeblock><b><ph>-- æååã®å®æ°ã§ã¯é£ç¶ããå¼ç¨ç¬¦ã«ããã
+-- ä¸éå¼ç¨ç¬¦ãããã¯ã¢ãã¹ãããã£ã¼ã表ãã¾ãã</ph>
+VALUES 'hello this is Joe''s string'</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj13733.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj14122.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj14122.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj14122.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj14122.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,48 @@
+<?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="rreffsqlj14122" xml:lang="ja">
+<title>REAL ãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>REAL data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>REALåã§ã¯IEEEæµ®åå°æ°ç¹æ°ã®è¨æ³ã«å¾ãæ°ã4ãã¤ãã®é åã«è¨é²ããã¾ãã</p></section>
+<refsyn><title>è¨æ³</title> <codeblock><b>REAL</b></codeblock> </refsyn>
+<section><title>対å¿ããã³ã³ãã¤ã«æã®Javaã®å</title> <p><i>java.lang.Float</i></p> </section>
+<section><title>JDBCã®ã¡ã¿ãã¼ã¿å(java.sql.Types)</title> <p>REAL</p> </section>
+<section><title>å¶é</title> <p>REALã®å¤ã®ç¯å²:</p> <ul>
+<li>REALã®æå°å¤: -3.402E+38</li>
+<li>REALã®æ大å¤: 3.402E+38</li>
+<li>REALã®æå°ã®æ£ã®å¤: 1.175E-37</li>
+<li>REALã®æ大ã®è² ã®å¤: -1.175E-37</li>
+</ul> <p>ãããã®å¶éã¯Javaã§ã®<codeph>java.lang.Float</codeph>åã®å¶éã¨ã¯ç°ãªãã¾ãã</p>
+<p>ãããã®ç¯å²å¤ã®å¤ãè¨ç®ãããã代å
¥ãããã¨ä¾å¤ããããã¾ãã
+ç®è¡æ¼ç®ã§ã¯çµæã¯é¶ã«ä¸¸ãå¦ç<b>ããã¾ãã</b>ã
+ããå¤ãå°ããããå ´åã¯ä¾å¤ãæããã¾ããã¢ã³ãã¼ããã¼ãæ¤ç¥ããããã«ãç®è¡æ¼ç®ã¯å精度ã§è¡ããã¾ãã</p>
+<p>æµ®åå°æ°ç¹æ°ã®å®æ°ã¯æåé·ã30æåã¾ã§ã«å¶éããã¦ãã¾ãã
+<codeblock>-- ãã®ä¾ã§ã¯å®æ°ãé·ãããããã¨ã©ã¼ã¨ãªãã¾ãã
+<b>values 01234567890123456789012345678901e0;</b></codeblock></p>
+<p>å¼ã«ããã¦ä»ã®ãã¼ã¿åã¨æ··å¨ãã¦å©ç¨ãããå ´åãçµæã®ãã¼ã¿åã¯<xref href="rrefsqlj27767.dita#rrefsqlj27767"></xref>ã«è¨è¿°ãããè¦åã«ã®ã£ã¨ã£ã¦æ±ºã¾ãã¾ãã</p>
+<p><xref href="rrefsqlj20204.dita#rrefsqlj20204"></xref>ãåç
§ãã¦ãã ããã</p>
+<p>å®æ°ã¯å¸¸ã«DOUBLE PRECISIONã¨ããã¾ããREALã«å¤æããã«ã¯CASTã使ã£ã¦ãã ããã</p> </section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj14122.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj14854.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj14854.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj14854.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj14854.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,48 @@
+<?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 xml:lang="ja" id="rrefsqlj14854">
+<title>HAVING ç¯</title>
+<prolog><metadata>
+<keywords><indexterm>HAVING clause</indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section>
+<p>HAVINGç¯ã«ãã<i><xref href="rrefselectexpression.dita#rrefselectexpression"/></i>ã®GROUP BYã®çµæãçµãè¾¼ã¾ãã¾ããWHEREç¯ãé¸æåä¸è¦§ã«ä½ç¨ããã®ã¨ã¯ç°ãªããHAVINGç¯ã¯è¡¨ããåé¡ãããé¨åéåã«å¯¾ãã¦ä½ç¨ãã¾ããããGROUP BYç¯ããªããã°ãHAVINGç¯ã¯çµæãåç¬ã®åé¡ã¨è¦ãªãã¦ä½ç¨ãã¾ãã
+SELECTç¯ã«ã¦GROUP BYå¥ã®ãªãåãç´æ¥åç
§ãããã¨ã¯ã§ãã¾ããããããå®æ°ãéç´ãç¹æ®å¤æ°ãåç
§ãããã¨ã¯ã§ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title>
+<codeblock><b>HAVING <i>æ¤ç´¢æ¡ä»¶</i></b></codeblock>
+<p><i>æ¤ç´¢æ¡ä»¶</i>ã¯ç¹æ®ãª<i>çå½å¼</i>ã§ãåé¡å(<xref href="rrefsqlj32654.dita#rrefsqlj32654"/>ãåç
§ãã¦ãã ããã)ããéç´å¼ã®ä¸é¨ã§ããåã®ã¿å«ããäºãã§ãã¾ãã
+ä¾ãã°ä»¥ä¸ã®ä¾ã§ã¯ãSALARYã¨ããåã¯åé¡ã®åãéç´ãå¯åãåããã«ããåã§ã¯ãªãã®ã§ããã®æã¯ä¸æ£ã§ãã
+<codeblock><b>-- SELECT COUNT(*)
+-- FROM SAMP.STAFF
+-- GROUP BY ID
+-- HAVING SALARY > 15000</b></codeblock></p>
+<p>HAVINGç¯ã®éç´ã¯SELECTã®ä¸è¦§ã«ãªãã¦ããã¾ãã¾ããã
+ããHAVINGç¯ãå¯åãåãããå«ããªãã°ããã®å¯åãåããã¯åé¡ã®åã«ã¤ãã¦ã®ã¿ãå¤ã®åãåãããåç
§ãããã¨ãã§ãã¾ãã</p>
+</refsyn>
+<example>
+<codeblock><b><ph>-- 2å¸ä»¥ä¸ã®èªè·¯ãã¨ã«ãã¨ã³ããã¼å¸ã®åè¨ã調ã¹ãã</ph>
+SELECT SUM(ECONOMY_SEATS_TAKEN), AIRLINE_FULL
+FROM FLIGHTAVAILABILITY, AIRLINES
+WHERE SUBSTR(FLIGHTAVAILABILITY.FLIGHT_ID, 1, 2) = AIRLINE
+GROUP BY AIRLINE_FULL
+HAVING COUNT(*) > 1
+</b></codeblock>
+</example></refbody></reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj14854.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15147.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15147.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15147.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15147.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="rrefsqlj15147" xml:lang="ja">
+<title>LONG VARCHARå</title>
+<prolog><metadata>
+<keywords><indexterm>LONG VARCHAR data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>LONG VARCHARåã«ããæ大ã§32,700æåãããªãæååãè¨é²ã§ãã¾ãããã®åã®åãå®ç¾©ããã¨ããæ大é·ãæå®ããå¿
è¦ããªããã¨ãé¤ãã°ããã®åã¯VARCHARã¨åæ§ã§ãã</p> </section>
+<refsyn><title>æ§æ</title> <codeblock><b>LONG VARCHAR</b></codeblock> </refsyn>
+<section><title>対å¿ããã³ã³ãã¤ã«æã®Javaã®å</title> <p><i>java.lang.String</i></p> </section>
+<section><title>JDBCã¡ã¿ãã¼ã¿å (java.sql.Types)</title> <p>LONGVARCHAR</p>
+<p>Javaã®å¤ãSQLã®å¤ã«å¤æããã¨ããLONG VARCHARã«å¯¾å¿ããJavaã®åã¯åå¨ãã¾ããã</p> </section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15147.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15260.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15260.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15260.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15260.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,58 @@
+<?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="rrefsqlj15260" xml:lang="ja">
+<title>DECIMAL ãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>DECIMAL data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>DECIMALã«ãã精度ã¨ç®çããæå®ãã¦æ£ç¢ºãªæ°ãæ±ãã¾ãã
+ãã®åã§ã¯ç²¾åº¦(å°æ°ç¹ã®å·¦å³ã®æ¡æ°ã®åè¨)ã¨ç®çã(å°æ°ç¹ä»¥ä¸ã®æ¡æ°)ãæå®ã§ãã¾ãã
+è¨æ¶è£
ç½®ã«ã¦å¿
è¦ã¨ãããé åã®ãµã¤ãºã¯ã精度ã«ãã決ã¾ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>{ DECIMAL | DEC } [(<i>精度</i> [, <i>ç®çã</i> ])]</b></codeblock>
+<p><i>精度</i>ã¯1ãã31ã®æ°ãã¨ãã¾ãã<i>ç®çã</i>ã¯ç²¾åº¦ä»¥ä¸ã®æ°ãã¨ãã¾ãã</p>
+<p>ç®çããæå®ãããªãã£ãå ´åã®æ¢å®å¤ã¯0ã¨ãªãã¾ãã精度ãæå®ãããªãã£ãå ´åã®æ¢å®å¤ã¯5ã¨ãªãã¾ãã</p>
+<p>DECIMALã«ä»£å
¥ãããã¨ãå¯è½ãªã®ã¯ãå°æ°é¨ä»¥å¤ã失ãããªãç¯å²ã®æ°ã§ãã
+DECIMALã®å¤ããå°æ°é¨ãç¡ãããå ´åã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯åæ¨ã¦ãè¡ãã¾ãã</p>
+<p>ä¾ãã°ã<codeblock>-- ãã®åå¤æã§å¤±ãããã®ã¯å°æ°é¨ã®ã¿ã§ãã
+<b>values cast (1.798765 AS decimal(5,2));</b>
+1
+--------
+1.79
+-- ãã®åå¤æã¯ãã¾ãè¡ãã¾ããã
+<b>values cast (1798765 AS decimal(5,2));</b>
+1
+--------
+ERROR 22003: The resulting value is outside the range
+for the data type DECIMAL/NUMERIC(5,2).</codeblock></p>
+<p>ä»ã®ãã¼ã¿åãå¼ã«ã¦æ··å¨ãã¦å©ç¨ããã¦ããå ´åãå¼ã®çµæã¨ãªãåã¯<xref href="rrefsqlj27767.dita#rrefsqlj27767"></xref>ã§æ¸ãããã¨ããã«æ±ºã¾ãã¾ãã</p>
+<p><xref
+href="rrefsqlj20204.dita#rrefsqlj20204"></xref>ãåç
§ãã¦ãã ããã</p>
+<p>äºã¤ã®DECIMALã®å¤ãå¼ã«ã¦ç¨ãããã¦ããå ´åãå¼ã®çµæã¨ãªãåã¯<xref href="rrefsqlj36146.dita#rrefsqlj36146"></xref>ã«è¨è¿°ãããè¦åã«å¾ã£ã¦æ±ºã¾ãã¾ãã</p> </refsyn>
+<section><title>対å¿ããã³ã³ãã¤ã«æã®Javaã®å</title> <p><i>java.math.BigDecimal</i></p> </section>
+<section><title>JDBC ã®ã¡ã¿ãã¼ã¿å (java.sql.Types)</title> <p>DECIMAL</p> </section>
+<example> <codeblock><b>VALUES 123.456
+
+VALUES 0.001</b></codeblock>
+<p>BIGINTã«ã¯å¤§ããããæ´æ°ã®å®æ°ã¯ãDECIMALã®å®æ°ã¨ãªãã¾ãã</p> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15260.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15309.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15309.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15309.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15309.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,42 @@
+<?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 xml:lang="ja" id="rrefsqlj15309">
+<title>WHERE CURRENT OF ç¯</title>
+<prolog><metadata>
+<keywords><indexterm>WHERE CURRENT OF clause</indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section>
+<p>WHERE CURRENT OFç¯ã¯UPDATEãDELETEæã«ã¦ä½¿ããã¨ãã§ãã¾ãã
+ããã«ããæ´æ°å¯è½ãªã«ã¼ã½ã«ã®ä½ç½®ã«ããæ´æ°ãåé¤ãè¡ãã¾ãã
+æ´æ°å¯è½ãªã«ã¼ã½ã«ã®è©³ç´°ã«ã¤ãã¦ã¯ã<xref href="rrefsqlj41360.dita#rrefsqlj41360"/>ãåç
§ãã¦ãã ããã</p></section>
+<refsyn><title>æ§æ</title>
+<codeblock><b>WHERE CURRENT OF <i><xref href="rrefcursorname.dita#rrefcursorname">ã«ã¼ã½ã«å</xref></i></b></codeblock>
+</refsyn>
+<example>
+<codeblock expanse="column">Statement s = conn.createStatement();
+s.setCursorName("AirlinesResults");
+ResultSet rs = conn.executeQuery(
+ "SELECT Airline, basic_rate " +
+ "FROM Airlines FOR UPDATE OF basic_rate");
+Statement s2 = conn.createStatement();
+s2.executeUpdate("UPDATE Airlines SET basic_rate = basic_rate " +
+ "+ .25 WHERE CURRENT OF AirlinesResults");</codeblock>
+</example></refbody></reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15309.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15446.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15446.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15446.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15446.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,69 @@
+<?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="rrefsqlj15446" xml:lang="en-us">
+<title>CREATE VIEW æ</title>
+<prolog><metadata>
+<keywords><indexterm>CREATE VIEW statement</indexterm><indexterm><indexterm>SQL
+statements</indexterm>CREATE VIEW</indexterm><indexterm>views<indexterm>creating</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>ãã¥ã¼ã¨ã¯ã¯ã¨ãªã«ããå®ç¾©ãããä»®æ³çãªè¡¨ã§ãã表ã¯ç ´æ£ããã¾ã§å©ç¨å¯è½ãªãã£ã¯ã·ã§ããªã®æ
å ±ã§ãããã¥ã¼ã¯æ´æ°ã§ãã¾ããã</p>
+<p>éå®ããããã¥ã¼ã®ååã«ã¦ãã¹ãã¼ãåã¯<i>SYS</i>ã§å§ã¾ã£ã¦ã¯ãªãã¾ããã</p>
+<p>ãã¥ã¼ã®ææè
ã¯èªåçã«SELECT権éãå¾ã¾ãããã¥ã¼ã®ææè
ããSELECT権éãå¥å¥ªãããã¨ã¯ã§ãã¾ããã<xref href="rrefattrib26867.dita#rrefattrib26867">ãã¼ã¿ãã¼ã¹ã®ææè
</xref>ã¯èªåçã«ãã¥ã¼ã¸ã®SELECT権éãæã¡ãSELECT権éãä»ã®ã¦ã¼ã¶ã«ä»ä¸ãããã¨ãã§ãã¾ãããã¼ã¿ãã¼ã¹ã®ææè
ããSELECT権éãå¥å¥ªãããã¨ã¯ã§ãã¾ããã</p>
+<p>ãã¥ã¼ã®ææè
ã¯ãã¥ã¼ãåç
§ããæ
å ±ãææããå ´åã®ã¿ãä»ã®ã¦ã¼ã¶ã«SELECT権éãä»ä¸ãããã¨ãã§ãã¾ãã</p><p>ãã¥ã¼ã®ææè
ãããã¥ã¼ãåç
§ããæ
å ±ãææãã¦ããªãå ´åããã¥ã¼ã®ææè
ã¯é©åãªæ¨©éãä»ä¸ããã¦ããªããã°ãªãã¾ãããä¾ãã°ã<codeph>user2</codeph>ã¨ããèªè¨¼èå¥åã<codeph>user1.t1</codeph>ã¨ãã表ã¨<codeph>user1.f_abs()</codeph>ã¨ããé¢æ°ãåç
§ããã<codeph>user2.v2</codeph>ã¨ãããã¥ã¼ã�
�½æããå ´åã<codeph>user2</codeph>ã¯<codeph>user1.t1</codeph>ã¸ã®SELECT権éã¨<codeph>user1.f_abs()ã¸ã®EXECUTE権éãæããªããã°ãªãã¾ããã</codeph>. </p>
+<p>SELECT権éãä»ä¸ãã権éã¯å¥å¥ªã§ãã¾ããããã¥ã¼ãåç
§ããæ
å ±ã¸ã®å¿
è¦ãªæ¨©éãå¥å¥ªãããå ´åããã¥ã¼ã¯ç ´æ£ããã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>CREATE VIEW <i><xref href="rrefviewname.dita#rrefviewname">ãã¥ã¼å</xref></i>
+ [ ( <i><xref href="rrefsimplecolumnname.dita#rrefsimplecolumnname">åç´åå</xref></i> [, <i><xref
+href="rrefsimplecolumnname.dita#rrefsimplecolumnname">åç´åå</xref></i>] * ) ]
+AS <i><xref href="rrefsqlj21571.dita#rrefsqlj21571">åãåãã</xref></i> </b></codeblock> <p>ãã¥ã¼ã®å®ç¾©ã«ãã¥ã¼ã®åä¸è¦§ãæ¸ããã¨ã§ããã¥ã¼ã®åã«æ示çãªååãä¸ãããã¨ãã§ãã¾ãã
+ãã¥ã¼ã®åä¸è¦§ããªãå ´åããã¥ã¼ã®ååã¯å
ã¨ãªãåãåããã®ååãå¼ç¶ãã¾ãããã¥ã¼ã®å
¨åã¯ä¸æãªååãæããªããã°ãªãã¾ããã</p> </refsyn>
+<example> <codeblock><b>CREATE VIEW SAMP.V1 (COL_SUM, COL_DIFF)
+ AS SELECT COMM + BONUS, COMM - BONUS
+ FROM SAMP.EMPLOYEE;
+
+CREATE VIEW SAMP.VEMP_RES (RESUME)
+ AS VALUES 'Delores M. Quintana', 'Heather A. Nicholls', 'Bruce Adamson';
+
+CREATE VIEW SAMP.PROJ_COMBO
+ (PROJNO, PRENDATE, PRSTAFF, MAJPROJ)
+ AS SELECT PROJNO, PRENDATE, PRSTAFF, MAJPROJ
+ FROM SAMP.PROJECT UNION ALL
+SELECT PROJNO, EMSTDATE, EMPTIME, EMPNO
+ FROM SAMP.EMP_ACT
+ WHERE EMPNO IS NOT NULL;</b></codeblock> </example>
+<section><title>æã®ä¾å</title>
+<p>ãã¥ã¼ã®å®ç¾©ã¯åç
§ãã表ããã¥ã¼ã«ä¾åãã¾ãã
+ãã¥ã¼ãåç
§ããDML(data manipulation language)æã¯ããã¥ã¼ãä¾åããã®ã¨åæ§ã«ããã®ãã¥ã¼ã«ä¾åãã¾ãã
+ãã¥ã¼ãåç
§ããæã¯ããã¥ã¼ãå©ç¨ããç´¢å¼ã«ä¾åãã¾ãããã®ç´¢å¼ã¯åãåãããã©ã®ããã«æé©åããããã«å¿ãã¦ææ¯ã«ç°ãªãã¾ãã
+ä¾ã以ä¸ã«æãã¾ãã<codeblock><b>CREATE TABLE T1 (C1 DOUBLE PRECISION);
+
+CREATE FUNCTION SIN (DATA DOUBLE)
+ RETURNS DOUBLE EXTERNAL NAME 'java.lang.Math.sin'
+ LANGUAGE JAVA PARAMETER STYLE JAVA;
+
+CREATE VIEW V1 (C1) AS SELECT SIN(C1) FROM T1;</b></codeblock></p>
+<p>æã¨ãããä¾åãããã¼ã¿ãã¼ã¹ã®æ
å ±ãæãã¾ãã
+<codeblock><b>SELECT * FROM V1
+</b></codeblock></p>
+<p><i>V1</i>ã¨ãããã¥ã¼ã<i>T1</i>ã¨ãã表ã
+å¤é¨ã®ã¹ã«ã©ã¼é¢æ°ã®<i>SIN</i></p> </section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15446.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15866.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15866.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15866.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15866.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 xml:lang="en-us" id="rrefsqlj15866">
+<title>CURRENT_TIMESTAMPé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>CURRENT_TIMESTAMP function</indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section>
+<p>CURRENT_TIMESTAMPã¯ç¾å¨ã®ã¿ã¤ã ã¹ã¿ã³ããè¿ãã¾ããé¢æ°ããè¿ãããå¤ã¯ä¸ã¤ã®æã®ãã¡ã§ããã°ãä½åº¦å®è¡ããã¦ãåãå¤ãè¿ãã¾ããã§ããããã«ã¼ã½ã«ããè¡ãæ¾ãéã«çµéããæéã«ãããããããã®é¢æ°ã¯åãå¤ãè¿ãã¾ãã</p></section>
+<refsyn><title>åå¸</title>
+<codeblock><b>CURRENT_TIMESTAMP</b></codeblock>
+<p>ã¾ãã¯</p>
+<codeblock><b>CURRENT TIMESTAMP</b></codeblock>
+</refsyn>
+<example>
+<codeblock><b>VALUES CURRENT_TIMESTAMP
+<ph>-- ã¾ãã¯</ph>
+
+VALUES CURRENT TIMESTAMP</b></codeblock>
+</example></refbody></reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj15866.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16095.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16095.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16095.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16095.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="rrefsqlj16095" xml:lang="ja">
+<title>åæ¯ã®å¶ç´</title>
+<refbody>
+<example> <codeblock><b>{
+ NOT NULL |
+ [ [CONSTRAINT <i><xref href="rrefconstraintname.dita#rrefconstraintname">å¶ç´å</xref></i>]
+ {
+ CHECK (<i><xref href="rrefsqlj91438.dita#rrefsqlj91438">æ¤ç´¢æ¡ä»¶</xref></i>) |
+ {
+ PRIMARY KEY |
+ UNIQUE |
+ <i><xref href="rrefsqlj16357.dita#rrefsqlj16357">REFERENCES ç¯</xref></i>
+ }
+ }
+}</b></codeblock></example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16095.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16221.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16221.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16221.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16221.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="rrefsqlj16221" xml:lang="ja">
+<title>SMALLINT ãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>SMALLINT data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>SMALLINTã§ã¯2ãã¤ãã®è¨æ¶é åãæä¾ãã¾ãã</p></section>
+<refsyn><title>Syntax</title> <codeblock><b>SMALLINT</b></codeblock> </refsyn>
+<section><title>対å¿ããã³ã³ãã¤ã«æã®Javaã®å</title> <p><i>java.lang.Short</i></p> </section>
+<section><title>JDBCã®ã¡ã¿ãã¼ã¿å (java.sql.Types)</title> <p>SMALLINT</p> </section>
+<section><title>æå°å¤</title> <p id="sqlj22378">-32768 (<i>java.lang.Short.MIN_VALUE</i>)</p> </section>
+<section><title>æ大å¤</title> <p id="sqlj97879">32767
+(<i>java.lang.Short.MAX_VALUE</i>)</p>
+<p>ä»ã®ãã¼ã¿åãå¼ã«ã¦æ··å¨ãã¦å©ç¨ãããå ´åãçµæã®ãã¼ã¿åã¯<xref href="rrefsqlj27767.dita#rrefsqlj27767"></xref>ã«è¨ãããè¦åã«åã決ã¾ãã¾ãã</p>
+<p><xref href="rrefsqlj20204.dita#rrefsqlj20204"></xref>ãåç
§ãã¦ãã ããã</p> <p>æ´æ°ã®å®æ°ã¯ããã®å¤ã«ããINTEGERãããã¯BIGINTã¨ãªãã¾ãã</p> </section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj16221.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native