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 [2/26] - in /db/derby/docs/trunk: ./ src/ja_JP/ src/ja_JP/ref/

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj1003454.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj1003454.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj1003454.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj1003454.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,47 @@
+<?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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj1003454" xml:lang="ja">
+<title>SQL92識別子の規則</title>
+<prolog><metadata>
+<keywords><indexterm>SQL92Identifiers<indexterm>rules for</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<conbody>
+<p>通常の識別子は二重引用符によって囲われていません。デリミトされた識別子は二重引用符によって囲まれています。</p>
+<p>通常の識別子は文字で始まり、文字、アンダースコア(_)、0-9の数字しか含みません。ここで文字と0-9の数字とは、Unicodeの全文字と0-9の数字を含みますが、<ph conref="../conrefs.dita#prod/productshortname"></ph>は、識別子を構成する文字がデータベースのロケールで利用可能であることを保障するものではありません。</p>
+<p><indexterm>delimited identifiers<indexterm>definition</indexterm></indexterm>
+デリミトされた識別子は二重引用符の間にどのような文字でも持つことができます。
+また識別氏を囲う二重引用符は、識別子の始まりと終わりを明示しているだけであり、それ自身は識別子とみなされません。またデリミトされた識別子の最後にある空白文字列は、無視されて切り捨てられます。<ph conref="../conrefs.dita#prod/productshortname"></ph>はデリミトされた識別子にある連続した二つの二重引用符を、ひとつの二重引用符とみなします。このみなされた二重引用符はデリミã�
 �ˆã•ã‚ŒãŸè­˜åˆ¥å­ã®ä¸€éƒ¨ã¨ã—て扱われます。</p>
