You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by tm...@apache.org on 2008/01/05 09:25:38 UTC

svn commit: r609101 [26/26] - in /db/derby/docs/trunk: ./ src/ja_JP/ src/ja_JP/ref/

Added: db/derby/docs/trunk/src/ja_JP/ref/rreftimestampfunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rreftimestampfunc.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rreftimestampfunc.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rreftimestampfunc.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,46 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreftimestampfunc" xml:lang="ja">
+<title>TIMESTAMP関数</title>
+<shortdesc>TIMESTAMP関数はタイムスタンプを、値あるいは値の対から返します。</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>functions<indexterm>TIMESTAMP</indexterm></indexterm>
+<indexterm>TIMESTAMP function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>引数にとることができる値は、二つ目の引数があるかどうかで決まります。<ul>
+<li>もし引数が一つである場合は、引数は、タイムスタンプか、CLOB・LONG VARCHAR・XML以外のタイムスタンプを有効に表す14文字の文字列である必要があります。14文字の文字列は、有効な日付および時刻を10進数で<i>yyyyxxddhhmmss</i>という書式で表す必要があります。ここで、<i>yyyy</i>は年、<i>xx</i>は月、<i>dd</i>は日、<i>hh</i>は時、<i>mm</i>は分、<i>ss</i>は秒です。</li>
+<li>もし両方の引数が指定された場合は、最初の引数は日付あるいは日付を有効に表す文字列で、二つ目の引数は時刻あるいは時刻を有効に表す文字列です。</li>
+</ul>二つ目の引数があるか否かで次の規則が決まります。<ul>
+<li>もし両方の引数が指定された場合、結果は最初の引数で指定された日付と、二つ目の引数で指定された時刻のタイムスタンプです。なお、タイムスタンプのマイクロ秒の部分は0となります。</li>
+<li>もし引数が一つで、それがタイムスタンプであった場合、結果はそのタイムスタンプです。</li>
+<li>もし引数が一つで、それが文字列であった場合、結果はその文字列で与えられたタイムスタンプです。14文字の文字列により指定されないマイクロ秒の部分は0となります。</li>
+</ul></p></section>
+<refsyn><title>Syntax</title><codeblock>TIMESTAMP ( <i>式</i> [, <i>式</i> ] )</codeblock> </refsyn>
+<example><title>例</title><p><codeph>records_table</codeph>という表の二つ目の列には(1998-12-25のような)日付が格納されて、三つ目の列には(17:12:30のような)時刻が格納されます。
+例示する文でタイムスタンプを返すことができます。<codeblock>SELECT TIMESTAMP(col2, col3) FROM records_table</codeblock></p>
+<p>次の節は<codeph>1998-12-25-17:12:30.0</codeph>を返します。<codeblock>VALUES TIMESTAMP('1998-12-25', '17.12.30'); 
+1 
+-------------------------- 
+1998-12-25 17:12:30.0 
+</codeblock></p> </example>
+</refbody>
+</reference>

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

Added: db/derby/docs/trunk/src/ja_JP/ref/rreftrademderby.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rreftrademderby.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rreftrademderby.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rreftrademderby.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,38 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE topic PUBLIC "-//OASIS//DTD DITA Topic//EN"
+ "../dtd/topic.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<topic id="rreftrademderby" xml:lang="en-us">
+<title>Trademarks</title>
+<body>
+<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 <ph conref="../conrefs.dita#prod/productlongname"></ph> 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>
+</body>
+</topic>

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

Added: db/derby/docs/trunk/src/ja_JP/ref/rreftriggername.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rreftriggername.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rreftriggername.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rreftriggername.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rreftriggername" xml:lang="ja">
+<title>TriggerName</title>
+<refbody>
+<section><p><i>トリガ名</i>によりユーザが作成したトリガを参照することができます。</p></section>
+<section><title>構文</title> <codeblock><b>[ <i><xref href="rrefschemaname.dita#rrefschemaname">スキーマ名</xref></i> . ] <i><xref
+href="crefsqlj34834.dita#crefsqlj34834">SQL92識別子</xref></i></b></codeblock></section>
+<section><title>例</title> <codeblock><b>DROP TRIGGER TRIG1</b></codeblock></section>
+</refbody>
+</reference>
+

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

