db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r854277 [43/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/rreftableexpression.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftableexpression.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftableexpression.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,112 @@
+<!--
+  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="TableExpression" />
+<meta content="表式" name="DC.subject" />
+<meta content="表式" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj19433.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefselectexpression.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj11277.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj1080779.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj23075.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj29911.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj33215.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftableexpression" 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>TableExpression</title>
+</head>
+<body id="rreftableexpression"><a name="rreftableexpression"><!-- --></a>
+
+
+<h1 class="topictitle1">TableExpression</h1>
+
+<div>
+<div class="section">
+<p><em>表式</em>により表、ビューあるいは関数を、<a href="rrefsqlj21583.html#rrefsqlj21583">FROM 節</a>にて指定します。これより<em><a href="rrefselectexpression.html#rrefselectexpression">選択式</a></em>にて結果が選択されます。</p>
+
+<p>列を限定するために、相関名を<em>表式</em>に適用することができます。
+相関名が与えられない場合、表名が列名を限定します。
+もし表に相関名が与えられた場合、表名により列を限定することはできず、列名を相関名で限定しなければなりません。</p>
+
+<p>FROM節にある項目は、同じ名前の相関名を持つことができません。また相関名はFROM節にある表の限定されない名前と同じ名前であってはなりません。</p>
+
+<div class="p">さらにAS節を使って表の列に名前を与えることができます。これは以下の状況で便利です。<ul>
+<li><a href="rrefsqlj11277.html#rrefsqlj11277">VALUES式</a>が<em><a href="rreftablesubquery.html#rreftablesubquery">表副問合せ</a></em>で使われている場合、<a href="rrefsqlj11277.html#rrefsqlj11277">VALUES式</a>の列に名前を与える方法は、他には無いです。</li>
+
+<li>列名が他の表の列名と同じ場合、別の名前を与えることで限定の必要がなくなります。</li>
+
+</ul>
+</div>
+
+<p><em>Fromの項目</em>にある<em><a href="rreftablesubquery.html#rreftablesubquery">表副問合せ</a></em>の問合せには、複数列を置くことができ、複数行を返すことができます。<em><a href="rreftablesubquery.html#rreftablesubquery">表副問合せ</a></em>を参照してください。</p>
+
+<p>ユーザが最適化のため何を指定できるかについては、<cite><span><em>Derbyのチューニング</em></span></cite>を参照してください。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4>
+<pre><strong>{
+表やビューあるいは関数式 | 結合式
+}
+</strong></pre>
+
+</div>
+
+<div class="example"><h4 class="sectiontitle">例</h4><pre><strong>
+<span>-- 結合式から選択できます。</span>
+SELECT E.EMPNO, E.LASTNAME, M.EMPNO, M.LASTNAME
+ FROM EMPLOYEE E LEFT OUTER JOIN
+   	DEPARTMENT INNER JOIN EMPLOYEE M 
+  ON MGRNO = M.EMPNO
+  ON E.WORKDEPT = DEPTNO
+</strong></pre>
+
+</div>
+</div>
+<div>
+<ul class="ullinks">
+<li class="ulchildlink"><strong><a href="rrefsqlj33215.html">表またはビューあるいは関数式</a></strong><br />
+</li>
+</ul>
+
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefsqlj19433.html" title="多くの文や式の構文の語句に、式や表副問合せのような式の一種があります。 式は文の定められた場所に置くことができます。">SQL式</a></div>
+</div>
+<div class="relconcepts"><strong>関連概念</strong><br />
+<div><a href="crefsqlj29911.html" title="">動的パラメータ</a></div>
+</div>
+<div class="relref"><strong>関連資料</strong><br />
+<div><a href="rrefselectexpression.html" title="">選択式</a></div>
+<div><a href="rrefsqlj11277.html" title="">VALUES式</a></div>
+<div><a href="rrefsqlj1080779.html" title="">式に関する優先順位</a></div>
+<div><a href="rrefsqlj23075.html" title="">真偽式</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablename.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablename.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablename.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,61 @@
+<!--
+  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="crefsqlj18919.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftablename" 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="rreftablename"><a name="rreftablename"><!-- --></a>
+
+
+<h1 class="topictitle1">表名</h1>
+
+<div>
+<div class="section"><p><em>表名</em>は表をあらわします。<em>表名</em>は<em>スキーマ名</em>で限定することができます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>[ <em><a href="rrefschemaname.html#rrefschemaname">スキーマ名</a>.</em> ] <em><a href="crefsqlj34834.html#crefsqlj34834">SQL92識別子</a></em></strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">例</h4> <pre><strong><span>-- SAMP.PROJECT はスキーマ名のある表名です。</span>
+SELECT COUNT(*) FROM SAMP.PROJECT</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</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/rreftablename.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablesubquery.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablesubquery.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablesubquery.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="表副問合せ" />
+<meta content="TableSubquery" name="DC.subject" />
+<meta content="TableSubquery" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefqueries.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftablesubquery" 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="rreftablesubquery"><a name="rreftablesubquery"><!-- --></a>
+
+
+<h1 class="topictitle1">表副問合せ</h1>
+
+<div>
+<div class="section">
+<p><em>表副問合せ</em>は複数の行を返す副問合せです。</p>
+ 
+<div class="p"><em><a href="rrefscalarsubquery.html#rrefscalarsubquery">スカラー副問合せ</a></em>とは異なり、<em>表副問合せ</em>は以下の文脈にてのみ可能です。
+<ul>
+<li><a href="rrefsqlj21583.html#rrefsqlj21583">FROM 節</a>の<em><a href="rreftableexpression.html#rreftableexpression">表式</a></em></li>
+
+<li>EXISTSやIN、量の比較</li>
+
+</ul>
+</div>
+ 
+<p><a href="rrefsqlj21583.html#rrefsqlj21583">FROM 節</a>の<em><a href="rreftableexpression.html#rreftableexpression">表式</a></em>にて使われた場合、複数の列を返すことができます。</p>
+
+<p>EXISTSでは、*を使う場合のみ複数の列を返すことができます。</p>
+
+<p>INや限定条件では、単列のみ返すことができます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4>
+<pre><strong>(<em><a href="rrefsqlj21571.html#rrefsqlj21571">問合せ</a></em>)</strong></pre>
+
+</div>
+
+<div class="example"><h4 class="sectiontitle">例</h4><pre><strong><span>-- FROM節の表式として、副問合せを使う。</span>
+SELECT VirtualFlightTable.flight_ID
+FROM
+    (SELECT flight_ID, orig_airport, dest_airport
+    FROM Flights
+    WHERE (orig_airport = 'SFO' OR dest_airport = 'SCL') )
+AS VirtualFlightTable
+<span>-- FROM節の表式として、副問合せ(values式)を使う。</span>
+SELECT mycol1
+FROM
+    (VALUES (1, 2), (3, 4))
+AS mytable (mycol1, mycol2)
+<span>-- EXISTSにて副問合せを使う</span>
+SELECT *
+FROM Flights
+WHERE EXISTS
+    (SELECT * FROM Flights WHERE dest_airport = 'SFO'
+    AND orig_airport = 'GRU')
+<span>-- INにて副問合せを使う</span>
+SELECT flight_id, segment_number
+FROM Flights
+WHERE flight_id IN
+    (SELECT flight_ID
+    FROM Flights WHERE orig_airport = 'SFO'
+    OR dest_airport = 'SCL')
+<span>-- 定量比較にて副問合せを使う</span>
+SELECT NAME, COMM 
+FROM STAFF 
+WHERE COMM &gt; 
+(SELECT AVG(BONUS + 800)
+     FROM EMPLOYEE
+     WHERE COMM &lt; 5000)</strong></pre>
+
+</div>
+</div>
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefqueries.html" title="">SQL 問い合わせ</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimefunc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimefunc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimefunc.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,84 @@
+<!--
+  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="TIME 関数" />
+<meta name="abstract" content="TIME関数は値の時刻の部分を返します。" />
+<meta name="description" content="TIME関数は値の時刻の部分を返します。" />
+<meta content="TIME function" name="DC.subject" />
+<meta content="TIME function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftimefunc" 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>TIME 関数</title>
+</head>
+<body id="rreftimefunc"><a name="rreftimefunc"><!-- --></a>
+
+
+<h1 class="topictitle1">TIME 関数</h1>
+
+
+
+<div><p>TIME関数は値の時刻の部分を返します。</p>
+
+<div class="section"> <p>引数は時刻、タイムスタンプ、CLOB・LONG VARCHAR・XML以外の時刻やタイムスタンプを表す有効な文字列である必要があります。
+この関数の結果は時刻です。引数にnullをとることがある場合、返り値もnullをとることがあります。
+引数がnullなら、返り値はnullです。
+</p>
+ 
+<div class="p">
+引数のデータ型に応じて、以下の規則があります。
+<ul>
+<li>引数が時刻なら、返り値はその時刻です。</li>
+
+<li>引数がタイムスタンプなら、返り値はタイムスタンプの時刻の部分です。</li>
+
+<li>もし引数が文字列なら、返り値は文字列が表す時刻です。</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>TIME ( <em>式</em> )</strong></pre>
+ </div>
+
+<div class="example"> <pre><strong>values time(current_timestamp)</strong></pre>
+ 
+<p>もし現在時刻が午後5:03なら、返り値は<samp class="codeph">17:03:00</samp>です。</p>
+ </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/rreftimefunc.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimestampfunc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimestampfunc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimestampfunc.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,90 @@
+<!--
+  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="TIMESTAMP関数" />
+<meta name="abstract" content="TIMESTAMP関数はタイムスタンプを、値あるいは値の対から返します。" />
+<meta name="description" content="TIMESTAMP関数はタイムスタンプを、値あるいは値の対から返します。" />
+<meta content="functions, TIMESTAMP, TIMESTAMP function" name="DC.subject" />
+<meta content="functions, TIMESTAMP, TIMESTAMP function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftimestampfunc" 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>TIMESTAMP関数</title>
+</head>
+<body id="rreftimestampfunc"><a name="rreftimestampfunc"><!-- --></a>
+
+
+<h1 class="topictitle1">TIMESTAMP関数</h1>
+
+
+
+<div><p>TIMESTAMP関数はタイムスタンプを、値あるいは値の対から返します。</p>
+
+<div class="section"> <div class="p">引数にとることができる値は、二つ目の引数があるかどうかで決まります。<ul>
+<li>もし引数が一つである場合は、引数は、タイムスタンプか、CLOB・LONG VARCHAR・XML以外のタイムスタンプを有効に表す14文字の文字列である必要があります。14文字の文字列は、有効な日付および時刻を10進数で<em>yyyyxxddhhmmss</em>という書式で表す必要があります。ここで、<em>yyyy</em>は年、<em>xx</em>は月、<em>dd</em>は日、<em>hh</em>は時、<em>mm</em>は分、<em>ss</em>は秒です。</li>
+
+<li>もし両方の引数が指定された場合は、最初の引数は日付あるいは日付を有効に表す文字列で、二つ目の引数は時刻あるいは時刻を有効に表す文字列です。</li>
+
+</ul>
+二つ目の引数があるか否かで次の規則が決まります。<ul>
+<li>もし両方の引数が指定された場合、結果は最初の引数で指定された日付と、二つ目の引数で指定された時刻のタイムスタンプです。なお、タイムスタンプのマイクロ秒の部分は0となります。</li>
+
+<li>もし引数が一つで、それがタイムスタンプであった場合、結果はそのタイムスタンプです。</li>
+
+<li>もし引数が一つで、それが文字列であった場合、結果はその文字列で与えられたタイムスタンプです。14文字の文字列により指定されないマイクロ秒の部分は0となります。</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">Syntax</h4><pre>TIMESTAMP ( <em>式</em> [, <em>式</em> ] )</pre>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">例</h4><div class="p"><samp class="codeph">records_table</samp>という表の二つ目の列には(1998-12-25のような)日付が格納されて、三つ目の列には(17:12:30のような)時刻が格納されます。
+例示する文でタイムスタンプを返すことができます。<pre>SELECT TIMESTAMP(col2, col3) FROM records_table</pre>
+</div>
+
+<div class="p">次の節は<samp class="codeph">1998-12-25-17:12:30.0</samp>を返します。<pre>VALUES TIMESTAMP('1998-12-25', '17.12.30'); 
+1 
+-------------------------- 
+1998-12-25 17:12:30.0 
+</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/rreftimestampfunc.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrademderby.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrademderby.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrademderby.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,65 @@
+<!--
+  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="topic" name="DC.Type" />
+<meta name="DC.Title" content="Trademarks" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftrademderby" 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>Trademarks</title>
+</head>
+<body id="rreftrademderby"><a name="rreftrademderby"><!-- --></a>
+
+
+<h1 class="topictitle1">Trademarks</h1>
+
+<div>
+<p>The following terms are trademarks or registered trademarks of other companies
+and have been used in at least one of the documents in the <span>Apache Derby</span> documentation
+library:</p>
+
+<p>Cloudscape, DB2, DB2 Universal Database, DRDA, and IBM are trademarks of
+International Business Machines Corporation in the United States, other countries,
+or both.</p>
+
+<p>Microsoft, Windows, Windows NT, and the Windows logo are trademarks of
+Microsoft Corporation in the United States, other countries, or both. </p>
+
+<p>Java and all Java-based trademarks are trademarks of Sun Microsystems,
+Inc. in the United States, other countries, or both.</p>
+
+<p>UNIX is a registered trademark of The Open Group in the United States and
+other countries.</p>
+
+<p>Other company, product, or service names may be trademarks or service marks
+of others.</p>
+
+</div>
+
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftriggername.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftriggername.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftriggername.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,60 @@
+<!--
+  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="TriggerName" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj18919.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftriggername" 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>TriggerName</title>
+</head>
+<body id="rreftriggername"><a name="rreftriggername"><!-- --></a>
+
+
+<h1 class="topictitle1">TriggerName</h1>
+
+<div>
+<div class="section"><p><em>トリガ名</em>によりユーザが作成したトリガを参照することができます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>[ <em><a href="rrefschemaname.html#rrefschemaname">スキーマ名</a></em> . ] <em><a href="crefsqlj34834.html#crefsqlj34834">SQL92識別子</a></em></strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">例</h4> <pre><strong>DROP TRIGGER TRIG1</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</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/rreftriggername.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrimfunc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrimfunc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrimfunc.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,138 @@
+<!--
+  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="TRIM 関数" />
+<meta content="functions, TRIM, TRIM function" name="DC.subject" />
+<meta content="functions, TRIM, TRIM function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftrimfunc" 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>TRIM 関数</title>
+</head>
+<body id="rreftrimfunc"><a name="rreftrimfunc"><!-- --></a>
+
+
+<h1 class="topictitle1">TRIM 関数</h1>
+
+
+<div>
+<div class="section">TRIMは文字式を引数にとる関数で、引数から前あるいは/および後の詰められた文字を取り除いた値を返します。省略可能な引数に文字を指定できて、この文字は取り除かれる、前あるいは後、あるいはその両方にある詰められた文字です。</div>
+
+<div class="section"><h4 class="sectiontitle">構文x</h4> <pre>TRIM( [ <em>trimOperands</em> ] <em>trimSource</em>)</pre>
+ 
+<div class="p">
+<pre>
+<em>trimOperands</em>  ::= { <em>trimType</em> [ <em>trimCharacter ] </em> FROM | <em>trimCharacter</em> FROM }
+<em>trimType</em>      ::= { LEADING | TRAILING | BOTH }
+<em>trimCharacter</em> ::= <em>文字式</em>
+<em>trimSource</em>    ::= <em>文字式</em>
+</pre>
+
+</div>
+<div class="p">
+<em>trimType</em>が指定されなかった場合、既定でBOTHとみなされます。<em>trimCharacter</em>が指定されなかった場合、既定で空白文字(' ')とみなされます。<em>trimCharacter</em>の値は以下のいずれかに評価されなければなりません。
+	<ul>
+	    <li>長さ一文字の文字列あるいは</li>
+
+	    <li>NULL</li>
+
+	</ul>
+
+</div>
+<div class="p">
+<em>trimCharacter</em>と<em>trimSource</em>がNULLと評価される場合、TRIM関数の結果はNULlです。さもなければTRIM関数の結果は以下のいずれかになります。
+	<ul>
+	<li>trimTypeがLEADINGなら、結果はtrimSourceの値の前からtrimCharを取り除いた値です。</li>
+
+	<li>trimTypeがTRAILINGなら、結果はtrimSourceの値の後ろからtrimCharを取り除いた値です。</li>
+
+	<li>trimTypeがBOTHなら、結果はtrimSourceの値の前*と*後からtrimCharを取り除いた値です。</li>
+
+	</ul>
+
+</div>
+<p><em>trimSource</em>のデータ型がCHARあるいはVARCHARなら、TRIM関数の返り値の型はVARCHARです。それ以外の場合、TRIM関数の返り値の型はCLOBです。
+</p>
+
+</div>
+
+<div class="example"><h4 class="sectiontitle">例</h4>
+<div class="p">
+<pre><strong><span>-- 'derby'を返します。(空白はありません。)</span>
+VALUES TRIM('  derby ')</strong></pre>
+ 
+</div>
+<div class="p">
+<pre><strong><span>-- 'derby'を返します。 (空白はありません。)</span>
+VALUES TRIM(BOTH ' ' FROM '  derby ')</strong></pre>
+ 
+</div>
+<div class="p">
+<pre><strong><span>-- 'derby 'を返します。 (末尾に空白があります。)</span>
+VALUES TRIM(LEADING ' ' FROM '  derby ')</strong></pre>
+ 
+</div>
+<div class="p">
+<pre><strong><span>-- '  derby'を返します。 (先頭に二つ空白があります。)</span>
+VALUES TRIM(TRAILING ' ' FROM '  derby ')</strong></pre>
+ 
+</div>
+<div class="p">
+<pre><strong><span>-- NULLを返します。</span>
+VALUES TRIM(cast (null as char(1)) FROM '  derby ')</strong></pre>
+ 
+</div>
+<div class="p">
+<pre><strong><span>-- NULLを返します。</span>
+VALUES TRIM(' ' FROM cast(null as varchar(30)))</strong></pre>
+ 
+</div>
+<div class="p">
+<pre><strong><span>-- ' derb'を返します。(先頭に空白がありあmす。)</span>
+VALUES TRIM('y' FROM ' derby')</strong></pre>
+ 
+</div>
+<div class="p">
+<pre><strong><span>-- <em>trimCharacter</em>には一文字しか指定できないのでエラーとなります。</span>
+VALUES TRIM('by' FROM ' derby')</strong></pre>
+ 
+</div>
+
+</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/rreftrimfunc.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefunfreezedbproc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefunfreezedbproc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefunfreezedbproc.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="SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE システム手続き" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlbuiltinsystemprocedures.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefunfreezedbproc" 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_UNFREEZE_DATABASE システム手続き</title>
+</head>
+<body id="rrefunfreezedbproc"><a name="rrefunfreezedbproc"><!-- --></a>
+
+
+<h1 class="topictitle1">SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE システム手続き</h1>
+
+<div>
+<div class="section"><p>バックアップ後に、<samp class="codeph">SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE</samp>システム手続きによりデータベースを解凍します。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre>SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE()</pre>
+ <p>この手続きは結果を返しません。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">例</h4> <pre>String backupdirectory = "c:/mybackups/" + JCalendar.getToday();
+CallableStatement cs = conn.prepareCall
+("CALL SYSCS_UTIL.SYSCS_FREEZE_DATABASE()");
+cs.execute();
+cs.close();
+// "backupdirectory"全体のバックアップを取るユーザのコード
+// バックアップが終わったら、データベースを解凍します。
+now unfreeze the database once backup has completed:
+CallableStatement cs = conn.prepareCall
+("CALL SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE()");
+cs.execute();
+cs.close();
+</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/rrefunfreezedbproc.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefviewname.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefviewname.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefviewname.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,61 @@
+<!--
+  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="crefsqlj18919.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefviewname" 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="rrefviewname"><a name="rrefviewname"><!-- --></a>
+
+
+<h1 class="topictitle1">ビュー名</h1>
+
+<div>
+<div class="section"><p><em>ビュー名</em>は表またはビューをあらわします。<em>ビュー名</em>は<em>スキーマ名</em>で限定することができます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>[ <em><a href="rrefschemaname.html#rrefschemaname">スキーマ名</a>.</em> ] <em><a href="crefsqlj34834.html#crefsqlj34834">SQL92識別子</a></em></strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">Example</h4> <pre><strong><span>-- これはスキーマ名のあるビュー名です。</span>
+SELECT COUNT(*) FROM SAMP.EMP_RESUME</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</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/rrefviewname.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefyearfunc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefyearfunc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefyearfunc.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="YEAR関数" />
+<meta content="YEAR function" name="DC.subject" />
+<meta content="YEAR function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefyearfunc" 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>YEAR関数</title>
+</head>
+<body id="rrefyearfunc"><a name="rrefyearfunc"><!-- --></a>
+
+
+<h1 class="topictitle1">YEAR関数</h1>
+
+
+<div>
+<div class="section"> 
+<p>YEAR関数は値の年の部分を返します。引数は、日付、タイムスタンプ、および日付やタイムスタンプを表す有効な文字列でなければなりません。
+関数の返り値は1から9999までの間の整数です。
+引数がnullをとる事がある場合、返り値はnullとなることがあります。
+もし引数がnullなら、返り値はnullです。</p>
+ 
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>YEAR ( <em>式</em> )</strong></pre>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">Example</h4> 
+<p>PROJECT表にあるプロジェクトから、開始日(PRSTDATE)と完了日(PRENDATE)が暦の上で同年であるものを選択します。</p>
+
+ <pre><strong>SELECT * FROM PROJECT
+WHERE YEAR(PRSTDATE) = YEAR(PRENDATE)</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/rrefyearfunc.html
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message