db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r854277 [32/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/rrefsqlj14122.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj14122.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj14122.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,95 @@
+<!--
+  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="REAL データ型" />
+<meta content="REAL data type" name="DC.subject" />
+<meta content="REAL data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreffsqlj14122" 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>REAL データ型</title>
+</head>
+<body id="rreffsqlj14122"><a name="rreffsqlj14122"><!-- --></a>
+
+
+<h1 class="topictitle1">REAL データ型</h1>
+
+
+<div>
+<div class="section"> <p>REAL型ではIEEE浮動小数点数の記法に従う数が4バイトの領域に記録されます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">記法</h4> <pre><strong>REAL</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対応するコンパイル時のJavaの型</h4> <p><em>java.lang.Float</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCのメタデータ型(java.sql.Types)</h4> <p>REAL</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">制限</h4> <p>REALの値の範囲:</p>
+ <ul>
+<li>REALの最小値: -3.402E+38</li>
+
+<li>REALの最大値: 3.402E+38</li>
+
+<li>REALの最小の正の値: 1.175E-37</li>
+
+<li>REALの最大の負の値: -1.175E-37</li>
+
+</ul>
+ <p>これらの制限はJavaでの<samp class="codeph">java.lang.Float</samp>型の制限とは異なります。</p>
+ 
+<p>これらの範囲外の値が計算されたり代入されると例外があがります。
+算術演算では結果は零に丸め処理<strong>されません</strong>。
+もし値が小さすぎる場合は例外が挙がります。アンダーフローを検知するために、算術演算は倍精度で行われます。</p>
+ 
+<div class="p">浮動小数点数の定数は文字長が30文字までに制限されています。
+<pre>-- この例では定数が長すぎるためエラーとなります。
+<strong>values 01234567890123456789012345678901e0;</strong></pre>
+</div>
+ 
+<p>式において他のデータ型と混在して利用された場合、結果のデータ型は<a href="rrefsqlj27767.html#rrefsqlj27767">式にて行われる数値型の項目</a>に記述された規則にのっとって決まります。</p>
+ 
+<p><a href="rrefsqlj20204.html#rrefsqlj20204">数値を異なる数値型の列に記録する</a>を参照してください。</p>
+ 
+<p>定数は常にDOUBLE PRECISIONとされます。REALに変換するにはCASTを使ってください。</p>
+ </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/rrefsqlj14122.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj14854.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj14854.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj14854.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="HAVING 節" />
+<meta content="HAVING clause" name="DC.subject" />
+<meta content="HAVING clause" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj14854" 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>HAVING 節</title>
+</head>
+<body id="rrefsqlj14854"><a name="rrefsqlj14854"><!-- --></a>
+
+
+<h1 class="topictitle1">HAVING 節</h1>
+
+<div>
+<div class="section">
+<p>HAVING節により<em><a href="rrefselectexpression.html#rrefselectexpression">選択式</a></em>のGROUP BYの結果が絞り込まれます。WHERE節が選択列一覧に作用するのとは異なり、HAVING節は表から分類された部分集合に対して作用します。もしGROUP BY節がなければ、HAVING節は結果を単独の分類と見なして作用します。
+SELECT節にてGROUP BY句のない列を直接参照することはできません。しかし定数や集約、特殊変数を参照することはできます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4>
+<pre><strong>HAVING <em>検索条件</em></strong></pre>
+
+<div class="p"><em>検索条件</em>は特殊な<em>真偽式</em>で、分類列(<a href="rrefsqlj32654.html#rrefsqlj32654">GROUP BY 節</a>を参照してください。)か、集約式の一部である列のみ含める事ができます。
+例えば以下の例では、SALARYという列は分類の列や集約、副問い合わせにある列ではないので、この文は不正です。
+<pre><strong>-- SELECT COUNT(*)
+-- FROM SAMP.STAFF
+-- GROUP BY ID
+-- HAVING SALARY &gt; 15000</strong></pre>
+</div>
+
+<p>HAVING節の集約はSELECTの一覧になくてもかまいません。
+もしHAVING節が副問い合わせを含むならば、その副問い合わせは分類の列についてのみ、外の問い合わせを参照することができます。</p>
+
+</div>
+
+<div class="example">
+<pre><strong><span>-- 2席以上の航路ごとに、エコノミー席の合計を調べる。</span>
+SELECT SUM(ECONOMY_SEATS_TAKEN), AIRLINE_FULL
+FROM FLIGHTAVAILABILITY, AIRLINES
+WHERE SUBSTR(FLIGHTAVAILABILITY.FLIGHT_ID, 1, 2) = AIRLINE
+GROUP BY AIRLINE_FULL
+HAVING COUNT(*) &gt; 1
+</strong></pre>
+
+</div>
+</div>
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefclauses.html" title="">SQL 節</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15147.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15147.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15147.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,68 @@
+<!--
+  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="LONG VARCHAR型" />
+<meta content="LONG VARCHAR data type" name="DC.subject" />
+<meta content="LONG VARCHAR data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj15147" 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>LONG VARCHAR型</title>
+</head>
+<body id="rrefsqlj15147"><a name="rrefsqlj15147"><!-- --></a>
+
+
+<h1 class="topictitle1">LONG VARCHAR型</h1>
+
+
+<div>
+<div class="section"> <p>LONG VARCHAR型により最大で32,700文字からなる文字列を記録できます。この型の列を定義するとき、最大長を指定する必要がないことを除けば、この型はVARCHARと同様です。</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>LONG VARCHAR</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対応するコンパイル時のJavaの型</h4> <p><em>java.lang.String</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCメタデータ型 (java.sql.Types)</h4> <p>LONGVARCHAR</p>
+ 
+<p>Javaの値をSQLの値に変換するとき、LONG VARCHARに対応するJavaの型は存在しません。</p>
+ </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/rrefsqlj15147.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15260.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15260.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15260.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,101 @@
+<!--
+  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="DECIMAL データ型" />
+<meta content="DECIMAL data type" name="DC.subject" />
+<meta content="DECIMAL data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj15260" 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>DECIMAL データ型</title>
+</head>
+<body id="rrefsqlj15260"><a name="rrefsqlj15260"><!-- --></a>
+
+
+<h1 class="topictitle1">DECIMAL データ型</h1>
+
+
+<div>
+<div class="section"> <p>DECIMALにより精度と目盛りを指定して正確な数を扱えます。
+この型では精度(小数点の左右の桁数の合計)と目盛り(小数点以下の桁数)を指定できます。
+記憶装置にて必要とされる領域のサイズは、精度により決まります。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>{ DECIMAL | DEC } [(<em>精度</em> [, <em>目盛り</em> ])]</strong></pre>
+ 
+<p><em>精度</em>は1から31の数をとります。<em>目盛り</em>は精度以下の数をとります。</p>
+ 
+<p>目盛りが指定されなかった場合の既定値は0となります。精度が指定されなかった場合の既定値は5となります。</p>
+ 
+<p>DECIMALに代入することが可能なのは、小数部以外が失われない範囲の数です。
+DECIMALの値から小数部を無くする場合、<span>Derby</span>は切捨てを行います。</p>
+ 
+<div class="p">例えば、<pre>-- この型変換で失われるのは小数部のみです。
+<strong>values cast (1.798765 AS decimal(5,2));</strong>
+1
+--------
+1.79
+-- この型変換はうまく行きません。
+<strong>values cast (1798765 AS decimal(5,2));</strong>
+1
+--------
+ERROR 22003: The resulting value is outside the range 
+for the data type DECIMAL/NUMERIC(5,2).</pre>
+</div>
+ 
+<p>他のデータ型が式にて混在して利用されていた場合、式の結果となる型は<a href="rrefsqlj27767.html#rrefsqlj27767">式にて行われる数値型の項目</a>で書かれたとおりに決まります。</p>
+ 
+<p><a href="rrefsqlj20204.html#rrefsqlj20204">数値を異なる数値型の列に記録する</a>も参照してください。</p>
+ 
+<p>二つのDECIMALの値が式にて用いられていた場合、式の結果となる型は<a href="rrefsqlj36146.html#rrefsqlj36146">小数を計算するときの目盛り</a>に記述された規則に従って決まります。</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対応するコンパイル時のJavaの型</h4> <p><em>java.math.BigDecimal</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBC のメタデータ型 (java.sql.Types)</h4> <p>DECIMAL</p>
+ </div>
+
+<div class="example"> <pre><strong>VALUES 123.456
+
+VALUES 0.001</strong></pre>
+ 
+<p>BIGINTには大きすぎる整数の定数は、DECIMALの定数となります。</p>
+ </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/rrefsqlj15260.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15309.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15309.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15309.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,74 @@
+<!--
+  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="WHERE CURRENT OF 節" />
+<meta content="WHERE CURRENT OF clause" name="DC.subject" />
+<meta content="WHERE CURRENT OF clause" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj15309" 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>WHERE CURRENT OF 節</title>
+</head>
+<body id="rrefsqlj15309"><a name="rrefsqlj15309"><!-- --></a>
+
+
+<h1 class="topictitle1">WHERE CURRENT OF 節</h1>
+
+<div>
+<div class="section">
+<p>WHERE CURRENT OF節はUPDATEやDELETE文にて使うことができます。
+これにより更新可能なカーソルの位置による更新や削除が行えます。
+更新可能なカーソルの詳細については、<a href="rrefsqlj41360.html#rrefsqlj41360">SELECT 文</a>を参照してください。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4>
+<pre><strong>WHERE CURRENT OF <em><a href="rrefcursorname.html#rrefcursorname">カーソル名</a></em></strong></pre>
+
+</div>
+
+<div class="example">
+<pre>Statement s = conn.createStatement();
+s.setCursorName("AirlinesResults");
+ResultSet rs = conn.executeQuery(
+    "SELECT Airline, basic_rate " +
+    "FROM Airlines FOR UPDATE OF basic_rate");
+Statement s2 = conn.createStatement();
+s2.executeUpdate("UPDATE Airlines SET basic_rate = basic_rate " +
+    "+ .25 WHERE CURRENT OF AirlinesResults");</pre>
+
+</div>
+</div>
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefclauses.html" title="">SQL 節</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15446.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15446.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15446.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,127 @@
+<!--
+  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="CREATE VIEW 文" />
+<meta content="CREATE VIEW statement, CREATE VIEW, SQL statements, views, creating" name="DC.subject" />
+<meta content="CREATE VIEW statement, CREATE VIEW, SQL statements, views, creating" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj95081.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcreatefunctionstatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj20937.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcreateprocedurestatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj31580.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljcreatesynonym.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj24513.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj43125.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj15446" 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>CREATE VIEW 文</title>
+</head>
+<body id="rrefsqlj15446"><a name="rrefsqlj15446"><!-- --></a>
+
+
+<h1 class="topictitle1">CREATE VIEW 文</h1>
+
+
+<div>
+<div class="section"> <p>ビューとはクエリにより定義された仮想的な表です。表は破棄するまで利用可能なディクショナリの情報です。ビューは更新できません。</p>
+
+<p>限定されたビューの名前にて、スキーマ名は<em>SYS</em>で始まってはなりません。</p>
+
+<p>ビューの所有者は自動的にSELECT権限を得ます。ビューの所有者からSELECT権限を剥奪することはできません。<a href="rrefattrib26867.html#rrefattrib26867">データベースの所有者</a>は自動的にビューへのSELECT権限を持ち、SELECT権限を他のユーザに付与することができます。データベースの所有者からSELECT権限を剥奪することはできません。</p>
+
+<p>ビューの所有者はビューが参照する情報を所有する場合のみ、他のユーザにSELECT権限を付与することができます。</p>
+<p>ビューの所有者が、ビューが参照する情報を所有していない場合、ビューの所有者は適切な権限を付与されていなければなりません。例えば、<samp class="codeph">user2</samp>という認証識別子が<samp class="codeph">user1.t1</samp>という表と<samp class="codeph">user1.f_abs()</samp>という関数を参照する、<samp class="codeph">user2.v2</samp>というビューを作成する場合、<samp class="codeph">user2</samp>は<samp class="codeph">user1.t1</samp>へのSELECT権限と<samp class="codeph">user1.f_abs()へのEXECUTE権限を持たなければã
 ªã‚Šã¾ã›ã‚“。</samp>. </p>
+
+<p>SELECT権限を付与する権限は剥奪できません。ビューが参照する情報への必要な権限が剥奪された場合、ビューは破棄されます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>CREATE VIEW <em><a href="rrefviewname.html#rrefviewname">ビュー名</a></em>
+    [ ( <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">単純列名</a></em> [, <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">単純列名</a></em>] * ) ]
+AS <em><a href="rrefsqlj21571.html#rrefsqlj21571">問い合わせ</a></em> </strong></pre>
+ <p>ビューの定義にビューの列一覧を書くことで、ビューの列に明示的な名前を与えることができます。
+ビューの列一覧がない場合、ビューの列名は元となる問い合わせの列名を引継ぎます。ビューの全列は一意な名前を持たなければなりません。</p>
+ </div>
+
+<div class="example"> <pre><strong>CREATE VIEW SAMP.V1 (COL_SUM, COL_DIFF)
+	AS SELECT COMM + BONUS, COMM - BONUS
+	FROM SAMP.EMPLOYEE;
+
+CREATE VIEW SAMP.VEMP_RES (RESUME)
+	AS VALUES 'Delores M. Quintana', 'Heather A. Nicholls', 'Bruce Adamson';
+
+CREATE VIEW SAMP.PROJ_COMBO 
+	(PROJNO, PRENDATE, PRSTAFF, MAJPROJ) 
+	AS SELECT PROJNO, PRENDATE, PRSTAFF, MAJPROJ
+	FROM SAMP.PROJECT UNION ALL 
+SELECT PROJNO, EMSTDATE, EMPTIME, EMPNO 
+	FROM SAMP.EMP_ACT 
+	WHERE EMPNO IS NOT NULL;</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">文の依存</h4> 
+<div class="p">ビューの定義は参照する表やビューに依存します。
+ビューを参照するDML(data manipulation language)文は、ビューが依存するのと同様に、そのビューに依存します。
+ビューを参照する文は、ビューが利用する索引に依存します。この索引は問い合わせがどのように最適化されるかに応じて文毎に異なります。
+例を以下に挙げます。<pre><strong>CREATE TABLE T1 (C1 DOUBLE PRECISION);
+
+CREATE FUNCTION SIN (DATA DOUBLE) 
+	RETURNS DOUBLE EXTERNAL NAME 'java.lang.Math.sin'
+	LANGUAGE JAVA PARAMETER STYLE JAVA;
+
+CREATE VIEW V1 (C1) AS SELECT SIN(C1) FROM T1;</strong></pre>
+</div>
+ 
+<div class="p">文とそれが依存するデータベースの情報を挙げます。
+<pre><strong>SELECT * FROM V1
+</strong></pre>
+</div>
+ 
+<p><em>V1</em>というビュー、<em>T1</em>という表、
+外部のスカラー関数の<em>SIN</em></p>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="crefsqlj95081.html" title="">CREATE 文</a></div>
+</div>
+<div class="relref"><strong>Related reference</strong><br />
+<div><a href="rrefcreatefunctionstatement.html" title="CREATE FUNCTION文により、式で利用できるJava関数を作成できます。">CREATE FUNCTION 文</a></div>
+<div><a href="rrefsqlj20937.html" title="">CREATE INDEX 文</a></div>
+<div><a href="rrefcreateprocedurestatement.html" title="">CREATE PROCEDURE 文</a></div>
+<div><a href="rrefsqlj31580.html" title="">CREATE SCHEMA 文</a></div>
+<div><a href="rrefsqljcreatesynonym.html" title="">CREATE SYNONYM 文</a></div>
+<div><a href="rrefsqlj24513.html" title="">CREATE TABLE 文</a></div>
+<div><a href="rrefsqlj43125.html" title="">CREATE TRIGGER 文</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15866.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15866.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj15866.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="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="CURRENT_TIMESTAMP関数" />
+<meta content="CURRENT_TIMESTAMP function" name="DC.subject" />
+<meta content="CURRENT_TIMESTAMP function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj15866" 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>CURRENT_TIMESTAMP関数</title>
+</head>
+<body id="rrefsqlj15866"><a name="rrefsqlj15866"><!-- --></a>
+
+
+<h1 class="topictitle1">CURRENT_TIMESTAMP関数</h1>
+
+<div>
+<div class="section">
+<p>CURRENT_TIMESTAMPは現在のタイムスタンプを返します。関数から返される値は一つの文のうちであれば、何度実行されても同じ値を返します。ですから、カーソルから行を拾う間に経過した時間にかかわらず、この関数は同じ値を返します。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">分布</h4>
+<pre><strong>CURRENT_TIMESTAMP</strong></pre>
+
+<p>または</p>
+
+<pre><strong>CURRENT TIMESTAMP</strong></pre>
+
+</div>
+
+<div class="example">
+<pre><strong>VALUES CURRENT_TIMESTAMP
+<span>-- または</span>
+
+VALUES CURRENT TIMESTAMP</strong></pre>
+
+</div>
+</div>
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="rrefsqlj29026.html" title="">組み込み関数</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16095.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16095.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16095.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,73 @@
+<!--
+  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="列毎の制約" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj13590.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42154.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj16357.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj91438.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj16095" 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>列毎の制約</title>
+</head>
+<body id="rrefsqlj16095"><a name="rrefsqlj16095"><!-- --></a>
+
+
+<h1 class="topictitle1">列毎の制約</h1>
+
+<div>
+<div class="example"> <pre><strong>{
+    NOT NULL |
+    [ [CONSTRAINT <em><a href="rrefconstraintname.html#rrefconstraintname">制約名</a></em>]
+    {
+        CHECK (<em><a href="rrefsqlj91438.html#rrefsqlj91438">検索条件</a></em>) |
+        {
+            PRIMARY KEY |
+            UNIQUE |
+            <em><a href="rrefsqlj16357.html#rrefsqlj16357">REFERENCES 節</a></em>
+        } 
+    }
+}</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefsqlj13590.html" title="">CONSTRAINT 節</a></div>
+</div>
+<div class="relref"><strong>関連資料</strong><br />
+<div><a href="rrefsqlj42154.html" title="">表ごとの制約</a></div>
+<div><a href="rrefsqlj16357.html" title="">参照定義</a></div>
+<div><a href="rrefsqlj91438.html" title="">検索条件</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16221.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16221.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16221.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,78 @@
+<!--
+  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="SMALLINT data type" name="DC.subject" />
+<meta content="SMALLINT data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj16221" 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="rrefsqlj16221"><a name="rrefsqlj16221"><!-- --></a>
+
+
+<h1 class="topictitle1">SMALLINT データ型</h1>
+
+
+<div>
+<div class="section"> <p>SMALLINTでは2バイトの記憶領域を提供します。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">Syntax</h4> <pre><strong>SMALLINT</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対応するコンパイル時のJavaの型</h4> <p><em>java.lang.Short</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCのメタデータ型 (java.sql.Types)</h4> <p>SMALLINT</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">最小値</h4> <p id="rrefsqlj16221__sqlj22378"><a name="rrefsqlj16221__sqlj22378"><!-- --></a>-32768 (<em>java.lang.Short.MIN_VALUE</em>)</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">最大値</h4> <p id="rrefsqlj16221__sqlj97879"><a name="rrefsqlj16221__sqlj97879"><!-- --></a>32767
+(<em>java.lang.Short.MAX_VALUE</em>)</p>
+ 
+<p>他のデータ型が式にて混在して利用された場合、結果のデータ型は<a href="rrefsqlj27767.html#rrefsqlj27767">式にて行われる数値型の項目</a>に記された規則に則り決まります。</p>
+ 
+<p><a href="rrefsqlj20204.html#rrefsqlj20204">数値を異なる数値型の列に記録する</a>も参照してください。</p>
+ <p>整数の定数は、その値によりINTEGERあるいはBIGINTとなります。</p>
+ </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/rrefsqlj16221.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16357.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16357.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16357.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="参照定義" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj13590.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj16095.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42154.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj91438.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj16357" 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>参照定義</title>
+</head>
+<body id="rrefsqlj16357"><a name="rrefsqlj16357"><!-- --></a>
+
+
+<h1 class="topictitle1">参照定義</h1>
+
+<div>
+<div class="example"> <pre><strong>REFERENCES <em><a href="rreftablename.html#rreftablename">表名</a></em> [ ( <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">単純列名</a></em> [ , <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">単純列名</a></em> ]* ) ]
+[ ON DELETE {NO ACTION | RESTRICT | CASCADE | SET NULL}]
+   [ ON UPDATE {NO ACTION | RESTRICT }]
+|
+[ ON UPDATE {NO ACTION | RESTRICT }] [ ON DELETE
+   {NO ACTION | RESTRICT | CASCADE | SET NULL}] </strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefsqlj13590.html" title="">CONSTRAINT 節</a></div>
+</div>
+<div class="relref"><strong>関連資料</strong><br />
+<div><a href="rrefsqlj16095.html" title="">列毎の制約</a></div>
+<div><a href="rrefsqlj42154.html" title="">表ごとの制約</a></div>
+<div><a href="rrefsqlj91438.html" title="">検索条件</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16762.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16762.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj16762.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,70 @@
+<!--
+  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="LENGTH関数" />
+<meta content="LENGTH function" name="DC.subject" />
+<meta content="LENGTH function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj16762" 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>LENGTH関数</title>
+</head>
+<body id="rrefsqlj16762"><a name="rrefsqlj16762"><!-- --></a>
+
+
+<h1 class="topictitle1">LENGTH関数</h1>
+
+
+<div>
+<div class="section"> <p>LENGTHは文字列式あるいはビット列式に適用して、文字の長さを結果として返します。</p>
+ 
+<p>あらゆる組込みのデータ型は暗黙のうちに文字列に変換できるので、この関数はあらゆるデータ型に適用することができます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>LENGTH ( { <em>文字列式</em> | <em>ビット列式</em> } )</strong></pre>
+ </div>
+
+<div class="example"> <pre><strong><span>-- 20を返す。</span>
+VALUES LENGTH('supercalifragilistic')
+<span>-- 1を返す。</span>
+VALUES LENGTH(X'FF')
+-- 4を返す
+VALUES LENGTH(1234567890)</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="rrefsqlj29026.html" title="">組み込み関数</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj18730.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj18730.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj18730.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,82 @@
+<!--
+  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="DATEデータ型" />
+<meta content="DATE data type" name="DC.subject" />
+<meta content="DATE data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj18730" 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>DATEデータ型</title>
+</head>
+<body id="rrefsqlj18730"><a name="rrefsqlj18730"><!-- --></a>
+
+
+<h1 class="topictitle1">DATEデータ型</h1>
+
+
+<div>
+<div class="section"> <p>DATEにより、<em>java.sql.Date</em>の範囲で年月日を記録できます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>DATE</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対応する実行時のJavaの型</h4> <p><em>java.sql.Date</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCメタデータ型(java.sql.Types)</h4><p>DATE</p>
+
+<p>一つの式に日付、時刻、タイムスタンプを混在させてはなりません。</p>
+
+<div class="p"><em>java.sql.Date</em>のメソッドにより扱うことのできる全ての値が、対応するSQLの日付や時刻のデータ型の列にて許されています。<span>Derby</span>はDATEの値に対して次の書式を用意しています。<pre>yyyy-mm-dd
+mm/dd/yyyy
+dd.mm.yyyy</pre>
+上に示した三つの書式のうち、最初のものは<em>java.sql.Date</em>の書式です。</div>
+
+<p>年は常に4桁の数字で表されなければなりません。それに対して月や日は一桁あるいは二桁の数字で表すことができます。</p>
+
+<p>さらに、<span>Derby</span>はDB2サーバのロケールに特有な日時の書式を受け付けます。もしとるべき書式があいまいである場合は、上で示した組込みの書式が優先されます。</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">例</h4> <pre><strong>VALUES DATE('1994-02-23')
+
+VALUES '1993-09-01'</strong></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/rrefsqlj18730.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj18922.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj18922.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj18922.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,110 @@
+<!--
+  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="LEFT OUTER JOIN演算" />
+<meta content="LEFT OUTER JOIN operation" name="DC.subject" />
+<meta content="LEFT OUTER JOIN operation" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29840.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj18922" 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>LEFT OUTER JOIN演算</title>
+</head>
+<body id="rrefsqlj18922"><a name="rrefsqlj18922"><!-- --></a>
+
+
+<h1 class="topictitle1">LEFT OUTER JOIN演算</h1>
+
+
+<div>
+<div class="section"> 
+<p>LEFT OUTER JOIN演算は、join節を記述できる<a href="rrefsqlj29840.html#rrefsqlj29840">JOIN演算</a>の一つです。
+この演算では最初の(左の)表にて、一致する行が二つ目の(右の)表にない行は、二つ目の表のNULLの行に結合されたものとして、結果に残ります。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4>
+<pre>
+<strong><em><a href="rreftableexpression.html#rreftableexpression">表式</a></em> LEFT [ OUTER ] JOIN <em><a href="rreftableexpression.html#rreftableexpression">表式</a></em>
+{
+    ON <em>真偽式</em> 
+    }</strong></pre>
+
+<p>ON節にあるいずれの真偽式も、直接の表と直接の問い合わせ文にあるいかなる表を参照することができます。
+ON節は結合されていない表を参照することもできますし、結合されている表を参照しなくともかまいません。(ただし一般的には参照します。)</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">例 1</h4><pre><strong>--都市に対応するアジアの国</strong>
+
+SELECT CITIES.COUNTRY, CITIES.CITY_NAME, REGION 
+FROM Countries 
+LEFT OUTER JOIN Cities
+ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE
+WHERE REGION = 'Asia'
+
+<strong>-- LEFT JOINという別の書き方により、前例と同じ結果を
+-- 実現する。
+</strong>
+SELECT  COUNTRIES.COUNTRY, CITIES.CITY_NAME,REGION 
+FROM COUNTRIES 
+LEFT JOIN CITIES 
+ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE
+WHERE REGION = 'Asia'
+</pre>
+</div>
+
+<div class="example"><h4 class="sectiontitle">例 2</h4><pre><strong>
+-- EMPLOYEEとDEPAETMENTという表を結合して、
+-- 1930より前に生まれた(BIRTHDATE)全ての社員の、
+-- 社員番号(EMPNO)と、
+-- 社員の苗字(LASTNAME)と、
+-- 部署番号(EMPLOYEEという表のWORKDEPTと、DEPARTMENTという表のDEPTNO)と、
+-- 部署名(DEPTNAME)を選択する。
+</strong>
+SELECT EMPNO, LASTNAME, WORKDEPT, DEPTNAME 
+   FROM SAMP.EMPLOYEE LEFT OUTER JOIN SAMP.DEPARTMENT 
+   ON WORKDEPT = DEPTNO 
+   AND YEAR(BIRTHDATE) &lt; 1930
+
+<strong>-- 管理者のいない部署を含め全ての部署を、
+-- 部署の管理者の社員番号と苗字と共に一覧する。
+</strong>
+SELECT DEPTNO, DEPTNAME, EMPNO, LASTNAME
+      FROM DEPARTMENT LEFT OUTER JOIN EMPLOYEE
+	    ON MGRNO = EMPNO</pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefsqlj29840.html" title="">JOIN 演算</a></div>
+</div>
+</div>
+
+</body>
+</html>

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



Mime
View raw message