Added: db/derby/docs/trunk/src/ja_JP/ref/rreftrimfunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rreftrimfunc.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rreftrimfunc.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rreftrimfunc.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,81 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreftrimfunc" xml:lang="en-us">
+<title>TRIM 関数</title>
+<prolog><metadata>
+<keywords><indexterm>functions<indexterm>TRIM</indexterm></indexterm>
+<indexterm>TRIM function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section>TRIMは文字式を引数にとる関数で、引数から前あるいは/および後の詰められた文字を取り除いた値を返します。省略可能な引数に文字を指定できて、この文字は取り除かれる、前あるいは後、あるいはその両方にある詰められた文字です。</section>
+<refsyn><title>構文x</title> <codeblock>TRIM( [ <i>trimOperands</i> ] <i>trimSource</i>)</codeblock> 
+<p>
+<codeblock>
+<i>trimOperands</i>  ::= { <i>trimType</i> [ <i>trimCharacter ] </i> FROM | <i>trimCharacter</i> FROM }
+<i>trimType</i>      ::= { LEADING | TRAILING | BOTH }
+<i>trimCharacter</i> ::= <i>文字式</i>
+<i>trimSource</i>    ::= <i>文字式</i>
+</codeblock>
+</p><p>
+<i>trimType</i>が指定されなかった場合、既定でBOTHとみなされます。<i>trimCharacter</i>が指定されなかった場合、既定で空白文字(' ')とみなされます。<i>trimCharacter</i>の値は以下のいずれかに評価されなければなりません。
+	<ul>
+	    <li>長さ一文字の文字列あるいは</li>
+	    <li>NULL</li>
+	</ul>
+</p><p>
+<i>trimCharacter</i>と<i>trimSource</i>がNULLと評価される場合、TRIM関数の結果はNULlです。さもなければTRIM関数の結果は以下のいずれかになります。
+	<ul>
+	<li>trimTypeがLEADINGなら、結果はtrimSourceの値の前からtrimCharを取り除いた値です。</li>
+	<li>trimTypeがTRAILINGなら、結果はtrimSourceの値の後ろからtrimCharを取り除いた値です。</li>
+	<li>trimTypeがBOTHなら、結果はtrimSourceの値の前*と*後からtrimCharを取り除いた値です。</li>
+	</ul>
+</p><p><i>trimSource</i>のデータ型がCHARあるいはVARCHARなら、TRIM関数の返り値の型はVARCHARです。それ以外の場合、TRIM関数の返り値の型はCLOBです。
+</p>
+</refsyn>
+<example><title>例</title>
+<p>
+<codeblock><b><ph>-- 'derby'を返します。(空白はありません。)</ph>
+VALUES TRIM('  derby ')</b></codeblock> 
+</p><p>
+<codeblock><b><ph>-- 'derby'を返します。 (空白はありません。)</ph>
+VALUES TRIM(BOTH ' ' FROM '  derby ')</b></codeblock> 
+</p><p>
+<codeblock><b><ph>-- 'derby 'を返します。 (末尾に空白があります。)</ph>
+VALUES TRIM(LEADING ' ' FROM '  derby ')</b></codeblock> 
+</p><p>
+<codeblock><b><ph>-- '  derby'を返します。 (先頭に二つ空白があります。)</ph>
+VALUES TRIM(TRAILING ' ' FROM '  derby ')</b></codeblock> 
+</p><p>
+<codeblock><b><ph>-- NULLを返します。</ph>
+VALUES TRIM(cast (null as char(1)) FROM '  derby ')</b></codeblock> 
+</p><p>
+<codeblock><b><ph>-- NULLを返します。</ph>
+VALUES TRIM(' ' FROM cast(null as varchar(30)))</b></codeblock> 
+</p><p>
+<codeblock><b><ph>-- ' derb'を返します。(先頭に空白がありあmす。)</ph>
+VALUES TRIM('y' FROM ' derby')</b></codeblock> 
+</p><p>
+<codeblock><b><ph>-- <i>trimCharacter</i>には一文字しか指定できないのでエラーとなります。</ph>
+VALUES TRIM('by' FROM ' derby')</b></codeblock> 
+</p>
+</example>
+</refbody>
+</reference>
\ No newline at end of file

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

Added: db/derby/docs/trunk/src/ja_JP/ref/rrefunfreezedbproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefunfreezedbproc.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefunfreezedbproc.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefunfreezedbproc.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,41 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefunfreezedbproc" xml:lang="ja">
+<title>SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE システム手続き</title>
+<refbody>
+<section><p>バックアップ後に、<codeph>SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE</codeph>システム手続きによりデータベースを解凍します。</p></section>
+<section><title>構文</title> <codeblock>SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE()</codeblock> <p>この手続きは結果を返しません。</p></section>
+<section><title>例</title> <codeblock>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();
+</codeblock></section>
+</refbody>
+</reference>
+

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

Added: db/derby/docs/trunk/src/ja_JP/ref/rrefviewname.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefviewname.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefviewname.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefviewname.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,31 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefviewname" xml:lang="ja">
+<title>ビュー名</title>
+<refbody>
+<section><p><i>ビュー名</i>は表またはビューをあらわします。<i>ビュー名</i>は<i>スキーマ名</i>で限定することができます。</p></section>
+<section><title>構文</title> <codeblock><b>[ <i><xref href="rrefschemaname.dita#rrefschemaname">スキーマ名</xref>.</i> ] <i><xref
+href="crefsqlj34834.dita#crefsqlj34834">SQL92識別子</xref></i></b></codeblock></section>
+<section><title>Example</title> <codeblock><b><ph>-- これはスキーマ名のあるビュー名です。</ph>
+SELECT COUNT(*) FROM SAMP.EMP_RESUME</b></codeblock></section>
+</refbody>
+</reference>
+

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

Added: db/derby/docs/trunk/src/ja_JP/ref/rrefyearfunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefyearfunc.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefyearfunc.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefyearfunc.dita Sat Jan  5 00:25:17 2008
@@ -0,0 +1,40 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefyearfunc" xml:lang="ja">
+<title>YEAR関数</title>
+<prolog><metadata>
+<keywords><indexterm>YEAR function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> 
+<p>YEAR関数は値の年の部分を返します。引数は、日付、タイムスタンプ、および日付やタイムスタンプを表す有効な文字列でなければなりません。
+関数の返り値は1から9999までの間の整数です。
+引数がnullをとる事がある場合、返り値はnullとなることがあります。
+もし引数がnullなら、返り値はnullです。</p> 
+</section>
+<refsyn><title>構文</title> <codeblock><b>YEAR ( <i>式</i> )</b></codeblock> </refsyn>
+<example> <title>Example</title>
+<p>PROJECT表にあるプロジェクトから、開始日(PRSTDATE)と完了日(PRENDATE)が暦の上で同年であるものを選択します。</p>
+ <codeblock><b>SELECT * FROM PROJECT
+WHERE YEAR(PRSTDATE) = YEAR(PRENDATE)</b></codeblock> </example>
+</refbody>
+</reference>
+

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