db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r854277 [13/44] - in /websites/production/db/content/derby: docs/10.4/ja_JP/ docs/10.4/ja_JP/getstart/ docs/10.4/ja_JP/images/ docs/10.4/ja_JP/ref/ manuals/
Date Wed, 13 Mar 2013 13:54:25 GMT
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefbuiltinteger.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefbuiltinteger.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefbuiltinteger.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,85 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="INTEGER関数" />
+<meta content="INTEGER function" name="DC.subject" />
+<meta content="INTEGER function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefbuiltinteger" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>INTEGER関数</title>
+</head>
+<body id="rrefbuiltinteger"><a name="rrefbuiltinteger"><!-- --></a>
+
+
+<h1 class="topictitle1">INTEGER関数</h1>
+
+
+<div>
+<div class="section">INTEGER関数は、数、文字列、日付、時刻を表す整数を定整数の書式を返します。</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>INT[EGER] (<em>数式</em> | <em>文字列式</em> ) </strong></pre>
+ <dl>
+
+<dt class="dlterm">数式</dt>
+
+<dd>組込みの数値データ型を返す式です。
+もし引数が数式であれば、その式が大きな整数の列や変数へと代入された時と同じ数が返ります。
+もし引数が整数の範囲に収まらないなら、エラーとなります。また、引数の小数部は切り捨てられます。</dd>
+
+
+<dt class="dlterm">文字列式</dt>
+
+<dd>文字定数の最大長より短い文字列長の文字列を返す式です。
+引数から前後の空白文字を取り除いた残りは、SQLの定整数書式に沿っていなければなりません。
+この文字列は長い文字列であってはなりません。
+もし引数が文字列であれば、その式が大きな整数の列や変数に代入されたときと同じ数が返ります。
+</dd>
+
+</dl>
+ <p>関数の結果は大きな整数です。引数にnullをとることができる場合、結果がnullとなることがあり、引数がnullなら返り値はnullです。
+</p>
+ </div>
+
+<div class="example"> <div class="p">EMPLOYEE表から給与(SALARY)を教育レベル(EDLEVEL)で除した数の一覧を選択します。この除算にて小数は切り捨てられます。この一覧には計算の元となる値や社員番号(EMPNO)が含まれます。この一覧は計算結果の降順となっています。: <pre><strong>SELECT INTEGER</strong> (SALARY / EDLEVEL), SALARY, EDLEVEL, EMPNO
+<strong>FROM</strong> EMPLOYEE
+<strong>ORDER BY</strong> 1 <strong>DESC</strong></pre>
+</div>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefsqlj29026.html" title="">組み込み関数</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefbuiltinteger.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefbuiltsmallint.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefbuiltsmallint.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefbuiltsmallint.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,94 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="SMALLINT関数" />
+<meta content="functions, SMALLINT, SMALLINT function" name="DC.subject" />
+<meta content="functions, SMALLINT, SMALLINT function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefbuiltsmallint" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>SMALLINT関数</title>
+</head>
+<body id="rrefbuiltsmallint"><a name="rrefbuiltsmallint"><!-- --></a>
+
+
+<h1 class="topictitle1">SMALLINT関数</h1>
+
+
+<div>
+<div class="section">SMALLINT関数は数や小さな整数の書式に沿った文字列を表す、小さな整数を返します。</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre>SMALLINT ( <em>数式</em> | <em>文字式</em> )</pre>
+ <dl>
+
+<dt class="dlterm">数式</dt>
+
+<dd>組込みの数値型を返す式です。
+もし引数が数式であれば、この関数の返り値は引数が、小さな整数の列や変数に代入されたときに変換されるのと同じ値となります。
+もし値が小さな整数の範囲に収まらない場合、エラーとなります。
+また引数が持つ小数部は切り捨てられます。</dd>
+
+
+<dt class="dlterm">文字式</dt>
+
+<dd>文字定数の最大長を超えない文字列を返す式です。
+先頭と末尾の空白文字は取り除かれ、その残りはSQLの整数定数の書式に沿わなければなりません。
+さらにその値は小さな整数の範囲の中に収まっていなければなりません。
+文字列は長い文字列であってはなりません。
+もし引数が文字式であるなら、この関数の返り値は引数が、小さな整数の列や変数に代入されたときに変換されるのと同じ値となります。
+</dd>
+
+</dl>
+ 
+<p>関数の結果は小さな整数となります。もし引数がnullをとることがある場合、返り値はnullをとることがあります。引数がnullなら返り値はnullです。
+</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">例</h4>
+<div class="p">32767.99という数を、小さな整数にするには、このような節を書きます。
+<pre>VALUES SMALLINT (32767.99)</pre>
+
+結果は32767です。</div>
+
+<div class="p">1という数を、小さな整数にするには、このような節を書きます。
+<pre>VALUES SMALLINT (1)</pre>
+
+結果は1です。</div>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefsqlj29026.html" title="">組み込み関数</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefbuiltsmallint.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefbuiltvarchar.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefbuiltvarchar.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefbuiltvarchar.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,86 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="VARCHAR関数" />
+<meta content="VARCHAR function" name="DC.subject" />
+<meta content="VARCHAR function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefbuiltvarchar" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>VARCHAR関数</title>
+</head>
+<body id="rrefbuiltvarchar"><a name="rrefbuiltvarchar"><!-- --></a>
+
+
+<h1 class="topictitle1">VARCHAR関数</h1>
+
+<div>
+<div class="section">VARCHAR関数は文字列を表す、可変長文字列を返します。</div>
+
+<div class="section"><h4 class="sectiontitle">文字列を可変長文字列に変換する構文</h4>
+<pre><strong>VARCHAR (<em>文字列式</em> ) </strong></pre>
+
+<dl>
+<dt class="dlterm">文字列式</dt>
+
+<dd>式の値は最大で32,672バイトの文字列でなければなりません。</dd>
+
+</dl>
+
+</div>
+
+<div class="section"><h4 class="sectiontitle">日時を可変長文字列に変換する構文</h4>
+<pre><strong>VARCHAR (<em>日時式</em> ) </strong></pre>
+
+<dl>
+<dt class="dlterm">日時式</dt>
+
+<dd>式の値は、日付、時刻、タイムスタンプの何れかの型でなければなりません。</dd>
+
+</dl>
+
+</div>
+
+<div class="example">
+<div class="p">EMPLOYEE表より、"Dolores Quintana"の仕事の説明(CHAR(8)のJOB)を、可変長文字列の値として選択する。
+<pre><strong>SELECT VARCHAR</strong>(JOB)
+<strong>FROM</strong> EMPLOYEE
+<strong>WHERE</strong> LASTNAME = 'QUINTANA'</pre>
+</div>
+
+</div>
+</div>
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefsqlj29026.html" title="">組み込み関数</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefbuiltvarchar.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcallprocedure.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcallprocedure.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcallprocedure.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,69 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="CALL (手続き) 文" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefcallprocedure" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>CALL (手続き) 文</title>
+</head>
+<body id="rrefcallprocedure"><a name="rrefcallprocedure"><!-- --></a>
+
+
+<h1 class="topictitle1">CALL (手続き) 文</h1>
+
+
+<div>
+<div class="section"><p>CALL (手続き)文により手続きを呼ぶことができます。
+手続きへの呼び出しは値を返しません。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4>
+<pre><strong>CALL <a href="rrefcreateprocedurestatement.html#rrefcreateprocedurestatement__rrefcrproprocedurename">手続名</a> ( [ <var class="varname">式</var> [, <var class="varname">式</var>]* ] )
+</strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">例</h4>
+<pre><strong>CREATE PROCEDURE SALES.TOTAL_REVENUE(IN S_MONTH INTEGER,
+IN S_YEAR INTEGER, OUT TOTAL DECIMAL(10,2))
+PARAMETER STYLE JAVA READS SQL DATA LANGUAGE JAVA EXTERNAL NAME 
+'com.acme.sales.calculateRevenueByMonth';
+CALL SALES.TOTAL_REVENUE(?,?,?);
+</strong></pre>
+</div>
+
+</div>
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="crefsqlj39374.html" title="">文</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcallprocedure.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcase.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcase.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcase.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,83 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="CASE 式" />
+<meta name="abstract" content="Derbyで条件式を書くには、CASE式を使います。" />
+<meta name="description" content="Derbyで条件式を書くには、CASE式を使います。" />
+<meta content="CASE expression" name="DC.subject" />
+<meta content="CASE expression" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefcase" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>CASE 式</title>
+</head>
+<body id="rrefcase"><a name="rrefcase"><!-- --></a>
+
+
+<h1 class="topictitle1">CASE 式</h1>
+
+
+
+<div><p><span>Derby</span>で条件式を書くには、CASE式を使います。</p>
+
+<div class="example"><h4 class="sectiontitle">CASE式の構文</h4>
+<p>式を置くことができる場所であれば、どこにでもCASE式を置くことができます。
+この式では真偽の判定に基づき、評価される式が決まります。</p>
+ 
+<pre><strong>CASE 
+  WHEN <em>真偽式</em> THEN <em>then式</em> 
+  [ WHEN <em>真偽式</em> THEN <em>then式</em> ]...
+  ELSE <em>else式</em> 
+END</strong></pre>
+ 
+<p><em>Then式</em>と<em>else式</em>は型に互換性がある式でなければなりません。組み込まれている型に関して言えば、同じ型であるか、型の間に組み込みの拡張変換がある必要があります。</p>
+
+<pre><strong>-- 3を返す。
+VALUES CASE WHEN 1=1 THEN 3 ELSE 4 END</strong></pre>
+ <pre><strong>
+-- 7を返す。
+VALUES
+   CASE
+      WHEN 1 = 2 THEN 3
+      WHEN 4 = 5 THEN 6
+      ELSE 7
+   END
+</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefsqlj29026.html" title="">組み込み関数</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcase.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcasenullif.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcasenullif.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcasenullif.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,66 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="NULLIF式" />
+<meta name="abstract" content="Derbyでは、条件式にはNULLIF式を使います。" />
+<meta name="description" content="Derbyでは、条件式にはNULLIF式を使います。" />
+<meta content="NULLIF expression" name="DC.subject" />
+<meta content="NULLIF expression" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefcasenullif" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>NULLIF式</title>
+</head>
+<body id="rrefcasenullif"><a name="rrefcasenullif"><!-- --></a>
+
+
+<h1 class="topictitle1">NULLIF式</h1>
+
+
+
+<div><p><span>Derby</span>では、条件式にはNULLIF式を使います。</p>
+
+<div class="example"><h4 class="sectiontitle">NULLIF式の構文</h4><pre><strong>NULLIF ( L, R )</strong></pre>
+
+NULLIF式はCASE式によく似ています。
+例えば、<pre><strong>NULLIF(V1,V2)</strong></pre>
+は、
+次のCASE式と同等です。<pre><strong>CASE WHEN V1=V2 THEN NULL ELSE V1 END</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefsqlj29026.html" title="">組み込み関数</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcasenullif.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcheckpointdbproc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcheckpointdbproc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcheckpointdbproc.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,67 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASEシステム手続き" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlbuiltinsystemprocedures.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefcheckpointdbproc" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASEシステム手続き</title>
+</head>
+<body id="rrefcheckpointdbproc"><a name="rrefcheckpointdbproc"><!-- --></a>
+
+
+<h1 class="topictitle1">SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASEシステム手続き</h1>
+
+<div>
+<div class="section"><p><samp class="codeph">SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE</samp>システム手続きにより、キャッシュされた情報を全てディスクに書き出して、チェックポイントを処理します。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre>SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE()</pre>
+ <p>この手続きでは結果は返りません。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">JDBCの例</h4> <pre>CallableStatement cs = conn.prepareCall
+("CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE()");
+cs.execute();
+cs.close();</pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">SQLの例</h4> <pre>CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();</pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="crefsqlbuiltinsystemprocedures.html" title="">組み込みシステム手続き</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcheckpointdbproc.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefclauses.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefclauses.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefclauses.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,124 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="SQL 節" />
+<meta name="abstract" content="" />
+<meta name="description" content="" />
+<meta content="clauses, SQL statements" name="DC.subject" />
+<meta content="clauses, SQL statements" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj23296.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj28468.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj18919.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj19433.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29840.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefqueries.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlbuiltinsystemfunctions.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefkeywords29722.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsql9241891.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsistabs38369.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefexcept16677.html" />
+<meta scheme="URI" name="DC.Relation" content="crefjdbc12657.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc87220.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbcjsr169.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc32593.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc4_0summary.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc1020262.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj13590.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj31783.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj21583.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj32654.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj14854.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj13658.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj33602.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj15309.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefclauses" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>SQL 節</title>
+</head>
+<body id="rrefclauses"><a name="rrefclauses"><!-- --></a>
+
+
+<h1 class="topictitle1">SQL 節</h1>
+
+
+
+<div><p />
+</div>
+
+<div>
+<ul class="ullinks">
+<li class="ulchildlink"><strong><a href="rrefsqlj13590.html">CONSTRAINT 節</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj31783.html">FOR UPDATE 節</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj21583.html">FROM 節</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj32654.html">GROUP BY 節</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj14854.html">HAVING 節</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj13658.html">ORDER BY 節</a></strong><br />
+ORDER BY節はSELECT文の省略可能な要素です。 ORDER BY節にてResultSetにある行の順番を指定できます。</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj33602.html">WHERE 節</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj15309.html">WHERE CURRENT OF 節</a></strong><br />
+</li>
+</ul>
+
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="crefsqlj23296.html" title="">SQL言語のリファレンス</a></div>
+</div>
+<div class="relconcepts"><strong>関連概念</strong><br />
+<div><a href="crefsqlj18919.html" title="">SQLの識別子</a></div>
+<div><a href="crefsqlj39374.html" title="">文</a></div>
+<div><a href="crefsqlbuiltinsystemfunctions.html" title="">組込みシステム関数</a></div>
+<div><a href="crefjdbc12657.html" title="Derbyは組み込みのJDBCドライバと共に提供されます。">JDBC リファレンス</a></div>
+</div>
+<div class="relref"><strong>関連資料</strong><br />
+<div><a href="rrefsqlj28468.html" title="">大文字小文字と特殊文字</a></div>
+<div><a href="rrefsqlj19433.html" title="多くの文や式の構文の語句に、式や表副問合せのような式の一種があります。 式は文の定められた場所に置くことができます。">SQL式</a></div>
+<div><a href="rrefsqlj29840.html" title="">JOIN 演算</a></div>
+<div><a href="rrefqueries.html" title="">SQL 問い合わせ</a></div>
+<div><a href="rrefsqlj29026.html" title="">組み込み関数</a></div>
+<div><a href="rrefkeywords29722.html" title="">SQL予約語</a></div>
+<div><a href="rrefsql9241891.html" title="">DerbyのサポートするSQL-92の機能</a></div>
+<div><a href="rrefsistabs38369.html" title="">Derbyのシステム表</a></div>
+<div><a href="rrefexcept16677.html" title="Derbyにて発生する全てのエラーは、JDBCからSQLExceptionとして挙がります。 もしユーザの定義した型から例外が挙がって、その例外がSQLExceptionでは無い場合、その例外はSQLExceptionにラップされています。 Derby固有のSQLExceptionは、SQLStateクラスに定義されたXで始まるコードを用います。標準に定義されたSQLStateの値は、対応する例外に対して返されます。">Derbyの例外メッセージとSQL state</a></div>
+<div><a href="rrefjdbc87220.html" title="">java.sql.BatchUpdateException クラス</a></div>
+<div><a href="rrefjdbcjsr169.html" title="">Connected Device ConfigurationおよびFoundation Profile向けのJDBCパッケージ(JSR169)</a></div>
+<div><a href="rrefjdbc32593.html" title="">JDBC 3.0の機能</a></div>
+<div><a href="rrefjdbc4_0summary.html" title="">JDBC 4.0の機能</a></div>
+<div><a href="rrefjdbc1020262.html" title="">JDBCエスケープの構文</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefclauses.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefclob.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefclob.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefclob.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,129 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="CLOBデータ型" />
+<meta content="CLOB data type" name="DC.subject" />
+<meta content="CLOB data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefclob" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>CLOBデータ型</title>
+</head>
+<body id="rrefclob"><a name="rrefclob"><!-- --></a>
+
+
+<h1 class="topictitle1">CLOBデータ型</h1>
+
+
+<div>
+<div class="section"> <p>CLOB(キャラクタラージオブジェクト)の値は、最大で2,147,483,647の文字長とすることができます。CLOBはユニコードの文字情報を記録するとき使うことができます。このような情報には様々な文字からなるサイズの大きな文書などが考えられます。</p>
+
+<p>CLOBの長さは数で与えられます。もしK、MやGが数のサフィックスに与えられた場合は、それぞれ1024、1024*1024、1024*1024*1024を意味します。</p>
+
+CLOBの長さは(ユニコードの)文字数をあらわします。</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4><pre><strong>{CLOB |CHARACTER LARGE OBJECT} [ ( 長さ [{K |M |G}] ) ]</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">既定の設定</h4><p>長さを指定しない場合、CLOBの長さは2ギガ(2,147,483,647)バイトとなります。</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対応する実行時のJavaの型</h4><p><em>java.sql.Clob</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBC メタデータの型(java.sql.Types)</h4><p>CLOB</p>
+
+<p>CLOBへのハンドルを取得するには、<em>java.sql.ResultSet</em>にある<em>getClob</em>メソッドを使ってください。</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">関連する情報</h4>
+<p><a href="rrefjdbc96386.html#rrefjdbc96386">java.sql.Blobインターフェイスとjava.sql.Clobインターフェイスの対応</a>を参照してください。</p>
+ </div>
+
+<div class="example"> <pre>import java.sql.*;
+
+public class clob
+{
+	public static void main(String[] args) {
+		try {
+			String url = "jdbc:derby:clobberyclob;create=true";
+
+			Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
+			Connection conn = DriverManager.getConnection(url);
+
+            Statement s = conn.createStatement();
+            s.executeUpdate("CREATE TABLE documents (id INT, text CLOB(64 K))");
+            conn.commit();
+
+            // --- ファイルを追加する。
+            java.io.File file = new java.io.File("asciifile.txt");
+            int fileLength = (int) file.length();
+
+            // - 最初に入力ストリームを作成する。
+            java.io.InputStream fin = new java.io.FileInputStream(file);
+            PreparedStatement ps = conn.prepareStatement("INSERT
+            INTO documents VALUES (?, ?)");
+            ps.setInt(1, 1477);
+
+            // - 入力パラメータの値を入力ストリームにする。
+            ps.setAsciiStream(2, fin, fileLength);
+            ps.execute();
+            conn.commit();
+
+            // --- 列を読む。
+            ResultSet rs = s.executeQuery("SELECT text FROM documents
+             WHERE id = 1477");
+            while (rs.next()) {
+                java.sql.Clob aclob = rs.getClob(1);
+                java.io.InputStream ip = rs.getAsciiStream(1);
+                int c = ip.read();
+                while (c &gt; 0) {
+                    System.out.print((char)c);
+                    c = ip.read();
+                }
+                System.out.print("\n");
+                // ...
+            }
+        } catch (Exception e) {
+            System.out.println("Error! "+e);
+        }
+    }
+}</pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="crefsqlj31068.html" title="">データ型</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefclob.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcolumnname.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcolumnname.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcolumnname.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,83 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="en-us" xml:lang="en-us">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="列名" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj18919.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefcolumnname" name="DC.Identifier" />
+<meta content="en-us" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>列名</title>
+</head>
+<body id="rrefcolumnname"><a name="rrefcolumnname"><!-- --></a>
+
+
+<h1 class="topictitle1">列名</h1>
+
+<div>
+<div class="section"><p>SQLの構文ではさまざまな文脈で、列の名前を<em>表名</em>や<em>相関名</em>により限定することができます。</p>
+</div>
+
+<div class="section"><p>一方で文脈によっては<em>列名</em>を<em>表名</em>や<em>相関名</em>で限定できず、<em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">単純列名</a></em>を使わなければならない場合もあります。
+そのような文脈とは、</p>
+</div>
+
+<div class="section"> <ul>
+<li>表の作成(<a href="rrefsqlj24513.html#rrefsqlj24513">CREATE TABLE 文</a>)</li>
+
+<li>カーソルの更新可能な列の特定</li>
+
+<li>SELECT式にある列の相関名(<em><a href="rrefselectexpression.html#rrefselectexpression">選択式</a></em>を参照)</li>
+
+<li><em>TableExpression</em>にある列の相関名 (<em><a href="rreftableexpression.html#rreftableexpression">TableExpression</a></em>を参照)</li>
+
+</ul>
+<div class="p">更新可能な列には相関名を使うことができません。仮に使えば、SQL例外が起きます。たとえば、<pre>SELECT c11 AS col1, c12 AS col2, c13 FROM t1 FOR UPDATE of c11,c13
+</pre>
+という例にて、相関名を<samp class="codeph">c11のcol1</samp>に使えません。なぜなら、 <samp class="codeph">c11</samp>はFOR UPDATE に存在するからです。一方で相関名を<samp class="codeph">c12</samp>に使うことができます。なぜなら、これはFOR UPDATEに存在しないからです。</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>[ { <em><a href="rreftablename.html#rreftablename">table-Name</a></em> | <em><a href="rrefcorrelationname.html#rrefcorrelationname">correlation-Name</a></em> } . ] <em><a href="crefsqlj34834.html#crefsqlj34834">SQL92Identifier</a></em></strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">例</h4> <pre><span>-- C.Country は
+<a href="rrefcorrelationname.html#rrefcorrelationname">相関名</a>により限定された
+--列名です。</span>
+SELECT C.Country
+FROM APP.Countries C</pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="crefsqlj18919.html" title="">SQLの識別子</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcolumnname.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefconstraintname.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefconstraintname.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefconstraintname.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,62 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="en-us" xml:lang="en-us">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="制約名" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj18919.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefconstraintname" name="DC.Identifier" />
+<meta content="en-us" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>制約名</title>
+</head>
+<body id="rrefconstraintname"><a name="rrefconstraintname"><!-- --></a>
+
+
+<h1 class="topictitle1">制約名</h1>
+
+<div>
+<div class="section"><p>制約名は限定できません。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong><em><a href="crefsqlj34834.html#crefsqlj34834">SQL92識別子</a></em></strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">例</h4> <pre><strong><span>-- country_fk2 は制約名です。</span>
+CREATE TABLE DETAILED_MAPS (COUNTRY_ISO_CODE CHAR(2)
+CONSTRAINT country_fk2 REFERENCES COUNTRIES)</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="crefsqlj18919.html" title="">SQLの識別子</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefconstraintname.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcopyright.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcopyright.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcopyright.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,56 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="en-us" xml:lang="en-us">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="Copyright" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefcopyright" name="DC.Identifier" />
+<meta content="en-us" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>Copyright</title>
+</head>
+<body id="rrefcopyright"><a name="rrefcopyright"><!-- --></a>
+
+
+<h1 class="topictitle1">Copyright</h1>
+
+<div>
+<div class="section"> <p><img src="../images/logowithtext.jpg" alt="Logo for Apache&#10;Derby" /></p>
+ <p>Copyright 2004-2008 The Apache Software Foundation</p>
+ <p> Licensed
+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 <a href="http://www.apache.org/licenses/LICENSE-2.0" target="_blank">http://www.apache.org/licenses/LICENSE-2.0</a>.</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">Related information</h4> <p><a href="rreflicense.html#rreflicense">License</a></p>
+ </div>
+
+</div>
+
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcopyright.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcorrelationname.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcorrelationname.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcorrelationname.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,69 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="en-us" xml:lang="en-us">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="相関名" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj18919.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefcorrelationname" name="DC.Identifier" />
+<meta content="en-us" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>相関名</title>
+</head>
+<body id="rrefcorrelationname"><a name="rrefcorrelationname"><!-- --></a>
+
+
+<h1 class="topictitle1">相関名</h1>
+
+<div>
+<div class="section"><p><em>相関名</em>はFROM句にあるテーブルについて与える事ができ、新しい名前、別名となります。<em>相関名</em>を<em>スキーマ名</em>で限定することはできません。</p>
+
+<div class="p">相関名は更新可能な列に使うことはできません。仮に使えばSQL例外が発生します。
+例えば、<pre>SELECT c11 AS col1, c12 AS col2, c13 FROM t1 FOR UPDATE of c11,c13
+</pre>
+という例では、相関名を<samp class="codeph">c11のcol1</samp>に使うことはできません。なぜなら、<samp class="codeph">c11</samp>はFOR UPDATEにある列だからです。
+それに対して相関名を<samp class="codeph">c12</samp>に使うことはできます。これはFOR UPDATEにないからです。</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong><em><a href="crefsqlj34834.html#crefsqlj34834">SQL92識別子</a></em></strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">例</h4> 
+<pre><span>-- Cは相関名です。
+</span>SELECT C.NAME
+FROM SAMP.STAFF C</pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="crefsqlj18919.html" title="">SQLの識別子</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcorrelationname.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcreatefrom.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcreatefrom.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcreatefrom.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,72 @@
+<!--
+  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.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="createFrom=Path属性" />
+<meta content="createFrom=path database connection URL attribute" name="DC.subject" />
+<meta content="createFrom=path database connection URL attribute" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefattrib24612.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefcreatefrom" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>createFrom=Path属性</title>
+</head>
+<body id="rrefcreatefrom"><a name="rrefcreatefrom"><!-- --></a>
+
+
+<h1 class="topictitle1">createFrom=Path属性</h1>
+
+
+<div>
+<div class="section"><h4 class="sectiontitle">機能</h4> 
+<p>起動時の接続URLに<em>createFrom=path</em>属性を指定して、指定した場所にあるフルバックアップからデータベースを作成することができます。
+もしderby.system.homeに同じ名前のデータベースがあれば、エラーが挙がって既存のデータベースにはなにも行いません。
+もしderby.system.homeに同じ名前のデータベースがなければ、バックアップの場所からデータベース全体がderby.system.homeへとコピーされて、データベースが開始されます。</p>
+ 
+<p>ログファイルは規定の場所へとコピーされます。logDevice属性を<em>createFrom=path</em>に併せて利用することで、ログファイルを別の場所に記録することができます。<em>createFrom=path</em>を利用するとき、個々のログファイルをログディレクトリにコピーする必要はありません。</p>
+ 
+<p>この属性の利用に関するより詳細な情報は、<span><em>Derby サーバと管理ガイド</em></span>の「バックアップした写しからデータベースを作成する」を参照してください。</p>
+
+</div>
+
+<div class="section"><h4 class="sectiontitle">他の属性との組み合わせ</h4> 
+<p>この属性を<em>rollforwardrecoveryFrom</em>や<em>restoreFrom</em>、<em>create</em>と組み合わせて利用しないでください。</p>
+ </div>
+
+<div class="example"> <pre>URL: jdbc:derby:wombat;createFrom=d:/backup/wombat</pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefattrib24612.html" title="Derbyでは、データベース接続URLに属性を指定する、 JDBCの機能を利用できます。">データベース接続URLに属性を指定する。</a></div>
+</div>
+</div>
+
+</body>
+</html>

Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcreatefrom.html
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message