+<p>デリミトされた識別子の中のピリオドはディクショナリの情報をあらわす識別子の一部であり、識別子の間の区切りではありません。</p>
+<p>ですから、次の例にて、<codeblock><b>"A.B"</b></codeblock></p>
+<p>は、ディクショナリの情報ですが、<codeblock><b>"A"."B"</b></codeblock></p>
+<p>は、他のディクショナリの情報で限定されたディクショナリの情報です。(つまり、A表のB列としてあらわされた情報であるということです。)</p>
+</conbody>
+</concept>
+
+
+
+
+
+
+
+
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj1003454.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj1004091.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj1004091.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj1004091.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj1004091.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,27 @@
+<?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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj1004091" xml:lang="en-us">
+<title>ディクショナリの情報を名前で限定する</title>
+<conbody>
+<p>ディクショナリの情報は、他のディクショナリの情報の一部となることがあり、そのとき情報をそれぞれのディクショナリの名前で限定できます。このとき構成は次の構成との間で、ピリオドで区切られます。<i>SQL92識別子は</i>はドットで区切られます。名前で限定することにより、ディクショナリの情報名があいまいになることを防ぐことができます。</p>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj1004091.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj18919.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj18919.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj18919.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj18919.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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj18919" xml:lang="ja">
+<title>SQLの識別子 </title>
+<conbody>
+<p><indexterm>SQL identifiers<indexterm>definition</indexterm></indexterm><indexterm>Identifiers<indexterm>definition</indexterm></indexterm><i
+>識別子</i>とは、ある言語においてキーワードやコマンドとは異なる、ユーザが作成した情報をあらわすものです。<indexterm>Dictionary
+objects<indexterm>definition</indexterm></indexterm>識別子は表、ビュー、索引、列、制約のような、ユーザがデータベースに作成した<i>ディクショナリの情報</i>をあらわすことがあります。ここで、これらの情報をディクショナリの情報とわれわれが呼ぶのは、<ph conref="../conrefs.dita#prod/productshortname"></ph>がデータディクショナリとも呼ばれる、システム表にこれらの情報を記録するからです。
+SQLの仕様は、こういった情報を特定の文で別名により扱う方法を用意しています。</p>
+<p><indexterm>SQL92Identifiers<indexterm>definition</indexterm></indexterm><indexterm>JavaIdentifiers<indexterm>definition</indexterm></indexterm
+>識別子は、その種類に応じてそれぞれの規則にそっていなければなりません。ディクショナリの情報の識別子の場合、SQL-92が定義する識別子の規則に沿わなければなりません。このことより、ディクショナリの情報の識別子のことを<i><xref href="crefsqlj34834.dita#crefsqlj34834">SQL92識別子</xref></i>と呼びます。.</p>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj18919.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj21305.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj21305.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj21305.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj21305.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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj21305" xml:lang="ja">
+<title>組み込まれた型の概要</title>
+<prolog><metadata>
+<keywords><indexterm>NULL<indexterm>not a data type</indexterm></indexterm>
+<indexterm>SQL-92 data types<indexterm>supported by Derby</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<conbody>
+<p>言語のコンパイラや言語の実行システムは、SQLの型を使います。前者はコンパイル時に式の型を判断して、後者は実行時に式の型を判断します。実行時の式の型はコンパイル時の型のサブタイプまたはその実装の何れかとすることができます。</p>
+<p>型にはそれぞれにその型の値があります。さらにデータベースに格納された値や式から返される値は、空(NULL)であることがあります。これは値がない、またはわからない事を意味します。
+キーワードのNULLを明示する文脈もありますが、空は独立した値ではありません。なぜならば値は関連した型を必要として、空にはそれがないからです。</p>
+<p>この章で説明する構文は、CREATE TABLE文にて列のデータ型を指定する構文です。</p>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj21305.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj22771.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj22771.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj22771.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj22771.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,72 @@
+<?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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj22771" xml:lang="en-us">
+<title>依存関係</title>
+<conbody>
+<p><indexterm>Dependencies<indexterm>internal tracking of</indexterm></indexterm><indexterm>Prepared
+statements<indexterm>tracking of dependencies</indexterm></indexterm><ph conref="../conrefs.dita#prod/productshortname"></ph> は準備済み文の依存関係を追跡します。準備済み文とは実行前にコンパイルされたSQL文の事です。典型的なシナリオとして、これらは準備(プレコンパイル)された後、複数回実行されます。</p>
+<p>準備済み文はディクショナリの情報や、それ自身から参照する他の文に依存します。(ディクショナリの情報とは、表・列・制約・索引・ビュー・トリガのことです。)
+準備済み文が依存しているディクショナリの情報や文が、破棄されたり変更されたりすると、内部的に準備済み文は無効となり、<ph conref="../conrefs.dita#prod/productshortname"></ph>は準備済み文が実行されるとき、自動的に再コンパイルを行おうとします。
+もしこのとき、準備済み文の再コンパイルが失敗すると、実行は失敗します。
+しかしながら、もし何らかの対応を行って(無くなった表を復活させるなどして)失われた依存性を元に戻せるのなら、失敗した準備済み文を成功裏に実行することができます。これは、<ph conref="../conrefs.dita#prod/productshortname"></ph>が再実行が要求されたとき、再コンパイルを自動的に行うからです。</p>
+<p>お互いに依存した文-UPDATE WHERE CURRENT文は参照する文に依存します。依存する文を破棄すると、UPDATE WHERE CURRENT文は無効になります。</p>
+<p>さらに準備済み文の結果がオープンしている場合、ある種のDDL文の実行を妨げます。</p>
+<p>それぞれの文に対応したマニュアルの頁には、その文が準備された場合、どのようなことをすると無効になるのかが書かれています。</p>
+<p>ここに<ph conref="../conrefs.dita#prod/productshortname"></ph>のijというツールを使って例を示します。   <codeblock>ij&gt; <b>CREATE TABLE mytable (mycol INT);</b>
+0 rows inserted/updated/deleted
+ij&gt; <b>INSERT INTO mytable VALUES (1), (2), (3);</b>
+3 rows inserted/updated/deleted
+-- この例ではijのprepareコマンドを使います。
+-- このコマンドにより文が準備されます。
+ij&gt; <b>prepare p1 AS 'INSERT INTO MyTable VALUES (4)';</b>
+-- p1はmytableに依存します;
+ij&gt; <b>execute p1;</b>
+1 row inserted/updated/deleted
+-- <ph conref="../conrefs.dita#prod/productshortname"></ph>は再コンパイルせずに文を実行します。
+ij&gt; <b>CREATE INDEX i1 ON mytable(mycol);</b>
+0 rows inserted/updated/deleted
+-- 新しい索引のため、p1は一時的に無効となります。
+ij&gt; <b>execute p1;</b>
+1 row inserted/updated/deleted
+-- <ph conref="../conrefs.dita#prod/productshortname"></ph>は自動的にp1を再コンパイルして、実行します。
+ij&gt; <b>DROP TABLE mytable;</b>
+0 rows inserted/updated/deleted
+-- <ph conref="../conrefs.dita#prod/productshortname"></ph>では以下のように表を破棄することができます。
+-- これはp1の結果が閉じているからです。
+-- しかしながらp1は一時的に無効となります。
+ij&gt; <b>CREATE TABLE mytable (mycol INT);</b>
+0 rows inserted/updated/deleted
+ij&gt; <b>INSERT INTO mytable VALUES (1), (2), (3);</b>
+3 rows inserted/updated/deleted
+ij&gt; <b>execute p1;</b>
+1 row inserted/updated/deleted
+-- p1は無効となっているので、<ph conref="../conrefs.dita#prod/productshortname"></ph>は実行の前に再コンパイルを行います。
+-- 再コンパイルは成功して、文は実行できます。
+ij&gt; <b>DROP TABLE mytable;</b>
+0 rows inserted/updated/deleted
+-- p1は無効です。
+-- 今度は最コンパイルしようとしても失敗するので、
+-- 実行も失敗です。
+ij&gt; <b>execute p1;</b>
+ERROR 42X05: Table/View 'MYTABLE' does not exist.</codeblock></p>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj22771.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj23296.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj23296.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj23296.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj23296.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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj23296" xml:lang="en-us">
+<title>SQL言語のリファレンス</title>
+<conbody>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph>はSQL-92のうち主要な機能のサブセットおよび、幾つかのSQL-99の機能を実現しています。</p>
+<p>この節では、文、組み込み関数、データ型、式、特殊文字などの説明を通して、SQL言語の概観を紹介します。</p>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj23296.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj28138.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj28138.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj28138.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj28138.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,47 @@
+<?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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj28138" xml:lang="ja">
+<title>数値型の概要</title>
+<conbody>
+<p>数値型には以下の型があります。それぞれの型は異なるサイズの記憶容量を持ちます。
+   <ul>
+<li>整数   <ul>
+<li><xref href="rrefsqlj16221.dita#rrefsqlj16221">SMALLINT</xref> (2 bytes)</li>
+<li><xref href="rrefsqlj10696.dita#rrefsqlj10696">INTEGER</xref> (4 bytes)</li>
+<li><xref href="rrefsqlj30435.dita#rrefsqlj30435">BIGINT</xref> (8 bytes)</li>
+</ul></li>
+<li>近似数または浮動小数点数   <ul>
+<li><xref href="rrefsqlj14122.dita#rrefsqlj14122">REAL</xref> (4 bytes)</li>
+<li><xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE PRECISION</xref> (8
+bytes)</li>
+<li><xref href="rrefsqlj27281.dita#rrefsqlj27281">FLOAT</xref> (<xref
+href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE PRECISION</xref>あるいは<xref
+href="rrefsqlj14122.dita#rrefsqlj14122">REAL</xref>の別名)</li>
+</ul></li>
+<li>正確な数<ul>
+<li><xref href="rrefsqlj15260.dita#rrefsqlj15260">DECIMAL</xref> (精度に応じた記録)</li>
+<li><xref href="rrefsqlj12362.dita#rrefsqlj12362">NUMERIC</xref> (<xref
+href="rrefsqlj15260.dita#rrefsqlj15260">DECIMAL</xref>の別名)</li>
+</ul></li>
+</ul></p>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj28138.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj29911.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj29911.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj29911.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj29911.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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj29911" xml:lang="ja">
+<title>動的パラメータ</title>
+<prolog><metadata>
+<keywords><indexterm>Dynamic parameters</indexterm><indexterm>IN (? or dynamic)
+parameters</indexterm><indexterm>Prepared statements<indexterm>use of dynamic
+parameters in</indexterm></indexterm><indexterm>? (dynamic parameter)<indexterm>in
+prepared statements</indexterm></indexterm></keywords>
+</metadata></prolog>
+<conbody>
+<p>JDBC APIの<i>PreparedStatement</i>を使うことで、値が決まっていないパラメータを持つ文を準備することができます。これらのパラメータは動的パラメータと呼ばれ、?で表されます。</p>
+<p>JDBC APIの文書では動的パラメータはIN、INOUT、OUTの何れかとされており、SQLではINとされています。</p>
+<note othertype="New" type="other"><ph conref="../conrefs.dita#prod/productshortname"></ph> は、JDBC 3.0で導入された<i>ParameterMetaData</i>のインターフェイスをサポートします。このインターフェイスにより準備された文にあるパラメータの数・型・属性が記述されます。
+より詳細な情報については、<cite><ph
+conref="../conrefs.dita#pub/citdevelop"></ph></cite>を参照してください。</note>
+<p>これらの値は、文が実行される前に指定されなければなりません。また値は文脈に沿った型を持たなければなりません。</p>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj29911.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj31068.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj31068.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj31068.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj31068.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,25 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.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.
+-->
+<concept id="crefsqlj31068" xml:lang="ja">
+<title>データ型</title>
+<conbody>
+<p>この節では<ph conref="../conrefs.dita#prod/productshortname"></ph>にて利用できるデータ型を説明します。</p>
+</conbody>
+</concept>

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj31068.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj34834.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj34834.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj34834.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj34834.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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj34834" xml:lang="en-us">
+<title>SQL92識別子</title>
+<conbody>
+<p><i>SQL92識別子</i>とは、SQL-92に沿ってディクショナリの情報をあらわす識別子です。SQL-92では、ディクショナリの情報をあらわす識別子は、128文字以内かつ(二重引用符によりデリミトされていなければ)システムにより大文字への変換が行われるため、大文字小文字が区別されないことになっています。また、デリミトされない限り識別子とはできない予約語があります。もし128文
 字以上の名前を使おうとすると、<i>SQLException</i> X0X11が挙がります。</p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph>には、SQL-92で定められている以外にもキーワードがあります。(<xref href="rrefkeywords29722.dita#rrefkeywords29722"></xref>を参照。)</p>
