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 [24/26] - in /db/derby/docs/trunk: ./ src/ja_JP/
src/ja_JP/ref/
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj73147.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj73147.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj73147.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj73147.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,41 @@
+<?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="rrefsqlj73147" xml:lang="ja">
+<title>SQRTé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>SQRT function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>æµ®åå°æ°ç¹æ°ã®å¹³æ¹æ ¹ãè¿ãã¾ããé©ç¨å¯è½ãªçµè¾¼ã¿ã®åã¯ã<xref href="rrefsqlj14122.dita#rrefsqlj14122">å®æ°</xref>ã<xref
+href="rrefsqlj27281.dita#rrefsqlj27281">å精度浮åå°æ°ç¹æ°</xref>ã<xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">å精度浮åå°æ°ç¹æ°</xref>ã«éããã¾ãã
+SQRTãè¿ãå¤ã®ãã¼ã¿åã¯ãå¼æ°ã®ãã¼ã¿åã¨åãã§ãã</p>
+<note>ä»ã®ãã¼ã¿åã«ã¤ãã¦SQRTãå®è¡ããã«ã¯ãæµ®åå°æ°ç¹æ°ã«å¤æããå¿
è¦ãããã¾ãã</note></section>
+<refsyn><title>æ§æ</title> <codeblock id="i1195048"><b>SQRT(<i>æµ®åå°æ°ç¹æ°å¼</i>)</b></codeblock> </refsyn>
+<example> <codeblock><b>-- è² æ°ã®è¡ããã£ãå ´åãä¾å¤ãçºçãã¾ãã
+VALUES SQRT(3421E+09)
+
+-- INTEGERã®æ°ãæµ®åå°æ°ç¹æ°ã«å¤æããå¾ãå¹³æ¹æ ¹ãæ±ãã¾ãã
+SELECT SQRT(myDoubleColumn) FROM MyTable
+
+VALUES SQRT (CAST(25 AS FLOAT));</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj73147.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj75638.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj75638.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj75638.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj75638.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,95 @@
+<?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="rrefsqlj75638" xml:lang="en-us">
+<title>å©ç¨å¯è½ãªå°åæ
å ±</title>
+<prolog><metadata>
+<keywords><indexterm>Territories<indexterm>supported</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section><p>å©ç¨å¯è½ãªå°åæ
å ±ã以ä¸ã«æãã¾ãã</p></section>
+<section><p> <table>
+<tgroup cols="2"><colspec colname="col1"/><colspec colname="col2"/>
+<thead>
+<row>
+<entry colname="col1" valign="top">å°å</entry>
+<entry colname="col2" valign="top"><ph conref="../conrefs.dita#prod/productshortname"></ph>ã®å°åè¨å®(derby.territory)</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">ä¸å½èª(ç°¡ä½å)</entry>
+<entry colname="col2">zh_CN</entry>
+</row>
+<row>
+<entry colname="col1">ä¸å½èª(ç¹ä½å)</entry>
+<entry colname="col2">zh_TW</entry>
+</row>
+<row>
+<entry colname="col1">ãã§ã³èª</entry>
+<entry colname="col2">cs</entry>
+</row>
+<row>
+<entry colname="col1">ãã©ã³ã¹èª</entry>
+<entry colname="col2">fr</entry>
+</row>
+<row>
+<entry colname="col1">ãã¤ãèª</entry>
+<entry colname="col2">de_DE</entry>
+</row>
+<row>
+<entry colname="col1">ãã³ã¬ãªã¼èª</entry>
+<entry colname="col2">hu</entry>
+</row>
+<row>
+<entry colname="col1">ã¤ã¿ãªã¢èª</entry>
+<entry colname="col2">it</entry>
+</row>
+<row>
+<entry colname="col1">æ¥æ¬èª</entry>
+<entry colname="col2">ja_JP</entry>
+</row>
+<row>
+<entry colname="col1">éå½èª</entry>
+<entry colname="col2">ko_KR</entry>
+</row>
+<row>
+<entry colname="col1">ãã¼ã©ã³ãèª</entry>
+<entry colname="col2">pl</entry>
+</row>
+<row>
+<entry colname="col1">ãã«ãã¬ã«èª(ãã©ã¸ã«èª)</entry>
+<entry colname="col2">pt_BR</entry>
+</row>
+<row>
+<entry colname="col1">ãã·ã¢èª</entry>
+<entry colname="col2">ru</entry>
+</row>
+<row>
+<entry colname="col1">ã¹ãã¤ã³èª</entry>
+<entry colname="col2">es</entry>
+</row>
+</tbody>
+</tgroup>
+</table></p></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj75638.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj81859.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj81859.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj81859.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj81859.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,180 @@
+<?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="rrefsqlj81859" xml:lang="ja">
+<title>ALTER TABLE æ</title>
+<prolog><metadata>
+<keywords><indexterm>ALTER TABLE statement</indexterm><indexterm>Compressing
+tables</indexterm><indexterm>Tables<indexterm>altering</indexterm><indexterm>compressing</indexterm></indexterm>
+<indexterm>Columns<indexterm>adding</indexterm></indexterm><indexterm>Constraints<indexterm>adding</indexterm><indexterm>dropping</indexterm><indexterm
+>compressing</indexterm></indexterm><indexterm>Defaults<indexterm>adding</indexterm><indexterm>dropping</indexterm></indexterm>
+<indexterm>Adding Columns</indexterm><indexterm>Adding Constraints</indexterm>
+<indexterm>Dropping Constraints</indexterm><indexterm>Defaults<indexterm>setting</indexterm></indexterm>
+<indexterm>Tables<indexterm>changing lock granularity for</indexterm></indexterm>
+<indexterm>Data types<indexterm>modifying</indexterm></indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section><p>The ALTER TABLE æã«ãã次ã®ãã¨ãå¯è½ã§ãã<ul>
+<li>表ã«åã追å ããã</li>
+<li>表ã«å¶ç´ã追å ããã</li>
+<li>表ã®åãç ´æ£ããã</li>
+<li>表ã«ããå¶ç´ãç ´æ£ããã</li>
+<li>VARCHAR, CHAR VARYING, and CHARACTER VARYING åã®å¹
ãå¢ããã</li>
+<li>表ã«å®ç¾©ãããè¡ã¬ãã«ã®ããã¯ãä¸æ¸ãããã(ãããã¯ä¸æ¸ããããå
容ãç ´æ£ããã)</li>
+<li>èå¥ååã®å¢åå¤ãéå§å¤ãå¤æ´ããã</li>
+<li>åãNullå¯ã§ãããå¦ãå¤æ´ããã</li>
+<li>åã®è¦å®å¤ãå¤æ´ããã</li>
+</ul></p></section>
+<section><title>æ§æ</title><codeblock><b>ALTER TABLE <i><xref href="rreftablename.dita#rreftablename">表å</xref></i>
+{
+ ADD COLUMN <i><xref href="rrefsqlj81859.dita#rrefsqlj81859/rrefaltercolumndef">åå®ç¾©</xref></i> |
+ ADD <i><xref href="rrefsqlj13590.dita#rrefsqlj13590">CONSTRAINTç¯</xref></i> |
+ DROP [ COLUMN ] åå [ CASCADE | RESTRICT ]
+ DROP { PRIMARY KEY | FOREIGN KEY å¶ç´å | UNIQUE
+ å¶ç´å | CHECK å¶ç´å | CONSTRAINT å¶ç´å }
+ ALTER [ COLUMN ] <i><xref href="rrefsqlj81859.dita#rrefsqlj81859/rrefsqlj37860">åå®ç¾©å¤æ´</xref></i> |
+ LOCKSIZE { ROW | TABLE }
+}</b></codeblock></section>
+<example id="rrefaltercolumndef"> <title>åå®ç¾©</title><codeblock><b><i><xref
+href="rrefsimplecolumnname.dita#rrefsimplecolumnname">åç´åå</xref></i> <i>ãã¼ã¿å</i>
+[ <i><xref href="rrefsqlj16095.dita#rrefsqlj16095">ååä½å¶ç´</xref></i> ]*
+[ [ WITH ] DEFAULT <varname>æ¢å®å¶ç´å¼</varname> ]</b></codeblock>
+<p><varname>æ¢å®å¶ç´å¼</varname>ã®è©³ç´°ã«ã¤ãã¦ã¯ã<xref href="rrefsqlj30540.dita#sqlj64478">åã®æ¢å®</xref>ãåç
§ãã¦ãã ããã</p></example>
+<example id="rrefsqlj37860"><title>åå®ç¾©å¤æ´</title><codeblock><b><i>åå</i> SET DATA TYPE VARCHAR(integer) |
+<i>column-name</i> SET INCREMENT BY å®æ´æ° |
+<i>column-name</i> RESTART WITH å®æ´æ° |
+<i>column-name</i> [ NOT ] NULL |
+<i>column-name</i> [ WITH ] DEFAULT æ¢å®å¤</b> </codeblock></example>
+<section><p>åå®ç¾©å¤æ´ã®SET INCREMENT BY å®æ´æ°ã«ãããèå¥ååã®ã¨ãé£ç¶ããå¤ã®ééãè¨å®ããã¾ããèå¥ååãã¨ã次ã®å¤ã¯ãæå¾ã«ã¨ãããå¤ã«å¢åãå ç®ãããå¤ã¨ãªãã¾ãããã®å ´ååã«ã¯ãããããIDENTITYå±æ§ãå®ç¾©ããã¦ããªããã°ãªãã¾ããã</p><p>RESTART WITH å®æ´æ°ã«ãããèå¥ååãã¨ã次ã®å¤ãè¨å®ããã¾ããRESTART WITHã¯ãGENERATED BY DEFAULTãå®ç¾©ããããä¸æãã¼ãæã¤èå¥ååã®ã
ã表ã«ä½¿ãã¨ä¾¿å©ã§ããGENERATED BY DEFAULTã¯æ示çã«å¤ãæ¿å
¥ãããã¨ããã³ãæé»çã«ã·ã¹ãã ãçºçªããå¤ãæ¿å
¥ãããã¨ã®ããããã許ããããæ示çã«æ¿å
¥ãããå¤ãã·ã¹ãã ãçºçªããå¤ã¨ã®éã§ç«¶åããäºããããã¾ãããã®ç«¶åãåé¿ããããã«ãRESTART WITHã«ããèå¥ååã§æ¬¡ã«çºçªãããå¤ãè¨å®ããäºãã§ããã®ã§ããèªåçã«çºçªãããå¤ã¨æåã§æ¿å
¥ãããæ�
�
å ±ãããã次ã®ä¾ã«ã¤ãã¦èãã¦ã¿ã¦ãã ããã
+<codeblock><b>CREATE TABLE tauto(i INT GENERATED BY DEFAULT AS IDENTITY, k INT)
+CREATE UNIQUE INDEX tautoInd ON tauto(i)
+INSERT INTO tauto(k) values 1,2</b></codeblock></p>
+<p>ã·ã¹ãã ã¯èªåçã«èå¥ååã«å¯¾ãã¦æ°å¤ãçºçªãã¾ããããããªãããããªãã¯æåã§èå¥ååã«å¹¾ã¤ãã®å¤ãæ¿å
¥ããªããã°ãªãã¾ããã§ããã
+<codeblock><b>INSERT INTO tauto VALUES (3,3)
+INSERT INTO tauto VALUES (4,4)
+INSERT INTO tauto VALUES (5,5)</b></codeblock></p>
+<p>èå¥ååã«ã¯ãã®æç¹ã§1ãã5ã®å¤ãããã¾ããããã§ããªããã·ã¹ãã ã«å¤ãçºçªãããã¨ãã·ã¹ãã ã¯3ã¨ããå¤ãçºçªãã¾ãããã®å¤ã«ããä¸æãã¼ä¾å¤ãçºçãã¾ãããªããªã3ã¨ããå¤ã¯æ¢ã«æåã§æ¿å
¥ããã¦ãã¾ã£ã¦ããããã§ããæåã§å¤ãæ¿å
¥ããã®ã§å¾å¦çã¨ãã¦ãèå¥ååã«å¯¾ãã¦RESTART WITH 6 ã®ALTER TABLEæãçºè¡ãã¾ãã
+<codeblock><b>ALTER TABLE tauto ALTER COLUMN i RESTART WITH 6</b></codeblock></p><p>ALTER
+TABLE ã¯è¡¨ãåç
§ãããããªããã¥ã¼ã«ãå½±é¿ãã¾ãããããã¯SELECTä¸è¦§ã«"*"ãæã£ã¦ãã¦ãç¶ãã§ããæ°ãã追å ãããåããã¥ã¼ããè¦ããããã«ããçºã«ã¯ããã¥ã¼ãç ´æ£ãã¦ä½ãç´ããªããã°ãªãã¾ããã</p></section>
+<section><title>åã®è¿½å </title>
+<p><i>追å ããåã®<xref href="rrefsqlj81859.dita#rrefsqlj81859/rrefaltercolumndef">åå®ç¾©</xref
+></i>ã¯ãæ§æã®ä¸ã§CREATE TABLEæã®åã¨åãã§ããã§ããããåã®å¶ç´ãALTER TABLE ADD COLUMNæã®æ°ããåã«æ¸ããã¨ãã§ãã¾ããããããªãããæ¢åã®ãã¼ãã«ã«NOT NULLå¶ç´ã®ããåã追å ãããã¨ã¯ããã®åã«æ¢å®å¤ãä¸ããå ´åã®ã¿å¯è½ã§ãããããªããã°ãALTER TABLEæãå®è¡ãããã¨ããä¾å¤ãçºçãã¾ãã</p>
+<p>CREATE TABLEã¨åæ§ãåå®ç¾©ã«ä¸æãããã¯ä¸»ãã¼å¶ç´ãããå ´åãåã¯nullå¤ãã¨ããã¨ãã§ãã¾ããããããã£ã¦ãNOT NULLå±æ§ãå¿
è¦ã§ãã(SQLSTATE 42831)
+</p><note>表ã«æ示çãªåä¸è¦§ãæå®ãããªãUPDATEããªã¬ãå®ç¾©ããã¦ããå ´åããã®è¡¨ã«åã追å ããã¨ã追å ãããåã¯UPDATEããªã¬ã®æé»çãªæ´æ°åä¸è¦§ã«è¿½å ããã¾ããããã«æ°ããåãæ¾ããã¨ãã§ãããããæ¨ç§»å¤æ°ã¸ã®å
¨ã¦ã®åç
§ã¯ç¡å¹ã¨ãªãã¾ãã</note></section>
+<section><title>å¶ç´ã®è¿½å </title>
+<p>ALTER TABLE ADD CONSTRAINTã«ãã表ãã¨ã®å¶ç´ãæ¢åã®è¡¨ã«è¿½å ããã¾ãããããã種é¡ã®è¡¨ãã¨ã®å¶ç´ãALTER TABLEã§è¿½å ã§ãã¾ãããã ããæ¢åã®è¡¨ã¸ã®å¶ç´ã®è¿½å ã«ã¯æ¬¡ã®æ©è½ä¸ã®å¶éãããã¾ãã<ul>
+<li>å¤é¨ãã¼ããã§ãã¯å¶ç´ãæ¢åã®è¡¨ã«è¿½å ãããã¨ã<ph
+conref="../conrefs.dita#prod/productshortname"></ph>ã¯æ¢åã®è¡ãå¶ç´ã«éåããªããã表ã調ã¹ã¾ããããããããã®è¡ãå¶ç´ã«éåããå ´åã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ä¾å¤ãæãã¦å¶ç´ã¯è¿½å ããã¾ããã</li>
+<li>主ãã¼ã«å«ã¾ããããããåã¯nullã§ãªãå¤ãã¨ããªããã°ãªãããã¾ãä¸æã§ãªããã°ãªãã¾ããã<p>ALTER TABLE ADD UNIQUEãPRIMARY KEYã¯ãåä¸ã®åã«ãã主ãã¼ãå®ç¾©ããç°¡åãªæ¹æ³ãæä¾ãã¾ããããPRIMARY KEYãCã¨ããåã®å®ç¾©ã«æ¸ããããããå ´åãããã¯PRIMARY KEY(C)ã¨ããå¥ã®ç¯ã«æ¸ããã®ã¨åãã§ããåã¯nullã®å¤ãã¨ã£ã¦ã¯ãªããªãã®ã§ãNOT NULLå±æ§ãæå®ãããªããã°ãªãã¾ããã</p></li>
+</ul></p><p>å¶ç´ã®æ§æã«ã¤ãã¦ã®è©³ç´°ã¯ã<xref href="rrefsqlj13590.dita#rrefsqlj13590"></xref>ãèªãã§ãã ããã
+ADD TABLE ADD CONSTRAINTã¨ããæ¸ãæ¹ã«ã¦ãå¶ç´ã追å ããå ´åã¯ã表æ¯ã®å¶ç´ã®æ§æã«å¾ã£ã¦ãã ããã</p></section>
+<section><title>åã®ç ´æ£</title><p>ALTER TABLE DROP COLUMNã«ããã表ããåãç ´æ£ã§ãã¾ãã</p>
+<p>COLUMNã¨ãããã¼ã¯ã¼ãã¯ç¡ãã¦ããã¾ãã¾ããã</p>
+<p>CASCADEãRESTRICTããç¡ãã¦ãã¾ãã¾ãããã©ã¡ããæå®ããªãã£ãå ´åãæ¢å®ã¯CASCADEã§ãã</p>
+<p>
+RESTRICTã®å ´åãä¾åãã¦ããã¹ãã¼ãã®æ
å ±ãç¡å¹ã«ãªããªãã°ãåã®ç ´æ£ã¯å¤±æãã¾ãã</p>
+<p>
+CASCADEã®å ´åãåã®ç ´æ£ã¨ä½µãã¦ãç¡å¹ã«ãªãã¹ãã¼ãã®æ
å ±ãç ´æ£ããã¾ãã</p>
+<p>
+DROP COLUMN RESTRICTã失æããåå ã¨ãªãã¹ãã¼ãã®æ
å ±ã«ã¯ã次ãå«ã¾ãã¾ãã
+ãã¥ã¼ãããªã¬ã主ãã¼å¶ç´ãå¤é¨ãã¼å¶ç´ãä¸æãã¼å¶ç´ããã§ãã¯å¶ç´ãå権éãç ´æ£ããåã«ä¾åããããããã®æ
å ±ãããã°ãDROP COLUMN RESTRICTã¯å¤±æãã¾ãã</p>
+<p>
+表ã«ã²ã¨ã¤ãããªãåã¯ãç ´æ£ãããã¨ãã§ãã¾ããã</p>
+<p>
+sqlAuthorizationãçã§ããå ´åãåãåé¤ãããã¨ã¯ã§ãã¾ããã(DERBY-1909ãåç
§ãã¦ãã ããã)
+)</p>
+<p>
+åãç´¢å¼ã«ã¦ä½¿ããã¦ãããå¦ãã«ããããããåã®ç ´æ£ã¯CASCADE/RESTRICTã®ã©ã¡ãã§ãåãããã«è¡ããã¾ããåãç ´æ£ãããã¨ããç´¢å¼ã«ãããã®åãåãé¤ããã¾ãããã®åãç´¢å¼ã«ãããã ã²ã¨ã¤ã®åã§ãã£ãå ´åãç´¢å¼å
¨ä½ãç ´æ£ããã¾ãã</p></section>
+<section><title>å¶ç´ã®ç ´æ£</title><p>ALTER TABLE DROP CONSTRAINTã«ãã表ã®å¶ç´ãç ´æ£ã§ãã¾ããååä»ããã¦ããªãå¶ç´ãç ´æ£ããããã«ã¯ã<i>SYS.SYSCONSTRAINTS</i>ã«è¨é²ããã¦ããèªåçæãããå¶ç´ã®ååãããªãããããèå¥åã¨ãã¦æå®ããå¿
è¦ãããã¾ãã</p>
+<p>主ãã¼ã»ä¸ææ§ã»å¤é¨ãã¼å¶ç´ãç ´æ£ããã¨ããã®å¶ç´ãæ©è½ããããã«åå¨ãã¦ããç´¢å¼ãç ´æ£ããã¾ãã(ãã®ç´¢å¼ã¯<i>æ¯æ´ç´¢å¼</i>ã¨ãå¼ã°ãã¾ãã)</p></section>
+<section><title>åã®å¤æ´</title>
+<p><i><xref href="rrefsqlj81859.dita#rrefsqlj81859/rrefsqlj37860">åå®ç¾©å¤æ´</xref></i>ã«ãããååã®ããåãå¤æ´ã§ãã¾ããå¯è½ãªå¤æ´å
容ã¯ä»¥ä¸ã®ã¨ããã§ãã
+<ul>
+<li>VARCHARåã®é·ããå¢ãããã¨ãã§ãã¾ããVARCHARã¨ãããã¼ã¯ã¼ãã®ä»£ããã«ãCHARACTER VARYINGãCHAR VARYINGã使ããã¨ãã§ãã¾ãã
+<p>ãããã®åã®å¹
ãå¢ããããã«ã¯ããã¼ã¿åã¨æ°ãããµã¤ãºãååã®å¾ã«æ¸ãã¾ãã</p>
+<p>åã®å¹
ãæ¸ããããããã¼ã¿åãå¤æ´ãããããäºã¯ã§ãã¾ããã主ãã¼ã®ä¸é¨ããå¤é¨ãã¼å¶ç´ããåç
§ããã¦ããä¸æãã¼ãå¤é¨ãã¼å¶ç´ã®ä¸é¨ã§ããåã®å¹
ã¯å¤æ´ã§ãã¾ããã</p></li>
+<li>èå¥ååã®ã¨ãé£ç¶ããå¤ã®ééãæå®ãããã¨ãã§ãã¾ãã<p>
+èå¥ååã®ã¨ãé£ç¶ããå¤ã®ééãè¨å®ããããã«ã¯ãå®æ´æ°ãä¸ãã¾ãããããããåã«ã¯èå¥åå±æ§ãä¸ãããã¦ããªããã°ãªãã¾ããã(SQLSTATE 42837)ãã表ã«æ¢ã«è¡ãããå ´åãåã®SET INCREMENT defaultãå ç®ãããå¤ã¯å¤æ´ããã¾ããã</p></li>
+<li>åã®Nullã¸ã®å¶ç´ã®å¤æ´
+åãNullãã¨ãäºã¸ã®å¶ç´ãå¤æ´ã§ãã¾ãã
+ <p>NOT NULLå¶ç´ãæ¢åã®åã«ä¸ãããã¨ãã§ãã¾ãããããè¡ãå ´åãæ¢åã®NULLå¤ã表ã®ãã®åã«åå¨ãã¦ã¯ãªãã¾ããã</p>
+ <p>NOT NULLå¶ç´ãæ¢åã®åããåãé¤ããã¨ãã§ãã¾ãããããè¡ãå ´åããã®åãPRIMARY KEYãUNIQUEã®å¶ç´ã«ã¦ä½¿ããã¦ããåã§ãã£ã¦ã¯ãªãã¾ããã</p></li>
+<li>åã®æ¢å®å¤ãå¤æ´ãã</li>
+</ul></p></section>
+<section><title>æ¢å®å¤ã®è¨å®</title><p>æ°è¦ã®åã«æ¢å®å¤ãä¸ãããã¨ãã§ãã¾ããæ¢å®å¤ã¨ã¯å¤ãæå®ãããªãã£ãå ´åã«åã«æ¿å
¥ãããå¤ã§ããããæ示çã«æ¢å®å¤ãä¸ãããã¦ããªãã£ãå ´åãåã®æ¢å®å¤ã¯NULLã§ããããæ°ããåã«æ¢å®å¤ãä¸ããå ´åã表ã«ããæ¢åã®è¡ã¯ãã®æ°åã«æ¢å®å¤ãã¨ããã¨ã¨ãªãã¾ãã</p><p>æ¢å®å¤ã®ãã詳細ãªæ
å ±ã«ã¤ãã¦ã¯ã<xref href="rrefsqlj24513.dita#rrefsqlj24513"></xref>ã
åç
§ãã¦ãã ããã</p></section>
+<section><title>表ã®ããã¯ç²åº¦ã®å¤æ´</title>
+<p>ããããªãã®ã·ã¹ãã ãæ¢å®ã®è¨å®ã§ããè¡æ¯ã®ããã¯ãè¡ãã®ã§ããã°ãLOCKSIZEç¯ã«ãã表ã®è¡æ¯ã®ããã¯ãä¸æ¸ããããã¨ãã§ãã¾ãã(ä¸æ¹ããªãã®ã·ã¹ãã ã表ãã¨ã®ããã¯ãè¡ãããè¨å®ããã¦ããå ´åã<ph conref="../conrefs.dita#prod/productshortname"></ph>ãLOCKSIZEç¯ã«å¯¾ãã¦ä¾å¤ãæããªãã£ãã¨ãã¦ããããã¯ã®ç²åº¦ãè¡åä½ã®ããã¯ã«å¤æ´ãããã¨ã¯ã§ãã¾ããã)
+表ã®è¡æ¯ã®ããã¯ãä¸æ¸ãããã«ã¯ã表ã«ããã¯ã®è¨å®ãè¡ãã¾ãã
+ãã表ã表æ¯ã®ããã¯ã§ä½æãããå ´åãALTER TABLEæã«ã¦LOCKSIZEç¯ã使ããã¨ã§ããã®è¨å®ãè¡æ¯ã®è¨å®ã«æ»ããã¨ãã§ãã¾ããããã便å©ãªå ´åãããã®ã§ããããã®è©³ç´°ã«ã¤ãã¦ã¯ã<cite><ph
+conref="../conrefs.dita#pub/cittuning"></ph></cite>ãåç
§ãã¦ãã ããã</p></section>
+<section><title>ä¾</title><codeblock><b><ph>-- æ¢åã®è¡¨ã«åãã¨ã®å¶ç´ã®ããåã追å ããã
+-- 表ã«æ¢åè¡ããã£ãå ´åãæ¢åè¡ã®æ°åã¯NULLãã¨ãã®ã§ã
+-- ä¾å¤ãçºçããã</ph>
+ALTER TABLE CITIES ADD COLUMN REGION VARCHAR(26)
+CONSTRAINT NEW_CONSTRAINT CHECK (REGION IS NOT NULL);
+
+<ph>-- æ¢åã®è¡¨ã«ä¸ææ§å¶ç´ã追å ããã
+-- éè¤ãããã¼ããã£ãå ´åãä¾å¤ãçºçããã</ph>
+ALTER TABLE SAMP.DEPARTMENT
+ADD CONSTRAINT NEW_UNIQUE UNIQUE (DEPTNO);
+
+<ph>-- Cities表ã«å¤é¨ãã¼å¶ç´ã追å ããã
+-- è¡ãå¶ç´ãæºãããæ¤è¨¼ããã¦ã
+-- ããå¶ç´ãæºãããªãè¡ãè¦ã¤ãã£ãå ´åã
+-- å¶ç´ã¯è¿½å ãããªãã</ph>
+ALTER TABLE CITIES ADD CONSTRAINT COUNTRY_FK
+Foreign Key (COUNTRY) REFERENCES COUNTRIES (COUNTRY);
+
+<ph>-- 主ãã¼å¶ç´ã表ã«è¿½å ããã
+-- æåã«è¡¨ãä½æãããã</ph>
+CREATE TABLE ACTIVITIES (CITY_ID INT NOT NULL,
+SEASON CHAR(2), ACTIVITY VARCHAR(32) NOT NULL);
+<ph>-- ãã主ãã¼ã¨ããåã«nullãéè¤ããå¤ãããå ´åã
+-- ãã®å¶ç´ã追å ãããã¨ã¯ã§ããªãã</ph>
+ALTER TABLE Activities ADD PRIMARY KEY (city_id, activity);
+
+<ph>-- ããä¾åããæ
å ±ãç¡ããã°ãcity_idåãç ´æ£ãããã</ph>
+ALTER TABLE Cities DROP COLUMN city_id RESTRICT;
+<ph>-- ä¾åããæ
å ±ã¨ä½µãã¦ãcity_idåãç ´æ£ãããã</ph>
+ALTER TABLE Cities DROP COLUMN city_id CASCADE;
+
+<ph>-- CITIES表ã®ä¸»ãã¼å¶ç´ãç ´æ£ããã</ph>
+ALTER TABLE Cities DROP CONSTRAINT Cities_PK;
+<ph>-- CITIES表ã®å¤é¨ãã¼å¶ç´ãç ´æ£ããã</ph>
+ALTER TABLE Cities DROP CONSTRAINT COUNTRIES_FK;
+<ph>-- æ¢å®å¤ã1ã«ã¨ãDEPTNOåã追å ããã</ph>
+ALTER TABLE SAMP.EMP_ACT ADD COLUMN DEPTNO INT DEFAULT 1;
+<ph>-- VARCHARåã®åå¹
ãå¢ããã</ph>
+ALTER TABLE SAMP.EMP_PHOTO ALTER PHOTO_FORMAT SET DATA TYPE VARCHAR(30);
+<ph>-- 表ã®ããã¯ç²åº¦ãå¤æ´ããã</ph>
+ALTER TABLE SAMP.SALES LOCKSIZE TABLE;
+
+<ph>-- MANAGERåã®NOT NULLå¶ç´ãç ´æ£ããã</ph>
+ALTER TABLE Employees ALTER COLUMN Manager NULL;
+<ph>-- SSNåã«NOT NULLå¶ç´ã追å ããã</ph>
+ALTER TABLE Employees ALTER COLUMN ssn NOT NULL;
+
+<ph>-- SALARYåã®æ¢å®å¤ãå¤æ´ããã</ph>
+ALTER TABLE Employees ALTER COLUMN Salary DEFAULT 1000.0
+
+</b></codeblock></section>
+<section><title>æã®çµæ</title><p>ALTER TABLE æã«ããå¤æ´ãã表ã«ä¾åããå
¨ã¦ã®æã¯ã次åã®å®è¡ã«ã¦åã³ã³ãã¤ã«ããã¾ããããå¤æ´ãã表ãåç
§ãããéããã«ã¼ã½ã«ãããå ´åãALTER TABLEã¯è¨±å¯ããã¾ããã</p></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj81859.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj89752.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj89752.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj89752.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj89752.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="rrefsqlj89752" xml:lang="ja">
+<title>åç
§ç¯</title>
+<refbody>
+<example> <codeblock><b>REFERENCING
+{
+{ OLD | NEW } [ ROW ] [ AS ] correlation-Name [ { OLD | NEW } [ ROW ] [ AS ] correlation-Name ] |
+{ OLD TABLE | NEW TABLE } [ AS ] Identifier [ { OLD TABLE | NEW TABLE } [AS] Identifier ] |
+{ OLD_TABLE | NEW_TABLE } [ AS ] Identifier [ { OLD_TABLE | NEW_TABLE } [AS] Identifier ]
+}</b></codeblock>
+<note>
+<codeph><b>OLD_TABLE | NEW_TABLE</b></codeph>ã¯ãå¾æ¹äºææ§åã³DB2ã¨ã®äºææ§ã®ããã®æ§æã§ããããã¯SQLæ¨æºã«æ²¿ã£ã¦ããªãã®ã§éæ¨å¥¨ã§ãã
+</note>
+</example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj89752.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj91438.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj91438.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj91438.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj91438.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,28 @@
+<?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="rrefsqlj91438" xml:lang="ja">
+<title>æ¤ç´¢æ¡ä»¶</title>
+<refbody>
+<section><p>A <i>æ¤ç´¢æ¡ä»¶</i> ã¨ã¯ã<xref href="rrefsqlj13590.dita#rrefsqlj13590/sqlj57077"></xref>ã«ã¦è¨è¿°ãããè¦ä»¶ãæºããã<xref href="rrefsqlj23075.dita#rrefsqlj23075">çå½å¼</xref>ã§ãã</p></section>
+<section><p><i>å¶ç´å</i>ãæ示ãããªãã£ãå ´åã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ä¸ææ§å¶ç´åã(åã®å¶ç´ã«ã表ã®å¶ç´ã«ã)çæãã¾ãã</p></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj91438.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj93082.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj93082.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj93082.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj93082.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="rrefsqlj93082" xml:lang="ja">
+<title>SUBSTRé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>functions<indexterm>SUBSTR</indexterm></indexterm><indexterm>SUBSTR
+function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section>
+<p>SUBSTRé¢æ°ã¯æååå¼ãããã¯ãããåå¼ã«ä½ç¨ãã¾ãã
+çµæã®ãã¼ã¿åã¯ãããããåè
ã®å ´åã¯<xref href="rrefsqlj41207.dita#rrefsqlj41207">VARCHAR</xref>ã§ãå¾è
ã®å ´åã¯<xref href="rrefsqlj32714.dita#rrefsqlj32714">VARCHAR FOR
+BIT DATA</xref>ã§ãã
+çµæã®æ大é·ã¯å
ã®å¼æ°ã®åã®æ大é·ã§ãã</p></section>
+<refsyn><title>æ§æ</title><codeblock>SUBSTR({ <i>æåå¼</i> },
+ <i>éå§ä½ç½®</i> [, <i>åã®é·ã</i> ] )</codeblock>
+<p>å¼æ°ã®<i>éå§ä½ç½®</i>ã¨çç¥å¯è½ãª<i>åã®é·ã</i>ã¯ã©ã¡ããæ´æ°å¼ã§ãã
+å
é ã®æåãããã¯ãããã®<i>éå§ä½ç½®</i>ã¯1ã§ãã
+ãã0ãä¸ããããå ´åã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯1ãä¸ãããããã®ã¨ã¿ãªãã¾ãã</p>
+<p><i>æåå¼</i>ã®ãã¼ã¿åã¯CHARãVARCHARãLONG VARCHARããããã¯(ãããå¼ã§ã¯ãªã)æååã«æé»ã®ãã¡ã«å¤æå¯è½ãªçµã¿è¾¼ã¿åã®ä½ããã§ãã</p>
+<p>æåå¼ã§ã¯<i>éå§ä½ç½®</i>ããã³<i>åã®é·ã</i>ã¨ãããã©ã¡ã¼ã¿ã¯æåãããã¾ãããããå¼ã«ã¤ãã¦ã¯ã<i>éå§ä½ç½®</i>ããã³<i>åã®é·ã</i>ã¨ãããã©ã¡ã¼ã¿ã¯ããããããã¾ãã</p>
+<p>ãã<i>éå§ä½ç½®</i>ãæ£ã§ããã°ããã®æ°ã¯åºã¨ãªãå¼ã®å
é ããæ°ããä½ç½®ãæãã¾ãã(å
é ã®æåã¯1ã¨æ°ãã¾ãã)<i>éå§ä½ç½®</i>ã¯è² ã¨ãããã¨ãã§ãã¾ããã</p>
+<p>ãã<i>åã®é·ã</i>ãæå®ãããªãã£ãå ´åãSUBSTRã¯å¼ã®<i>éå§ä½ç½®</i>ããæ«å°¾ã¾ã§ã®é¨ååãè¿ãã¾ãããã<i>åã®é·ã</i>ãæå®ãããå ´åãSUBSTRã¯<i>éå§ä½ç½®</i>ããå§ã¾ã<i>åã®é·ã</i>ã®ãVARCHARãããã¯VARBITãè¿ãã¾ãã
+ãã<i>åã®é·ã</i>ã«è² ã®æ°ãä¸ããããå ´åãSUBSTRé¢æ°ã¯ã¨ã©ã¼ãè¿ãã¾ãã</p> </refsyn>
+<example><title>ä¾</title>
+<p><codeph>hello</codeph>ã¨ããåèªã®äºã¤ç®ã®æåããæå¾ã¾ã§ã®é¨ååãè¿ãã«ã¯ã次ã®ãããªç¯ãæ¸ãã¾ãã<codeblock>VALUES SUBSTR('hello', 2)</codeblock>
+çµæã¯'<codeph>ello</codeph>'ã¨ãªãã¾ãã</p>
+<p><codeph>hello</codeph>ã¨ããåèªã®æåã®æåããäºã¤ç®ã®æåã¾ã§ã®é¨ååãè¿ãã«ã¯ã次ã®ãããªç¯ãæ¸ãã¾ãã<codeblock>VALUES SUBSTR('hello',1,2)</codeblock>
+çµæã¯'<codeph>he</codeph>'ã¨ãªãã¾ãã</p></example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj93082.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj95598.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj95598.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj95598.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj95598.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="rrefsqlj95598" xml:lang="ja">
+<title>RENAME INDEX æ</title>
+<prolog><metadata>
+<keywords><indexterm>RENAME INDEX statement</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>ãã®æã§ãç¾å¨ã®ã¹ãã¼ãã«ããç´¢å¼ã®ååãå¤æ´ã§ãã¾ãã
+ã¦ã¼ã¶ã¯<i>SYS</i>ã¹ãã¼ãã«ããç´¢å¼ã®ååãå¤æ´ã§ãã¾ããã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>RENAME INDEX <i>ç´¢å¼å</i> TO <i>æ°ç´¢å¼å</i></b></codeblock> </refsyn>
+<example> <codeblock><b>RENAME INDEX DESTINDEX TO ARRIVALINDEX</b></codeblock> </example>
+<section><title>æã®ä¾å</title>
+<p>éããã«ã¼ã½ã«ãããç´¢å¼ã«ã¯ãRENAME INDEX ãå®è¡ã§ãã¾ããã</p> </section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj95598.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj97870.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj97870.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj97870.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj97870.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,34 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqlj97870" xml:lang="ja">
+<title>LTRIMé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>LTRIM function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>LTRIMã¯æååå¼ããå
é ã«ãã空ç½æåã®åãåãé¤ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>LTRIM(<i>æåå¼</i>)</b></codeblock> <p>A <i>æåå¼</i>ã®ãã¼ã¿åã¯ãCHARãVARCHARãããã¯LONG VARCHARãããã¯æé»ã«æååã«å¤æå¯è½ãªçµè¾¼ã¿ã®åã§ãã</p>
+<p>ãã<i>æåå¼</i>ã®è©ä¾¡ã空ãªããLTRIMã¯NULLãè¿ãã¾ãã</p> </refsyn>
+<example> <codeblock><b><ph>-- 'asdf 'ãè¿ãã¾ãã</ph>
+VALUES LTRIM(' asdf ')</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj97870.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj98067.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj98067.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj98067.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj98067.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="rrefsqlj98067" xml:lang="ja">
+<title>ABSã¨ABSVALé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>ABS or ABSVAL function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>ABS 㨠ABSVALã¯æ°å¼ã®çµ¶å¯¾å¤ãè¿ãã¾ãã
+帰ãå¤ã®åã¯å¼æ°ã®åã¨åãã§ããçµè¾¼ã¿ã®æ°å¤åã¯å
¨ã¦ä½¿ããã¨ãã§ãã¾ãã
+(<xref href="rrefsqlj15260.dita#rrefsqlj15260">DECIMAL</xref>, <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE PRECISION</xref>, <xref href="rrefsqlj27281.dita#rrefsqlj27281">FLOAT</xref>, <xref
+href="rrefsqlj10696.dita#rrefsqlj10696">INTEGER</xref>ã <xref href="rrefsqlj30435.dita#rrefsqlj30435">BIGINT</xref>ã <xref
+href="rrefsqlj12362.dita#rrefsqlj12362">NUMERIC</xref>ã <xref href="rrefsqlj14122.dita#rrefsqlj14122">REAL</xref>
+ããã¨<xref href="rrefsqlj16221.dita#rrefsqlj16221">SMALLINT</xref>)ã</p></section>
+<refsyn><title>æ§æ</title> <codeblock id="i1195049"><b>ABS(<i>æ°å¼</i>)</b></codeblock> </refsyn>
+<example> <codeblock><b><ph>-- 3ãè¿ãã</ph>
+VALUES ABS(-3)</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqlj98067.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcreatesynonym.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcreatesynonym.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcreatesynonym.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcreatesynonym.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,41 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<reference id="rrefsqljcreatesynonym" xml:lang="en-us">
+<title>CREATE SYNONYM æ</title>
+<prolog><metadata>
+<keywords><indexterm>CREATE SYNONYM statement</indexterm><indexterm>Synonyms<indexterm>creating</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section><p>CREATE SYNONYMæã«ãã£ã¦åãã¹ãã¼ããããã¯ç°ãªãã¹ãã¼ãã«åå¨ãã表ããã¥ã¼ã«å¥åãä¸ããäºãã§ãã¾ãã
+ããã«å¥åã«å¥åãä¸ãã¦ãå
¥ãåã®å¥åãä½æãããã¨ãã§ãã¾ãã
+å¥åã¯å
ã®éå®ããã表ããã¥ã¼ã®ååã«ä»£ãããSELECTãINSERTãUPDATEãDELETEãLOCK TABLEæã«ã¦å©ç¨ã§ãã¾ããåå¨ããªã表ããã¥ã¼ã¸ã®å¥åãä½æãããã¨ãå¯è½ã§ãããå¥åãå©ç¨ããåã¾ã§ã«å¯¾è±¡ã®è¡¨ããã¥ã¼ã¯åå¨ãã¦ããªããã°ãªãã¾ããã</p><p>å¥åã¯è¡¨ããã¥ã¼ã¨åãåå空éãå
±æãã¾ããåãã¹ãã¼ãã«æ¢ã«ãã表ã¨åãååã§å¥åãä½ããã¨ã¯ã§ãã¾ãããåæ§ã«æ¢
ã«åå¨ããå¥åã¨åãååã®è¡¨ããã¥ã¼ãä½æãããã¨ã¯ã§ãã¾ããã</p>
+<p>å¥åã¯ä½ææã«ã¾ã åå¨ãã¦ããªã表ããã¥ã¼ã«ãä½æãããã¨ãã§ãã¾ãããã表ããã¥ã¼ãåå¨ãã¦ããªããã°ããã®ãã¨ãè¦åããã¾ãã(SQLSTATE 01522)
+DMLæã§å¥åã使ãã¨ãã«ã¯åç
§ããæ
å ±ã¯åå¨ãã¦ããªããã°ãªãã¾ããã</p>
+<p>å
¥ãåã«ãªã£ãå¥å(ä»ã®å¥åã¸ã®å¥å)ãä½æãããã¨ã¯ã§ãã¾ãããåç
§é¢ä¿ã循ç°ãããããªå¥åãä½æãããã¨ããã¨ã¨ã©ã¼ã¨ãªãã¾ãã(SQLSTATE 42916)</p>
+<p>å¥åã¯ã·ã¹ãã ã¹ãã¼ãã«å®ç¾©ã§ãã¾ããã'SYS'ã§ååãå§ã¾ãããããã¹ãã¼ãã¯ã·ã¹ãã ã¹ãã¼ãã¨ã¿ãªããã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã«ããã¦äºç´ããã¦ãã¾ãã</p>
+<p>ä¸æ表ã¸ã®å¥åã¯ä½æã§ãã¾ãããä¸æ表ã«å¥åãå®ç¾©ãããã¨ããã¨ã¨ã©ã¼ã¨ãªãã¾ãã(SQLSTATE XCL51)</p></section>
+<section><title>æ§æ</title><codeblock><b>CREATE SYNONYM <xref href="rrefsynonymname.dita#rrefsynonymname">å¥ã®å</xref> FOR { <xref
+href="rrefviewname.dita#rrefviewname">ãã¥ã¼å</xref> | <xref href="rreftablename.dita#rreftablename">表å</xref> }</b></codeblock>
+æä¸ã®<xref href="rrefsynonymname.dita#rrefsynonymname">å¥ã®å</xref>ã¯ã対象ã®è¡¨ããã¥ã¼ã«ä¸ããå¥åã§ããä¸æ¹ã§ã<xref
+href="rrefviewname.dita#rrefviewname">ãã¥ã¼å</xref>ã<xref href="rreftablename.dita#rreftablename">表å</xref>ã¯ã対象ã®è¡¨ããã¥ã¼ã®å
ã®ååã§ãã</section>
+<example><title>ä¾</title>CREATE SYNONYM SAMP.T1 FOR SAMP.TABLEWITHLONGNAME</example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcreatesynonym.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrentdate.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrentdate.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrentdate.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrentdate.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqljcurrentdate" xml:lang="ja">
+<title>CURRENT DATE é¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>CURRENT DATE function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>CURRENT DATE ã¯<xref href="rrefsqlj34177.dita#rrefsqlj34177">CURRENT_DATE</xref>ã®å¥åã§ãã</p></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrentdate.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrentschema.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrentschema.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrentschema.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrentschema.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,43 @@
+<?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="rrefsqljcurrentschema" xml:lang="ja">
+<title>CURRENT SCHEMAé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>CURRENT SCHEMA function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>CURRENT SCHEMAã¯ãã¼ã¿ãã¼ã¹ã®æ
å ±ã¸ã®åç
§åãéå®ã§ããã¹ãã¼ãåãè¿ãã¾ãã</p>
+<note>CURRENT SCHEMAã¨CURRENT SQLIDã¯å¥åã§ãã</note>
+<p>ãããã®é¢æ°ã¯æ大128æåã®æååãè¿ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>CURRENT SCHEMA
+
+<b>-- ã¾ãã¯ã</b>
+
+CURRENT SQLID</b></codeblock> </refsyn>
+<example> <codeblock><b><ph>-- nameã¨ããåã®æ¢å®å¤ãç¾å¨ã®ã¹ãã¼ãåã«ããã</ph>
+CREATE TABLE mytable (id int, name VARCHAR(128) DEFAULT CURRENT SQLID)
+<ph>-- 表ã«ç¾å¨ã®ã¹ãã¼ãåã¨ãªã£ã¦ããæ¢å®å¤ãæ¿å
¥ããã</ph>
+INSERT INTO mytable(id) VALUES (1)
+<ph>-- ç¾å¨ã®ã¹ãã¼ãã¨åãååã®è¡¨ãè¿ãã</ph>
+SELECT name FROM mytable WHERE name = CURRENT SCHEMA</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrentschema.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrenttimestamp.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrenttimestamp.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrenttimestamp.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrenttimestamp.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqljcurrenttimestamp" xml:lang="ja">
+<title>CURRENT TIMESTAMPé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>CURRENT TIMESTAMP function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>CURRENT TIMESTAMP ã¯<xref href="rrefsqlj15866.dita#rrefsqlj15866">CURRENT_TIMESTAMP</xref>ã®å¥åã§ãã</p></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljcurrenttimestamp.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljdoubleprecision.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljdoubleprecision.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljdoubleprecision.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljdoubleprecision.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="rrefsqljdoubleprecision" xml:lang="ja">
+<title>DOUBLE PRECISION ãã¼ã¿å</title>
+<prolog><metadata>
+<keywords><indexterm>DOUBLE PRECISION data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>DOUBLE PRECISIONã¯IEEEæµ®åå°æ°ç¹è¡¨è¨ã«åºã¥ãã¦æ°ãã8ãã¤ãã®é åã«è¨é²ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title>
+<codeblock><b>DOUBLE PRECISION</b></codeblock> <p>ã¾ãã¯ã</p> <codeblock><b>DOUBLE</b></codeblock>
+<p>DOUBLEã¯DOUBLE PRECISIONã¨åãæå³ã§ç¨ãããã¨ãã§ãã¾ãã</p> </refsyn>
+<section><title>å¶é</title>
+<p>DOUBLEã®å¤ã¯ä»¥ä¸ã®ç¯å²ã§ãã</p> <ul>
+<li>DOUBLEã®æå°å¤: -1.79769E+308</li>
+<li>DOUBLEã®æ大å¤: 1.79769E+308</li>
+<li>DOUBLEã®æå°ã®æ£ã®å¤: 2.225E-307</li>
+<li>DOUBLEã®æ大ã®è² ã®å¤: -2.225E-307</li>
+</ul> <p>ãããã®å¶éã¯ãJavaã®åã§ãã<codeph>java.lang.Double</codeph>ã®å¶éã¨ã¯ç°ãªãã¾ãã</p>
+<p>ãããã®ç¯å²å¤ã®å¤ãè¨ç®ãããã代å
¥ãããã¨ä¾å¤ãæããã¾ãã
+æ°ã®æ¼ç®å¦çã§ã¯ãçµæã®å¤ã¯é¶ã«ä¸¸ãå¦ç<b>ããã¾ãã</b>ã
+ããå¤ãå°ããããå ´åã¯ä¾å¤ã¨ãªãã¾ãã</p>
+<p>æµ®åå°æ°ç¹æ°ã®å®æ°ã¯30æåã¾ã§ã«å¶éããã¾ãã
+<codeblock>-- ãã®ä¾ã§ã¯å®æ°å¤ãé·ãããããã失æãã¾ãã
+<b>values 01234567890123456789012345678901e0;</b></codeblock></p> </section>
+<section><title>対å¿ããã³ã³ãã¤ã«æã®Javaã®å</title> <p><i>java.lang.Double</i></p> </section>
+<section><title>JDBC ã®ã¡ã¿ãã¼ã¿å (java.sql.Types)</title> <p>DOUBLE</p>
+<p>å¼ã«ã¦ä»ã®ãã¼ã¿åãæ··å¨ããå ´åãå¼ã®çµæã®åã¯<xref href="rrefsqlj27767.dita#rrefsqlj27767"></xref>ã§è¨è¿°ãããè¦åã«å¾ã決ã¾ãã¾ãã</p>
+<p><xref href="rrefsqlj20204.dita#rrefsqlj20204"></xref>ãåç
§ãã¦ãã ããã</p> </section>
+<example id="sqlj35021"><title>ä¾</title> <codeblock><b>3421E+09
+425.43E9
+9E-10
+4356267544.32333E+30</b></codeblock> </example>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljdoubleprecision.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljdropsynonym.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljdropsynonym.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljdropsynonym.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljdropsynonym.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,32 @@
+<?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="rrefsqljdropsynonym" xml:lang="ja">
+<title>DROP SYNONYM æ</title>
+<prolog><metadata>
+<keywords><indexterm>DROP SYNONYM statement</indexterm><indexterm>Synonyms<indexterm>dropping</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>表ããã¥ã¼ã®å¥åãç ´æ£ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>DROP SYNONYM <xref href="rrefsynonymname.dita#rrefsynonymname">å¥åå</xref></b></codeblock> </refsyn>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljdropsynonym.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljgrant.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljgrant.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljgrant.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljgrant.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,81 @@
+<?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
+
+"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="rrefsqljgrant" xml:lang="ja">
+<title>GRANT æ </title>
+<shortdesc>GRANT æã使ã£ã¦ããã¼ã¿ãã¼ã¹ã«ããæ
å ±ã®æä½æ¨©éããæå®ããä¸äººãããã¯å
¨ã¦ã¼ã¶ã«ä¸ãããã¨ãã§ãã¾ãã</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>GRANT statement</indexterm><indexterm>SQL statements<indexterm>GRANT</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>次ã®æ¨©éãä¸ãããã¨ãã§ãã¾ãã<ul>
+<li>表ããã®æ
å ±ã®åé¤</li>
+<li>表ã¸ã®æ
å ±ã®æ¿å
¥</li>
+<li>表ãããã¯è¡¨ã«ããåã®é¨åéåã¸ã®å¤é¨ãã¼å¶ç´ã®ä½æ</li>
+<li>表ããã¥ã¼ã表ã«ããåã®é¨åéåããã®æ
å ±ã®é¸æ</li>
+<li>表ã¸ã®ããªã¬ã¼ã®ä½æ</li>
+<li>表ãããã¯è¡¨ã«ããåã®é¨åéåã®æ
å ±ã®æ´æ°</li>
+<li>é¢æ°ãããã¯æç¶ãã®å®è¡</li>
+</ul></p><p>GRANTæãçºè¡ããåã«ã<codeph>derby.database.sqlAuthorization</codeph>å±æ§ã<codeph>true</codeph>ã§ãããã¨ã確èªãã¦ãã ããã<codeph>derby.database.sqlAuthorization</codeph>å±æ§ã«ãããSQLèªè¨¼ãæå¹ã«ãªãã¾ãã</p>
+
+
+<p>ã¦ã¼ã¶ã«æ¨©éä»ä¸ãèªãããã¦ããæ
å ±ã§ããã°ããã®æ
å ±ã¸ã®æ¨©éãã¦ã¼ã¶ã¯ä¸ãããã¨ãã§ãã¾ãã
+詳細ã«ã¤ãã¦ã¯ã権éãä¸ãããã¨ãã¦ããæ
å ±ã«å¯¾å¿ããCREATEæã®èª¬ææãèªãã§ãã ããã</p>
+<p>GRANTæã®æ¸ãæ¹ã¯ã表ã«å¯¾ãã権éä»ä¸ãªã®ããããã¨ãããã°ã©ã ã«ã¼ãã³ã«å¯¾ãã権éä»ä¸ãªã®ãã«ããããã®æ§æãç°ãªãã¾ãã</p></section>
+<section><title>表ã®å ´åã®æ§æ</title><codeblock><b>GRANT <i><xref href="rrefsqljgrant.dita#rrefsqljgrant/grantprivtype">権éã¿ã¤ã</xref></i
+> ON [TABLE] { <i><xref href="rreftablename.dita#rreftablename"></xref></i> | <i><xref
+href="rrefviewname.dita#rrefviewname"></xref></i> } TO <i><xref href="rrefsqljgrant.dita#rrefsqljgrant/grantgrantees">権éãä¸ãããã人</xref></i></b></codeblock
+></section>
+<section><title>ããã°ã©ã ã«ã¼ãã³ã®å ´åã®æ§æ</title><codeblock><b>GRANT EXECUTE ON { FUNCTION | PROCEDURE } <i><xref
+href="rrefsqljgrant.dita#rrefsqljgrant/grantroutinename">ããã°ã©ã ã«ã¼ãã³ã®æ示å</xref></i> TO <i><xref
+href="rrefsqljgrant.dita#rrefsqljgrant/grantgrantees">権éãä¸ãããã人</xref></i></b></codeblock></section>
+
+<section id="granttablepriv"><title>表権é</title><codeblock><b> DELETE |
+ INSERT |
+ REFERENCES [<i>åä¸è¦§</i>] |
+ SELECT [<i>åä¸è¦§</i>] |
+ TRIGGER |
+ UPDATE [<i>åä¸è¦§</i>]
+</b></codeblock></section>
+<section id="grantcollist"><title>åä¸è¦§</title><codeblock><b> ( åèå¥å {, åèå¥å}* )
+</b></codeblock></section>
+<section><p>ALL PRIVILEGES権éã«ããæå®ãã表ã¸ã®ãã¹ã¦ã®æ¨©éãã¦ã¼ã¶ã«ä»ä¸ãã¾ãã権éã®ä¸¦ã³ãæå®ãã¦ã表ã¸ã®ä¸ã¤ä»¥ä¸ã®æ¨©éãä»ä¸ãããã¨ãå¯è½ã§ãã</p>
+<p>DELETE権éã«ããæå®ãã表ããè¡ãåé¤ãã権éãä»ä¸ãã¾ãã</p>
+<p>INSERT権éã«ããæå®ãã表ã«è¡ãæ¿å
¥ãã権éãä»ä¸ãã¾ãã</p>
+<p>REFERENCES権éã«ããæå®ãã表ã¸ã®å¤é¨ãã¼åç
§ãä½æãã権éãä»ä¸ãã¾ããREFERENCESã«åããã¦å並ã³ãæå®ãããå ´åãæå®ããåã¸ã®å¤é¨ãã¼åç
§ã ãã許å¯ããã¾ãã</p>
+<p>SELECT権éã«ãã表ãããã¯ãã¥ã¼ã§SELECTæãè¡ã権éãä»ä¸ããã¾ããããSELECT権éã§åã®ä¸¦ã³ãæå®ãããå ´åããããã®åã«ã®ã¿æ¨©éã¯æå¹ã§ããåã®ä¸¦ã³ãæå®ãããªãã£ãå ´åã表ã®å
¨åã«ã¤ãã¦æ¨©éã¯æå¹ã§ãã</p>
+<p>TRIGGER権éã«ããæå®ãã表ã«ããªã¬ãä½æãã権éãä»ä¸ããã¾ãã</p>
+<p>UPDATE権éã«ããæå®ãã表ã«UPDATEæã使ã権éãä»ä¸ããã¾ããåã®ä¸¦ã³ãæå®ãããå ´åã権éã¯æå®ãããåã«ã®ã¿æå¹ã§ããWHEREç¯ã®ããæã§è¡ãæ´æ°ããå ´åãæ´æ°ããè¡ã«ããåã¸ã®SELECT権éãå¿
è¦ã§ãã</p></section>
+
+<section id="grantgrantees"><title>権éãä¸ãããã人</title><codeblock><b>{ <i>èªè¨¼èå¥å</i> | PUBLIC } [,{ <i>èªè¨¼èå¥å</i> | PUBLIC } ] *</b
+></codeblock><p>ç¹å®ã®ã¦ã¼ã¶ã¾ãã¯å
¨ã¦ã¼ã¶ã«æ¨©éãä¸ãããã¨ãã§ãã¾ãã
+PUBLIC ã¨ãããã¼ã¯ã¼ãã¯å
¨ã¦ã¼ã¶ãããããã¾ããPUBLICãä¸ããããå ´åãç¾åããã¦ã¼ã¶ã®ã¿ãªããã以éã«ä½æãããã¦ã¼ã¶ã«ã権éãä¸ãããã¾ãã
+PUBLICã«ä¸ãããã権éã¨ãåã
ã®ã¦ã¼ã¶ã«ä¸ãããã権éã¯ãç¬ç«ãã¦ãã¾ãã
+ä¾ãã°ã<codeph>t</codeph>ã¨ãã表ã¸ã®SELECT権éããPUBLICã¨<codeph>harry</codeph>ã¨ããèªè¨¼èå¥åã«å¯¾ãã¦ä¸ãããã¦ããã¨ãã¾ãããããã®å ´åã¯ã<codeph>harry</codeph>ã¨ããèªè¨¼èå¥åããSELECT権éãå¥å¥ªãããã¨ãã¦ããHarryã¯PUBLICã®æ¨©éãéãã¦ã<codeph>t</codeph>ã¨ãã表ãæä½å¯è½ã§ãã</p></section>
+<section id="grantroutinename"><title>ããã°ã©ã ã«ã¼ãã³ã®æ示å</title><codeblock><b>{
+ <i>é¢æ°å</i> | <i>æç¶ãã®åå</i>
+}</b></codeblock></section>
+<example id="grantexamples"><title>ä¾</title><p>tã¨ãã表ã¸ã®SELECT権éã<codeph>maria</codeph> 㨠<codeph>harry</codeph>ã¨ããèªè¨¼èå¥åã«ä¸ããã«ã¯ã次ã®ããã«æ¸ãã¾ãã<codeblock><b>GRANT SELECT ON TABLE t TO maria,harry</b> </codeblock></p>
+<p>tã¨ãã表ã¸ã®UPDATEã¨TRIGGER権éãã<codeph>anita</codeph>ã¨<codeph>zhi</codeph>ã¨ããèªè¨¼èå¥åã«ä¸ããã«ã¯ã次ã®ããã«æ¸ãã¾ãã<codeblock><b>GRANT UPDATE, TRIGGER ON TABLE t TO anita,zhi</b> </codeblock></p>
+<p>s.vã¨ãã表ã¸ã®SELECT権éãå
¨ã¦ã®ã¦ã¼ã¶ã«ä¸ããã«ã¯ã次ã®ããã«æ¸ãã¾ãã<codeblock><b>GRANT SELECT ON TABLE s.v to PUBLIC</b></codeblock></p
+>
+<p>pã¨ããæç¶ãã®å®è¡æ¨©éãã<codeph>george</codeph>ã¨ããèªè¨¼èå¥åã«ä¸ããã«ã¯ã次ã®ããã«æ¸ãã¾ãã</p><codeblock><b>GRANT EXECUTE ON PROCEDURE p TO george</b> </codeblock></example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljgrant.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljmod.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljmod.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljmod.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljmod.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,37 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqljmod" xml:lang="ja">
+<title>MODé¢æ°</title>
+<prolog><metadata>
+<keywords><indexterm>MOD function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>MODã¯ãä¸ã¤ç®ã®å¼æ°ãäºã¤ç®ã®å¼æ°ã§å²ã£ãå°ä½(æ³)ãè¿ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>mod(æ´æ°å, æ´æ°å) </b></codeblock>
+<p>é¢æ°ã®çµæã¯ã<ul>
+<li>両æ¹ã®å¼æ°ãSMALLINTãªããSMALLIINTã</li>
+<li>çæ¹ã®å¼æ°ãINTEGERã§ãããçæ¹ãINTEGERãããã¯SMALLINTãªããINTEGERã</li>
+<li>çæ¹ã®å¼æ°ãBIGINTã§ãããçæ¹ãBIGINTãããã¯INTEGERãããã¯SMALLINTãªããBIGINTã</li>
+</ul></p>
+<p>è¿ãå¤ã¯NULLãã¨ããã¨ããããããä½ããã®å¼æ°ãNULLãªããè¿ãå¤ã¯NULLã§ãã</p> </refsyn>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljmod.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native