db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r854277 [35/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/rrefsqlj29026.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29026.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29026.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,305 @@
+<!--
+  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="crefsqlj23296.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj28468.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj18919.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj19433.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29840.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefqueries.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlbuiltinsystemfunctions.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefkeywords29722.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsql9241891.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsistabs38369.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefexcept16677.html" />
+<meta scheme="URI" name="DC.Relation" content="crefjdbc12657.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc87220.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbcjsr169.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc32593.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc4_0summary.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc1020262.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj55788.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj33923.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj98067.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncacos.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncasin.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncatan.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj32693.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefbuiltbigint.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcase.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj33562.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncceil.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefbuiltchar.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj40899.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffunccos.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj38716.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj66113.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljcurrentdate.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj34177.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcurrentisolation.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljcurrentschema.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj1055824.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj33772.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljcurrenttimestamp.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj15866.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42324.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdatefunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdayfunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncdegrees.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefbuiltdouble.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncexp.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncfloor.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefhourfunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefidentityvallocal.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefbuiltinteger.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42049.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj16762.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffunclog.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffunclog10.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj61998.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj97870.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj27781.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj33520.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefminutefunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljmod.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefmonthfunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcasenullif.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncpi.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncradians.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj32613.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsecondfunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj25228.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncsin.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefbuiltsmallint.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj73147.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj93082.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj13083.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffunctan.html" />
+<meta scheme="URI" name="DC.Relation" content="rreftimefunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rreftimestampfunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rreftrimfunc.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29930.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42476.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefbuiltvarchar.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncxmlexists.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncxmlparse.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncxmlquery.html" />
+<meta scheme="URI" name="DC.Relation" content="rreffuncxmlserialize.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefyearfunc.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj29026" 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="rrefsqlj29026"><a name="rrefsqlj29026"><!-- --></a>
+
+
+<h1 class="topictitle1">組み込み関数</h1>
+
+<div>
+<div class="section"><p>組み込み関数は何らかの処理を行うSQLキーワードや特殊な演算子です。
+組み込み関数には、キーワードか特殊な組込みの演算子が与えられています。
+組み込み関数のキーワードはSQL92識別子であり、大文字小文字を区別しません。
+TIMESTAMPADDやTIMESTAMPDIFFのようなエスケープ関数は、JDBCのエスケープ関数の構文に沿ってのみ利用できます。<a href="rrefjdbc1020262.html#rrefjdbc1020262">JDBCエスケープの構文</a>を参照してください。
+</p>
+</div>
+
+</div>
+
+<div>
+<ul class="ullinks">
+<li class="ulchildlink"><strong><a href="rrefsqlj55788.html">標準組込み関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj33923.html">集約 (集合関数)</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj98067.html">ABSとABSVAL関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffuncacos.html">ACOS 関数</a></strong><br />
+ACOS関数は与えられた数を引数とした逆余弦関数の値を返します。</li>
+<li class="ulchildlink"><strong><a href="rreffuncasin.html">ASIN 関数</a></strong><br />
+ASIN 関数は与えられた数を引数とする逆正弦の値を返します。</li>
+<li class="ulchildlink"><strong><a href="rreffuncatan.html">ATAN 関数</a></strong><br />
+ATAN 関数は与えられた数を引数とした逆正接を返します。</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj32693.html">AVG関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefbuiltbigint.html">BIGINT関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefcase.html">CASE 式</a></strong><br />
+Derbyで条件式を書くには、CASE式を使います。</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj33562.html">CAST 関数</a></strong><br />
+CAST関数により値の型を他の型に変換します。また動的な引数(?)やNULL値に型を与えます。</li>
+<li class="ulchildlink"><strong><a href="rreffuncceil.html">CEILおよびCEILING関数</a></strong><br />
+CEILおよびCEILING関数は与えられた数を切り上げて、その数以上の最小の値を返します。</li>
+<li class="ulchildlink"><strong><a href="rrefbuiltchar.html">CHAR 関数</a></strong><br />
+CHAR関数により固定長の文字列への変換値が返されます。</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj40899.html">Concatenation</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffunccos.html">COS 関数</a></strong><br />
+COS関数は引数から余弦を返します。</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj38716.html">COUNT 関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj66113.html">COUNT(*) 関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqljcurrentdate.html">CURRENT DATE 関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj34177.html">CURRENT_DATE関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefcurrentisolation.html">CURRENT ISOLATION 関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqljcurrentschema.html">CURRENT SCHEMA関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj1055824.html">CURRENT TIME</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj33772.html">CURRENT_TIME関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqljcurrenttimestamp.html">CURRENT TIMESTAMP関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj15866.html">CURRENT_TIMESTAMP関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj42324.html">CURRENT_USER関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefdatefunc.html">DATE関数</a></strong><br />
+DATE関数は引数から日付を返します。</li>
+<li class="ulchildlink"><strong><a href="rrefdayfunc.html">DAY 関数</a></strong><br />
+DAY関数は値のうち日付の部分を返します。</li>
+<li class="ulchildlink"><strong><a href="rreffuncdegrees.html">DEGREES 関数</a></strong><br />
+DEGREES関数はラジアンの値を度の値へ変換します。</li>
+<li class="ulchildlink"><strong><a href="rrefbuiltdouble.html">DOUBLE関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffuncexp.html">EXP関数</a></strong><br />
+EXP関数はeを底として、引数の累乗を返します。</li>
+<li class="ulchildlink"><strong><a href="rreffuncfloor.html">FLOOR関数</a></strong><br />
+FLOOR関数は引数の値に切り捨ての丸め処理を行い、引数以下の最大の整数を返します。</li>
+<li class="ulchildlink"><strong><a href="rrefhourfunc.html">HOUR関数</a></strong><br />
+HOUR関数は値の時の部分を返します。</li>
+<li class="ulchildlink"><strong><a href="rrefidentityvallocal.html">IDENTITY_VAL_LOCAL関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefbuiltinteger.html">INTEGER関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj42049.html">LCASEあるいはLOWER関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj16762.html">LENGTH関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffunclog.html">LNあるいはLOG関数</a></strong><br />
+LNあるいはLOG関数は引数の自然対数(eを底とします。)を返します。</li>
+<li class="ulchildlink"><strong><a href="rreffunclog10.html">LOG10 関数</a></strong><br />
+LOG10関数は10を底とした対数を返します。</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj61998.html">LOCATE関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj97870.html">LTRIM関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj27781.html">MAX関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj33520.html">MIN関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefminutefunc.html">MINUTE 関数</a></strong><br />
+MINUTE関数は値の分の部分を返します。</li>
+<li class="ulchildlink"><strong><a href="rrefsqljmod.html">MOD関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefmonthfunc.html">MONTH関数</a></strong><br />
+MONTH関数は値から月の部分を返します。</li>
+<li class="ulchildlink"><strong><a href="rrefcasenullif.html">NULLIF式</a></strong><br />
+Derbyでは、条件式にはNULLIF式を使います。</li>
+<li class="ulchildlink"><strong><a href="rreffuncpi.html">PI 関数</a></strong><br />
+PI関数はpiに最も近い値を返します。</li>
+<li class="ulchildlink"><strong><a href="rreffuncradians.html">RADIANS 関数</a></strong><br />
+RADIANS関数は引数を度からラジアンに変換します。</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj32613.html">RTRIM関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsecondfunc.html">SECOND関数</a></strong><br />
+SECOND関数は引数の秒の部分を返します。</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj25228.html">SESSION_USER関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffuncsin.html">SIN 関数</a></strong><br />
+SIN関数は引数の正弦を返します。</li>
+<li class="ulchildlink"><strong><a href="rrefbuiltsmallint.html">SMALLINT関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj73147.html">SQRT関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj93082.html">SUBSTR関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj13083.html">SUM関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffunctan.html">TAN 関数</a></strong><br />
+TAN関数は引数から計算した正接を返します。</li>
+<li class="ulchildlink"><strong><a href="rreftimefunc.html">TIME 関数</a></strong><br />
+TIME関数は値の時刻の部分を返します。</li>
+<li class="ulchildlink"><strong><a href="rreftimestampfunc.html">TIMESTAMP関数</a></strong><br />
+TIMESTAMP関数はタイムスタンプを、値あるいは値の対から返します。</li>
+<li class="ulchildlink"><strong><a href="rreftrimfunc.html">TRIM 関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj29930.html">UCASE関数およびUPPER関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj42476.html">USER関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefbuiltvarchar.html">VARCHAR関数</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rreffuncxmlexists.html">XMLEXISTS 演算子</a></strong><br />
+XMLEXISTSは、SQLにてXMLを問い合わせるときに利用できるSQL/XML演算子です。</li>
+<li class="ulchildlink"><strong><a href="rreffuncxmlparse.html">XMLPARSE演算子</a></strong><br />
+XMLPARSEは、文字列式を構文解析してDerbyXML値にするSQL/XML演算子です。</li>
+<li class="ulchildlink"><strong><a href="rreffuncxmlquery.html">XMLQUERY演算子</a></strong><br />
+XMLQUERYはSQLにてXMLの値を問い合わせることができるSQL/XML演算子です。</li>
+<li class="ulchildlink"><strong><a href="rreffuncxmlserialize.html">XMLSERIALIZE 演算子</a></strong><br />
+XMLSERIALIZEはXML型の情報を文字型の情報に変換するSQL/XML演算子です。これはDerby XML値を変換する唯一の方法です。</li>
+<li class="ulchildlink"><strong><a href="rrefyearfunc.html">YEAR関数</a></strong><br />
+</li>
+</ul>
+
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="crefsqlj23296.html" title="">SQL言語のリファレンス</a></div>
+</div>
+<div class="relconcepts"><strong>関連概念</strong><br />
+<div><a href="crefsqlj18919.html" title="">SQLの識別子</a></div>
+<div><a href="crefsqlj39374.html" title="">文</a></div>
+<div><a href="crefsqlbuiltinsystemfunctions.html" title="">組込みシステム関数</a></div>
+<div><a href="crefjdbc12657.html" title="Derbyは組み込みのJDBCドライバと共に提供されます。">JDBC リファレンス</a></div>
+</div>
+<div class="relref"><strong>関連資料</strong><br />
+<div><a href="rrefsqlj28468.html" title="">大文字小文字と特殊文字</a></div>
+<div><a href="rrefclauses.html" title="">SQL 節</a></div>
+<div><a href="rrefsqlj19433.html" title="多くの文や式の構文の語句に、式や表副問合せのような式の一種があります。 式は文の定められた場所に置くことができます。">SQL式</a></div>
+<div><a href="rrefsqlj29840.html" title="">JOIN 演算</a></div>
+<div><a href="rrefqueries.html" title="">SQL 問い合わせ</a></div>
+<div><a href="rrefkeywords29722.html" title="">SQL予約語</a></div>
+<div><a href="rrefsql9241891.html" title="">DerbyのサポートするSQL-92の機能</a></div>
+<div><a href="rrefsistabs38369.html" title="">Derbyのシステム表</a></div>
+<div><a href="rrefexcept16677.html" title="Derbyにて発生する全てのエラーは、JDBCからSQLExceptionとして挙がります。 もしユーザの定義した型から例外が挙がって、その例外がSQLExceptionでは無い場合、その例外はSQLExceptionにラップされています。 Derby固有のSQLExceptionは、SQLStateクラスに定義されたXで始まるコードを用います。標準に定義されたSQLStateの値は、対応する例外に対して返されます。">Derbyの例外メッセージとSQL state</a></div>
+<div><a href="rrefjdbc87220.html" title="">java.sql.BatchUpdateException クラス</a></div>
+<div><a href="rrefjdbcjsr169.html" title="">Connected Device ConfigurationおよびFoundation Profile向けのJDBCパッケージ(JSR169)</a></div>
+<div><a href="rrefjdbc32593.html" title="">JDBC 3.0の機能</a></div>
+<div><a href="rrefjdbc4_0summary.html" title="">JDBC 4.0の機能</a></div>
+<div><a href="rrefjdbc1020262.html" title="">JDBCエスケープの構文</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29840.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29840.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29840.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,134 @@
+<!--
+  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="JOIN 演算" />
+<meta content="JOIN operations, Outer joins" name="DC.subject" />
+<meta content="JOIN operations, Outer joins" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj23296.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj28468.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj18919.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj19433.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefqueries.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlbuiltinsystemfunctions.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefkeywords29722.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsql9241891.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsistabs38369.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefexcept16677.html" />
+<meta scheme="URI" name="DC.Relation" content="crefjdbc12657.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc87220.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbcjsr169.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc32593.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc4_0summary.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc1020262.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj35034.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj18922.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj57522.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj29840" 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>JOIN 演算</title>
+</head>
+<body id="rrefsqlj29840"><a name="rrefsqlj29840"><!-- --></a>
+
+
+<h1 class="topictitle1">JOIN 演算</h1>
+
+
+<div>
+<div class="section"> <p>JOIN演算は<a href="rrefsqlj21583.html#rrefsqlj21583">FROM 節</a>の<em><a href="rreftableexpression.html#rreftableexpression">TableExpression</a></em>に置くことができ、2表の間の結合を記述します。(WHERE節にて"WHERE t1.col1
+= t2.col2"等と書いて、明示的に等価性の判定式を記述することでも、結合を実現することもできます。)</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong><em>JOIN式</em></strong></pre>
+ 
+<div class="p">JOIN演算は、以下のいずれかです。<ul>
+<li><a href="rrefsqlj35034.html#rrefsqlj35034">INNER JOIN 演算</a>   
+<p>join節により2表の間の結合を明示的に指定します。<a href="rrefsqlj35034.html#rrefsqlj35034">INNER JOIN 演算</a>を参照してください。</p>
+</li>
+
+<li><a href="rrefsqlj18922.html#rrefsqlj18922">LEFT OUTER JOIN演算</a>   
+<p>join節により2表の間の結合を明示的に指定します。また最初の表にて一致行が二つ目の表にない行も残ります。<a href="rrefsqlj18922.html#rrefsqlj18922">LEFT OUTER JOIN演算</a>を参照してください。</p>
+</li>
+
+<li><a href="rrefsqlj57522.html#rrefsqlj57522">RIGHT OUTER JOIN 演算</a>   
+<p>join節により2表の間の結合を明示的に指定します。また二つ目の表にて一致行が最初の表にない行も残ります。<a href="rrefsqlj57522.html#rrefsqlj57522">RIGHT OUTER JOIN 演算</a>を参照してください。</p>
+</li>
+
+</ul>
+</div>
+ <p>どの場合でも、結合された表の片方もしくは両方に、outer join節あるいは<a href="rrefsqlj33602.html#rrefsqlj33602">WHERE 節</a>で、追加の絞込条件を置くことができます。</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JOIN演算と、問い合わせの最適化</h4> 
+<p>結合にどのような最適化が行われるかについては、<cite><span><em>Derbyのチューニング</em></span></cite>を参照してください。</p>
+ </div>
+
+</div>
+
+<div>
+<ul class="ullinks">
+<li class="ulchildlink"><strong><a href="rrefsqlj35034.html">INNER JOIN 演算</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj18922.html">LEFT OUTER JOIN演算</a></strong><br />
+</li>
+<li class="ulchildlink"><strong><a href="rrefsqlj57522.html">RIGHT OUTER JOIN 演算</a></strong><br />
+</li>
+</ul>
+
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="crefsqlj23296.html" title="">SQL言語のリファレンス</a></div>
+</div>
+<div class="relconcepts"><strong>関連概念</strong><br />
+<div><a href="crefsqlj18919.html" title="">SQLの識別子</a></div>
+<div><a href="crefsqlj39374.html" title="">文</a></div>
+<div><a href="crefsqlbuiltinsystemfunctions.html" title="">組込みシステム関数</a></div>
+<div><a href="crefjdbc12657.html" title="Derbyは組み込みのJDBCドライバと共に提供されます。">JDBC リファレンス</a></div>
+</div>
+<div class="relref"><strong>関連資料</strong><br />
+<div><a href="rrefsqlj28468.html" title="">大文字小文字と特殊文字</a></div>
+<div><a href="rrefclauses.html" title="">SQL 節</a></div>
+<div><a href="rrefsqlj19433.html" title="多くの文や式の構文の語句に、式や表副問合せのような式の一種があります。 式は文の定められた場所に置くことができます。">SQL式</a></div>
+<div><a href="rrefqueries.html" title="">SQL 問い合わせ</a></div>
+<div><a href="rrefsqlj29026.html" title="">組み込み関数</a></div>
+<div><a href="rrefkeywords29722.html" title="">SQL予約語</a></div>
+<div><a href="rrefsql9241891.html" title="">DerbyのサポートするSQL-92の機能</a></div>
+<div><a href="rrefsistabs38369.html" title="">Derbyのシステム表</a></div>
+<div><a href="rrefexcept16677.html" title="Derbyにて発生する全てのエラーは、JDBCからSQLExceptionとして挙がります。 もしユーザの定義した型から例外が挙がって、その例外がSQLExceptionでは無い場合、その例外はSQLExceptionにラップされています。 Derby固有のSQLExceptionは、SQLStateクラスに定義されたXで始まるコードを用います。標準に定義されたSQLStateの値は、対応する例外に対して返されます。">Derbyの例外メッセージとSQL state</a></div>
+<div><a href="rrefjdbc87220.html" title="">java.sql.BatchUpdateException クラス</a></div>
+<div><a href="rrefjdbcjsr169.html" title="">Connected Device ConfigurationおよびFoundation Profile向けのJDBCパッケージ(JSR169)</a></div>
+<div><a href="rrefjdbc32593.html" title="">JDBC 3.0の機能</a></div>
+<div><a href="rrefjdbc4_0summary.html" title="">JDBC 4.0の機能</a></div>
+<div><a href="rrefjdbc1020262.html" title="">JDBCエスケープの構文</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29930.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29930.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj29930.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="UCASE関数およびUPPER関数" />
+<meta content="functions, UPPER, UCASE, UPPER function, UCASE function" name="DC.subject" />
+<meta content="functions, UPPER, UCASE, UPPER function, UCASE function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj29930" 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>UCASE関数およびUPPER関数</title>
+</head>
+<body id="rrefsqlj29930"><a name="rrefsqlj29930"><!-- --></a>
+
+
+<h1 class="topictitle1">UCASE関数およびUPPER関数</h1>
+
+
+<div>
+<div class="section"> <p>UCASEおよびUPPERは文字式を引数にとり、全てのアルファベットの文字を大文字にして返します。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4><pre>UCASEまたはUPPER ( <em>文字式</em> ) </pre>
+
+<div class="p">もし引数の型がCHARであれば、返り値の型はCHARです。それ以外の場合は、返り値の型はVARCHARです。
+<div class="note"><span class="notetitle">注: </span>UPPERとLOWERは、データベースのロケールによる影響を受けます。ロケールの設定についての、詳細は<em><a href="rrefattrib56769.html#rrefattrib56769">territory=ll_CC 属性</a></em>を参照してください。
+</div>
+</div>
+<p>返り値の長さと最大長は、引数の長さと最大長と同じです。</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">例</h4>次の節により、<div class="p"><samp class="codeph">aSD1#w</samp>という文字列を大文字にして返す事ができます。
+<pre>VALUES UPPER('aSD1#w')</pre>
+
+返り値は<samp class="codeph">ASD1#W</samp>です。</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/rrefsqlj29930.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30118.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30118.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30118.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,64 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="LONG VARCHAR FOR BIT DATAデータ型" />
+<meta content="LONG VARCHAR FOR BIT DATA type" name="DC.subject" />
+<meta content="LONG VARCHAR FOR BIT DATA type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj30118" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>LONG VARCHAR FOR BIT DATAデータ型</title>
+</head>
+<body id="rrefsqlj30118"><a name="rrefsqlj30118"><!-- --></a>
+
+
+<h1 class="topictitle1">LONG VARCHAR FOR BIT DATAデータ型</h1>
+
+
+<div>
+<div class="section"> <p>LONG VARCHAR FOR BIT DATA型には最大で32,700バイトのビット列を記録できます。この型は列の定義を行うときに最大長を指定する必要がないことを除き、<a href="rrefsqlj32714.html#rrefsqlj32714">VARCHAR
+FOR BIT DATA</a>と同じです。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>LONG VARCHAR FOR BIT DATA</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBC メタデータ型(java.sql.Types)</h4><p>LONGVARBINARY</p>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="crefsqlj31068.html" title="">データ型</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30435.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30435.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30435.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,81 @@
+<!--
+  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="BIGINT データ型" />
+<meta content="BIGINT data type" name="DC.subject" />
+<meta content="BIGINT data type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj30435" 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>BIGINT データ型</title>
+</head>
+<body id="rrefsqlj30435"><a name="rrefsqlj30435"><!-- --></a>
+
+
+<h1 class="topictitle1">BIGINT データ型</h1>
+
+
+<div>
+<div class="section"> <p>BIGINTでは整数の記録のため8バイトの領域が割り当てられます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>BIGINT</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">コンパイル時の対応するJavaの型</h4> <p><em>java.lang.Long</em></p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCメタ情報での型(java.sql.Types)</h4> <p>BIGINT</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">最小値</h4> <p id="rrefsqlj30435__sqlj76321"><a name="rrefsqlj30435__sqlj76321"><!-- --></a>-9223372036854775808
+(<em>java.lang.Long.MIN_VALUE</em>)</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">最大値</h4> <p id="rrefsqlj30435__sqlj25246"><a name="rrefsqlj30435__sqlj25246"><!-- --></a>9223372036854775807
+(<em>java.lang.Long.MAX_VALUE</em>)</p>
+ 
+<p>他のデータ型と混在させて利用した場合、結果のデータ型は<a href="rrefsqlj27767.html#rrefsqlj27767">式にて行われる数値型の項目</a>に書かれたルールに従います。</p>
+ 
+<p>小さな記憶領域しか持たない場所に、それより大きな記憶領域を占める整数値を代入しようとすると、その整数値が小さな記憶領域では記録できずにエラーとなることがあります。またどのような整数でも、適切にnumericの値とする事ができます。BIGINTであれば、充分な精度を持つDECIMALに記録することができます。</p>
+ </div>
+
+<div class="example"> <pre><strong>9223372036854775807</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/rrefsqlj30435.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30540.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30540.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj30540.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,102 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="en-us" xml:lang="en-us">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="列定義" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj24513.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj37836.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj30540" name="DC.Identifier" />
+<meta content="en-us" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>列定義</title>
+</head>
+<body id="rrefsqlj30540"><a name="rrefsqlj30540"><!-- --></a>
+
+
+<h1 class="topictitle1">列定義</h1>
+
+<div>
+<div class="example"> <pre><strong><em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">単純列名</a></em> <em>データ型</em>
+    [ <em><a href="rrefsqlj16095.html#rrefsqlj16095">列毎の制約</a></em> ]*
+    [ [ WITH ] DEFAULT <var class="varname">既定制約式</var>
+       |<em><a href="rrefsqlj37836.html#rrefsqlj37836">発番列仕様</a></em> ]
+    [ <em><a href="rrefsqlj16095.html#rrefsqlj16095">列毎の制約</a></em> ]*
+</strong></pre>
+</div>
+
+<div class="section"><p><em>データ型</em>の仕様は<a href="crefsqlj31068.html#crefsqlj31068">データ型</a>にて説明されています。</p>
+
+<p><em><a href="rrefsqlj16095.html#rrefsqlj16095">列毎の制約</a></em>と<em><a href="rrefsqlj42154.html#rrefsqlj42154">表毎の制約</a></em>は、<a href="rrefsqlj13590.html#rrefsqlj13590">CONSTRAINT 節</a>にて説明されています。</p>
+</div>
+
+<div class="section" id="rrefsqlj30540__sqlj64478"><a name="rrefsqlj30540__sqlj64478"><!-- --></a><h4 class="sectiontitle">列の既定値</h4>
+<p>既定値の定義として、いかなる表への参照もない<em>既定制約式</em>があります。
+これに可能であるのは定数、日時の特殊変数、現在のスキーマ、ユーザ、nullです。</p>
+ 
+<pre><strong><var class="varname">既定制約式</var>:
+          NULL
+        | CURRENT { SCHEMA | SQLID }
+        | USER | CURRENT_USER | SESSION_USER
+        | DATE
+        | TIME
+        | TIMESTAMP
+        | CURRENT DATE | CURRENT_DATE
+        | CURRENT TIME | CURRENT_TIME
+        | CURRENT TIMESTAMP | CURRENT_TIMESTAMP
+        | <var class="varname">literal</var>
+</strong></pre>
+
+<p>Derbyのリテラル値についての詳細は、<a href="crefsqlj31068.html#crefsqlj31068">データ型</a>を参照してください。</p>
+
+<p><var class="varname">既定制約式</var>におく値は、列と互換性のある型でなければなりません。加えて以下の制約があります。</p>
+
+<ul>
+<li>USER、CURRENT_USERやSESSION_USERを指定した場合、列の長さは少なくとも8である必要があります。</li>
+
+<li>CURRENT SCHEMAやCURRENT SQLIDを指定した場合、列の長さは少なくとも128である必要があります。</li>
+
+<li>列が整数型である場合、既定値は整数のリテラルである必要があります。</li>
+
+<li>列が10進の型である場合、既定値の桁数と精度は列のそれぞれの定義の範囲内である必要があります。</li>
+
+</ul>
+
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="rrefsqlj24513.html" title="">CREATE TABLE 文</a></div>
+</div>
+<div class="relref"><strong>Related reference</strong><br />
+<div><a href="rrefsqlj37836.html" title="">発番列仕様</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31580.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31580.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31580.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="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 SCHEMA 文" />
+<meta content="CREATE SCHEMA statement, CREATE SCHEMA, SQL statements, schemas, creating" name="DC.subject" />
+<meta content="CREATE SCHEMA statement, CREATE SCHEMA, SQL statements, schemas, 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="rrefsqljcreatesynonym.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="rrefsqlj31580" 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 SCHEMA 文</title>
+</head>
+<body id="rrefsqlj31580"><a name="rrefsqlj31580"><!-- --></a>
+
+
+<h1 class="topictitle1">CREATE SCHEMA 文</h1>
+
+
+<div>
+<div class="section"> <p>スキーマにより情報を論理的に一つの集合に分類すること、および、一意な名前空間を提供する事ができます。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>CREATE SCHEMA { [ <em><a href="rrefschemaname.html#rrefschemaname">スキーマ名</a></em> AUTHORIZATION <em>ユーザ名</em> ] | [ <em>スキーマ名</em> ] | 
+[ AUTHORIZATION <em>ユーザ名</em> ] }</strong>
+</pre>
+ <p>CREATE SCHEMA 文によりスキーマを作成することができます。スキーマ名は128文字を超えてはなりません。スキーマ名はデータベースの内で一意で無ければなりません。</p>
+ 
+<div class="p">CREATE SCHEMA文はデータベースないしシステムにおいて、<samp class="codeph">derby.database.sqlAuthorization</samp>が<samp class="codeph">true</samp>となっている場合、アクセス制御の対象となります。データベース所有者だけが現在のユーザ名とは異なる名前のスキーマを作成することができます。またデータベース所有者だけが現在のユーザ名とは異なる<pre>AUTHORIZATION <em>user-name</em></pre>
+を指定できます。
+<samp class="codeph">derby.database.sqlAuthorization</samp>属性についてのより詳細な情報は、<span><em>Derbyのチューニング</em></span>を参照してください。</div>
+</div>
+
+<div class="example"><h4 class="sectiontitle">CREATE SCHEMAの例</h4><div class="p">飛行機に関連した表をおくスキーマを作成して、<samp class="codeph">anita</samp>という認証識別子にスキーマの全ての情報を操作する権限を与えるには次のようにします。<pre><strong>CREATE SCHEMA FLIGHTS AUTHORIZATION anita</strong> </pre>
+</div>
+
+<div class="p">従業員に関連した表をおくスキーマを作成するには次のようにします。<pre><strong>CREATE SCHEMA EMP</strong> </pre>
+</div>
+
+<div class="p"><samp class="codeph">takumi</samp>というスキーマ名がそのまま認証識別子であるスキーマを作成するには次のようにします。<pre><strong>CREATE SCHEMA AUTHORIZATION takumi</strong> </pre>
+</div>
+
+<div class="p"><samp class="codeph">EMP</samp>と<samp class="codeph">FLIGHTS</samp>の各スキーマに<samp class="codeph">availability</samp>という表を作成するには次のようにします。<pre><strong>CREATE TABLE FLIGHTS.AVAILABILITY
+	(FLIGHT_ID CHAR(6) NOT NULL, SEGMENT_NUMBER INT NOT NULL,
+	FLIGHT_DATE DATE NOT NULL, ECONOMY_SEATS_TAKEN INT,
+	BUSINESS_SEATS_TAKEN INT, FIRSTCLASS_SEATS_TAKEN INT, 
+	CONSTRAINT FLT_AVAIL_PK
+	PRIMARY KEY (FLIGHT_ID, SEGMENT_NUMBER, FLIGHT_DATE))</strong> </pre>
+</div>
+<pre><strong>CREATE TABLE EMP.AVAILABILITY
+	(HOTEL_ID INT NOT NULL, BOOKING_DATE DATE NOT NULL, ROOMS_TAKEN INT,
+	CONSTRAINT HOTELAVAIL_PK PRIMARY KEY (HOTEL_ID, BOOKING_DATE))
+</strong></pre>
+ </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="rrefsqljcreatesynonym.html" title="">CREATE SYNONYM 文</a></div>
+<div><a href="rrefsqlj24513.html" title="">CREATE TABLE 文</a></div>
+<div><a href="rrefsqlj43125.html" title="">CREATE TRIGGER 文</a></div>
+<div><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/rrefsqlj31580.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31648.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31648.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31648.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,86 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="DROP SCHEMA 文" />
+<meta content="DROP SCHEMA statement, Schemas, dropping" name="DC.subject" />
+<meta content="DROP SCHEMA statement, Schemas, 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="rrefsqljdropsynonym.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="rrefsqlj31648" 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 SCHEMA 文</title>
+</head>
+<body id="rrefsqlj31648"><a name="rrefsqlj31648"><!-- --></a>
+
+
+<h1 class="topictitle1">DROP SCHEMA 文</h1>
+
+
+<div>
+<div class="section"> <p>DROP SCHEMA 文によりスキーマを破棄できます。
+破棄するスキーマは空で無ければなりません。</p>
+  <p><em>APP</em>スキーマ(既定のユーザスキーマです。)や<em>SYS</em>スキーマは破棄できません。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>DROP SCHEMA <em><a href="rrefschemaname.html#rrefschemaname">スキーマ名</a></em> RESTRICT</strong></pre>
+ 
+<p>RESTRICTキーワードによりデータベースから破棄しようとするスキーマには、情報があってはならないことを指定します。このRESTRICTキーワードは必須です。</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- SAMP スキーマを破棄します。
+-- SAMPスキーマをデータベースから削除できるのは、
+-- スキーマに情報が定義されていないときのみです。</span>
+DROP SCHEMA SAMP RESTRICT</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="rrefsqljdropsynonym.html" title="">DROP SYNONYM 文</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/rrefsqlj31648.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31783.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31783.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj31783.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,83 @@
+<!--
+  Licensed to the Apache Software Foundation (ASF) under one or more
+  contributor license agreements.  See the NOTICE file distributed with
+  this work for additional information regarding copyright ownership.
+  The ASF licenses this file to You under the Apache License, Version 2.0
+  (the "License"); you may not use this file except in compliance with
+  the License.  You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="FOR UPDATE 節" />
+<meta content="FOR UPDATE clause, Cursors" name="DC.subject" />
+<meta content="FOR UPDATE clause, Cursors" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj31783" 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>FOR UPDATE 節</title>
+</head>
+<body id="rrefsqlj31783"><a name="rrefsqlj31783"><!-- --></a>
+
+
+<h1 class="topictitle1">FOR UPDATE 節</h1>
+
+
+<div>
+<div class="section">  
+<p><a href="rrefsqlj41360.html#rrefsqlj41360">SELECT文</a>にはFOR UPDATE節を持たせることができます。
+既定でカーソルは読み込みしかできません。FOR UPDATE節により、コンパイル中にSELECT文が更新可能な<em>カーソル</em>の必要条件を満たすかを検証して、カーソルを更新可能とします。
+更新可能であることの詳細については、<a href="rrefsqlj41360.html#rrefsqlj41360__sqlj15384">更新可能なカーソルの必要条件</a>を参照してください。</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>FOR
+{
+    READ ONLY | FETCH ONLY |
+    UPDATE [ OF <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">単純列名</a></em> [ , <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">単純列名</a></em>]* ]
+}</strong></pre>
+ <p><em>単純列名</em> により、問い合わせ文のFROM節にある表にて、可視な名前を参照します。</p>
+ 
+</div>
+
+<div class="section">
+<div class="p"><div class="note"><span class="notetitle">注: </span>更新可能なJDBCのResultSetを得るために、必ずしもFOR UPDATE節を使う必要はありません。
+JDBCのResultSetの元となる文が、更新可能なカーソルの必要条件を満たしてさえいれば、JDBC Statementから、並行処理モードが<samp class="codeph">ResultSet.CONCUR_UPDATABLE</samp>のJDBC ResultSetを生成することができます。
+</div>
+</div>
+ 
+<p>索引の列が更新されていても、索引を使った最適化が可能です。索引がどのようにカーソルに影響するかについては、<cite><span><em>Derbyのチューニング</em></span></cite>を参照してください。</p>
+ 
+</div>
+
+<div class="example"> <pre><strong>SELECT RECEIVED, SOURCE, SUBJECT, NOTE_TEXT FROM SAMP.IN_TRAY FOR UPDATE
+</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="rrefclauses.html" title="">SQL 節</a></div>
+</div>
+</div>
+
+</body>
+</html>

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

Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32268.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32268.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32268.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="SET SCHEMA 文" />
+<meta content="SET SCHEMA statement, Schemas, changing default for session" name="DC.subject" />
+<meta content="SET SCHEMA statement, Schemas, changing default for session" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj35312.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj41180.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj32268" 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>SET SCHEMA 文</title>
+</head>
+<body id="rrefsqlj32268"><a name="rrefsqlj32268"><!-- --></a>
+
+
+<h1 class="topictitle1">SET SCHEMA 文</h1>
+
+
+<div>
+<div class="section"> <p>SET SCHEMA 文により、接続の既定スキーマを指定したスキーマに設定できます。
+接続から発行される文にて対象のスキーマ名を明示的に指定しなかった場合、既定スキーマが対象のスキーマとなります。</p>
+ 
+<p>SET SCHEMA文を成功裏に実行するためには、設定するスキーマが存在していなければなりません。
+スキーマが存在していなければ、エラーとなります。<a href="rrefsqlj31580.html#rrefsqlj31580">CREATE SCHEMA 文</a>を参照してください。</p>
+ 
+<p>SET SCHEMA 文はトランザクション処理されません。それゆえSET SCHEMA 文が実行されると、トランザクションがロールバックされても、SET SCHEMA 文により変更されたスキーマのままです。</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">構文</h4> <pre><strong>SET [CURRENT] SCHEMA [=]
+{ <em><a href="rrefschemaname.html#rrefschemaname">スキーマ名</a> </em>|
+USER | ? | '&lt;文字列定数&gt;' } | SET CURRENT SQLID [=]
+{
+<em><a href="rrefschemaname.html#rrefschemaname">スキーマ名</a> </em>| USER | ? | '&lt;文字列定数&gt;' }</strong></pre>
+ 
+<p><em><a href="rrefschemaname.html#rrefschemaname">スキーマ名</a></em>は最大で128文字からなる識別子です。スキーマ名は二重引用符で囲まれない限り、大文字小文字を区別しません。(例を挙げると、SYSはsYs、SYs、sysのいずれとも等価です。)</p>
+ 
+<p>USERは現在のユーザです。現在のユーザが定義されていない場合、現在のスキーマは既定で<em>APP</em>です。(接続にユーザ名が定義されている場合、そのユーザ名に対応したスキーマがあるなら、それが接続の既定のスキーマとなります。</p>
+ 
+<p>? は準備された文で利用できる動的な引数です。SET SCHEMA文を準備して、異なるスキーマを値にとって実行することができます。このときスキーマの値は文字列定数と扱われ、大文字小文字が区別されます。例えば、<em>APP</em>を指定するには、"app"ではなく"APP"を使います。</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- 以下の例は全て等価で、
+-- HOTELというスキーマがあれば動作します。</span>
+SET SCHEMA HOTEL
+SET SCHEMA hotel
+SET CURRENT SCHEMA hotel
+SET CURRENT SQLID hotel
+SET SCHEMA = hotel
+SET CURRENT SCHEMA = hotel
+SET CURRENT SQLID = hotel
+SET SCHEMA "HOTEL" <span>-- クォートされた識別子</span>
+SET SCHEMA 'HOTEL' <span>-- クォートされた文字列</span>
+ <span>--小文字のhotelは存在しないので、
+ --この例はエラーとなります。</span>
+SET SCHEMA = 'hotel'
+<span> --SQLIDはCURRENTとともに使わなければならないので、
+ --この例は失敗します。</span>
+SET SQLID hotel
+<span> -- これによりスキーマは現在のユーザIDに設定されます。</span>
+SET CURRENT SCHEMA USER
+<span>// Javaのプログラムでset schemaを使う例です。</span>
+PreparedStatement ps = conn.PrepareStatement("set schema ?");
+ps.setString(1,"HOTEL");
+ps.executeUpdate();
+... do some work
+ps.setString(1,"APP");
+ps.executeUpdate();
+
+ps.setString(1,"app"); <span>//error - string is case sensitive
+// no app will be found </span>
+ps.setNull(1, Types.VARCHAR); <span>//error - null is not allowed</span> </strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親トピック:</strong> <a href="crefsqlj35312.html" title="">SET 文</a></div>
+</div>
+<div class="relref"><strong>関連資料</strong><br />
+<div><a href="rrefsqlj41180.html" title="">SET ISOLATION 文</a></div>
+</div>
+</div>
+
+</body>
+</html>

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



Mime
View raw message