+<section><title>例</title> <codeblock><b><ph>-- この例ではシステムカタログに格納されビュー名は
+-- ANIDENTIFIERです。</ph>
+CREATE VIEW AnIdentifier (RECEIVED) AS VALUES 1
+<ph>-- この例ではシステムカタログに格納されたビュー名の
+-- 大文字小文字は損なわれません。</ph>
+CREATE VIEW "ACaseSensitiveIdentifier" (RECEIVED) AS VALUES 1</b></codeblock></section>
+<section><p>以降の節にて、<i>SQL92識別子</i>によりディクショナリの情報をあらわす時の規則を説明します。</p></section>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj34834.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj35312.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj35312.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj35312.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj35312.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,27 @@
+<?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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj35312" xml:lang="ja">
+<title>SET 文</title>
+<conbody>
+<p>Set文で、スキーマと分離レベルを設定できます。</p>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj35312.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj39374.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj39374.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj39374.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj39374.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,33 @@
+<?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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj39374" xml:lang="ja">
+<title>文</title>
+<conbody>
+<p>本節は言語の高レベルな構造と、それから言語の部分について、マニュアルを提供します。
+たとえばCREATE INDEX文は高レベルの文です。これをユーザはJDBCのインターフェイスを通して直接実行することができます。本節にはSQLの節についても書かれています。これは、高レベルの文ではなく、直接実行することはできませんが、高レベルの文の一部となることができます。例えばORDER BY節やWHERE節は節です。最後に本節には、式について書かれています。式は文に置くことã�
 �Œã§ãã‚‹è¤‡é›‘な構文です。例えば、<i><xref href="rrefselectexpression.dita#rrefselectexpression">Select式</xref></i>や<i><xref
