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 [23/26] - in /db/derby/docs/trunk: ./ src/ja_JP/
src/ja_JP/ref/
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj43125.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj43125.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj43125.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj43125.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,140 @@
+<?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="rrefsqlj43125" xml:lang="en-us">
+<title>CREATE TRIGGER æ</title>
+<prolog><metadata>
+<keywords><indexterm>CREATE TRIGGER statement</indexterm><indexterm>SQL statements<indexterm>CREATE
+TRIGGER</indexterm></indexterm><indexterm>triggers<indexterm>creating</indexterm></indexterm>
+<indexterm>triggers<indexterm>defining when they fire</indexterm></indexterm>
+<indexterm>triggers<indexterm>database events</indexterm></indexterm><indexterm>triggers<indexterm>referencing
+clause</indexterm><indexterm>referencing old and new values</indexterm></indexterm>
+<indexterm>triggers<indexterm>statement versus row triggers</indexterm></indexterm>
+<indexterm>triggers<indexterm>triggered-SQL-statement</indexterm></indexterm>
+<indexterm>triggers<indexterm>order of execution</indexterm></indexterm><indexterm>triggers<indexterm>recursion</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>ããªã¬ã«ãããã¼ã¿ãã¼ã¹ã®ã¤ãã³ãã«å¿ãã¦å®è¡ãããã¢ã¯ã·ã§ã³ã®éåãã表ã«å®ç¾©ãããã¨ãã§ãã¾ããããã§<i>ãã¼ã¿ãã¼ã¹ã®ã¤ãã³ã</i>ã¨ã¯åé¤ãæ¿å
¥ãæ´æ°å¦çã®ãã¨ã§ãã
+ä¾ãã°è¡¨ã«åé¤ã¸ã®ããªã¬ãå®ç¾©ããå ´åããã®ããªã¬ã®ã¢ã¯ã·ã§ã³ã¯è¡¨ããè¡ãåé¤ãããã¨ãã«å®è¡ããã¾ãã</p><p>å¶ç´ã¨ä½µãã¦ãããªã¬ã«ããæ³¢åçãªåé¤ãæ´æ°ãå®ç¾©ãããã¨ã§ãæ
å ±ã®æ´åæ§ãä¿ã¤ãã¨ãã§ãã¾ãã
+ããªã¬ã§å®ç¾ã§ããæ©è½ã¯ãã®ã»ãã«ããè¦åã®å示ããä»ã®è¡¨ã®æ´æ°ãe-mailã®éä¿¡ããã®ä»ã®å¦çãªã©ãå¤å²ã«ãããã¾ãã</p><p>ã²ã¨ã¤ã®è¡¨ã«å®ç¾©å¯è½ãªããªã¬ã®æ°ã«ã¯ããããã®ããªã¬ãåãã¤ãã³ãã¸ã®ããªã¬ã§ãããå¦ãã«ããããããä¸éã¯ããã¾ããã</p>
+<p>ã¹ãã¼ãã®ææè
ã§ããã¦ã¼ã¶ã§ããã°ããã®ã¹ãã¼ãã«ããªã¬ãä½æãããã¨ãã§ãã¾ãã
+ææãã¦ããªã表ã«ããªã¬ãå®ç¾©ããããã«ã¯ããã®è¡¨ã«TRIGGER権éãæã£ã¦ããªããã°ãªãã¾ããã
+<xref href="rrefattrib26867.dita#rrefattrib26867">ãã¼ã¿ãã¼ã¹ã®ææè
</xref>ã§ããã¦ã¼ã¶ã§ããã°ãã©ã®ã¹ãã¼ãã®ã©ã®è¡¨ã«å¯¾ãã¦ãããªã¬ãä½æãããã¨ãã§ãã¾ãã</p>
+<p>ããªã¬ã¯ããªã¬ãå®ç¾©ããã¦ãã表ã¨ã¯ç°ãªãã¹ãã¼ãã«å®ç¾©ãããã¨ãå¯è½ã§ãã</p>
+<p>éå®ãããããªã¬åã®ã¹ãã¼ãåã¯ã<i>SYS</i>ã§å§ã¾ã£ã¦ã¯ãªãã¾ããã</p></section>
+<refsyn id="syn001"><title>æ§æ</title><codeblock><b>CREATE TRIGGER <i><xref
+href="rreftriggername.dita#rreftriggername">ããªã¬å</xref></i>
+{ AFTER | NO CASCADE BEFORE }
+{ INSERT | DELETE | UPDATE [ OF <i>åå</i> [, <i><xref href="rrefcolumnname.dita#rrefcolumnname">åå</xref></i>]* ] }
+ON <i><xref href="rreftablename.dita#rreftablename">表å</xref></i>
+[ <i><xref href="rrefsqlj89752.dita#rrefsqlj89752">åç
§ç¯</xref></i> ]
+[ FOR EACH { ROW | STATEMENT } ] [ MODE DB2SQL ]
+<i><xref href="rrefsqlj43125.dita#rrefsqlj43125/i1149821">ããªã¬ãããSQLæ</xref></i></b></codeblock> </refsyn>
+<section><title>ããªã¬ã®çºç«ãåãå¾ã</title> <p>ããªã¬ã¯<i>åã®ããªã¬</i>ãããã¯<i>å¾ã®ããªã¬</i>ã®ããããã¨ãã¦å®ç¾©ã§ãã¾ãã<ul>
+<li><i>åã®ããªã¬</i>ã¯æã«ããå¤æ´ãé©ç¨ããå¶ç´ã«ããæ¤è¨¼ãè¡ãããåã«çºç«ãã¾ãã
+åã®ããªã¬ã¯ãè¡ã®ããªã¬ãããã¯æã®ããªã¬ã®ãããã«ããªããã¨ãã§ãã¾ãã(詳細ã¯<xref href="rrefsqlj43125.dita#rrefsqlj43125/sqlj54276"></xref>ãåç
§ãã¦ãã ããã)</li>
+<li><i>å¾ã®ããªã¬</i>ã¯å¤æ´ãé©ç¨ããå¶ç´ã«ããæ¤è¨¼ãæºããããå¾ã«çºç«ãã¾ãã
+<i>å¾ã®ããªã¬</i>ã¯ãè¡ã®ããªã¬ãããã¯æã®ããªã¬ã®ãããã«ããªããã¨ãã§ãã¾ãã(詳細ã¯<xref href="rrefsqlj43125.dita#rrefsqlj43125/sqlj54276"></xref>ãåç
§ãã¦ãã ããã)</li>
+</ul></p> </section>
+<section><title>æ¿å
¥ãåé¤ãæ´æ°ã®ãããã«ããããªã¬ã¯çºç«ãããã®ã</title>
+<p>ããªã¬ã¯ã©ã®ããã«å®ç¾©ããããã«å¾ã£ã¦ã次ã®ããããã®ãã¼ã¿ãã¼ã¹ã®ã¤ãã³ãã«ããçºç«ãã¾ãã(ä¸è¨ã®<xref href="rrefsqlj43125.dita#rrefsqlj43125/syn001"></xref>ãåç
§ãã¦ãã ããã<ul>
+<li>INSERT</li>
+<li>UPDATE</li>
+<li>DELETE</li>
+</ul></p>
+<p>表ã®ã¤ãã³ããã¨ã«å®ç¾©ã§ããããªã¬ã®æ°ã«ä¸éã¯ããã¾ãããããã«æ´æ°ã¸ã®ããªã¬ã§ããã°ã対象ã¨ãªãåãæ示ãããã¨ãã§ãã¾ãã</p> </section>
+<section id="sqlj67748"><title>å¤ãå¤ãåç
§ããã®ããæ°ããå¤ãåç
§ããã®ã:åç
§ç¯</title>
+<p>çºç«ã®åå ã¨ãªã£ãã¤ãã³ãã§ç¾å¨å¤æ´ãããæ
å ±ãããªã¬ãããSQLæããåç
§ãããã¨ã¯è¯ããããã¨ã§ãã
+ã¾ããããªã¬ãããSQLæãåç
§ããªããã°ãªããªãã®ã¯æ°ããå¤(å¤æ´å¾ãå¾ã®å¤ãã¨è¨ããã¨ãã§ãã¾ã)ã§ããå ´åãããã¾ãã</p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph>ã«ã¦ãçºç«ããåå ã¨ãªã£ãã¤ãã³ãã«ããå¤æ´ãããæ
å ±ãããªã¬ããåç
§ããæ¹æ³ã¯ã²ã¨ã¤ã ãã§ã¯ããã¾ãããå¤æ´ãããæ
å ±ã¯ããªã¬ãããSQLæããã<i>é·ç§»å¤æ°</i>ãããã¯<i>é·ç§»è¡¨</i>ã§åç
§ãããã¨ãã§ãã¾ãã
+åç
§ç¯ã«ã¦é·ç§»å¤æ°ã¸ã®ç¸é¢åãå¥åããOLD/NEW AS <i>ç¸é¢å</i>ã¨ããæ¸å¼ã§è¨è¿°ã§ãã¾ãã</p>
+<p>ä¾ãã°ã次ã®ãããªç¯ãããªã¬ã®å®ç¾©ã«è¨è¿°ããå ´åã<codeblock><b>REFERENCING OLD AS DELETEDROW</b></codeblock></p>
+<p>ããªã¬ãããSQLæã§ãã®ç¸é¢åãåç
§ã§ãã¾ãã<codeblock><b>DELETE FROM HotelAvailability WHERE hotel_id = DELETEDROW.hotel_id</b
+></codeblock></p> <p>é·ç§»å¤æ°ã¯OLDãNEWã®ããããã«é¢ããããåä¸ã®è¡ãæã¤<i>java.sql.ResultSet</i>ã«ãããããã¾ãã<note>é·ç§»å¤æ°ã使ããã®ã¯ãè¡ã®ããªã¬ã ãã§ãã(<xref href="rrefsqlj43125.dita#rrefsqlj43125/sqlj54276"></xref>ãåç
§ãã¦ãã ããã)
+ã¾ããæ¿å
¥ã¤ãã³ãã®è¡ã®ããªã¬ã§ã¯OLDã®è¡ãåç
§ã§ãã¾ãããåé¤ã¤ãã³ãã®è¡ã®ããªã¬ã§ã¯NEWã®è¡ãåç
§ã§ãã¾ããã</note></p>
+<p>æã®ããªã¬ã§ã¯ãé·ç§»<i>表</i>ãããªã¬ãããSQLæãããªã¬ã®è³æ ¼ã§åç
§å¯è½ã§ãã
+åç
§ç¯ã«ã¦åç
§è¡¨ã¸ã®ç¸é¢åãå¥åããOLD_TABLE/NEW_TABLE AS ç¸é¢åã¨ããæ¸å¼ã§è¨è¿°ã§ãã¾ãã</p>
+<p>ä¾ãã°ã
+ <codeblock><b>REFERENCING OLD_TABLE AS DeletedHotels</b></codeblock></p>
+<p>ã¨æ¸ããã¨ã§èå¥å(<i>DeletedHotels</i>)ãããªã¬ãããSQLæã§ä½¿ããã¨ãã§ãã¾ãã
+ <codeblock><b>DELETE FROM HotelAvailability WHERE hotel_id IN
+ (SELECT hotel_id FROM DeletedHotels)</b></codeblock></p>
+<p>é·ç§»è¡¨ã¯å¤ããæ°ãããã«é¢ããããããªã¬ãçç«ããåå ã®ã¤ãã³ãã§å½±é¿ãåããè¡ã®æ°ã¨åãåºæ°ããã¤<i>java.sql.ResultSet</i>ã«ãããããã¾ãã
+<note>æã®ããªã¬(<xref href="rrefsqlj43125.dita#rrefsqlj43125/sqlj54276"></xref>ãåç
§ãã¦ãã ããã)ã§ã®ã¿é·ç§»è¡¨ã¯å©ç¨å¯è½ã§ãã
+INSERTæã¸ã®ããªã¬ã§ã¯ãOLDã®è¡¨ã¯åç
§ã§ãã¾ãããDELETEæã¸ã®ããªã¬ã§ã¯ãNEWã®è¡¨ã¯åç
§ã§ãã¾ããã</note></p>
+<p>åç
§ç¯ã§ã¯ãæ°ãããã®ã¨å¤ããã®ã«ããããä¸ã¤ã¾ã§ãç¸é¢åãããã¯èå¥åãå®ç¾©ã§ãã¾ãã
+ã¾ããè¡ã®ããªã¬ã«ã¯é·ç§»è¡¨ã®èå¥åãå®ç¾©ã§ããªãä¸æ¹ã§ãæã®ããªã¬ã«ã¯é·ç§»å¤æ°ã®ç¸é¢åãå®ç¾©ã§ãã¾ããã</p> </section>
+<section id="sqlj54276"><title>æã®ããªã¬ã¨è¡ã®ããªã¬</title>
+<p>ããªã¬ã«ã¯ã<i>æã®ããªã¬</i>ã¨<i>è¡ã®ããªã¬</i>ãããã¾ãã
+CREATE TRIGGERæã®FOR EACHç¯ã«ã¦ãã©ã¡ãã®ããªã¬ã§ãããæ示ãããªãã£ãå ´åã®æ¢å®ã¯ã<i>æã®ããªã¬</i>ã§ãã
+ <ul>
+<li><i>æã®ããªã¬</i> <p>æã®ããªã¬ã¯ããªã¬ã®ã¤ãã³ãæ¯ã«ä¸åçºç«ãã¾ããããªã¬ã®çºç«ã«æ¿å
¥ã»æ´æ°ã»åé¤ã«ã¦ä½è¡ãå¤æ´ããããã¯é¢ä¿ããã¾ããã</p></li>
+<li><i>è¡ã®ããªã¬</i> <p>è¡ã®ããªã¬ã¯ããªã¬ã®ã¤ãã³ããå½±é¿ããè¡æ¯ã«ä¸åçºç«ãã¾ããå½±é¿ãä¸è¡ã«ãåã°ãªãã£ãå ´åãããªã¬ã¯çºç«ãã¾ããã</p></li>
+</ul> <note>åã®å¤ãå
ã®å¤ã¨çããå¤ã«å¤æ´ããå ´å(ä¾ãã°ãUPDATE T SET C = Cã¨ããæãèãã¦ãã ããã)ãããªã¬ã®ã¤ãã³ãåã¨å¾ã§åã®å¤ã«å¤åãç¡ãã¦ããè¡ã®ããªã¬ã¯çºç«ãã¾ãã</note></p> </section>
+<section id="i1149821"><title>ããªã¬ãããSQLæ</title>
+<p>ããªã¬ã§å®ç¾©ãããã¢ã¯ã·ã§ã³ã®ãã¨ããããªã¬ãããSQLæã¨å¼ã³ã¾ãã(ä¸è¨ã<xref href="rrefsqlj43125.dita#rrefsqlj43125/syn001"></xref>ã®æçµè¡ããåç
§ãã¦ãã ããã)
+ããªã¬ãããSQLæã«ã¯ä»¥ä¸ã®å¶éãããã¾ãã<ul>
+<li>åçãªå¼æ°(?)ããã£ã¦ã¯ãªãã¾ããã</li>
+<li>ããªã¬ãå®ç¾©ããã¦ãã表ã®ä½æããå¤æ´ãç ´æ£ãè¡ã£ã¦ã¯ãªãã¾ããã</li>
+<li>ããªã¬ãå®ç¾©ããã¦ãã表ã¸ã®ç´¢å¼ã®ä½æãç ´æ£ãè¡ã£ã¦ã¯ãªãã¾ããã</li>
+<li>ããªã¬ãå®ç¾©ããã¦ãã表ã¸ã®ããªã¬ã®ä½æãç ´æ£ãè¡ã£ã¦ã¯ãªãã¾ããã</li>
+<li>ãã©ã³ã¶ã¯ã·ã§ã³ã®ã³ãããããã¼ã«ããã¯ãåé¢ã¬ãã«ã®å¤æ´ãè¡ã£ã¦ã¯ãªãã¾ããã</li>
+<li>åã®ããªã¬ã®ã¢ã¯ã·ã§ã³ã«INSERT/UPDATE/DELETEæããã£ã¦ã¯ãªãã¾ããã</li>
+<li>åã®ããªã¬ã®ã¢ã¯ã·ã§ã³ã§æ´æ°ãè¡ãæç¶ããå¼ã³åºãã¦ã¯ãªãã¾ããã</li>
+</ul></p><p>ããªã¬ãããSQLæã§ã¯ããªã¬ãå®ç¾©ããã表以å¤ã®ãã¼ã¿ãã¼ã¹ã®æ
å ±ãåç
§ãããã¨ãã§ãã¾ãããããã®ãã¼ã¿ãã¼ã¹ã®æ
å ±ãç ´æ£ããã¦ããå ´åãããªã¬ã¯ç¡å¹ã¨ãªãã¾ãã
+次åã®å®è¡ã«ã¦ããªã¬ã®åã³ã³ãã¤ã«ã失æããå ´åãå¼ã³åºãã¯ä¾å¤ãæãã¦ãããªã¬ãçºç«ãããæã¯ãã¼ã«ããã¯ããã¾ãã</p>
+<p>ããªã¬ãããSQLæã®è©³ç´°ã«ã¤ãã¦ã¯ã<cite><ph conref="../conrefs.dita#pub/citdevelop"></ph></cite>ãåç
§ãã¦ãã ããã</p> </section>
+<section><title>å®è¡ã®é åº</title> <p>ããªã¬ãçºç«ããããã¼ã¿ãã¼ã¹ã®ã¤ãã³ããèµ·ããã¨ã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯å¦çã次ã®é ã§è¡ãã¾ãã<ul>
+<li>æåã«<i>No Cascade Before</i>ãªããªã¬ã®ã¢ã¯ã·ã§ã³ãå®è¡ãã¾ãã</li>
+<li>次ã«ãå¶ç´(主ãã¼ãä¸æãã¼ãå¤é¨ãã¼)ã®æ¤è¨¼ãè¡ãã¾ãã</li>
+<li>ç¶ãã¦ãæ´æ°ãå¤æ´ãåé¤ãªã©ã®å¦çãè¡ãã¾ãã</li>
+<li>æå¾ã«<i>After</i>ãªããªã¬ãçºç«ãã¾ãã</li>
+</ul></p> <p>åã表ã«å¯¾ãã¦ãåãã¤ãã³ãã®ãçºç«ããæ(ããªã¬ãåãå¾ãã¨ããæå³ã§ãã)ãåãããªã¬ãè¤æ°å®ç¾©ããã¦ããå ´åãããªã¬ã¯ä½æãããé ã«å®è¡ããã¾ãã</p> </section>
+<example> <codeblock><b><ph>-- æã¨ããªã¬
+</ph>
+CREATE TRIGGER t1 NO CASCADE BEFORE UPDATE ON x
+ FOR EACH ROW MODE DB2SQL
+ values app.notifyEmail('Jerry', 'Table x is about to be updated');
+
+CREATE TRIGGER FLIGHTSDELETE
+ AFTER DELETE ON FLIGHTS
+ REFERENCING OLD_TABLE AS DELETEDFLIGHTS
+ FOR EACH STATEMENT
+ DELETE FROM FLIGHTAVAILABILITY WHERE FLIGHT_ID IN
+ (SELECT FLIGHT_ID FROM DELETEDFLIGHTS);
+
+CREATE TRIGGER FLIGHTSDELETE3
+ AFTER DELETE ON FLIGHTS
+ REFERENCING OLD AS OLD
+ FOR EACH ROW
+ DELETE FROM FLIGHTAVAILABILITY WHERE FLIGHT_ID = OLD.FLIGHT_ID;
+</b></codeblock> <note><cite><ph conref="../conrefs.dita#pub/citdevelop"></ph></cite>ã«ã¯ããå¤ãã®ä¾ãæ¸ããã¦ãã¾ãã</note> </example>
+<section><title>ããªã¬ã®å帰</title> <p>ããªã¬ã®å帰ã¯æ大16ã¾ã§ã§ãã</p> </section>
+<section><title>é¢é£ããæ
å ±</title>
+<p>ç¾å¨ã®æå»ãç¾å¨ã®ã¦ã¼ã¶ãè¿ãç¹æ®ã·ã¹ãã é¢æ°ã¯ãããªã¬ãä½æããã¨ãã§ã¯ãªããããªã¬ãçºç«ããã¨ãã«è©ä¾¡ããã¾ãããã®ãããªé¢æ°ã«ã¯ä»¥ä¸ã®ãã®ãããã¾ãã<ul>
+<li><xref href="rrefsqlj34177.dita#rrefsqlj34177"></xref></li>
+<li><xref href="rrefsqlj33772.dita#rrefsqlj33772"></xref></li>
+<li><xref href="rrefsqlj15866.dita#rrefsqlj15866"></xref></li>
+<li><xref href="rrefsqlj42324.dita#rrefsqlj42324"></xref></li>
+<li><xref href="rrefsqlj25228.dita#rrefsqlj25228"></xref></li>
+<li><xref href="rrefsqlj42476.dita#rrefsqlj42476"></xref></li>
+</ul></p> </section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj43125.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj55788.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj55788.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj55788.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj55788.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,82 @@
+<?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="rrefsqlj55788" xml:lang="en-us">
+<title>æ¨æºçµè¾¼ã¿é¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>functions<indexterm>standard built-in, list of</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>Derbyã«ã¦ãµãã¼ãããã¦ããæ¨æºçµã¿è¾¼ã¿é¢æ°ã¯ä»¥ä¸ã®ã¨ããã§ãã</p><ul>
+<li><xref href="rrefsqlj98067.dita#rrefsqlj98067"></xref></li>
+<li><xref href="rreffuncacos.dita#rreffuncacos"></xref></li>
+<li><xref href="rreffuncasin.dita#rreffuncasin"></xref></li>
+<li><xref href="rreffuncatan.dita#rreffuncatan"></xref></li>
+<li><xref href="rrefbuiltbigint.dita#rrefbuiltbigint"></xref></li>
+<li><xref href="rrefsqlj33562.dita#rrefsqlj33562"></xref></li>
+<li><xref href="rreffuncceil.dita#rreffuncceil"></xref></li>
+<li><xref href="rrefbuiltchar.dita#rrefbuiltchar"></xref></li>
+<li><xref href="rrefsqlj40899.dita#rrefsqlj40899"></xref></li>
+<li><xref href="rreffunccos.dita#rreffunccos"></xref></li>
+<li><xref href="rrefcasenullif.dita#rrefcasenullif"></xref></li>
+<li><xref href="rrefsqlj34177.dita#rrefsqlj34177"></xref></li>
+<li><xref href="rrefcurrentisolation.dita#rrefcurrentisolation"></xref></li>
+<li><xref href="rrefsqlj33772.dita#rrefsqlj33772"></xref></li>
+<li><xref href="rrefsqlj15866.dita#rrefsqlj15866"></xref></li>
+<li><xref href="rrefsqlj42324.dita#rrefsqlj42324"></xref></li>
+<li><xref href="rrefdatefunc.dita#rrefdatefunc"></xref></li>
+<li><xref href="rrefdayfunc.dita#rrefdayfunc"></xref></li>
+<li><xref href="rreffuncdegrees.dita#rreffuncdegrees"></xref></li>
+<li><xref href="rrefbuiltdouble.dita#rrefbuiltdouble"></xref></li>
+<li><xref href="rreffuncexp.dita#rreffuncexp"></xref></li>
+<li><xref href="rreffuncfloor.dita#rreffuncfloor"></xref></li>
+<li><xref href="rrefhourfunc.dita#rrefhourfunc"></xref></li>
+<li><xref href="rrefidentityvallocal.dita#rrefidentityvallocal"></xref></li>
+<li><xref href="rrefbuiltinteger.dita#rrefbuiltinteger"></xref></li>
+<li><xref href="rrefsqlj16762.dita#rrefsqlj16762"></xref></li>
+<li><xref href="rreffunclog.dita#rreffunclog"></xref></li>
+<li><xref href="rreffunclog10.dita#rreffunclog10"></xref></li>
+<li><xref href="rrefsqlj61998.dita#rrefsqlj61998"></xref></li>
+<li><xref href="rrefsqlj42049.dita#rrefsqlj42049"></xref></li>
+<li><xref href="rrefsqlj97870.dita#rrefsqlj97870"></xref></li>
+<li><xref href="rrefminutefunc.dita#rrefminutefunc"></xref></li>
+<li><xref href="rrefsqljmod.dita#rrefsqljmod"></xref></li>
+<li><xref href="rrefmonthfunc.dita#rrefmonthfunc"></xref></li>
+<li><xref href="rreffuncpi.dita#rreffuncpi"></xref></li>
+<li><xref href="rreffuncradians.dita#rreffuncradians"></xref></li>
+<li><xref href="rrefsqlj32613.dita#rrefsqlj32613"></xref></li>
+<li><xref href="rrefsecondfunc.dita#rrefsecondfunc"></xref></li>
+<li><xref href="rrefsqlj25228.dita#rrefsqlj25228"></xref></li>
+<li><xref href="rreffuncsin.dita#rreffuncsin"></xref></li>
+<li><xref href="rrefbuiltsmallint.dita#rrefbuiltsmallint"></xref></li>
+<li><xref href="rrefsqlj73147.dita#rrefsqlj73147"></xref></li>
+<li><xref href="rrefsqlj93082.dita#rrefsqlj93082"></xref></li>
+<li><xref href="rreffunctan.dita#rreffunctan"></xref></li>
+<li><xref href="rreftimefunc.dita#rreftimefunc"></xref></li>
+<li><xref href="rreftimestampfunc.dita#rreftimestampfunc"></xref></li>
+<li><xref href="rreftrimfunc.dita#rreftrimfunc"></xref></li>
+<li><xref href="rrefsqlj29930.dita#rrefsqlj29930"></xref></li>
+<li><xref href="rrefsqlj42476.dita#rrefsqlj42476"></xref></li>
+<li><xref href="rrefbuiltvarchar.dita#rrefbuiltvarchar"></xref></li>
+<li><xref href="rrefyearfunc.dita#rrefyearfunc"></xref></li>
+</ul></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj55788.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj57522.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj57522.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj57522.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj57522.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,72 @@
+<?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="rrefsqlj57522" xml:lang="ja">
+<title>RIGHT OUTER JOIN æ¼ç®</title>
+<prolog><metadata>
+<keywords><indexterm>RIGHT OUTER JOIN operation</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>RIGHT OUTER JOINæ¼ç®ã¯ãJOINç¯ã«ç½®ããã¨ã®ã§ãã<xref href="rrefsqlj29840.dita#rrefsqlj29840">JOINæ¼ç®</xref>ã®ä¸ç¨®ã§ãã
+ãã®å¼ã§ã¯ãä¸ã¤ç®(å·¦)ã®è¡¨ã«åãè¡ããªãäºã¤ç®(å³)ã®è¡¨ã«ããè¡ãçµæã«æ®ãã¾ãããã®ã¨ãä¸ã¤ç®ã®è¡¨ããã®æ
å ±ã¯NULLã¨æ±ããã¾ããA LEFT OUTER JOIN B 㯠B RIGHT OUTER JOIN Aã¨ãåã®é ãéãäºãé¤ãã°åãã§ãã</p></section>
+<refsyn><title>æ§æ</title><codeblock><b><i><xref href="rreftableexpression.dita#rreftableexpression">表å¼</xref></i> RIGHT [ OUTER ] JOIN <i
+><xref href="rreftableexpression.dita#rreftableexpression">表å¼</xref></i>
+{
+ ON <i>çå½å¼</i>
+ }</b></codeblock>
+<p>ONç¯ã«ã¦å¯è¦ãªã®ã¯ãç´æ¥ã®è¡¨ã¨ç´æ¥ã®SELECTã«ããååãã«ãã表ã§ãã
+ONç¯ã§ã¯çµåããã¦ããªã表ãåç
§ãããã¨ãã§ãã¾ãããçµåãã¦ãã表ãåç
§ããªãã¨ããã¾ãã¾ããã(ãã ãä¸è¬çã«ã¯åç
§ãã¾ãã)</p> </refsyn>
+<example> <title>ä¾1</title><codeblock>
+<b>-- é½å¸ã®ãªãå½ãå«ããã
+-- å
¨ã¦ã®å½ã¨é½å¸ã®ä¸è¦§ãå¾ã¾ãã
+</b>
+SELECT COUNTRIES.COUNTRY, CITIES.CITY_NAME
+FROM CITIES
+RIGHT OUTER JOIN COUNTRIES
+ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE
+
+<b>-- é½å¸ã®ãªãå½ãå«ããã
+-- ã¢ããªã«ã®å
¨ã¦ã®å½ã¨é½å¸ã®ä¸è¦§ãå¾ã¾ãã
+</b>
+SELECT COUNTRIES.COUNTRY, CITIES.CITY_NAME
+FROM CITIES
+RIGHT OUTER JOIN COUNTRIES
+ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE
+WHERE Countries.region = 'Africa'
+
+<b>-- RIGHT JOINã¨ããåãå
容ã®è¨è¿°ã«ããã
+-- åã®ä¾ã¨åãçµæãå¾ã¾ãã</b>
+SELECT COUNTRIES.COUNTRY, CITIES.CITY_NAME
+FROM CITIES
+RIGHT JOIN COUNTRIES
+ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE
+WHERE Countries.region = 'Africa'
+</codeblock> </example>
+<example><title>ä¾2</title><codeblock><b>-- æ¼ç®ã¯è¡¨å¼ã®ä¸ã¤ã§ãã
+-- ãªã®ã§FRONå¥ã«ã¯è¤æ°ã®æ¼ç®ãç½®ããã¨ãã§ãã¾ãã
+-- 以ä¸ã®ä¾ã§ã¯å
¨ç¤¾å¡ã®ç¤¾å¡çªå·ã¨èåãã
+-- ãã®ç¤¾å¡ã®ç®¡çè
ã®ç¤¾å¡çªå·ã¨èåã¨å
±ã«ä¸è¦§ãã¾ãã
+</b>
+SELECT E.EMPNO, E.LASTNAME, M.EMPNO, M.LASTNAME
+ FROM EMPLOYEE E RIGHT OUTER JOIN
+ DEPARTMENT RIGHT OUTER JOIN EMPLOYEE M
+ ON MGRNO = M.EMPNO
+ ON E.WORKDEPT = DEPTNO</codeblock></example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj57522.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj57924.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj57924.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj57924.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj57924.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="rrefsqlj57924" xml:lang="ja">
+<title>CHAR FOR BIT DATA ãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>CHAR FOR BIT DATA data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>CHAR FOR BIT DATAåã«ããã決ããããé·ãã®ãã¤ãã®ä¸¦ã³ãè¨é²ããäºãã§ãã¾ããããã¯ãæååã«ããè¨é²ãé©åã§ã¯ãªãæ§é åããã¦ããªãæ
å ±ãè¨é²ããã«ä¾¿å©ã§ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>{ CHAR | CHARACTER }[(<i>é·ã</i>)] FOR BIT DATA</b></codeblock> <p><i>é·ã</i>ã¯ç¬¦å·ã®ãªãæ´æ°ã®ãªãã©ã«ã§ãé·ãããã¤ãã§æå®ãã¾ãã</p>
+<p>CHAR FOR BIT DATAåã®æ¢å®ã®<i>é·ã</i>ã¯1ã§ããããã«æ大ã®<i>é·ã</i>ã¯254ãã¤ãã§ãã</p> </refsyn>
+<section><title>JDBC ã¡ã¿æ
å ±å(java.sql.Types)</title> <p>BINARY</p>
+<p>CHAR FOR BIT DATAã¯åºå®é·ã®ãã¤ãåãè¨é²ãã¾ããããå¤ã対象ã«ã¦å®ç¾©ãããé·ãããçããã®ã§ãã£ãå ´åã空ãã¯0x20ã¨ãããã¤ãå¤ã§ã¤ãããã¾ãã</p>
+<p>CHAR FOR BIT DATAã¨VARCHAR FOR BIT DATAã®å¤ã¯æ£ç¢ºã«æ¯è¼ããã¾ãã両æ¹ã®ãããåãçããã¨è©ä¾¡ãããããã«ã¯ã両æ¹ã<i>å®éã«</i>åãé·ãã§ãªããã°ãªãã¾ããã
+(ããã¯ãä»ã®DBMSã«ããããã¤ããªã®å¤ã®æ±ãã¨ã¯éãã®ã§ãããããã¯SQL-92ã«ã¦å®ç¾©ãããæ¯ãèãã§ãã</p>
+<p>VARCHAR FOR BIT DATAãCHAR FOR BIT DATAã®å¤ã¸ã®æä½(ä¾ãã°é£çµãªã©)ã¯VARCHAR FOR BIT DATAã«æºãã¾ãã</p> </section>
+<example> <p> <codeblock><b>CREATE TABLE t (b CHAR(2) FOR BIT DATA);
+INSERT INTO t VALUES (X'DE');
+SELECT *
+FROM t;
+<ph>-- 次ã®åºåãå¾ããã¾ãã</ph>
+B
+-----
+de20</b></codeblock></p> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj57924.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj58560.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj58560.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj58560.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj58560.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,1223 @@
+<?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="rrefsqlj58560" xml:lang="ja">
+<title>ãã¼ã¿åã¨ã代å
¥ã»æ¯è¼ã»ä¸¦ã³æ¿ãã»é åºä»ã</title>
+<shortdesc></shortdesc>
+<prolog><metadata>
+<keywords><indexterm>data types<indexterm>assignments and comparisions</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<table><title><ph conref="../conrefs.dita#prod/productshortname"></ph>ã«ã¦å¯è½ãªä»£å
¥</title>
+<desc>ãã®è¡¨ã§ã¯<ph conref="../conrefs.dita#prod/productshortname"></ph>ã«ã¦ä»£å
¥ã®å¯è½ãªãã¼ã¿åã®çµã¿åããã説æãã¾ãã"Y"ã¯ä»£å
¥ã§ãããã¨ã表ãã¾ãã</desc>
+<tgroup cols="20"><colspec colname="colspec0" colwidth="350*"/><colspec colname="col2"
+colwidth="84*"/><colspec colname="col3" colwidth="84*"/><colspec colname="col4"
+colwidth="84*"/><colspec colname="col5" colwidth="84*"/><colspec colname="col6"
+colwidth="81*"/><colspec colname="colspec1" colwidth="84*"/><colspec colname="colspec9"
+colwidth="84*"/><colspec colname="colspec8" colwidth="84*"/><colspec colname="colspec7"
+colwidth="84*"/><colspec colname="colspec6" colwidth="81*"/><colspec colname="colspec5"
+colwidth="84*"/><colspec colname="colspec4" colwidth="87*"/><colspec colname="colspec3"
+colwidth="81*"/><colspec colname="colspec2" colwidth="84*"/><colspec colname="colspec10"
+colwidth="84*"/><colspec colname="colspec13" colwidth="84*"/><colspec colname="colspec12"
+colwidth="84*"/><colspec colname="colspec11" colwidth="84*"/><colspec colname="COLSPEC14"
+colwidth="84*"/>
+<thead>
+<row>
+<entry colname="colspec0" valign="top">Types</entry>
+<entry colname="col2" valign="top"> <lines>S
+M
+A
+L
+L
+I
+N
+T</lines></entry>
+<entry colname="col3" valign="top"> <lines>I
+N
+T
+E
+G
+E
+R</lines></entry>
+<entry colname="col4" valign="top"> <lines>B
+I
+G
+I
+N
+T</lines></entry>
+<entry colname="col5" valign="top"> <lines>D
+E
+C
+I
+M
+A
+L</lines></entry>
+<entry colname="col6" valign="top"> <lines>R
+E
+A
+L</lines></entry>
+<entry colname="colspec1" valign="top"> <lines>D
+O
+U
+B
+L
+E</lines></entry>
+<entry colname="colspec9" valign="top"> <lines>F
+L
+O
+A
+T</lines></entry>
+<entry colname="colspec8" valign="top"> <lines>C
+H
+A
+R</lines></entry>
+<entry colname="colspec7" valign="top"> <lines>V
+A
+R
+C
+H
+A
+R</lines></entry>
+<entry colname="colspec6" valign="top"> <lines>L
+O
+N
+G
+
+V
+A
+R
+C
+H
+A
+R</lines></entry>
+<entry colname="colspec5" valign="top"> <lines>C
+H
+A
+R
+
+F
+O
+R
+
+B
+I
+T
+
+D
+A
+T
+A</lines></entry>
+<entry colname="colspec4" valign="top"> <lines>V
+A
+R
+C
+H
+A
+R
+
+F
+O
+R
+
+B
+I
+T
+
+D
+A
+T
+A</lines></entry>
+<entry colname="colspec3" valign="top"> <lines>L
+O
+N
+G
+
+V
+A
+R
+C
+H
+A
+R
+
+F
+O
+R
+
+B
+I
+T
+
+D
+A
+T
+A</lines></entry>
+<entry colname="colspec2" valign="top"> <lines>C
+L
+O
+B</lines></entry>
+<entry colname="colspec10" valign="top"> <lines>B
+L
+O
+B</lines></entry>
+<entry colname="colspec13" valign="top"> <lines>D
+A
+T
+E</lines></entry>
+<entry colname="colspec12" valign="top"> <lines>T
+I
+M
+E</lines></entry>
+<entry colname="colspec11" valign="top"> <lines>T
+I
+M
+E
+S
+T
+A
+M
+P</lines></entry>
+<entry colname="COLSPEC14" valign="top"> <lines>X
+M
+L</lines></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="colspec0">SMALL INT</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">INTEGER</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">BIGINT</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">DECIMAL</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">REAL</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">DOUBLE</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">FLOAT</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">CHAR</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">Y</entry>
+<entry colname="colspec7">Y</entry>
+<entry colname="colspec6">Y</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">Y</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">Y</entry>
+<entry colname="colspec12">Y</entry>
+<entry colname="colspec11">Y</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">VARCHAR</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">Y</entry>
+<entry colname="colspec7">Y</entry>
+<entry colname="colspec6">Y</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">Y</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">Y</entry>
+<entry colname="colspec12">Y</entry>
+<entry colname="colspec11">Y</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">LONG VARCHAR</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">Y</entry>
+<entry colname="colspec7">Y</entry>
+<entry colname="colspec6">Y</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">Y</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">CHAR FOR BIT DATA</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">Y</entry>
+<entry colname="colspec4">Y</entry>
+<entry colname="colspec3">Y</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">VARCHAR FOR BIT DATA</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">Y</entry>
+<entry colname="colspec4">Y</entry>
+<entry colname="colspec3">Y</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">LONG VARCHAR FOR BIT DATA</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">Y</entry>
+<entry colname="colspec4">Y</entry>
+<entry colname="colspec3">Y</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">CLOB</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">Y</entry>
+<entry colname="colspec7">Y</entry>
+<entry colname="colspec6">Y</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">Y</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">BLOB</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">Y</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">DATE</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">Y</entry>
+<entry colname="colspec7">Y</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">Y</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">TIME</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">Y</entry>
+<entry colname="colspec7">Y</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">Y</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">TIME STAMP</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">Y</entry>
+<entry colname="colspec7">Y</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">Y</entry>
+<entry colname="COLSPEC14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">XML</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">Y</entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+<table><title>Derbyã«ã¦å¯è½ãªæ¯è¼</title>
+<desc>ãã®è¡¨ã§ã¯<ph conref="../conrefs.dita#prod/productshortname"></ph>ã«ã¦æ¯è¼ãããã¨ã®ã§ããããã¼ã¿åã®çµã¿åããã示ãã¾ãã
+"Y"ã¯æ¯è¼ãå¯è½ã§ãããã¨ã表ãã¾ãã</desc>
+<tgroup cols="20"><colspec colname="colspec0" colwidth="350*"/><colspec colname="col2"
+colwidth="83*"/><colspec colname="col3" colwidth="83*"/><colspec colname="col4"
+colwidth="83*"/><colspec colname="col5" colwidth="83*"/><colspec colname="col6"
+colwidth="80*"/><colspec colname="colspec1" colwidth="83*"/><colspec colname="colspec9"
+colwidth="83*"/><colspec colname="colspec8" colwidth="83*"/><colspec colname="colspec7"
+colwidth="83*"/><colspec colname="colspec6" colwidth="80*"/><colspec colname="colspec5"
+colwidth="83*"/><colspec colname="colspec4" colwidth="86*"/><colspec colname="colspec3"
+colwidth="80*"/><colspec colname="colspec2" colwidth="83*"/><colspec colname="colspec10"
+colwidth="83*"/><colspec colname="colspec13" colwidth="75*"/><colspec colname="colspec12"
+colwidth="89*"/><colspec colname="colspec11" colwidth="89*"/><colspec colname="COLSPEC15"
+colwidth="89*"/>
+<thead>
+<row>
+<entry colname="colspec0" valign="top">Types</entry>
+<entry colname="col2" valign="top"> <lines>S
+M
+A
+L
+L
+I
+N
+T</lines></entry>
+<entry colname="col3" valign="top"> <lines>I
+N
+T
+E
+G
+E
+R</lines></entry>
+<entry colname="col4" valign="top"> <lines>B
+I
+G
+I
+N
+T</lines></entry>
+<entry colname="col5" valign="top"> <lines>D
+E
+C
+I
+M
+A
+L</lines></entry>
+<entry colname="col6" valign="top"> <lines>R
+E
+A
+L</lines></entry>
+<entry colname="colspec1" valign="top"> <lines>D
+O
+U
+B
+L
+E</lines></entry>
+<entry colname="colspec9" valign="top"> <lines>F
+L
+O
+A
+T</lines></entry>
+<entry colname="colspec8" valign="top"> <lines>C
+H
+A
+R</lines></entry>
+<entry colname="colspec7" valign="top"> <lines>V
+A
+R
+C
+H
+A
+R</lines></entry>
+<entry colname="colspec6" valign="top"> <lines>L
+O
+N
+G
+
+V
+A
+R
+C
+H
+A
+R</lines></entry>
+<entry colname="colspec5" valign="top"> <lines>C
+H
+A
+R
+
+F
+O
+R
+
+B
+I
+T
+
+D
+A
+T
+A</lines></entry>
+<entry colname="colspec4" valign="top"> <lines>V
+A
+R
+C
+H
+A
+R
+
+F
+O
+R
+
+B
+I
+T
+
+D
+A
+T
+A</lines></entry>
+<entry colname="colspec3" valign="top"> <lines>L
+O
+N
+G
+
+V
+A
+R
+C
+H
+A
+R
+
+F
+O
+R
+
+B
+I
+T
+
+D
+A
+T
+A</lines></entry>
+<entry colname="colspec2" valign="top"> <lines>C
+L
+O
+B</lines></entry>
+<entry colname="colspec10" valign="top"> <lines>B
+L
+O
+B</lines></entry>
+<entry colname="colspec13" valign="top"> <lines>D
+A
+T
+E</lines></entry>
+<entry colname="colspec12" valign="top"> <lines>T
+I
+M
+E</lines></entry>
+<entry colname="colspec11" valign="top"> <lines>T
+I
+M
+E
+S
+T
+A
+M
+P</lines></entry>
+<entry colname="COLSPEC15" valign="top"> <lines>X
+M
+L</lines></entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="colspec0">SMALL INT</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">INTEGER</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">BIGINT</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">DECIMAL</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">REAL</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">DOUBLE</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">FLOAT</entry>
+<entry colname="col2">Y</entry>
+<entry colname="col3">Y</entry>
+<entry colname="col4">Y</entry>
+<entry colname="col5">Y</entry>
+<entry colname="col6">Y</entry>
+<entry colname="colspec1">Y</entry>
+<entry colname="colspec9">Y</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">CHAR</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">Y</entry>
+<entry colname="colspec7">Y</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">Y</entry>
+<entry colname="colspec12">Y</entry>
+<entry colname="colspec11">Y</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">VARCHAR</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">Y</entry>
+<entry colname="colspec7">Y</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">Y</entry>
+<entry colname="colspec12">Y</entry>
+<entry colname="colspec11">Y</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">LONG VARCHAR</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">CHAR FOR BIT DATA</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">Y</entry>
+<entry colname="colspec4">Y</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">VARCHAR FOR BIT DATA</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">Y</entry>
+<entry colname="colspec4">Y</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">LONG VARCHAR FOR BIT DATA</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">CLOB</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">BLOB</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">DATE</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">Y</entry>
+<entry colname="colspec7">Y</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">Y</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">TIME</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">Y</entry>
+<entry colname="colspec7">Y</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">Y</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">TIME STAMP</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">Y</entry>
+<entry colname="colspec7">Y</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">Y</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">XML</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj58560.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj59893.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj59893.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj59893.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj59893.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqlj59893" xml:lang="ja">
+<title>DROP INDEX æ</title>
+<prolog><metadata>
+<keywords><indexterm>DROP INDEX statement</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>DROP INDEX ã§æå®ããç´¢å¼ã¯ç ´æ£ããã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>DROP INDEX <i><xref href="rrefindexname.dita#rrefindexname">ç´¢å¼å</xref></i></b></codeblock> </refsyn>
+<example> <codeblock><b>DROP INDEX OrigIndex
+
+DROP INDEX DestIndex</b></codeblock> </example>
+<section><title>æã®ä¾å</title>
+<p>ç ´æ£ãããã¨ãã¦ããç´¢å¼ããããã¼ãã«ã«ãéãã¦ããã«ã¼ã½ã«ãããå ´åãDROP INDEX æã¯ã¨ã©ã¼ã¨ãªã£ã¦ãç´¢å¼ã¯ç ´æ£ããã¾ãããç´¢å¼ãç ´æ£ãããå ´åã«ã¯ãç ´æ£ãããç´¢å¼ã®è¡¨ã«ä¾åãã¦ããæã¯ç¡å¹ã¨ãªãã¾ãã</p> </section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj59893.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj61102.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj61102.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj61102.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj61102.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,35 @@
+<?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="rrefsqlj61102" xml:lang="ja">
+<title>DROP VIEW æ</title>
+<prolog><metadata>
+<keywords><indexterm>DROP VIEW statement</indexterm><indexterm>Views<indexterm>dropping</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>æå®ãããã¥ã¼ãç ´æ£ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>DROP VIEW <xref href="rrefviewname.dita#rrefviewname">ãã¥ã¼å</xref></b></codeblock> </refsyn>
+<example> <codeblock><b>DROP VIEW AnIdentifier</b></codeblock> </example>
+<section><title>æã®ä¾å</title>
+<p>ãã¥ã¼ãåç
§ããæã¯ããã¥ã¼ãç ´æ£ãããã¨ãã«ç¡å¹ã«ãªãã¾ãããã¥ã¼ã«éããã«ã¼ã½ã«ãããå ´åãDROP VIEWã¯å®è¡ã§ãã¾ããããã¥ã¼ãä¾åãã¦ããæ
å ±ãç ´æ£ããåã«ããã¥ã¼ã¯ç ´æ£ãããªããã°ãªãã¾ããã</p> </section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj61102.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj61998.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj61998.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj61998.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj61998.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,56 @@
+<?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="rrefsqlj61998" xml:lang="ja">
+<title>LOCATEé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>LOCATE function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+ <section>
+ <p>LOCATEé¢æ°ã使ã£ã¦ãæååã®ä¸è´ããç®æãä»ã®æååããæ¢ãåºããã¨ãã§ãã¾ããæååãè¦ã¤ãã£ãå ´åãLOCATEã¯è¦ã¤ãã£ãä½ç½®ãè¿ãã¾ããè¦ã¤ãããªãã£ãå ´åãLOCATEã¯0ãè¿ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock id="i1195050"><b>LOCATE(<i>æåå¼</i>, <i>æåå¼</i> [, <i>éå§ä½ç½®</i>] ) </b>
+ </codeblock>
+ <p>LOCATEé¢æ°ã«ã¯å¿
é ãªäºã¤ã®å¼æ°ã¨ãä»»æã§æå®ã§ããä¸ã¤ç®ã®å¼æ°ãããã¾ãã
+ <ul>
+ <li>æåã®æåå¼ã§æå®ãããæåå<b>ã</b>æ¢ãåºããã¾ãã</li>
+ <li>äºã¤ç®ã®æåå¼ã§æå®ãããæåå<b>ãã</b>ãæ¢ãåºããã¾ãã</li>
+ <li>ä¸ã¤ç®ã®å¼æ°ã¯éå§ä½ç½®ã§ãäºã¤ç®ã®å¼æ°ã®ã©ã®ä½ç½®ããæååãæ¢ãåºãããæå®ãã¾ããããä¸ã¤ç®ã®å¼æ°ãæå®ãããªããã°ãLOCATEé¢æ°ã¯äºã¤ç®ã®å¼æ°ã®é ããæååãæ¢ãåºãã¾ãã</li>
+ </ul></p>
+ <p>LOCATEã®è¿ãå¤ã¯æ´æ°ã§ããLOCATEé¢æ°ã¯äºã¤ç®ã®å¼æ°ã®ãã¡ã§ãä¸ã¤ç®ã®å¼æ°ãæåã«è¦ã¤ãã£ãä½ç½®ã表ãæ´æ°ãè¿ãã¾ãããã®ä½ç½®ã¯1ããå§ã¾ãã¾ãã
+ããäºã¤ç®ã®å¼æ°ããä¸ã¤ç®ã®å¼æ°ãè¦ã¤ãããªãã£ãå ´åãLOCATEã¯0ãè¿ãã¾ããããä¸ã¤ç®ã®å¼æ°ã空æåå('')ã ã£ãå ´åã¯äºã¤ç®ã®å¼æ°ã空æååã§ãã£ãã¨ãã¦ããLOCATEã¯ä¸ã¤ç®ã®å¼æ°(ããæå®ããã¦ããªããã°1)ãè¿ãã¾ãã
+ããããã®æåå¼ã«NULLã渡ãããå ´åã¯NULLãè¿ãã¾ãã</p>
+</refsyn>
+<example>
+ <codeblock><b><ph>-- 'love'ã2ã®ä½ç½®ã§è¦ã¤ããã®ã§2ãè¿ãã</ph>
+ VALUES LOCATE('love', 'clover')</b></codeblock>
+ <codeblock><b><ph>-- 'clover'ãã'stove'ã¯è¦ã¤ãããªãã®ã§0ãè¿ãã</ph>
+ VALUES LOCATE('stove', 'clover')</b></codeblock>
+ <codeblock><b><ph>-- 5ãè¿ãã(éå§ä½ç½®ã¯4)</ph>
+ VALUES LOCATE('iss', 'Mississippi', 4)</b></codeblock>
+ <codeblock><b><ph>-- 空æååã¯ç¹å¥ã§1ãè¿ãã</ph>
+ VALUES LOCATE('', 'ABC')</b></codeblock>
+ <codeblock><b><ph>-- ''ãã'AAA'ã¯è¦ã¤ãããªãã®ã§0ãè¿ãã</ph>
+ VALUES LOCATE('AAA', '')</b></codeblock>
+ <codeblock><b><ph>-- 3ãè¿ãã</ph>
+ VALUES LOCATE('', '', 3)</b></codeblock>
+</example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj61998.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj66113.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj66113.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj66113.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj66113.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,33 @@
+<?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="rrefsqlj66113" xml:lang="ja">
+<title>COUNT(*) é¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>COUNT(*) aggregate function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>COUNT(*) ã¯è¡æ°ãæ°ããéç´é¢æ°ã§ããNULLãéè¤ã¯æé¤ããã¾ãããCOUNT(*)ã¯å¼ã¸ã®æä½ã§ã¯ããã¾ããã</p></section>
+<refsyn><title>åå¸</title><codeblock><b>COUNT(*)</b></codeblock>
+<p>çµæã®ãã¼ã¿åã¯<xref href="rrefsqlj10696.dita#rrefsqlj10696">INTEGER</xref>ã§ãã</p> </refsyn>
+<example> <codeblock><b><ph>-- Flightsã¨ãã表ã«ããè¡æ°ãæ°ãã¾ãã</ph>
+SELECT COUNT(*)
+FROM Flights</b></codeblock> </example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj66113.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native