db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r854277 [41/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/rrefsqljcreatesynonym.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljcreatesynonym.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljcreatesynonym.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,91 @@
+<!--
+  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 SYNONYM 文" />
+<meta content="CREATE SYNONYM statement, Synonyms, creating" name="DC.subject" />
+<meta content="CREATE SYNONYM statement, Synonyms, 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="rrefsqlj24513.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj43125.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj15446.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqljcreatesynonym" 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 SYNONYM 文</title>
+</head>
+<body id="rrefsqljcreatesynonym"><a name="rrefsqljcreatesynonym"><!-- --></a>
+
+
+<h1 class="topictitle1">CREATE SYNONYM 文</h1>
+
+
+<div>
+<div class="section"><p>CREATE SYNONYM文によって同じスキーマあるいは異なるスキーマに存在する表やビューに別名を与える事ができます。
+さらに別名に別名を与えて、入れ子の別名を作成することもできます。
+別名は元の限定された表やビューの名前に代わり、SELECT、INSERT、UPDATE、DELETEやLOCK TABLE文にて利用できます。存在しない表やビューへの別名を作成することも可能ですが、別名を利用する前までに対象の表やビューは存在していなければなりません。</p>
+<p>別名は表やビューと同じ名前空間を共有します。同じスキーマに既にある表と同じ名前で別名を作ることはできません。同様に既に存在する別名と同じ名前の表やビューを作成することはできません。</p>
+
+<p>別名は作成時にまだ存在していない表やビューにも作成することができます。もし表やビューが存在していなければ、そのことを警告されます。(SQLSTATE  01522)
+DML文で別名を使うときには参照する情報は存在していなければなりません。</p>
+
+<p>入れ子になった別名(他の別名への別名)を作成することはできますが、参照関係が循環するような別名を作成しようとするとエラーとなります。(SQLSTATE 42916)</p>
+
+<p>別名はシステムスキーマに定義できません。'SYS'で名前が始まるあらゆるスキーマはシステムスキーマとみなされ、<span>Derby</span>において予約されています。</p>
+
+<p>一時表への別名は作成できません。一時表に別名を定義しようとするとエラーとなります。(SQLSTATE XCL51)</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4><pre><strong>CREATE SYNONYM <a href="rrefsynonymname.html#rrefsynonymname">別の名</a> FOR { <a href="rrefviewname.html#rrefviewname">ビュー名</a> | <a href="rreftablename.html#rreftablename">表名</a> }</strong></pre>
+
+文中の<a href="rrefsynonymname.html#rrefsynonymname">別の名</a>は、対象の表やビューに与える別名です。一方で、<a href="rrefviewname.html#rrefviewname">ビュー名</a>や<a href="rreftablename.html#rreftablename">表名</a>は、対象の表やビューの元の名前です。</div>
+
+<div class="example"><h4 class="sectiontitle">例</h4>CREATE SYNONYM SAMP.T1 FOR SAMP.TABLEWITHLONGNAME</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="rrefsqlj24513.html" title="">CREATE TABLE 文</a></div>
+<div><a href="rrefsqlj43125.html" title="">CREATE TRIGGER 文</a></div>
+<div><a href="rrefsqlj15446.html" title="">CREATE VIEW 文</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljcurrentdate.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljcurrentdate.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljcurrentdate.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,57 @@
+<!--
+  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="CURRENT DATE 関数" />
+<meta content="CURRENT DATE function" name="DC.subject" />
+<meta content="CURRENT DATE function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqljcurrentdate" 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>CURRENT DATE 関数</title>
+</head>
+<body id="rrefsqljcurrentdate"><a name="rrefsqljcurrentdate"><!-- --></a>
+
+
+<h1 class="topictitle1">CURRENT DATE 関数</h1>
+
+
+<div>
+<div class="section"> <p>CURRENT DATE は<a href="rrefsqlj34177.html#rrefsqlj34177">CURRENT_DATE</a>の別名です。</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/rrefsqljcurrentdate.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljcurrentschema.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljcurrentschema.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljcurrentschema.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,76 @@
+<!--
+  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="CURRENT SCHEMA関数" />
+<meta content="CURRENT SCHEMA function" name="DC.subject" />
+<meta content="CURRENT SCHEMA function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqljcurrentschema" 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>CURRENT SCHEMA関数</title>
+</head>
+<body id="rrefsqljcurrentschema"><a name="rrefsqljcurrentschema"><!-- --></a>
+
+
+<h1 class="topictitle1">CURRENT SCHEMA関数</h1>
+
+
+<div>
+<div class="section"> <p>CURRENT SCHEMAはデータベースの情報への参照名を限定できるスキーマ名を返します。</p>
+ 
+<div class="note"><span class="notetitle">注: </span>CURRENT SCHEMAとCURRENT SQLIDは別名です。</div>
+ 
+<p>これらの関数は最大128文字の文字列を返します。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>CURRENT SCHEMA
+
+<strong>-- または、</strong>
+
+CURRENT SQLID</strong></pre>
+ </div>
+
+<div class="example"> <pre><strong><span>-- nameという列の既定値を現在のスキーマ名にする。</span>
+CREATE TABLE mytable (id int, name VARCHAR(128) DEFAULT CURRENT SQLID)
+<span>-- 表に現在のスキーマ名となっている既定値を挿入する。</span>
+INSERT INTO mytable(id) VALUES (1)
+<span>-- 現在のスキーマと同じ名前の表を返す。</span>
+SELECT name FROM mytable WHERE name = CURRENT SCHEMA</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/rrefsqljcurrentschema.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljcurrenttimestamp.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljcurrenttimestamp.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljcurrenttimestamp.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,57 @@
+<!--
+  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="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="rrefsqljcurrenttimestamp" 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>CURRENT TIMESTAMP関数</title>
+</head>
+<body id="rrefsqljcurrenttimestamp"><a name="rrefsqljcurrenttimestamp"><!-- --></a>
+
+
+<h1 class="topictitle1">CURRENT TIMESTAMP関数</h1>
+
+
+<div>
+<div class="section"> <p>CURRENT TIMESTAMP は<a href="rrefsqlj15866.html#rrefsqlj15866">CURRENT_TIMESTAMP</a>の別名です。</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/rrefsqljcurrenttimestamp.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljdoubleprecision.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljdoubleprecision.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljdoubleprecision.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,105 @@
+<!--
+  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="DOUBLE PRECISION データ型" />
+<meta content="DOUBLE PRECISION data type" name="DC.subject" />
+<meta content="DOUBLE PRECISION data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqljdoubleprecision" 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>DOUBLE PRECISION データ型</title>
+</head>
+<body id="rrefsqljdoubleprecision"><a name="rrefsqljdoubleprecision"><!-- --></a>
+
+
+<h1 class="topictitle1">DOUBLE PRECISION データ型</h1>
+
+
+<div>
+<div class="section"> <p>DOUBLE PRECISIONはIEEE浮動小数点表記に基づいて数を、8バイトの領域に記録します。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> 
+<pre><strong>DOUBLE PRECISION</strong></pre>
+ <p>または、</p>
+ <pre><strong>DOUBLE</strong></pre>
+ 
+<p>DOUBLEはDOUBLE PRECISIONと同じ意味で用いることができます。</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">制限</h4> 
+<p>DOUBLEの値は以下の範囲です。</p>
+ <ul>
+<li>DOUBLEの最小値: -1.79769E+308</li>
+
+<li>DOUBLEの最大値: 1.79769E+308</li>
+
+<li>DOUBLEの最小の正の値: 2.225E-307</li>
+
+<li>DOUBLEの最大の負の値: -2.225E-307</li>
+
+</ul>
+ <p>これらの制限は、Javaの型である<samp class="codeph">java.lang.Double</samp>の制限とは異なります。</p>
+ 
+<p>これらの範囲外の値が計算されたり代入されると例外が挙がります。
+数の演算処理では、結果の値は零に丸め処理<strong>されません</strong>。
+もし値が小さすぎた場合は例外となります。</p>
+ 
+<div class="p">浮動小数点数の定数は30文字までに制限されます。
+<pre>-- この例では定数値が長すぎるため、失敗します。
+<strong>values 01234567890123456789012345678901e0;</strong></pre>
+</div>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">対応するコンパイル時のJavaの型</h4> <p><em>java.lang.Double</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBC のメタデータ型 (java.sql.Types)</h4> <p>DOUBLE</p>
+ 
+<p>式にて他のデータ型が混在する場合、式の結果の型は<a href="rrefsqlj27767.html#rrefsqlj27767">式にて行われる数値型の項目</a>で記述された規則に従い決まります。</p>
+ 
+<p><a href="rrefsqlj20204.html#rrefsqlj20204">数値を異なる数値型の列に記録する</a>も参照してください。</p>
+ </div>
+
+<div class="example" id="rrefsqljdoubleprecision__sqlj35021"><a name="rrefsqljdoubleprecision__sqlj35021"><!-- --></a><h4 class="sectiontitle">例</h4> <pre><strong>3421E+09
+425.43E9
+9E-10
+4356267544.32333E+30</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/rrefsqljdoubleprecision.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljdropsynonym.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljdropsynonym.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljdropsynonym.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,76 @@
+<!--
+  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="DROP SYNONYM 文" />
+<meta content="DROP SYNONYM statement, Synonyms, dropping" name="DC.subject" />
+<meta content="DROP SYNONYM statement, Synonyms, dropping" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj80721.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdropfunctionstatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj59893.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdropprocedurestatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj31648.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj34148.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42082.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj61102.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqljdropsynonym" 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>DROP SYNONYM 文</title>
+</head>
+<body id="rrefsqljdropsynonym"><a name="rrefsqljdropsynonym"><!-- --></a>
+
+
+<h1 class="topictitle1">DROP SYNONYM 文</h1>
+
+
+<div>
+<div class="section"> <p>表やビューの別名を破棄します。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>DROP SYNONYM <a href="rrefsynonymname.html#rrefsynonymname">別名名</a></strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="crefsqlj80721.html" title="">DROP文</a></div>
+</div>
+<div class="relref"><strong>関連資料</strong><br />
+<div><a href="rrefdropfunctionstatement.html" title="">DROP FUNCTION 文</a></div>
+<div><a href="rrefsqlj59893.html" title="">DROP INDEX 文</a></div>
+<div><a href="rrefdropprocedurestatement.html" title="">DROP PROCEDURE 文</a></div>
+<div><a href="rrefsqlj31648.html" title="">DROP SCHEMA 文</a></div>
+<div><a href="rrefsqlj34148.html" title="">DROP TABLE 文</a></div>
+<div><a href="rrefsqlj42082.html" title="">DROP TRIGGER 文</a></div>
+<div><a href="rrefsqlj61102.html" title="">DROP VIEW 文</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljgrant.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljgrant.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljgrant.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,155 @@
+<!--
+  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="GRANT 文" />
+<meta name="abstract" content="GRANT 文を使って、データベースにある情報の操作権限を、指定した一人あるいは全ユーザに与えることができます。" />
+<meta name="description" content="GRANT 文を使って、データベースにある情報の操作権限を、指定した一人あるいは全ユーザに与えることができます。" />
+<meta content="GRANT statement, SQL statements, GRANT" name="DC.subject" />
+<meta content="GRANT statement, SQL statements, GRANT" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljrevoke.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljrevoke.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsistabssystableperms.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsistabssyscolperms.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqljgrant" 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>GRANT 文 </title>
+</head>
+<body id="rrefsqljgrant"><a name="rrefsqljgrant"><!-- --></a>
+
+
+<h1 class="topictitle1">GRANT 文 </h1>
+
+
+
+<div><p>GRANT 文を使って、データベースにある情報の操作権限を、指定した一人あるいは全ユーザに与えることができます。</p>
+
+<div class="section"> <div class="p">次の権限を与えることができます。<ul>
+<li>表からの情報の削除</li>
+
+<li>表への情報の挿入</li>
+
+<li>表あるいは表にある列の部分集合への外部キー制約の作成</li>
+
+<li>表やビュー、表にある列の部分集合からの情報の選択</li>
+
+<li>表へのトリガーの作成</li>
+
+<li>表あるいは表にある列の部分集合の情報の更新</li>
+
+<li>関数あるいは手続きの実行</li>
+
+</ul>
+</div>
+<p>GRANT文を発行する前に、<samp class="codeph">derby.database.sqlAuthorization</samp>属性が<samp class="codeph">true</samp>であることを確認してください。<samp class="codeph">derby.database.sqlAuthorization</samp>属性により、SQL認証が有効になります。</p>
+
+
+
+<p>ユーザに権限付与が認められている情報であれば、その情報への権限をユーザは与えることができます。
+詳細については、権限を与えようとしている情報に対応したCREATE文の説明文を読んでください。</p>
+
+<p>GRANT文の書き方は、表に対する権限付与なのか、それともプログラムルーチンに対する権限付与なのかにより、その構文が異なります。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">表の場合の構文</h4><pre><strong>GRANT <em><a href="rrefsqljgrant.html#rrefsqljgrant__grantprivtype">権限タイプ</a></em> ON [TABLE] { <em><a href="rreftablename.html#rreftablename">表名</a></em> | <em><a href="rrefviewname.html#rrefviewname">ビュー名</a></em> } TO <em><a href="rrefsqljgrant.html#rrefsqljgrant__grantgrantees">権限を与えられる人</a></em></strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">プログラムルーチンの場合の構文</h4><pre><strong>GRANT EXECUTE ON { FUNCTION | PROCEDURE } <em><a href="rrefsqljgrant.html#rrefsqljgrant__grantroutinename">プログラムルーチンの指示子</a></em> TO <em><a href="rrefsqljgrant.html#rrefsqljgrant__grantgrantees">権限を与えられる人</a></em></strong></pre>
+</div>
+
+
+<div class="section" id="rrefsqljgrant__granttablepriv"><a name="rrefsqljgrant__granttablepriv"><!-- --></a><h4 class="sectiontitle">表権限</h4><pre><strong>  DELETE |
+  INSERT |
+  REFERENCES [<em>列一覧</em>] |
+  SELECT [<em>列一覧</em>] |
+  TRIGGER |
+  UPDATE [<em>列一覧</em>]
+</strong></pre>
+</div>
+
+<div class="section" id="rrefsqljgrant__grantcollist"><a name="rrefsqljgrant__grantcollist"><!-- --></a><h4 class="sectiontitle">列一覧</h4><pre><strong>  ( 列識別子 {, 列識別子}* )
+</strong></pre>
+</div>
+
+<div class="section"><p>ALL PRIVILEGES権限により指定した表へのすべての権限をユーザに付与します。権限の並びを指定して、表への一つ以上の権限を付与することも可能です。</p>
+
+<p>DELETE権限により指定した表から行を削除する権限を付与します。</p>
+
+<p>INSERT権限により指定した表に行を挿入する権限を付与します。</p>
+
+<p>REFERENCES権限により指定した表への外部キー参照を作成する権限を付与します。REFERENCESに合わせて列並びが指定された場合、指定した列への外部キー参照だけが許可されます。</p>
+
+<p>SELECT権限により表あるいはビューでSELECT文を行う権限が付与されます。もしSELECT権限で列の並びが指定された場合、それらの列にのみ権限は有効です。列の並びが指定されなかった場合、表の全列について権限は有効です。</p>
+
+<p>TRIGGER権限により指定した表にトリガを作成する権限が付与されます。</p>
+
+<p>UPDATE権限により指定した表にUPDATE文を使う権限が付与されます。列の並びが指定された場合、権限は指定された列にのみ有効です。WHERE節のある文で行を更新する場合、更新する行にある列へのSELECT権限も必要です。</p>
+</div>
+
+
+<div class="section" id="rrefsqljgrant__grantgrantees"><a name="rrefsqljgrant__grantgrantees"><!-- --></a><h4 class="sectiontitle">権限を与えられる人</h4><pre><strong>{	<em>認証識別子</em> | PUBLIC } [,{ <em>認証識別子</em> | PUBLIC } ] *</strong></pre>
+<p>特定のユーザまたは全ユーザに権限を与えることができます。
+PUBLIC というキーワードは全ユーザをあらわします。PUBLICが与えられた場合、現存するユーザのみならず、以降に作成されたユーザにも権限が与えられます。
+PUBLICに与えられた権限と、個々のユーザに与えられた権限は、独立しています。
+例えば、<samp class="codeph">t</samp>という表へのSELECT権限が、PUBLICと<samp class="codeph">harry</samp>という認証識別子に対して与えられているとしましょう。この場合は、<samp class="codeph">harry</samp>という認証識別子からSELECT権限が剥奪されたとしても、HarryはPUBLICの権限を通して、<samp class="codeph">t</samp>という表を操作可能です。</p>
+</div>
+
+<div class="section" id="rrefsqljgrant__grantroutinename"><a name="rrefsqljgrant__grantroutinename"><!-- --></a><h4 class="sectiontitle">プログラムルーチンの指示子</h4><pre><strong>{
+	<em>関数名</em> | <em>手続きの名前</em>
+}</strong></pre>
+</div>
+
+<div class="example" id="rrefsqljgrant__grantexamples"><a name="rrefsqljgrant__grantexamples"><!-- --></a><h4 class="sectiontitle">例</h4><div class="p">tという表へのSELECT権限を<samp class="codeph">maria</samp> と <samp class="codeph">harry</samp>という認証識別子に与えるには、次のように書きます。<pre><strong>GRANT SELECT ON TABLE t TO maria,harry</strong> </pre>
+</div>
+
+<div class="p">tという表へのUPDATEとTRIGGER権限を、<samp class="codeph">anita</samp>と<samp class="codeph">zhi</samp>という認証識別子に与えるには、次のように書きます。<pre><strong>GRANT UPDATE, TRIGGER ON TABLE t TO anita,zhi</strong> </pre>
+</div>
+
+<div class="p">s.vという表へのSELECT権限を全てのユーザに与えるには、次のように書きます。<pre><strong>GRANT SELECT ON TABLE s.v to PUBLIC</strong></pre>
+</div>
+
+<p>pという手続きの実行権限を、<samp class="codeph">george</samp>という認証識別子に与えるには、次のように書きます。</p>
+<pre><strong>GRANT EXECUTE ON PROCEDURE p TO george</strong> </pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="crefsqlj39374.html" title="">文</a></div>
+</div>
+<div class="relref"><strong>関連資料</strong><br />
+<div><a href="rrefsqljrevoke.html" title="REVOKE文を使って、指定したユーザあるいは全ユーザから、データベースの情報に対して操作を行う権限を剥奪することができます。">REVOKE 文</a></div>
+<div><a href="rrefsistabssystableperms.html" title="SYSTABLEPERMS表には権限が付与されているテーブルの情報が記録されます。">SYSTABLEPERMS システム表</a></div>
+<div><a href="rrefsistabssyscolperms.html" title="SYSCOLPERMS 表には権限が付与されている列の情報が記録されます。">SYSCOLPERMS システム表</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljmod.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljmod.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljmod.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="MOD関数" />
+<meta content="MOD function" name="DC.subject" />
+<meta content="MOD function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqljmod" 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>MOD関数</title>
+</head>
+<body id="rrefsqljmod"><a name="rrefsqljmod"><!-- --></a>
+
+
+<h1 class="topictitle1">MOD関数</h1>
+
+
+<div>
+<div class="section"> <p>MODは、一つ目の引数を二つ目の引数で割った剰余(法)を返します。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>mod(整数型, 整数型) </strong></pre>
+ 
+<div class="p">関数の結果は、<ul>
+<li>両方の引数がSMALLINTなら、SMALLIINT。</li>
+
+<li>片方の引数がINTEGERで、もう片方がINTEGERあるいはSMALLINTなら、INTEGER。</li>
+
+<li>片方の引数がBIGINTで、もう片方がBIGINTあるいはINTEGERあるいはSMALLINTなら、BIGINT。</li>
+
+</ul>
+</div>
+ 
+<p>返り値はNULLをとることがあり、もし何れかの引数がNULLなら、返り値はNULLです。</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/rrefsqljmod.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljrenamecolumnstatement.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljrenamecolumnstatement.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljrenamecolumnstatement.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,107 @@
+<!--
+  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="RENAME COLUMN 文" />
+<meta name="abstract" content="RENAME COLUMN 文で表にある列の名前を変更できます。" />
+<meta name="description" content="RENAME COLUMN 文で表にある列の名前を変更できます。" />
+<meta content="RENAME COLUMN statement, RENAME COLUMN, SQL statements, renaming, columns" name="DC.subject" />
+<meta content="RENAME COLUMN statement, RENAME COLUMN, SQL statements, renaming, columns" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqljrenamestatements.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj95598.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljrenametablestatement.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqljcolumnstatements" 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>RENAME COLUMN 文</title>
+</head>
+<body id="rrefsqljcolumnstatements"><a name="rrefsqljcolumnstatements"><!-- --></a>
+
+
+    <h1 class="topictitle1">RENAME COLUMN 文</h1>
+
+
+
+<div><p>RENAME COLUMN 文で表にある列の名前を変更できます。</p>
+
+<div class="section"> <p>RENAME COLUMN文により全てのスキーマにある既存表の既存列の名前を変更できます。(<em>SYS</em>のスキーマを除きます。)</p>
+
+<p>列の名前を変えることができるのは、データベースの所有者あるいは表の所有者のみです。</p>
+
+<p>表への他の定義変更は可能です。詳細は、<a href="rrefsqlj81859.html#rrefsqlj81859">ALTER TABLE 文</a>を参照してください。</p>
+
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4>
+    <pre><strong>RENAME COLUMN <em><a href="rreftablename.html">表名</a></em>.<em><a href="rrefsimplecolumnname.html">単純列名</a></em> TO <em><a href="rrefsimplecolumnname.html">単純列名</a></em></strong></pre>
+
+</div>
+
+<div class="example" id="rrefsqljcolumnstatements__renamecolumnexamples"><a name="rrefsqljcolumnstatements__renamecolumnexamples"><!-- --></a><h4 class="sectiontitle">例</h4>
+
+<div class="p"><em>employee</em>という表にある<em>manager</em>という列の名前を
+<em>supervisor</em>に変更するには次のようにします。
+<pre><strong>RENAME COLUMN EMPLOYEE.MANAGER TO SUPERVISOR</strong></pre>
+
+</div>
+
+<div class="p">ALTER TABLEとRENAME COLUMNを使って、列のデータ型を変更できます。
+<em>t</em>という表にある<em>c1</em>という列のデータ型を<em>NEWTYPE</em>に変更するためには、次のようにします。
+<pre><strong>
+    ALTER TABLE t ADD COLUMN c1_newtype NEWTYPE
+    UPDATE t SET c1_newtype = c1
+    ALTER TABLE t DROP COLUMN c1
+    RENAME COLUMN t.c1_newtype TO c1
+</strong></pre>
+</div>
+
+</div>
+
+<div class="section"><h4 class="sectiontitle">利用上の留意点</h4>
+<div class="note" id="rrefsqljcolumnstatements__restriction"><a name="rrefsqljcolumnstatements__restriction"><!-- --></a><span class="notetitle">Note: </span>列を参照するビューやトリガ、チェック制約、外部キー制約がある場合、列名の変更は失敗します。
+</div>
+
+<div class="note" id="rrefsqljcolumnstatements__restriction"><a name="rrefsqljcolumnstatements__restriction"><!-- --></a><span class="notetitle">Note: </span>名称を変更する列を参照する、開いたカーソルがある場合、RENAME COLUMN文は実行できません。</div>
+
+<div class="note"><span class="notetitle">Note: </span>列への索引があっても、列の名前は変更できます。索引は更新されて、変更後の列名で参照するようになります。</div>
+
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="crefsqljrenamestatements.html" title="">RENAME 文</a></div>
+</div>
+<div class="relref"><strong>Related reference</strong><br />
+<div><a href="rrefsqlj95598.html" title="">RENAME INDEX 文</a></div>
+<div><a href="rrefsqljrenametablestatement.html" title="">RENAME TABLE 文</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljrenametablestatement.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljrenametablestatement.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqljrenametablestatement.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="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="RENAME TABLE 文" />
+<meta content="RENAME TABLE statement, RENAME TABLE, SQL statements, renaming, tables" name="DC.subject" />
+<meta content="RENAME TABLE statement, RENAME TABLE, SQL statements, renaming, tables" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqljrenamestatements.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljrenamecolumnstatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj95598.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqljrenamestatements" 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>RENAME TABLE 文</title>
+</head>
+<body id="rrefsqljrenamestatements"><a name="rrefsqljrenamestatements"><!-- --></a>
+
+
+<h1 class="topictitle1">RENAME TABLE 文</h1>
+
+
+<div>
+<div class="section"> <p>RENAME TABLEによりあらゆるスキーマにある既存の表の名前を変更できます。(ただし<em>SYS</em>のスキーマは除きます。)</p>
+
+<p>表の名前を変更できるのは<a href="rrefattrib26867.html#rrefattrib26867">データベースの所有者</a>と表の所有者です。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>RENAME TABLE <em>表名</em> TO <em><a href="rrefnewtablename.html#rrefnewtablename">新表名</a></em></strong></pre>
+ 
+<p>表を参照するビューや外部キーがあった場合、名前を変えようとするとエラーが発生します。
+さらに、表にトリガやチェック制約があった場合も、名前を変えようとするとエラーが発生します。</p>
+ </div>
+
+<div class="example"> <pre><strong>RENAME TABLE SAMP.EMP_ACT TO EMPLOYEE_ACT</strong></pre>
+ 
+<p>詳細については、<a href="rrefsqlj81859.html#rrefsqlj81859">ALTER TABLE 文</a>も参照してください。</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">文の依存</h4> 
+<p>表に索引が定義されていても、表の名前は変更可能です。</p>
+ 
+<p>名前を変更しようとする表に、開いたカーソルがあった場合、RENAME TABLE文は失敗します。</p>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="crefsqljrenamestatements.html" title="">RENAME 文</a></div>
+</div>
+<div class="relref"><strong>Related reference</strong><br />
+<div><a href="rrefsqljrenamecolumnstatement.html" title="RENAME COLUMN 文で表にある列の名前を変更できます。">RENAME COLUMN 文</a></div>
+<div><a href="rrefsqlj95598.html" title="">RENAME INDEX 文</a></div>
+</div>
+</div>
+
+</body>
+</html>

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



Mime
View raw message