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 [20/26] - in /db/derby/docs/trunk: ./ src/ja_JP/
src/ja_JP/ref/
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj24513.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj24513.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj24513.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj24513.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,90 @@
+<?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="rrefsqlj24513" xml:lang="ja">
+<title>CREATE TABLE æ</title>
+<prolog><metadata>
+<keywords><indexterm>CREATE TABLE statement</indexterm><indexterm><indexterm>SQL
+statements</indexterm>CREATE TABLE</indexterm><indexterm>tables<indexterm>creating</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>CREATE TABLEæã«ãã表ãä½æãã¾ãã表ã«ã¯åããã³å¶ç´ããã£ã¦ãæ
å ±ã沿ãã¹ãè¦åã決ãããã¦ãã¾ãã表ãã¨ã®å¶ç´ã¯åã®éåãªããã¯åãæå®ãã¾ããåã«ã¯ãã¼ã¿åã決ã¾ã£ã¦ãã¦ãåã®å¶ç´(åãã¨ã®å¶ç´)ãããã¾ãã</p>
+<p>表ã<xref href="rrefattrib26867.dita#rrefattrib26867">ãã¼ã¿ãã¼ã¹ã®ææè
</xref>ã¯èªåçã«ä»¥ä¸ã®æ¨©éãæã¡ãã¾ãä»ã®ã¦ã¼ã¶ã«ãããã®æ¨©éãä¸ããäºãã§ãã¾ãã<ul>
+<li>INSERT</li>
+<li>SELECT</li>
+<li>REFERENCES</li>
+<li>TRIGGER</li>
+<li>UPDATE</li>
+</ul>ãããã®æ¨©éã表ããã¼ã¿ãã¼ã¹ã®ææè
ããå¥å¥ªãããã¨ã¯ã§ãã¾ããã</p>
+<p>å¶ç´ã«ã¤ãã¦ã®æ
å ±ã¯ã<xref href="rrefsqlj13590.dita#rrefsqlj13590"></xref>ãåç
§ãã¦ãã ããã</p>
+<p>åã«ã¯æ¢å®å¤ãä¸ãããã¨ãã§ãã¾ããæ¢å®å¤ã¨ã¯å¤ãæå®ãããªãã£ãã¨ããåã«æ¿å
¥ãããå¤ã§ããæ示ãããªãå ´ååã®æ¢å®å¤ã¯NULLã§ãã詳細ã¯<xref href="rrefsqlj30540.dita#rrefsqlj30540/sqlj64478"></xref>ãåç
§ãã¦ãã ããã</p>
+<p><codeph>SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY</codeph>ã¨ããã·ã¹ãã ã®æç¶ãå¼ã¶ãã¨ã§ããã¼ã¸ãµã¤ãºã®ãããªè¨é²ã®å±æ§ãè¨å®ãããã¨ãã§ãã¾ãã</p>
+<p>表ãéå®ããå ´åãã¹ãã¼ãåã¯<i>SYS</i>ã§å§ã¾ã£ã¦ã¯ãªãã¾ããã</p></section>
+<refsyn><title>æ§æ</title>
+ <p>CREATE TABLEã«ã¯äºéãã®æ¸ãæ¹ãããã¾ããããã¯ãåã®å®ç¾©ã¨å¶ç´ãæå®ãããã¨ããããåãåããå¼ã®çµæã«åºã¥ãåãå®ç¾©ãããã«ããã¾ãã</p>
+<codeblock><b>CREATE TABLE <i><xref href="rreftablename.dita#rreftablename">表å</xref></i></b>
+ ( {<i><xref href="rrefsqlj30540.dita#rrefsqlj30540">åå®ç¾©</xref></i> | <i><xref
+href="rrefsqlj42154.dita#rrefsqlj42154">表æ¯å¶ç´</xref></i>}
+ [ , {<i><xref href="rrefsqlj30540.dita#rrefsqlj30540">åå®ç¾©</xref></i> | <i><xref
+href="rrefsqlj42154.dita#rrefsqlj42154">表æ¯å¶ç´</xref></i>} ] * )
+ |
+ [ ( <i><xref href="rrefsimplecolumnname.dita#rrefsimplecolumnname">åå</xref></i> [ , <i><xref href="rrefsimplecolumnname.dita#rrefsimplecolumnname">åå</xref></i> ] * ) ]
+ <b>AS</b> <i>åãåããå¼</i>
+ <b>WITH NO DATA</b>
+ }
+
+</codeblock> </refsyn>
+<example><title>ä¾</title><codeblock><b>CREATE TABLE HOTELAVAILABILITY
+ (HOTEL_ID INT NOT NULL, BOOKING_DATE DATE NOT NULL,
+ ROOMS_TAKEN INT DEFAULT 0, PRIMARY KEY (HOTEL_ID, BOOKING_DATE));
+<ph>-- 表ã§ä¸»ãã¼ãå®ç¾©ãããã¨ã§ã2åãããªã主ãã¼ãå®ç¾©ã§ãã¾ãã</ph>
+PRIMARY KEY (hotel_id, booking_date))
+<ph>-- èå¥ååã®å±æ§ããINTEGERã®åã«ä¸ãã
+-- ããã«åã«ä¸»ãã¼å¶ç´ãå®ç¾©ãã¾ãã</ph>
+CREATE TABLE PEOPLE
+ (PERSON_ID INT NOT NULL GENERATED ALWAYS AS IDENTITY
+ CONSTRAINT PEOPLE_PK PRIMARY KEY, PERSON VARCHAR(26));
+<ph>-- èå¥ååã®å±æ§ããSMALLINTã®åã«ä¸ãã
+-- åæå¤ã5ã«å¢åå¤ã5ã«è¨å®ãã¾ãã</ph>
+CREATE TABLE GROUPS
+ (GROUP_ID SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY
+ (START WITH 5, INCREMENT BY 5), ADDRESS VARCHAR(100), PHONE VARCHAR(15));</b></codeblock><note>ãã¾ãã¾ãªå¶ç´ã使ã£ããããå¤ãã®CREATE TABLEæã®ä¾ã<xref href="rrefsqlj13590.dita#rrefsqlj13590"></xref>ã«ããã¾ãã</note> </example>
+<section><title>CREATE TABLE ... AS ... </title>
+ <p>ããä¸ã¤ã®CREATE TABLEæã®æ¸ãæ¹ã¯ãåãåããã§åã®ååã¨/ãããã¯åã®ãã¼ã¿åãæå®ãã¾ããåãåããçµæã®åã¯ãæ°ãã表ã®ååãä½æããã¨ãã«ã¢ãã«ã¨ãã¦å©ç¨ããã¾ãã</p>
+<p>æ°ãã表ã«ååãæå®ãããªãã£ãå ´åãåãåããã®çµæã®å
¨åããæ°ãã表ã«åãååã¨å¯¾å¿ãããã¼ã¿åã§ä½æããã¾ãã
+ã²ã¨ã¤ãããã¯ãã以ä¸ã®åã®ååãæ°ãã表ã«æå®ãããå ´åãåãåããå¼ã®çµæã«ã¯åæ°ã®åãç¡ããã°ãªãã¾ãããåãåããçµæã®åã®ãã¼ã¿åã¯æ°ãã表ã®å¯¾å¿ããåã«å¼ãç¶ããã¾ãã</p>
+<p>WITH NO DATAç¯ã¯åãåããçµæè¡ã®ãã¼ã¿ã¯ä½¿ããããåã®å称ã¨åã ããå©ç¨ããããã¨ã表ãã¾ãã
+WITH NO DATAã¯<b>å¿
ã</b>æå®ãã¦ãã ãããä»å¾ã®ãªãªã¼ã¹ã«ã¦ãDerbyã§ãWITH DATAãæå®ãã¦ãåãåããå¼ã®çµæãæ°è¦ä½æããã表ã«æ¿å
¥ããããã«åºæ¥ãããã«ãªãããããã¾ããããããç¾å¨ã®ãªãªã¼ã¹ã§ã¯ãWITH NO DATAã®æããå¦çããã¾ããã</p>
+</section>
+<example><title>ä¾</title>
+ <codeblock><b>
+<ph>-- æ¢åã®è¡¨ã®å
¨åã¨ãã¼ã¿åã使ã£ã¦æ°ãã表ãä½æããã</ph>
+CREATE TABLE T3 AS SELECT * FROM T1 WITH NO DATA;
+<ph>-- åã«ååãæå®ãã¦è¡¨ãä½æããããã®ãã¼ã¿åã¯æ¢å表ã®åã«æ²¿ã£ããã®ã¨ããã</ph>
+CREATE TABLE T3 (A,B,C,D,E) AS SELECT * FROM T1 WITH NO DATA;
+<ph>-- åã«ååãæå®ãã¦è¡¨ãä½æããããã®ãã¼ã¿åã¯æ¢å表ã®æå®ãããåã®ãã¼ã¿åã«æ²¿ã£ããã®ã¨ããã</ph>
+CREATE TABLE T3 (A,B,C) AS SELECT V,DP,I FROM T1 WITH NO DATA;
+<ph>-- ãã®ä¾ã§ã¯åãåããå¼ã®çµæã«ããåã«ååããªããããã®ãã¼ã¿åã¯æ°è¦ä½æããã表ã«ã¦å¯¾å¿ããåã®ãã¼ã¿åã¨ãªãã</ph>
+CREATE TABLE T3 (X,Y) AS SELECT 2*I,2.0*F FROM T1 WITH NO DATA;
+</b></codeblock>
+</example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj24513.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj25228.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj25228.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj25228.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj25228.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="rrefsqlj25228" xml:lang="ja">
+<title>SESSION_USERé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>SESSION_USER function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>SESSION_USERã¯ãç¾å¨ã®ã¦ã¼ã¶ã®èªè¨¼èå¥åãããã¯ååãè¿ãã¾ãã
+ç¾å¨ã®ã¦ã¼ã¶ããªãå ´åã¯ã<i>APP</i>ãè¿ãã¾ãã</p>
+<p><xref
+href="rrefsqlj42476.dita#rrefsqlj42476">USER</xref>ã<xref href="rrefsqlj42324.dita#rrefsqlj42324">CURRENT_USER</xref>ã
+SESSION_USER ã¯äºãã«å¥åã§ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>SESSION_USER</b></codeblock> </refsyn>
+<example> <codeblock><b>VALUES SESSION_USER</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj25228.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj26498.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj26498.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj26498.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj26498.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,75 @@
+<?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="rrefsqlj26498" xml:lang="ja">
+<title>UPDATEæ</title>
+<prolog><metadata>
+<keywords><indexterm>UPDATE statement</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<refsyn><title>æ§æ</title> <codeblock><b>{
+ UPDATE <i><xref href="rreftablename.dita#rreftablename">表å</xref></i>
+ SET <i><xref href="rrefcolumnname.dita#rrefcolumnname">åå</xref></i> = <i>å¤</i>
+ [ , <i><xref href="rrefcolumnname.dita#rrefcolumnname">åå</xref></i> = <i>å¤</i>} ]*
+ [<i><xref href="rrefsqlj33602.dita#rrefsqlj33602">WHEREç¯</xref></i>] |
+ UPDATE <i><xref href="rreftablename.dita#rreftablename">表å</xref></i>
+ SET <i><xref href="rrefcolumnname.dita#rrefcolumnname">åå</xref></i> = <i>å¤</i>
+ [ , <i><xref href="rrefcolumnname.dita#rrefcolumnname">åå</xref></i> = <i>å¤</i> ]*
+ <i><xref href="rrefsqlj15309.dita#rrefsqlj15309">WHERE CURRENT OF</xref></i>
+}</b></codeblock>
+<p><varname>å¤</varname>ã®å®ç¾©ã¯ä»¥ä¸ã®éãã§ãã</p>
+<codeblock><b><i>å¼</i> | DEFAULT</b></codeblock>
+<p>ä¸ã¤ç®ã®æ¸ãæ¹ã¯æ¤ç´¢ã«ããæ´æ°ã¨ãããWHEREç¯ãçã«è©ä¾¡ãããå
¨è¡ã®ä¸ã¤ä»¥ä¸ã®åãæ´æ°ãã¾ãã</p>
+<p>äºã¤ç®ã®æ¸ãæ¹ã¯ä½ç½®ã«ããæ´æ°ã¨ãããæ´æ°å¯è½ãªéããã«ã¼ã½ã«ã®ç¾å¨è¡ã®ä¸ã¤ä»¥ä¸ã®åãæ´æ°ãã¾ããã«ã¼ã½ã«ãä½æããSELECTæã®<xref href="rrefsqlj31783.dita#rrefsqlj31783">FOR UPDATE ç¯</xref>ã«ã¦åãæ示ãããå ´åããã®åã ããæ´æ°å¯è½ã§ããããåãæ示ããã¦ããªããSELECTæã«FOR UPDATEç¯ãç¡ãã£ãå ´åã¯ãå
¨ã¦ã®åãæ´æ°ã§ãã¾ãã</p>
+<p>æ´æ°å¾ã®å¤ã«DEFAULTãæå®ããã¨ã表ã«ã¦å®ç¾©ãããæ¢å®å¤ã«åã®å¤ãè¨å®ããã¾ãã</p> </refsyn>
+<example><title>ä¾</title> <codeblock><b>
+<ph>
+-- 'E21'ã®é¨ç½²(WORKDEPT)ã«ã¦ç®¡çè
以å¤ãä¸æçã«åé
å±ããã¦ããã
+-- ãã®ãã¨ããEMPLOYEEã¨ãã表ã®å½¼ãã®ä»äº(JOB)ãNULLã«ã
+-- å½¼ãã¸ã®æ¯æã(SALARY, BONUS, COMM)ã0ã«ãã¦ããããã</ph>
+UPDATE EMPLOYEE
+ SET JOB=NULL, SALARY=0, BONUS=0, COMM=0
+ WHERE WORKDEPT = 'E21' AND JOB <> 'MANAGER'
+
+-- ç¹å®ã®è©æ¸ããæããªã社å¡ã管çè
ã«ææ ¼ããã
+UPDATE EMPLOYEE
+ SET JOB = 'MANAGER'
+ WHERE JOB IS NULL;
+<ph>// å
¨ã¦ã®ããã¸ã§ã¯ãã®äººå¡é
ç½®(PRSTAFF)ã1.5å¢ããã</ph>
+stmt.executeUpdate("UPDATE PROJECT SET PRSTAFF = "
+"PRSTAFF + 1.5" +
+"WHERE CURRENT OF" + ResultSet.getCursorName());
+
+<ph>-- EMPLOYEEã¨ãã表ã«ã¦ç¤¾å¡çªå·(EMPNO)ã'000290'ã®ç¤¾å¡ã®ä»äº(JOB)ãã
+-- æ¢å®å¤ã§ããNULLã«æ´æ°ããã</ph>
+UPDATE EMPLOYEE
+ SET JOB = DEFAULT
+ WHERE EMPNO = '000290'
+</b></codeblock> </example>
+<section><title>æã®ä¾å</title> <p>æ¤ç´¢ã«ããæ´æ°ã®æã¯ãæ´æ°ãããã¨ãã¦ãã表ãããã®ã³ã³ã°ãããªãã(ãã¼ããç´¢å¼ãªã©ã®è¨é²åä½)ããã®å¶ç´ãWHEREç¯ãSETå¼ã«æ¸ããã表ã«ä¾åãã¾ããæ¤ç´¢ã«ããæ´æ°ã®æºåãããæã®å¯¾è±¡è¡¨ã«CREATE INDEXãDROP INDEXæãALTER TABLEæãå®è¡ãããã¨ããã®æã¯ç¡å¹ã¨ãªãã¾ãã</p>
+<p>ä½ç½®ã«ããæ´æ°ã®æã¯ã«ã¼ã½ã«ãã«ã¼ã½ã«ãåç
§ããå
¨ã¦ã®è¡¨ã«ä¾åãã¾ããã«ã¼ã½ã«ãã¾ã éãã¦ããªãã¨ããä½ç½®ã«ããæ´æ°ã®æãã³ã³ãã¤ã«ãããã¨ãã§ãã¾ããããããªããJDBCã®<i>close</i>ã¡ã½ããã«ããéããã«ã¼ã½ã«ããªããã¨ãä½ç½®ã«ããæ´æ°ã®æã¯ç¡å¹ã¨ãªãã¾ãã</p>
+<p>
+ä½ç½®ã«ããæ´æ°ã®æºåãããæã®å¯¾è±¡è¡¨ã«ãCREATE INDEXãDROP INDEXæãALTER TABLEæãå®è¡ãããã¨ããã®æã¯ç¡å¹ã¨ãªãã¾ãã
+</p>
+<p>å¥åãç ´æ£ããã¨ããã®å¥åã使ã£ã¦ããæ´æ°ã®æºåãããæã¯ç¡å¹ã«ãªãã¾ãã</p>
+<p>æ´æ°ã®å¯¾è±¡è¡¨ã«ã¦ããªã¬ã®ç ´æ£ãä½æãè¡ãããã¨ãæ´æ°ã®æã¯ç¡å¹ã«ãªãã¾ãã</p> </section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj26498.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27281.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27281.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27281.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27281.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="rrefsqlj27281" xml:lang="ja">
+<title>FLOATãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>FLOAT data type<indexterm>as alias for REAL or DOUBLE
+PRECISION</indexterm></indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>FLOATã¯ãæå®ãã精度ã«ããREALãããã¯DOUBLE PRECISIONã®å¥åã¨ãªãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>FLOAT [ (<i>精度</i>) ]</b></codeblock> <p>æ¢å®ã®<i>精度</i>ã¯53ã§ãããã¯DOUBLE PRECISIONã¨åçã§ãã
+精度ã23以ä¸ã§ããå ´åãFLOATã¯REALã¨åçã«ãªãã¾ãã精度ã24以ä¸ã§ããå ´åãFLOATã¯DOUBLE PRECISIONã¨åçã¨ãªãã¾ãããã精度ã«0ãæå®ããã¨ãã¨ã©ã¼ã¨ãªãã¾ããããè² ã®ç²¾åº¦ãæå®ããã¨ãæ§æã¨ã©ã¼ã¨ãªãã¾ãã</p> </refsyn>
+<section><title>JDBC ã®ã¡ã¿ãã¼ã¿å (java.sql.Types)</title> <p>REAL
+or DOUBLE</p> </section>
+<section><title>å¶é</title>
+<p>ãã24以ä¸ã®ç²¾åº¦ãæå®ããå ´åãFLOATã«ã¯DOUBLEã¨åãå¶éããããã¾ãã</p>
+<p>ãã23以ä¸ã®ç²¾åº¦ãæå®ããå ´åãFLOATã«ã¯REALã¨åãå¶éããããã¾ãã</p> </section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27281.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27620.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27620.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27620.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27620.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,42 @@
+<?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="rrefsqlj27620" xml:lang="ja">
+<title>TIMESTAMPãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>TIMESTAMP data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>TIMESTAMPã§ã¯æ¥ä»ã¨æå»ãçµåãããå¤ãè¨é²ããã¾ããã¾ãç§ã®å°æ°ç¹ä»¥ä¸ã9æ¡ã®å¤ãè¨é²ããã¾ãã</p></section>
+<refsyn><title>æ§æ</title><codeblock><b>TIMESTAMP</b></codeblock> </refsyn>
+<section><title>対å¿ããã³ã³ãã¤ã«æã®Javaã®å</title><p><i>java.sql.Timestamp</i></p> </section>
+<section><title>JDBC ã¡ã¿ãã¼ã¿å (java.sql.Types)</title><p>TIMESTAMP</p>
+<p>æ¥ä»ãæå»ãã¿ã¤ã ã¹ã¿ã³ãã¯ãä¸ã¤ã®å¼ã§æ··å¨ãã¦ä½¿ãã¾ããã</p>
+<p><ph
+conref="../conrefs.dita#prod/productshortname"></ph>ã§ã¯TIMESTAMPã以ä¸ã®æ¸å¼ã§æ¸ãã¾ãã<codeblock>yyyy-mm-dd hh:mm:ss[.nnnnnn]
+yyyy-mm-dd-hh.mm.ss[.nnnnnn]</codeblock>
+ä¸è¨ã®äºã¤ã®æ¸å¼ã®ãã¡ãæåã®ä¸ã¤ã¯<i>java.sql.Timestamp</i>ã®æ¸å¼ã§ãã</p>
+<p>å¹´ã¯å¸¸ã«4æåã®æ°åã§è¡¨ãããªããã°ãªãã¾ãããæãæ¥ãæã¯1æåãããã¯2æåã®æ°åã¨ãããã¨ãã§ãã¾ããåãç§ã¯2æåã®æ°åã§è¡¨ãããªããã°ãªãã¾ãããããã»ã«ã³ããæ¸ãããå ´åã1æåãã6æåã®æ°åã§è¡¨ããã¾ãã</p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph> ã¯ãã¼ã¿ãã¼ã¹ãµã¼ãã®ãã±ã¼ã«ã«åºæã®æ¥ææ¸å¼ã§æ¸ãããæååãåãä»ãã¾ããããé©ç¨ããã¹ãæ¸å¼ãææ§ã§ããå ´åãå
ã«è¿°ã¹ãçµè¾¼ã¿ã®æ¸å¼ãåªå
ããã¾ãã</p> </section>
+<example> <title>ä¾</title><codeblock><b>VALUES '1960-01-01 23:03:20'
+VALUES TIMESTAMP('1962-09-23 03:23:34.234')
+VALUES TIMESTAMP('1960-01-01 23:03:20')</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27620.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27767.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27767.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27767.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27767.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,73 @@
+<?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="rrefsqlj27767" xml:lang="ja">
+<title>å¼ã«ã¦è¡ãããæ°å¤åã®é
ç®</title>
+<refbody>
+<section><p>å¼ã«ã¦æ´æ°åã使ãããã¨ã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯çµæã®åãå°ãªãã¨ãINTEGERã«ã¾ã§ææ ¼ãã¾ããå¼ã«ã¦æ´æ°åã¨éæ´æ°åãæ··å¨ãã¦ä½¿ãããã¨ã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯å¼ã®çµæãå¼ä¸ã®æãé«ãåã«ææ ¼ãã¾ãã<xref
+href="#rrefsqlj27767/sqlj39640"></xref>ã«ã¦ãå¼ä¸ã®ãã¼ã¿åã®ææ ¼ã説æãã¾ãã
+
+ <table frame="all" id="sqlj39640"><title>å¼ã«ã¦è¡ãããåã®ææ ¼</title>
+<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="1" colnum="1" colwidth="62*"/>
+<colspec colname="2" colnum="2" colwidth="38*"/>
+<thead>
+<row>
+<entry align="left" colname="1" valign="bottom">å¼ã«ãããæã大ããªå</entry>
+<entry align="left" colname="2" valign="bottom">å¼ã®çµæå</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="1">DOUBLE PRECISION</entry>
+<entry colname="2">DOUBLE PRECISION</entry>
+</row>
+<row>
+<entry colname="1">REAL</entry>
+<entry colname="2">DOUBLE PRECISION</entry>
+</row>
+<row>
+<entry colname="1">DECIMAL</entry>
+<entry colname="2">DECIMAL</entry>
+</row>
+<row>
+<entry colname="1">BIGINT</entry>
+<entry colname="2">BIGINT</entry>
+</row>
+<row>
+<entry colname="1">INTEGER</entry>
+<entry colname="2">INTEGER</entry>
+</row>
+<row>
+<entry colname="1">SMALLINT</entry>
+<entry colname="2">INTEGER</entry>
+</row>
+</tbody>
+</tgroup>
+</table></p></section>
+<section><p>ä¾:
+<codeblock><b><ph>-- å精度浮åå°æ°ç¹æ°ãè¿ãã¾ãã</ph>
+VALUES 1 + 1.0e0
+<ph>-- å°æ°ã®æ°ãè¿ãã¾ãã</ph>
+VALUES 1 + 1.0
+<ph>-- æ´æ°ãè¿ãã¾ãã</ph>
+VALUES CAST (1 AS INT) + CAST (1 AS INT)</b></codeblock></p></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27767.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27781.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27781.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27781.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27781.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,54 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqlj27781" xml:lang="en-us">
+<title>MAXé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>MAX aggregate function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>MAXã¯è¡ã®éåããæ大ã®å¤ãæ±ããéç´é¢æ°ã§ãã(<xref href="rrefsqlj33923.dita#rrefsqlj33923"></xref>ãåç
§ãã¦ãã ããã)
+MAXã¯çµã¿è¾¼ã¾ãããã¼ã¿åã®å¼ã«å¯¾ãã¦ã®ã¿é©ç¨ãããã¨ãã§ãã¾ãã
+(CHARãVARCHARãDATEãTIMEãCHAR FOR BIT DATAçãå«ã¿ã¾ãã)</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>MAX ( [ DISTINCT | ALL ] <i>å¼</i> )</b></codeblock> <p>DISTINCTãALLã¨ããéå®è©ã«ãããéè¤ãé¤å»ãããããã®ã¾ã¾æ®ãããã決ã¾ãã¾ããããããã®éå®è©ã¯MAXã®å¼ã§ã¯æå³ãæã¡ã¾ããã
+<i><xref href="rrefselectexpression.dita#rrefselectexpression">é¸æå¼</xref></i>ã«ç½®ããã¨ã®ã§ãããDISTINCTã®éå®è©ã¯ä¸ã¤ã ãã§ãã
+ä¾ãã°ã次ã®ååãã¯è¨±ããã¦ãã¾ããã
+<codeblock><b>SELECT COUNT (DISTINCT flying_time), MAX (DISTINCT miles)
+FROM Flights</b></codeblock></p>
+<p><i>å¼</i>ã¯è¤æ°ã®åã¸ã®åç
§ãå¼ãå«ããã¨ãã§ãã¾ãããä»ã®éç´ãå¯ååããå«ããã¨ã¯ã§ãã¾ããã
+ã¾ãçµè¾¼ã¿ã®ãã¼ã¿åã«è©ä¾¡ãããªããã°ãªãã¾ããã
+å¾ã£ã¦çµè¾¼ã¿ã®ãã¼ã¿åã¨è©ä¾¡ãããã¡ã½ãããå¼ã¶ãã¨ãã§ãã¾ãã
+(ä¾ãã°<i>java.lang.Integer</i>ã<i>int</i>ãè¿ãã¡ã½ããã¯INTEGERã¨è©ä¾¡ããã¾ãã)
+ããå¼ãNULLã¨è©ä¾¡ãããå ´åãéç´ã«ããã¦ãã®å¤ã¯ç¡è¦ããã¾ãã</p>
+<p>CHARãVARCHARã«ã¤ãã¦ã¯ãå¤ã®æ«å°¾ã«ãã空ç½æååã¯ãMAXã®æ¯ãèãã«å½±é¿ãããã¾ãã
+ãã¨ãã°ã'z'ã¨'z 'ã®ä¸¡æ¹ãåã«æ ¼ç´ããã¦ããå ´åã空ç½ã¯æ¯è¼ã«ã¦ç¡è¦ãããã®ã§çµæã¯ä¸å®ã§ãããä½ããçæ¹ã®å¤ãè¿ããã¾ãã</p>
+<p>çµæã®ãã¼ã¿åã¯MAXãåä½ããå¼ã¨åããã®ã¨ãªãã¾ãã(ãªã¼ãã¼ããã¼ãããã¨ã¯ããã¾ããã)</p> </refsyn>
+<example> <codeblock><b><ph>-- FlightAvailabilityã¨ãã表ããæè¿ã®æ¥ä»ãæ¢ãã</ph>
+SELECT MAX (flight_date) FROM FlightAvailability
+<ph>-- ããããã®ç©ºæ¸¯ãåºçºããæãé·è·é¢ã®ä¾¿ãæ¢ãã
+-- ãªã10æé以ä¸ã®ä¾¿ã®ã¿ã¨ããã</ph>
+SELECT MAX(flying_time), orig_airport
+FROM Flights
+GROUP BY orig_airport
+HAVING MAX(flying_time) > 10
+</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj27781.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj28468.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj28468.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj28468.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj28468.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,63 @@
+<?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="rrefsqlj28468" xml:lang="ja">
+<title>大æåå°æåã¨ç¹æ®æå</title>
+<prolog><metadata>
+<keywords><indexterm>Case sensitivity of keywords and identifiers</indexterm>
+<indexterm>Keywords<indexterm>case insensitivity of</indexterm></indexterm>
+<indexterm>Special characters<indexterm>escaping in SQL statements</indexterm></indexterm>
+<indexterm>Escape character<indexterm>for single-quotation mark</indexterm></indexterm>
+<indexterm>Strings<indexterm>delimited by single quotation marks within SQL
+statements</indexterm></indexterm><indexterm>Unicode escapes<indexterm>support
+for in SQL statements</indexterm></indexterm><indexterm>Java identifiers<indexterm>case
+sensitivity of within SQL</indexterm></indexterm><indexterm>* as wildcard
+in SQL SELECT</indexterm><indexterm>% as wildcard in SQL</indexterm><indexterm>_
+as wildcard within SQL</indexterm><indexterm>Wildcards in SQL</indexterm>
+<indexterm>Comment delimiters within SQL</indexterm><indexterm>-- (comment
+delimiters within SQL)</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section><p>JDBCã®ã¯ã©ã¹ãã¡ã½ããã«SQLæã®æååã渡ãã¦ã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã«SQLãçºè¡ãããã¨ãã§ãã¾ãã
+SQLæã®æååã«å¯è½ãªæåã»ããã¯Unicodeã§ãããã®æååã«ã¯ã次ã®è¦åãé©ç¨ããã¾ãã<ul>
+<li>äºéå¼ç¨ç¬¦ã§SQL-92ã«å®ç¾©ããã¦ããç¹æ®èå¥åãããªãããã¦ã<i>ããªãããããèå¥å</i>ã¨ãããã¨ãã§ãã¾ãã</li>
+<li>ä¸éå¼ç¨ç¬¦ã§æåã®åãåºåããã¨ãã§ãã¾ãã</li>
+<li>æåã®åã«ã¦ä¸éå¼ç¨ç¬¦ã¾ãã¯ã¢ãã¹ãããã£ã¼ãããããã«ã¯ãä¸éå¼ç¨ç¬¦ã2ã¤ä¸¦ã¹ã¾ãã(è¨ãæ¹ãå¤ããã°ãä¸éå¼ç¨ç¬¦ã¯ä¸éå¼ç¨ç¬¦ã®ã¨ã¹ã±ã¼ãæåã§ãã)<p>äºéå¼ç¨ç¬¦ã«ã¯ã¨ã¹ã±ã¼ãæåãå¿
è¦ã§ã¯ããã¾ãããäºéå¼ç¨ç¬¦ãããããã«ã¯ãåã«äºéå¼ç¨ç¬¦ã使ã£ã¦ãã ããããã ããJavaã®ããã°ã©ã ã§ã¯ãäºéå¼ç¨ç¬¦ã¯ããã¯ã¹ã©ãã·ã¥ã«ããã¨ã¹ã±ã¼ãã�
�å¿
è¦ã§ãããã¨ãæ°ã«çããå¿
è¦ãããã¾ãã</p><ph><b>ä¾:</b></ph>
+<codeblock><b><ph>-- ä¸éå¼ç¨ç¬¦ã¯ã¨ã¹ã±ã¼ãæåã§ã-- ä¸éå¼ç¨ç¬¦ã«å¯¾ãã¦</ph>
+
+VALUES 'Joe''s umbrella'
+<ph>-- ijã§ã¯äºéå¼ç¨ç¬¦ã¯ã¨ã¹ã±ã¼ãããã¾ããã</ph>
+VALUES 'He said, "hello!"'
+
+n = stmt.executeUpdate(
+ "UPDATE aTable setStringcol = 'He said, \"hello!\"'");</b></codeblock></li>
+<li>SQLã®ãã¼ã¯ã¼ãã¯å¤§æåå°æåãåºå¥ãã¾ãããä¾ãã°ãSELECTã¨ãããã¼ã¯ã¼ãã¯ãSELECTãSelectãselectãsELECTã®ãããã§ãæ¸ããã¨ãã§ãã¾ãã</li>
+<li>SQL-92ã®æ¸ãæ¹ã«ããèå¥åã¯å¤§æåå°æåãåºå¥ãã¾ããã(<i><xref href="crefsqlj34834.dita#crefsqlj34834"></xref></i>ãåç
§ãã¦ãã ããã)ãã ãããªãããããèå¥åã¯ããã§ã¯ããã¾ããã</li>
+<li>Javaã®æ¸ãæ¹ã«ããèå¥åã¯å¸¸ã«å¤§æåå°æåãåºå¥ãã¾ãã</li>
+<li>*ã¯ã<i><xref href="rrefselectexpression.dita#rrefselectexpression">SelectExpression</xref>.</i>ã«ã¦ã¯ã¤ã«ãã«ã¼ãæåã§ãã<xref
+href="rrefselectexpression.dita#rrefselectexpression/sqlj38441"></xref>ãåç
§ãã¦ãã ããã
+ãã®æåã¯åæã«æ
å ±æ¼ç®åã§ãããã¾ãããã®ã»ãã®å ´åãã®æåã¯ã0å以ä¸ã®ç¹°ãè¿ãã表ããæ§æã®ã¡ã¿æåã§ãã</li>
+<li>%ã¨_ã¯ãLIKEæ¼ç®åã«ç¶ãæåã®åã«ã¦ä½¿ãããã¨ãã¯ã¤ã«ãã«ã¼ãæåã¨ãªãã¾ãã(ããã¯ã¨ã¹ã±ã¼ããããªãã£ãå ´åã§ãã)詳細ã¯<xref
+href="rrefsqlj23075.dita#rrefsqlj23075"></xref>ãåç
§ãã¦ãã ããã</li>
+<li>SQL-92ã®ä»æ§ã«æ²¿ã£ã¦ä¸è¡ãããã¯è¤æ°è¡ã®ã³ã¡ã³ããæ¸ããã¨ãã§ãã¾ããä¸è¡ã®ã³ã¡ã³ãã¯äºã¤ã®ããã·ã¥(--)ã§å§ã¾ãæ¹è¡æåã§çµããã¾ããè¤æ°è¡ã®æ¹è¡ã¯åå¾ãå²ãæ¸ãæ¹ã§ãã¹ã©ãã·ã¥ã»ã¹ã¿ã¼(/*)ã§å§ã¾ããã¹ã¿ã¼ã»ã¹ã©ãã·ã¥(*/)ã§çµããã¾ãããã®æ¸ãæ¹ã§ã¯å
¥ãåã¨ãªãå ´åããããã¨ãçæãã¦ãã ãããã³ã¡ã³ãã®éå§æåã¨çµäºæåã®éã«ããããã�
�ãæåã¯ç¡è¦ããã¾ãã</li>
+</ul></p></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj28468.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29026.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29026.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29026.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29026.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,29 @@
+<?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="rrefsqlj29026" xml:lang="ja">
+<title>çµã¿è¾¼ã¿é¢æ°</title>
+<refbody>
+<section><p>çµã¿è¾¼ã¿é¢æ°ã¯ä½ããã®å¦çãè¡ãSQLãã¼ã¯ã¼ããç¹æ®ãªæ¼ç®åã§ãã
+çµã¿è¾¼ã¿é¢æ°ã«ã¯ããã¼ã¯ã¼ããç¹æ®ãªçµè¾¼ã¿ã®æ¼ç®åãä¸ãããã¦ãã¾ãã
+çµã¿è¾¼ã¿é¢æ°ã®ãã¼ã¯ã¼ãã¯SQL92èå¥åã§ããã大æåå°æåãåºå¥ãã¾ããã
+TIMESTAMPADDãTIMESTAMPDIFFã®ãããªã¨ã¹ã±ã¼ãé¢æ°ã¯ãJDBCã®ã¨ã¹ã±ã¼ãé¢æ°ã®æ§æã«æ²¿ã£ã¦ã®ã¿å©ç¨ã§ãã¾ãã<xref href="rrefjdbc1020262.dita#rrefjdbc1020262"></xref>ãåç
§ãã¦ãã ããã
+</p></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29026.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29840.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29840.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29840.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29840.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,43 @@
+<?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="rrefsqlj29840" xml:lang="ja">
+<title>JOIN æ¼ç®</title>
+<prolog><metadata>
+<keywords><indexterm>JOIN operations</indexterm><indexterm>Outer joins</indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>JOINæ¼ç®ã¯<xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM ç¯</xref>ã®<i><xref href="rreftableexpression.dita#rreftableexpression">TableExpression</xref
+></i>ã«ç½®ããã¨ãã§ãã2表ã®éã®çµåãè¨è¿°ãã¾ãã(WHEREç¯ã«ã¦"WHERE t1.col1
+= t2.col2"çã¨æ¸ãã¦ãæ示çã«ç価æ§ã®å¤å®å¼ãè¨è¿°ãããã¨ã§ããçµåãå®ç¾ãããã¨ãã§ãã¾ãã)</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b><i>JOINå¼</i></b></codeblock>
+<p>JOINæ¼ç®ã¯ã以ä¸ã®ããããã§ãã<ul>
+<li><xref href="rrefsqlj35034.dita#rrefsqlj35034"></xref>
+<p>joinç¯ã«ãã2表ã®éã®çµåãæ示çã«æå®ãã¾ãã<xref href="rrefsqlj35034.dita#rrefsqlj35034"></xref>ãåç
§ãã¦ãã ããã</p></li>
+<li><xref href="rrefsqlj18922.dita#rrefsqlj18922"></xref>
+<p>joinç¯ã«ãã2表ã®éã®çµåãæ示çã«æå®ãã¾ããã¾ãæåã®è¡¨ã«ã¦ä¸è´è¡ãäºã¤ç®ã®è¡¨ã«ãªãè¡ãæ®ãã¾ãã<xref href="rrefsqlj18922.dita#rrefsqlj18922"></xref>ãåç
§ãã¦ãã ããã</p></li>
+<li><xref href="rrefsqlj57522.dita#rrefsqlj57522"></xref>
+<p>joinç¯ã«ãã2表ã®éã®çµåãæ示çã«æå®ãã¾ããã¾ãäºã¤ç®ã®è¡¨ã«ã¦ä¸è´è¡ãæåã®è¡¨ã«ãªãè¡ãæ®ãã¾ãã<xref href="rrefsqlj57522.dita#rrefsqlj57522"></xref>ãåç
§ãã¦ãã ããã</p></li>
+</ul></p> <p>ã©ã®å ´åã§ããçµåããã表ã®çæ¹ãããã¯ä¸¡æ¹ã«ãouter joinç¯ãããã¯<xref href="rrefsqlj33602.dita#rrefsqlj33602">WHERE ç¯</xref>ã§ã追å ã®çµè¾¼æ¡ä»¶ãç½®ããã¨ãã§ãã¾ãã</p> </refsyn>
+<section><title>JOINæ¼ç®ã¨ãåãåããã®æé©å</title>
+<p>çµåã«ã©ã®ãããªæé©åãè¡ããããã«ã¤ãã¦ã¯ã<cite><ph conref="../conrefs.dita#pub/cittuning"></ph></cite>ãåç
§ãã¦ãã ããã</p> </section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29840.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29930.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29930.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29930.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29930.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,39 @@
+<?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="rrefsqlj29930" xml:lang="ja">
+<title>UCASEé¢æ°ããã³UPPERé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>functions<indexterm>UPPER</indexterm></indexterm><indexterm>functions<indexterm>UCASE</indexterm></indexterm>
+<indexterm>UPPER function</indexterm><indexterm>UCASE function</indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>UCASEããã³UPPERã¯æåå¼ãå¼æ°ã«ã¨ããå
¨ã¦ã®ã¢ã«ãã¡ãããã®æåã大æåã«ãã¦è¿ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title><codeblock>UCASEã¾ãã¯UPPER ( <i>æåå¼</i> ) </codeblock>
+<p>ããå¼æ°ã®åãCHARã§ããã°ãè¿ãå¤ã®åã¯CHARã§ãããã以å¤ã®å ´åã¯ãè¿ãå¤ã®åã¯VARCHARã§ãã
+<note>UPPERã¨LOWERã¯ããã¼ã¿ãã¼ã¹ã®ãã±ã¼ã«ã«ããå½±é¿ãåãã¾ãããã±ã¼ã«ã®è¨å®ã«ã¤ãã¦ã®ã詳細ã¯<i><xref
+href="rrefattrib56769.dita#rrefattrib56769"></xref></i>ãåç
§ãã¦ãã ããã
+</note></p><p>è¿ãå¤ã®é·ãã¨æ大é·ã¯ãå¼æ°ã®é·ãã¨æ大é·ã¨åãã§ãã</p> </refsyn>
+<example><title>ä¾</title>次ã®ç¯ã«ããã<p><codeph>aSD1#w</codeph>ã¨ããæååã大æåã«ãã¦è¿ãäºãã§ãã¾ãã
+<codeblock>VALUES UPPER('aSD1#w')</codeblock>
+è¿ãå¤ã¯<codeph>ASD1#W</codeph>ã§ãã</p> </example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj29930.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30118.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30118.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30118.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30118.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,32 @@
+<?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="rrefsqlj30118" xml:lang="ja">
+<title>LONG VARCHAR FOR BIT DATAãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>LONG VARCHAR FOR BIT DATA type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>LONG VARCHAR FOR BIT DATAåã«ã¯æ大ã§32,700ãã¤ãã®ãããåãè¨é²ã§ãã¾ãããã®åã¯åã®å®ç¾©ãè¡ãã¨ãã«æ大é·ãæå®ããå¿
è¦ããªããã¨ãé¤ãã<xref href="rrefsqlj32714.dita#rrefsqlj32714">VARCHAR
+FOR BIT DATA</xref>ã¨åãã§ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>LONG VARCHAR FOR BIT DATA</b></codeblock> </refsyn>
+<section><title>JDBC ã¡ã¿ãã¼ã¿å(java.sql.Types)</title><p>LONGVARBINARY</p></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30118.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30435.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30435.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30435.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30435.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,40 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqlj30435" xml:lang="ja">
+<title>BIGINT ãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>BIGINT data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>BIGINTã§ã¯æ´æ°ã®è¨é²ã®ãã8ãã¤ãã®é åãå²ãå½ã¦ããã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>BIGINT</b></codeblock> </refsyn>
+<section><title>ã³ã³ãã¤ã«æã®å¯¾å¿ããJavaã®å</title> <p><i>java.lang.Long</i></p> </section>
+<section><title>JDBCã¡ã¿æ
å ±ã§ã®å(java.sql.Types)</title> <p>BIGINT</p> </section>
+<section><title>æå°å¤</title> <p id="sqlj76321">-9223372036854775808
+(<i>java.lang.Long.MIN_VALUE</i>)</p> </section>
+<section><title>æ大å¤</title> <p id="sqlj25246">9223372036854775807
+(<i>java.lang.Long.MAX_VALUE</i>)</p>
+<p>ä»ã®ãã¼ã¿åã¨æ··å¨ããã¦å©ç¨ããå ´åãçµæã®ãã¼ã¿åã¯<xref href="rrefsqlj27767.dita#rrefsqlj27767"></xref>ã«æ¸ãããã«ã¼ã«ã«å¾ãã¾ãã</p>
+<p>å°ããªè¨æ¶é åããæããªãå ´æã«ããããã大ããªè¨æ¶é åãå ããæ´æ°å¤ã代å
¥ãããã¨ããã¨ããã®æ´æ°å¤ãå°ããªè¨æ¶é åã§ã¯è¨é²ã§ããã«ã¨ã©ã¼ã¨ãªããã¨ãããã¾ããã¾ãã©ã®ãããªæ´æ°ã§ããé©åã«numericã®å¤ã¨ããäºãã§ãã¾ããBIGINTã§ããã°ãå
åãªç²¾åº¦ãæã¤DECIMALã«è¨é²ãããã¨ãã§ãã¾ãã</p> </section>
+<example> <codeblock><b>9223372036854775807</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30435.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30540.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30540.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30540.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30540.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,58 @@
+<?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="rrefsqlj30540" xml:lang="en-us">
+<title>åå®ç¾©</title>
+<refbody>
+<example> <codeblock><b><i><xref href="rrefsimplecolumnname.dita#rrefsimplecolumnname">åç´åå</xref></i> <i>ãã¼ã¿å</i>
+ [ <i><xref href="rrefsqlj16095.dita#rrefsqlj16095">åæ¯ã®å¶ç´</xref></i> ]*
+ [ [ WITH ] DEFAULT <varname>æ¢å®å¶ç´å¼</varname>
+ |<i><xref href="rrefsqlj37836.dita#rrefsqlj37836">çºçªåä»æ§</xref></i> ]
+ [ <i><xref href="rrefsqlj16095.dita#rrefsqlj16095">åæ¯ã®å¶ç´</xref></i> ]*
+</b></codeblock></example>
+<section><p><i>ãã¼ã¿å</i>ã®ä»æ§ã¯<xref href="crefsqlj31068.dita#crefsqlj31068"></xref>ã«ã¦èª¬æããã¦ãã¾ãã</p>
+<p><i><xref href="rrefsqlj16095.dita#rrefsqlj16095">åæ¯ã®å¶ç´</xref></i>ã¨<i><xref
+href="rrefsqlj42154.dita#rrefsqlj42154">表æ¯ã®å¶ç´</xref></i>ã¯ã<xref
+href="rrefsqlj13590.dita#rrefsqlj13590"></xref>ã«ã¦èª¬æããã¦ãã¾ãã</p></section>
+<section id="sqlj64478"><title>åã®æ¢å®å¤</title>
+<p>æ¢å®å¤ã®å®ç¾©ã¨ãã¦ããããªã表ã¸ã®åç
§ããªã<i>æ¢å®å¶ç´å¼</i>ãããã¾ãã
+ããã«å¯è½ã§ããã®ã¯å®æ°ãæ¥æã®ç¹æ®å¤æ°ãç¾å¨ã®ã¹ãã¼ããã¦ã¼ã¶ãnullã§ãã</p>
+<codeblock><b><varname>æ¢å®å¶ç´å¼</varname>:
+ NULL
+ | CURRENT { SCHEMA | SQLID }
+ | USER | CURRENT_USER | SESSION_USER
+ | DATE
+ | TIME
+ | TIMESTAMP
+ | CURRENT DATE | CURRENT_DATE
+ | CURRENT TIME | CURRENT_TIME
+ | CURRENT TIMESTAMP | CURRENT_TIMESTAMP
+ | <varname>literal</varname>
+</b></codeblock>
+<p>Derbyã®ãªãã©ã«å¤ã«ã¤ãã¦ã®è©³ç´°ã¯ã<xref href="crefsqlj31068.dita#crefsqlj31068"></xref>ãåç
§ãã¦ãã ããã</p>
+<p><varname>æ¢å®å¶ç´å¼</varname>ã«ããå¤ã¯ãåã¨äºææ§ã®ããåã§ãªããã°ãªãã¾ãããå ãã¦ä»¥ä¸ã®å¶ç´ãããã¾ãã</p>
+<ul>
+<li>USERãCURRENT_USERãSESSION_USERãæå®ããå ´åãåã®é·ãã¯å°ãªãã¨ã8ã§ããå¿
è¦ãããã¾ãã</li>
+<li>CURRENT SCHEMAãCURRENT SQLIDãæå®ããå ´åãåã®é·ãã¯å°ãªãã¨ã128ã§ããå¿
è¦ãããã¾ãã</li>
+<li>åãæ´æ°åã§ããå ´åãæ¢å®å¤ã¯æ´æ°ã®ãªãã©ã«ã§ããå¿
è¦ãããã¾ãã</li>
+<li>åã10é²ã®åã§ããå ´åãæ¢å®å¤ã®æ¡æ°ã¨ç²¾åº¦ã¯åã®ããããã®å®ç¾©ã®ç¯å²å
ã§ããå¿
è¦ãããã¾ãã</li>
+</ul>
+</section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj30540.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31580.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31580.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31580.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31580.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,49 @@
+<?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="rrefsqlj31580" xml:lang="en-us">
+<title>CREATE SCHEMA æ</title>
+<prolog><metadata>
+<keywords><indexterm>CREATE SCHEMA statement</indexterm><indexterm><indexterm>SQL
+statements</indexterm>CREATE SCHEMA</indexterm><indexterm>schemas<indexterm>creating</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>ã¹ãã¼ãã«ããæ
å ±ãè«ççã«ä¸ã¤ã®éåã«åé¡ãããã¨ãããã³ãä¸æãªåå空éãæä¾ããäºãã§ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>CREATE SCHEMA { [ <i><xref href="rrefschemaname.dita#rrefschemaname">ã¹ãã¼ãå</xref></i> AUTHORIZATION <i
+>ã¦ã¼ã¶å</i> ] | [ <i>ã¹ãã¼ãå</i> ] |
+[ AUTHORIZATION <i>ã¦ã¼ã¶å</i> ] }</b>
+</codeblock> <p>CREATE SCHEMA æã«ããã¹ãã¼ããä½æãããã¨ãã§ãã¾ããã¹ãã¼ãåã¯128æåãè¶
ãã¦ã¯ãªãã¾ãããã¹ãã¼ãåã¯ãã¼ã¿ãã¼ã¹ã®å
ã§ä¸æã§ç¡ããã°ãªãã¾ããã</p>
+<p>CREATE SCHEMAæã¯ãã¼ã¿ãã¼ã¹ãªããã·ã¹ãã ã«ããã¦ã<codeph>derby.database.sqlAuthorization</codeph>ã<codeph>true</codeph>ã¨ãªã£ã¦ããå ´åãã¢ã¯ã»ã¹å¶å¾¡ã®å¯¾è±¡ã¨ãªãã¾ãããã¼ã¿ãã¼ã¹ææè
ã ããç¾å¨ã®ã¦ã¼ã¶åã¨ã¯ç°ãªãååã®ã¹ãã¼ããä½æãããã¨ãã§ãã¾ããã¾ããã¼ã¿ãã¼ã¹ææè
ã ããç¾å¨ã®ã¦ã¼ã¶åã¨ã¯ç°ãªã<codeblock>AUTHORIZATION <i>user-name</i></codeblock>ãæå®ã§ãã¾ãã
+<codeph>derby.database.sqlAuthorization</codeph>å±æ§ã«ã¤ãã¦ã®ãã詳細ãªæ
å ±ã¯ã<ph conref="../conrefs.dita#pub/cittuning"></ph>ãåç
§ãã¦ãã ããã</p></refsyn>
+<example><title>CREATE SCHEMAã®ä¾</title><p>é£è¡æ©ã«é¢é£ãã表ãããã¹ãã¼ããä½æãã¦ã<codeph>anita</codeph>ã¨ããèªè¨¼èå¥åã«ã¹ãã¼ãã®å
¨ã¦ã®æ
å ±ãæä½ãã権éãä¸ããã«ã¯æ¬¡ã®ããã«ãã¾ãã<codeblock><b>CREATE SCHEMA FLIGHTS AUTHORIZATION anita</b> </codeblock></p>
+<p>å¾æ¥å¡ã«é¢é£ãã表ãããã¹ãã¼ããä½æããã«ã¯æ¬¡ã®ããã«ãã¾ãã<codeblock><b>CREATE SCHEMA EMP</b> </codeblock></p>
+<p><codeph>takumi</codeph>ã¨ããã¹ãã¼ãåããã®ã¾ã¾èªè¨¼èå¥åã§ããã¹ãã¼ããä½æããã«ã¯æ¬¡ã®ããã«ãã¾ãã<codeblock><b>CREATE SCHEMA AUTHORIZATION takumi</b> </codeblock></p>
+<p><codeph>EMP</codeph>ã¨<codeph>FLIGHTS</codeph>ã®åã¹ãã¼ãã«<codeph>availability</codeph>ã¨ãã表ãä½æããã«ã¯æ¬¡ã®ããã«ãã¾ãã<codeblock><b>CREATE TABLE FLIGHTS.AVAILABILITY
+ (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 FLT_AVAIL_PK
+ PRIMARY KEY (FLIGHT_ID, SEGMENT_NUMBER, FLIGHT_DATE))</b> </codeblock></p><codeblock><b>CREATE TABLE EMP.AVAILABILITY
+ (HOTEL_ID INT NOT NULL, BOOKING_DATE DATE NOT NULL, ROOMS_TAKEN INT,
+ CONSTRAINT HOTELAVAIL_PK PRIMARY KEY (HOTEL_ID, BOOKING_DATE))
+</b></codeblock> </example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31580.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31648.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31648.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31648.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31648.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="rrefsqlj31648" xml:lang="ja">
+<title>DROP SCHEMA æ</title>
+<prolog><metadata>
+<keywords><indexterm>DROP SCHEMA statement</indexterm><indexterm>Schemas<indexterm>dropping</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>DROP SCHEMA æã«ããã¹ãã¼ããç ´æ£ã§ãã¾ãã
+ç ´æ£ããã¹ãã¼ãã¯ç©ºã§ç¡ããã°ãªãã¾ããã</p> <p><i>APP</i>ã¹ãã¼ã(æ¢å®ã®ã¦ã¼ã¶ã¹ãã¼ãã§ãã)ã<i>SYS</i>ã¹ãã¼ãã¯ç ´æ£ã§ãã¾ããã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>DROP SCHEMA <i><xref href="rrefschemaname.dita#rrefschemaname">ã¹ãã¼ãå</xref></i> RESTRICT</b></codeblock>
+<p>RESTRICTãã¼ã¯ã¼ãã«ãããã¼ã¿ãã¼ã¹ããç ´æ£ãããã¨ããã¹ãã¼ãã«ã¯ãæ
å ±ããã£ã¦ã¯ãªããªããã¨ãæå®ãã¾ãããã®RESTRICTãã¼ã¯ã¼ãã¯å¿
é ã§ãã</p> </refsyn>
+<example> <codeblock><b><ph>-- SAMP ã¹ãã¼ããç ´æ£ãã¾ãã
+-- SAMPã¹ãã¼ãããã¼ã¿ãã¼ã¹ããåé¤ã§ããã®ã¯ã
+-- ã¹ãã¼ãã«æ
å ±ãå®ç¾©ããã¦ããªãã¨ãã®ã¿ã§ãã</ph>
+DROP SCHEMA SAMP RESTRICT</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31648.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31783.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31783.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31783.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31783.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,50 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqlj31783" xml:lang="ja">
+<title>FOR UPDATE ç¯</title>
+<prolog><metadata>
+<keywords><indexterm>FOR UPDATE clause</indexterm><indexterm>Cursors</indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <indexterm>Cursors</indexterm><indexterm>In-place updates</indexterm>
+<p><xref href="rrefsqlj41360.dita#rrefsqlj41360">SELECTæ</xref>ã«ã¯FOR UPDATEç¯ãæããããã¨ãã§ãã¾ãã
+æ¢å®ã§ã«ã¼ã½ã«ã¯èªã¿è¾¼ã¿ããã§ãã¾ãããFOR UPDATEç¯ã«ãããã³ã³ãã¤ã«ä¸ã«SELECTæãæ´æ°å¯è½ãª<i>ã«ã¼ã½ã«</i>ã®å¿
è¦æ¡ä»¶ãæºããããæ¤è¨¼ãã¦ãã«ã¼ã½ã«ãæ´æ°å¯è½ã¨ãã¾ãã
+æ´æ°å¯è½ã§ãããã¨ã®è©³ç´°ã«ã¤ãã¦ã¯ã<xref href="rrefsqlj41360.dita#rrefsqlj41360/sqlj15384">æ´æ°å¯è½ãªã«ã¼ã½ã«ã®å¿
è¦æ¡ä»¶</xref>ãåç
§ãã¦ãã ããã</p> </section>
+<refsyn><title>æ§æ</title> <codeblock><b>FOR
+{
+ READ ONLY | FETCH ONLY |
+ UPDATE [ OF <i><xref href="rrefsimplecolumnname.dita#rrefsimplecolumnname">åç´åå</xref></i> [ , <i><xref
+href="rrefsimplecolumnname.dita#rrefsimplecolumnname">åç´åå</xref></i>]* ]
+}</b></codeblock> <p><i>åç´åå</i> ã«ãããåãåããæã®FROMç¯ã«ãã表ã«ã¦ãå¯è¦ãªååãåç
§ãã¾ãã</p>
+</refsyn>
+<section>
+<p><note>æ´æ°å¯è½ãªJDBCã®ResultSetãå¾ãããã«ãå¿
ãããFOR UPDATEç¯ã使ãå¿
è¦ã¯ããã¾ããã
+JDBCã®ResultSetã®å
ã¨ãªãæããæ´æ°å¯è½ãªã«ã¼ã½ã«ã®å¿
è¦æ¡ä»¶ãæºããã¦ããããã°ãJDBC Statementããã並è¡å¦çã¢ã¼ãã<codeph>ResultSet.CONCUR_UPDATABLE</codeph>ã®JDBC ResultSetãçæãããã¨ãã§ãã¾ãã
+</note></p>
+<p>ç´¢å¼ã®åãæ´æ°ããã¦ãã¦ããç´¢å¼ã使ã£ãæé©åãå¯è½ã§ããç´¢å¼ãã©ã®ããã«ã«ã¼ã½ã«ã«å½±é¿ãããã«ã¤ãã¦ã¯ã<cite><ph
+conref="../conrefs.dita#pub/cittuning"></ph></cite>ãåç
§ãã¦ãã ããã</p>
+</section>
+<example> <codeblock><b>SELECT RECEIVED, SOURCE, SUBJECT, NOTE_TEXT FROM SAMP.IN_TRAY FOR UPDATE
+</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj31783.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native