+href="rreftablesubquery.dita#rreftablesubquery">表副問い合わせ</xref></i>等が式です。
+これらの節や式には、リファレンスとして使いやすいよう、それぞれにマニュアルの頁が用意されています。</p>
+<p>特に何も書かれていなければ、<i>文</i>と記された全ての高レベルの文は、JDBCのインターフェイスを介して、実行する事あるいは用意して実行することが可能です。
+一方、個々の式について、高レベルの文として実行可能か否かこのマニュアルにて書かれています。</p>
+<p>本節では文の利用についての一般的な情報や、個々の文についての説明が書かれています。</p>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj39374.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj41507.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj41507.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj41507.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj41507.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,25 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.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.
+-->
+<concept id="crefsqlj41507" xml:lang="ja">
+<title>数値型</title>
+<conbody>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph>の数値型です。</p>
+</conbody>
+</concept>

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj41507.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj80721.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj80721.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj80721.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj80721.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,27 @@
+<?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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj80721" xml:lang="ja">
+<title>DROP文</title>
+<conbody>
+<p>関数、索引、手続、スキーマ、別名、表、トリガ、ビューのDrop文が使えます。</p>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj80721.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj95081.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqlj95081.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqlj95081.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqlj95081.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,27 @@
+<?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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqlj95081" xml:lang="ja">
+<title>CREATE 文</title>
+<conbody>
+<p>関数、索引、手続き、スキーマ、別名、表、トリガ、ビューのCREATE文が使えます。</p>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqlj95081.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native

Added: db/derby/docs/trunk/src/ja_JP/ref/crefsqljrenamestatements.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/crefsqljrenamestatements.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/crefsqljrenamestatements.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/crefsqljrenamestatements.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,27 @@
+<?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 concept PUBLIC "-//OASIS//DTD DITA Concept//EN"
+ "../dtd/concept.dtd">
+<concept id="crefsqljrenamestatements" xml:lang="ja">
+<title>RENAME 文</title>
+<conbody>
+<p>索引や列、表にRENAME 文を使えます。</p>
+</conbody>
+</concept>
+

Propchange: db/derby/docs/trunk/src/ja_JP/ref/crefsqljrenamestatements.dita
------------------------------------------------------------------------------
    svn:svn:eol-style = native