You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@db.apache.org by rh...@apache.org on 2013/03/13 14:54:25 UTC
svn commit: r854277 [40/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/
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj59893.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj59893.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj59893.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,85 @@
+<!--
+ 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 INDEX æ" />
+<meta content="DROP INDEX statement" name="DC.subject" />
+<meta content="DROP INDEX statement" 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="rrefdropprocedurestatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj31648.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="rrefsqlj59893" 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 INDEX æ</title>
+</head>
+<body id="rrefsqlj59893"><a name="rrefsqlj59893"><!-- --></a>
+
+
+<h1 class="topictitle1">DROP INDEX æ</h1>
+
+
+<div>
+<div class="section"> <p>DROP INDEX ã§æå®ããç´¢å¼ã¯ç ´æ£ããã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>DROP INDEX <em><a href="rrefindexname.html#rrefindexname">ç´¢å¼å</a></em></strong></pre>
+ </div>
+
+<div class="example"> <pre><strong>DROP INDEX OrigIndex
+
+DROP INDEX DestIndex</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æã®ä¾å</h4>
+<p>ç ´æ£ãããã¨ãã¦ããç´¢å¼ããããã¼ãã«ã«ãéãã¦ããã«ã¼ã½ã«ãããå ´åãDROP INDEX æã¯ã¨ã©ã¼ã¨ãªã£ã¦ãç´¢å¼ã¯ç ´æ£ããã¾ãããç´¢å¼ãç ´æ£ãããå ´åã«ã¯ãç ´æ£ãããç´¢å¼ã®è¡¨ã«ä¾åãã¦ããæã¯ç¡å¹ã¨ãªãã¾ãã</p>
+ </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="rrefdropprocedurestatement.html" title="">DROP PROCEDURE æ</a></div>
+<div><a href="rrefsqlj31648.html" title="">DROP SCHEMA æ</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/rrefsqlj59893.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj61102.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj61102.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj61102.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="DROP VIEW æ" />
+<meta content="DROP VIEW statement, Views, dropping" name="DC.subject" />
+<meta content="DROP VIEW statement, Views, 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="rrefsqljdropsynonym.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj34148.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42082.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj61102" 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 VIEW æ</title>
+</head>
+<body id="rrefsqlj61102"><a name="rrefsqlj61102"><!-- --></a>
+
+
+<h1 class="topictitle1">DROP VIEW æ</h1>
+
+
+<div>
+<div class="section"> <p>æå®ãããã¥ã¼ãç ´æ£ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>DROP VIEW <a href="rrefviewname.html#rrefviewname">ãã¥ã¼å</a></strong></pre>
+ </div>
+
+<div class="example"> <pre><strong>DROP VIEW AnIdentifier</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æã®ä¾å</h4>
+<p>ãã¥ã¼ãåç
§ããæã¯ããã¥ã¼ãç ´æ£ãããã¨ãã«ç¡å¹ã«ãªãã¾ãããã¥ã¼ã«éããã«ã¼ã½ã«ãããå ´åãDROP VIEWã¯å®è¡ã§ãã¾ããããã¥ã¼ãä¾åãã¦ããæ
å ±ãç ´æ£ããåã«ããã¥ã¼ã¯ç ´æ£ãããªããã°ãªãã¾ããã</p>
+ </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="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>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj61102.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj61998.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj61998.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj61998.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,99 @@
+<!--
+ 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="LOCATE颿°" />
+<meta content="LOCATE function" name="DC.subject" />
+<meta content="LOCATE function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj61998" 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>LOCATE颿°</title>
+</head>
+<body id="rrefsqlj61998"><a name="rrefsqlj61998"><!-- --></a>
+
+
+<h1 class="topictitle1">LOCATE颿°</h1>
+
+
+<div>
+ <div class="section">
+ <p>LOCATE颿°ã使ã£ã¦ãæååã®ä¸è´ããç®æãä»ã®æååããæ¢ãåºããã¨ãã§ãã¾ããæååãè¦ã¤ãã£ãå ´åãLOCATEã¯è¦ã¤ãã£ãä½ç½®ãè¿ãã¾ããè¦ã¤ãããªãã£ãå ´åãLOCATEã¯0ãè¿ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre id="rrefsqlj61998__i1195050"><a name="rrefsqlj61998__i1195050"><!-- --></a><strong>LOCATE(<em>æåå¼</em>, <em>æåå¼</em> [, <em>éå§ä½ç½®</em>] ) </strong>
+ </pre>
+
+ <div class="p">LOCATE颿°ã«ã¯å¿
é ãªäºã¤ã®å¼æ°ã¨ãä»»æã§æå®ã§ããä¸ã¤ç®ã®å¼æ°ãããã¾ãã
+ <ul>
+ <li>æåã®æåå¼ã§æå®ãããæåå<strong>ã</strong>æ¢ãåºããã¾ãã</li>
+
+ <li>äºã¤ç®ã®æåå¼ã§æå®ãããæåå<strong>ãã</strong>ãæ¢ãåºããã¾ãã</li>
+
+ <li>ä¸ã¤ç®ã®å¼æ°ã¯éå§ä½ç½®ã§ãäºã¤ç®ã®å¼æ°ã®ã©ã®ä½ç½®ããæååãæ¢ãåºãããæå®ãã¾ããããä¸ã¤ç®ã®å¼æ°ãæå®ãããªããã°ãLOCATE颿°ã¯äºã¤ç®ã®å¼æ°ã®é ããæååãæ¢ãåºãã¾ãã</li>
+
+ </ul>
+</div>
+
+ <p>LOCATEã®è¿ãå¤ã¯æ´æ°ã§ããLOCATE颿°ã¯äºã¤ç®ã®å¼æ°ã®ãã¡ã§ãä¸ã¤ç®ã®å¼æ°ãæåã«è¦ã¤ãã£ãä½ç½®ãè¡¨ãæ´æ°ãè¿ãã¾ãããã®ä½ç½®ã¯1ããå§ã¾ãã¾ãã
+ããäºã¤ç®ã®å¼æ°ããä¸ã¤ç®ã®å¼æ°ãè¦ã¤ãããªãã£ãå ´åãLOCATEã¯0ãè¿ãã¾ããããä¸ã¤ç®ã®å¼æ°ã空æåå('')ã ã£ãå ´åã¯äºã¤ç®ã®å¼æ°ã空æååã§ãã£ãã¨ãã¦ããLOCATEã¯ä¸ã¤ç®ã®å¼æ°(ããæå®ããã¦ããªããã°1)ãè¿ãã¾ãã
+ããããã®æåå¼ã«NULLãæ¸¡ãããå ´åã¯NULLãè¿ãã¾ãã</p>
+
+</div>
+
+<div class="example">
+ <pre><strong><span>-- 'love'ã2ã®ä½ç½®ã§è¦ã¤ããã®ã§2ãè¿ãã</span>
+ VALUES LOCATE('love', 'clover')</strong></pre>
+
+ <pre><strong><span>-- 'clover'ãã'stove'ã¯è¦ã¤ãããªãã®ã§0ãè¿ãã</span>
+ VALUES LOCATE('stove', 'clover')</strong></pre>
+
+ <pre><strong><span>-- 5ãè¿ãã(éå§ä½ç½®ã¯4)</span>
+ VALUES LOCATE('iss', 'Mississippi', 4)</strong></pre>
+
+ <pre><strong><span>-- 空æååã¯ç¹å¥ã§1ãè¿ãã</span>
+ VALUES LOCATE('', 'ABC')</strong></pre>
+
+ <pre><strong><span>-- ''ãã'AAA'ã¯è¦ã¤ãããªãã®ã§0ãè¿ãã</span>
+ VALUES LOCATE('AAA', '')</strong></pre>
+
+ <pre><strong><span>-- 3ãè¿ãã</span>
+ VALUES LOCATE('', '', 3)</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/rrefsqlj61998.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj66113.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj66113.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj66113.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,67 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="COUNT(*) 颿°" />
+<meta content="COUNT(*) aggregate function" name="DC.subject" />
+<meta content="COUNT(*) aggregate function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj66113" 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>COUNT(*) 颿°</title>
+</head>
+<body id="rrefsqlj66113"><a name="rrefsqlj66113"><!-- --></a>
+
+
+<h1 class="topictitle1">COUNT(*) 颿°</h1>
+
+
+<div>
+<div class="section"> <p>COUNT(*) ã¯è¡æ°ãæ°ããéç´é¢æ°ã§ããNULLãéè¤ã¯æé¤ããã¾ãããCOUNT(*)ã¯å¼ã¸ã®æä½ã§ã¯ããã¾ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åå¸</h4><pre><strong>COUNT(*)</strong></pre>
+
+<p>çµæã®ãã¼ã¿åã¯<a href="rrefsqlj10696.html#rrefsqlj10696">INTEGER</a>ã§ãã</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- Flightsã¨ãã表ã«ããè¡æ°ãæ°ãã¾ãã</span>
+SELECT COUNT(*)
+FROM Flights</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/rrefsqlj66113.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj73147.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj73147.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj73147.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="SQRT颿°" />
+<meta content="SQRT function" name="DC.subject" />
+<meta content="SQRT function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj73147" 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>SQRT颿°</title>
+</head>
+<body id="rrefsqlj73147"><a name="rrefsqlj73147"><!-- --></a>
+
+
+<h1 class="topictitle1">SQRT颿°</h1>
+
+
+<div>
+<div class="section"> <p>æµ®åå°æ°ç¹æ°ã®å¹³æ¹æ ¹ãè¿ãã¾ããé©ç¨å¯è½ãªçµè¾¼ã¿ã®åã¯ã<a href="rrefsqlj14122.html#rrefsqlj14122">宿°</a>ã<a href="rrefsqlj27281.html#rrefsqlj27281">å精度浮åå°æ°ç¹æ°</a>ã<a href="rrefsqljdoubleprecision.html#rrefsqljdoubleprecision">å精度浮åå°æ°ç¹æ°</a>ã«éããã¾ãã
+SQRTãè¿ãå¤ã®ãã¼ã¿åã¯ã弿°ã®ãã¼ã¿åã¨åãã§ãã</p>
+
+<div class="note"><span class="notetitle">注: </span>ä»ã®ãã¼ã¿åã«ã¤ãã¦SQRTãå®è¡ããã«ã¯ãæµ®åå°æ°ç¹æ°ã«å¤æããå¿
è¦ãããã¾ãã</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre id="rrefsqlj73147__i1195048"><a name="rrefsqlj73147__i1195048"><!-- --></a><strong>SQRT(<em>æµ®åå°æ°ç¹æ°å¼</em>)</strong></pre>
+ </div>
+
+<div class="example"> <pre><strong>-- è² æ°ã®è¡ããã£ãå ´åãä¾å¤ãçºçãã¾ãã
+VALUES SQRT(3421E+09)
+
+-- INTEGERã®æ°ãæµ®åå°æ°ç¹æ°ã«å¤æããå¾ãå¹³æ¹æ ¹ãæ±ãã¾ãã
+SELECT SQRT(myDoubleColumn) FROM MyTable
+
+VALUES SQRT (CAST(25 AS FLOAT));</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/rrefsqlj73147.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj75638.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj75638.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj75638.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,162 @@
+<!--
+ 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 content="Territories, supported" name="DC.subject" />
+<meta content="Territories, supported" name="keywords" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj75638" 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="rrefsqlj75638"><a name="rrefsqlj75638"><!-- --></a>
+
+
+<h1 class="topictitle1">å©ç¨å¯è½ãªå°åæ
å ±</h1>
+
+
+<div>
+<div class="section"><p>å©ç¨å¯è½ãªå°åæ
å ±ã以ä¸ã«æãã¾ãã</p>
+</div>
+
+<div class="section"><div class="p">
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all">
+<thead align="left">
+<tr>
+<th valign="top" id="N10064">å°å</th>
+
+<th valign="top" id="N1006C"><span>Derby</span>ã®å°åè¨å®(derby.territory)</th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" headers="N10064 ">ä¸å½èª(ç°¡ä½å)</td>
+
+<td valign="top" headers="N1006C ">zh_CN</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10064 ">ä¸å½èª(ç¹ä½å)</td>
+
+<td valign="top" headers="N1006C ">zh_TW</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10064 ">ãã§ã³èª</td>
+
+<td valign="top" headers="N1006C ">cs</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10064 ">ãã©ã³ã¹èª</td>
+
+<td valign="top" headers="N1006C ">fr</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10064 ">ãã¤ãèª</td>
+
+<td valign="top" headers="N1006C ">de_DE</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10064 ">ãã³ã¬ãªã¼èª</td>
+
+<td valign="top" headers="N1006C ">hu</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10064 ">ã¤ã¿ãªã¢èª</td>
+
+<td valign="top" headers="N1006C ">it</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10064 ">æ¥æ¬èª</td>
+
+<td valign="top" headers="N1006C ">ja_JP</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10064 ">éå½èª</td>
+
+<td valign="top" headers="N1006C ">ko_KR</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10064 ">ãã¼ã©ã³ãèª</td>
+
+<td valign="top" headers="N1006C ">pl</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10064 ">ãã«ãã¬ã«èª(ãã©ã¸ã«èª)</td>
+
+<td valign="top" headers="N1006C ">pt_BR</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10064 ">ãã·ã¢èª</td>
+
+<td valign="top" headers="N1006C ">ru</td>
+
+</tr>
+
+<tr>
+<td valign="top" headers="N10064 ">ã¹ãã¤ã³èª</td>
+
+<td valign="top" headers="N1006C ">es</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+</div>
+
+</div>
+
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj75638.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj81859.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj81859.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj81859.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,268 @@
+<!--
+ 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="ALTER TABLE æ" />
+<meta content="ALTER TABLE statement, Compressing tables, Tables, altering, compressing, Columns, adding, Constraints, dropping, Defaults, Adding Columns, Adding Constraints, Dropping Constraints, setting, changing lock granularity for, Data types, modifying" name="DC.subject" />
+<meta content="ALTER TABLE statement, Compressing tables, Tables, altering, compressing, Columns, adding, Constraints, dropping, Defaults, Adding Columns, Adding Constraints, Dropping Constraints, setting, changing lock granularity for, Data types, modifying" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj81859" 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>ALTER TABLE æ</title>
+</head>
+<body id="rrefsqlj81859"><a name="rrefsqlj81859"><!-- --></a>
+
+
+<h1 class="topictitle1">ALTER TABLE æ</h1>
+
+
+<div>
+<div class="section"><div class="p">The ALTER TABLE æã«ããæ¬¡ã®ãã¨ãå¯è½ã§ãã<ul>
+<li>表ã«åã追å ããã</li>
+
+<li>表ã«å¶ç´ã追å ããã</li>
+
+<li>表ã®åãç ´æ£ããã</li>
+
+<li>表ã«ããå¶ç´ãç ´æ£ããã</li>
+
+<li>VARCHAR, CHAR VARYING, and CHARACTER VARYING åã®å¹
ãå¢ããã</li>
+
+<li>表ã«å®ç¾©ãããè¡ã¬ãã«ã®ããã¯ã䏿¸ãããã(ãããã¯ä¸æ¸ããããå
容ãç ´æ£ããã)</li>
+
+<li>èå¥ååã®å¢åå¤ãéå§å¤ã夿´ããã</li>
+
+<li>åãNullå¯ã§ãããå¦ã夿´ããã</li>
+
+<li>åã®è¦å®å¤ã夿´ããã</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4><pre><strong>ALTER TABLE <em><a href="rreftablename.html#rreftablename">表å</a></em>
+{
+ ADD COLUMN <em><a href="rrefsqlj81859.html#rrefsqlj81859__rrefaltercolumndef">åå®ç¾©</a></em> |
+ ADD <em><a href="rrefsqlj13590.html#rrefsqlj13590">CONSTRAINTç¯</a></em> |
+ DROP [ COLUMN ] åå [ CASCADE | RESTRICT ]
+ DROP { PRIMARY KEY | FOREIGN KEY å¶ç´å | UNIQUE
+ å¶ç´å | CHECK å¶ç´å | CONSTRAINT å¶ç´å }
+ ALTER [ COLUMN ] <em><a href="rrefsqlj81859.html#rrefsqlj81859__rrefsqlj37860">åå®ç¾©å¤æ´</a></em> |
+ LOCKSIZE { ROW | TABLE }
+}</strong></pre>
+</div>
+
+<div class="example" id="rrefsqlj81859__rrefaltercolumndef"><a name="rrefsqlj81859__rrefaltercolumndef"><!-- --></a><h4 class="sectiontitle">åå®ç¾©</h4> <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> ]</strong></pre>
+
+<p><var class="varname">æ¢å®å¶ç´å¼</var>ã®è©³ç´°ã«ã¤ãã¦ã¯ã<a href="rrefsqlj30540.html#sqlj64478">åã®æ¢å®</a>ãåç
§ãã¦ãã ããã</p>
+</div>
+
+<div class="example" id="rrefsqlj81859__rrefsqlj37860"><a name="rrefsqlj81859__rrefsqlj37860"><!-- --></a><h4 class="sectiontitle">åå®ç¾©å¤æ´</h4><pre><strong><em>åå</em> SET DATA TYPE VARCHAR(integer) |
+<em>column-name</em> SET INCREMENT BY 宿´æ° |
+<em>column-name</em> RESTART WITH 宿´æ° |
+<em>column-name</em> [ NOT ] NULL |
+<em>column-name</em> [ WITH ] DEFAULT æ¢å®å¤</strong> </pre>
+</div>
+
+<div class="section"><p>åå®ç¾©å¤æ´ã®SET INCREMENT BY 宿´æ°ã«ãããèå¥ååã®ã¨ãé£ç¶ããå¤ã®ééãè¨å®ããã¾ããèå¥ååãã¨ã次ã®å¤ã¯ãæå¾ã«ã¨ãããå¤ã«å¢åãå ç®ãããå¤ã¨ãªãã¾ãããã®å ´ååã«ã¯ãããããIDENTITY屿§ãå®ç¾©ããã¦ããªããã°ãªãã¾ããã</p>
+<div class="p">RESTART WITH 宿´æ°ã«ãããèå¥ååãã¨ã次ã®å¤ãè¨å®ããã¾ããRESTART WITHã¯ãGENERATED BY DEFAULTãå®ç¾©ãããã䏿ãã¼ãæã¤èå¥ååã®ãã表ã«ä½¿ãã¨ä¾¿å©ã§ããGENERATED BY DEFAULTã¯æç¤ºçã«å¤ãæ¿å
¥ãããã¨ããã³ãæé»çã«ã·ã¹ãã ãçºçªããå¤ãæ¿å
¥ãããã¨ã®ããããã許ããããæç¤ºçã«æ¿å
¥ãããå¤ãã·ã¹ãã ãçºçªããå¤ã¨ã®éã§ç«¶åããäºããããã¾ãããã®ç«¶åãåé¿ã�
�ãããã«ãRESTART WITHã«ããèå¥ååã§æ¬¡ã«çºçªãããå¤ãè¨å®ããäºãã§ããã®ã§ããèªåçã«çºçªãããå¤ã¨æåã§æ¿å
¥ãããæ
å ±ããããæ¬¡ã®ä¾ã«ã¤ãã¦èãã¦ã¿ã¦ãã ããã
+<pre><strong>CREATE TABLE tauto(i INT GENERATED BY DEFAULT AS IDENTITY, k INT)
+CREATE UNIQUE INDEX tautoInd ON tauto(i)
+INSERT INTO tauto(k) values 1,2</strong></pre>
+</div>
+
+<div class="p">ã·ã¹ãã ã¯èªåçã«èå¥ååã«å¯¾ãã¦æ°å¤ãçºçªãã¾ããããããªãããããªãã¯æåã§èå¥ååã«å¹¾ã¤ãã®å¤ãæ¿å
¥ããªããã°ãªãã¾ããã§ããã
+<pre><strong>INSERT INTO tauto VALUES (3,3)
+INSERT INTO tauto VALUES (4,4)
+INSERT INTO tauto VALUES (5,5)</strong></pre>
+</div>
+
+<div class="p">èå¥ååã«ã¯ãã®æç¹ã§1ãã5ã®å¤ãããã¾ããããã§ããªããã·ã¹ãã ã«å¤ãçºçªãããã¨ãã·ã¹ãã ã¯3ã¨ããå¤ãçºçªãã¾ãããã®å¤ã«ãã䏿ãã¼ä¾å¤ãçºçãã¾ãããªããªã3ã¨ããå¤ã¯æ¢ã«æåã§æ¿å
¥ããã¦ãã¾ã£ã¦ããããã§ããæåã§å¤ãæ¿å
¥ããã®ã§å¾å¦çã¨ãã¦ãèå¥ååã«å¯¾ãã¦RESTART WITH 6 ã®ALTER TABLEæãçºè¡ãã¾ãã
+<pre><strong>ALTER TABLE tauto ALTER COLUMN i RESTART WITH 6</strong></pre>
+</div>
+<p>ALTER
+TABLE ã¯è¡¨ãåç
§ãããããªããã¥ã¼ã«ãå½±é¿ãã¾ãããããã¯SELECTä¸è¦§ã«"*"ãæã£ã¦ãã¦ãç¶ãã§ããæ°ãã追å ãããåããã¥ã¼ããè¦ããããã«ããçºã«ã¯ããã¥ã¼ãç ´æ£ãã¦ä½ãç´ããªããã°ãªãã¾ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åã®è¿½å </h4>
+<p><em>追å ããåã®<a href="rrefsqlj81859.html#rrefsqlj81859__rrefaltercolumndef">åå®ç¾©</a></em>ã¯ãæ§æã®ä¸ã§CREATE TABLEæã®åã¨åãã§ããã§ããããåã®å¶ç´ãALTER TABLE ADD COLUMNæã®æ°ããåã«æ¸ããã¨ãã§ãã¾ããããããªãããæ¢åã®ãã¼ãã«ã«NOT NULLå¶ç´ã®ããåã追å ãããã¨ã¯ããã®åã«æ¢å®å¤ãä¸ããå ´åã®ã¿å¯è½ã§ãããããªããã°ãALTER TABLEæãå®è¡ãããã¨ããä¾å¤ãçºçãã¾ãã</p>
+
+<p>CREATE TABLEã¨åæ§ãåå®ç¾©ã«ä¸æãããã¯ä¸»ãã¼å¶ç´ãããå ´åãåã¯nullå¤ãã¨ããã¨ãã§ãã¾ããããããã£ã¦ãNOT NULL屿§ãå¿
è¦ã§ãã(SQLSTATE 42831)
+</p>
+<div class="note"><span class="notetitle">注: </span>è¡¨ã«æç¤ºçãªåä¸è¦§ãæå®ãããªãUPDATEããªã¬ãå®ç¾©ããã¦ããå ´åããã®è¡¨ã«åã追å ããã¨ã追å ãããåã¯UPDATEããªã¬ã®æé»çãªæ´æ°åä¸è¦§ã«è¿½å ããã¾ããããã«æ°ããåãæ¾ããã¨ãã§ãããããæ¨ç§»å¤æ°ã¸ã®å
¨ã¦ã®åç
§ã¯ç¡å¹ã¨ãªãã¾ãã</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">å¶ç´ã®è¿½å </h4>
+<div class="p">ALTER TABLE ADD CONSTRAINTã«ãã表ãã¨ã®å¶ç´ãæ¢åã®è¡¨ã«è¿½å ããã¾ãããããã種é¡ã®è¡¨ãã¨ã®å¶ç´ãALTER TABLEã§è¿½å ã§ãã¾ãããã ããæ¢åã®è¡¨ã¸ã®å¶ç´ã®è¿½å ã«ã¯æ¬¡ã®æ©è½ä¸ã®å¶éãããã¾ãã<ul>
+<li>å¤é¨ãã¼ããã§ãã¯å¶ç´ãæ¢åã®è¡¨ã«è¿½å ãããã¨ã<span>Derby</span>ã¯æ¢åã®è¡ãå¶ç´ã«éåããªããã表ã調ã¹ã¾ããããããããã®è¡ãå¶ç´ã«éåããå ´åã<span>Derby</span>ã¯ä¾å¤ãæãã¦å¶ç´ã¯è¿½å ããã¾ããã</li>
+
+<li>主ãã¼ã«å«ã¾ããããããåã¯nullã§ãªãå¤ãã¨ããªããã°ãªãããã¾ã䏿ã§ãªããã°ãªãã¾ããã<p>ALTER TABLE ADD UNIQUEãPRIMARY KEYã¯ãåä¸ã®åã«ãã主ãã¼ãå®ç¾©ããç°¡åãªæ¹æ³ãæä¾ãã¾ããããPRIMARY KEYãCã¨ããåã®å®ç¾©ã«æ¸ããããããå ´åãããã¯PRIMARY KEY(C)ã¨ããå¥ã®ç¯ã«æ¸ããã®ã¨åãã§ããåã¯nullã®å¤ãã¨ã£ã¦ã¯ãªããªãã®ã§ãNOT NULL屿§ãæå®ãããªããã°ãªãã¾ããã</p>
+</li>
+
+</ul>
+</div>
+<p>å¶ç´ã®æ§æã«ã¤ãã¦ã®è©³ç´°ã¯ã<a href="rrefsqlj13590.html#rrefsqlj13590">CONSTRAINT ç¯</a>ãèªãã§ãã ããã
+ADD TABLE ADD CONSTRAINTã¨ããæ¸ãæ¹ã«ã¦ãå¶ç´ã追å ããå ´åã¯ã表æ¯ã®å¶ç´ã®æ§æã«å¾ã£ã¦ãã ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åã®ç ´æ£</h4><p>ALTER TABLE DROP COLUMNã«ããã表ããåãç ´æ£ã§ãã¾ãã</p>
+
+<p>COLUMNã¨ãããã¼ã¯ã¼ãã¯ç¡ãã¦ããã¾ãã¾ããã</p>
+
+<p>CASCADEãRESTRICTããç¡ãã¦ãã¾ãã¾ãããã©ã¡ããæå®ããªãã£ãå ´åãæ¢å®ã¯CASCADEã§ãã</p>
+
+<p>
+RESTRICTã®å ´åãä¾åãã¦ããã¹ãã¼ãã®æ
å ±ãç¡å¹ã«ãªããªãã°ãåã®ç ´æ£ã¯å¤±æãã¾ãã</p>
+
+<p>
+CASCADEã®å ´åãåã®ç ´æ£ã¨ä½µãã¦ãç¡å¹ã«ãªãã¹ãã¼ãã®æ
å ±ãç ´æ£ããã¾ãã</p>
+
+<p>
+DROP COLUMN RESTRICTã失æããåå ã¨ãªãã¹ãã¼ãã®æ
å ±ã«ã¯ã次ãå«ã¾ãã¾ãã
+ãã¥ã¼ãããªã¬ã主ãã¼å¶ç´ãå¤é¨ãã¼å¶ç´ã䏿ãã¼å¶ç´ããã§ãã¯å¶ç´ã忍©éãç ´æ£ããåã«ä¾åããããããã®æ
å ±ãããã°ãDROP COLUMN RESTRICTã¯å¤±æãã¾ãã</p>
+
+<p>
+表ã«ã²ã¨ã¤ãããªãåã¯ãç ´æ£ãããã¨ãã§ãã¾ããã</p>
+
+<p>
+sqlAuthorizationãçã§ããå ´åãåãåé¤ãããã¨ã¯ã§ãã¾ããã(DERBY-1909ãåç
§ãã¦ãã ããã)
+)</p>
+
+<p>
+åãç´¢å¼ã«ã¦ä½¿ããã¦ãããå¦ãã«ããããããåã®ç ´æ£ã¯CASCADE/RESTRICTã®ã©ã¡ãã§ãåãããã«è¡ããã¾ããåãç ´æ£ãããã¨ããç´¢å¼ã«ãããã®åãåãé¤ããã¾ãããã®åãç´¢å¼ã«ãããã ã²ã¨ã¤ã®åã§ãã£ãå ´åãç´¢å¼å
¨ä½ãç ´æ£ããã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">å¶ç´ã®ç ´æ£</h4><p>ALTER TABLE DROP CONSTRAINTã«ãã表ã®å¶ç´ãç ´æ£ã§ãã¾ããååä»ããã¦ããªãå¶ç´ãç ´æ£ããããã«ã¯ã<em>SYS.SYSCONSTRAINTS</em>ã«è¨é²ããã¦ããèªåçæãããå¶ç´ã®ååãããªãããããèå¥åã¨ãã¦æå®ããå¿
è¦ãããã¾ãã</p>
+
+<p>主ãã¼ã»ä¸ææ§ã»å¤é¨ãã¼å¶ç´ãç ´æ£ããã¨ããã®å¶ç´ãæ©è½ããããã«åå¨ãã¦ããç´¢å¼ãç ´æ£ããã¾ãã(ãã®ç´¢å¼ã¯<em>æ¯æ´ç´¢å¼</em>ã¨ãå¼ã°ãã¾ãã)</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åã®å¤æ´</h4>
+<div class="p"><em><a href="rrefsqlj81859.html#rrefsqlj81859__rrefsqlj37860">åå®ç¾©å¤æ´</a></em>ã«ãããååã®ããåã夿´ã§ãã¾ããå¯è½ãªå¤æ´å
容ã¯ä»¥ä¸ã®ã¨ããã§ãã
+<ul>
+<li>VARCHARåã®é·ããå¢ãããã¨ãã§ãã¾ããVARCHARã¨ãããã¼ã¯ã¼ãã®ä»£ããã«ãCHARACTER VARYINGãCHAR VARYINGã使ããã¨ãã§ãã¾ãã
+<p>ãããã®åã®å¹
ãå¢ããããã«ã¯ããã¼ã¿åã¨æ°ãããµã¤ãºãååã®å¾ã«æ¸ãã¾ãã</p>
+
+<p>åã®å¹
ãæ¸ããããããã¼ã¿åã夿´ãããããäºã¯ã§ãã¾ããã主ãã¼ã®ä¸é¨ããå¤é¨ãã¼å¶ç´ããåç
§ããã¦ãã䏿ãã¼ãå¤é¨ãã¼å¶ç´ã®ä¸é¨ã§ããåã®å¹
ã¯å¤æ´ã§ãã¾ããã</p>
+</li>
+
+<li>èå¥ååã®ã¨ãé£ç¶ããå¤ã®ééãæå®ãããã¨ãã§ãã¾ãã<p>
+èå¥ååã®ã¨ãé£ç¶ããå¤ã®ééãè¨å®ããããã«ã¯ã宿´æ°ãä¸ãã¾ãããããããåã«ã¯èå¥å屿§ãä¸ãããã¦ããªããã°ãªãã¾ããã(SQLSTATE 42837)ããè¡¨ã«æ¢ã«è¡ãããå ´åãåã®SET INCREMENT defaultãå ç®ãããå¤ã¯å¤æ´ããã¾ããã</p>
+</li>
+
+<li>åã®Nullã¸ã®å¶ç´ã®å¤æ´
+åãNullãã¨ãäºã¸ã®å¶ç´ã夿´ã§ãã¾ãã
+ <p>NOT NULLå¶ç´ãæ¢åã®åã«ä¸ãããã¨ãã§ãã¾ãããããè¡ãå ´åãæ¢åã®NULLå¤ã表ã®ãã®åã«åå¨ãã¦ã¯ãªãã¾ããã</p>
+
+ <p>NOT NULLå¶ç´ãæ¢åã®åããåãé¤ããã¨ãã§ãã¾ãããããè¡ãå ´åããã®åãPRIMARY KEYãUNIQUEã®å¶ç´ã«ã¦ä½¿ããã¦ããåã§ãã£ã¦ã¯ãªãã¾ããã</p>
+</li>
+
+<li>åã®æ¢å®å¤ã夿´ãã</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ¢å®å¤ã®è¨å®</h4><p>æ°è¦ã®åã«æ¢å®å¤ãä¸ãããã¨ãã§ãã¾ããæ¢å®å¤ã¨ã¯å¤ãæå®ãããªãã£ãå ´åã«åã«æ¿å
¥ãããå¤ã§ããããæç¤ºçã«æ¢å®å¤ãä¸ãããã¦ããªãã£ãå ´åãåã®æ¢å®å¤ã¯NULLã§ããããæ°ããåã«æ¢å®å¤ãä¸ããå ´åã表ã«ããæ¢åã®è¡ã¯ãã®æ°åã«æ¢å®å¤ãã¨ããã¨ã¨ãªãã¾ãã</p>
+<p>æ¢å®å¤ã®ããè©³ç´°ãªæ
å ±ã«ã¤ãã¦ã¯ã<a href="rrefsqlj24513.html#rrefsqlj24513">CREATE TABLE æ</a>ãåç
§ãã¦ãã ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">表ã®ããã¯ç²åº¦ã®å¤æ´</h4>
+<p>ããããªãã®ã·ã¹ãã ãæ¢å®ã®è¨å®ã§ããè¡æ¯ã®ããã¯ãè¡ãã®ã§ããã°ãLOCKSIZEç¯ã«ãã表ã®è¡æ¯ã®ããã¯ã䏿¸ããããã¨ãã§ãã¾ãã(䏿¹ããªãã®ã·ã¹ãã ã表ãã¨ã®ããã¯ãè¡ãããè¨å®ããã¦ããå ´åã<span>Derby</span>ãLOCKSIZEç¯ã«å¯¾ãã¦ä¾å¤ãæããªãã£ãã¨ãã¦ããããã¯ã®ç²åº¦ãè¡åä½ã®ããã¯ã«å¤æ´ãããã¨ã¯ã§ãã¾ããã)
+表ã®è¡æ¯ã®ããã¯ã䏿¸ãããã«ã¯ã表ã«ããã¯ã®è¨å®ãè¡ãã¾ãã
+ãã表ã表æ¯ã®ããã¯ã§ä½æãããå ´åãALTER TABLEæã«ã¦LOCKSIZEç¯ã使ããã¨ã§ããã®è¨å®ãè¡æ¯ã®è¨å®ã«æ»ããã¨ãã§ãã¾ããããã便å©ãªå ´åãããã®ã§ããããã®è©³ç´°ã«ã¤ãã¦ã¯ã<cite><span><em>Derbyã®ãã¥ã¼ãã³ã°</em></span></cite>ãåç
§ãã¦ãã ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ä¾</h4><pre><strong><span>-- æ¢åã®è¡¨ã«åãã¨ã®å¶ç´ã®ããåã追å ããã
+-- è¡¨ã«æ¢åè¡ããã£ãå ´åãæ¢åè¡ã®æ°åã¯NULLãã¨ãã®ã§ã
+-- ä¾å¤ãçºçããã</span>
+ALTER TABLE CITIES ADD COLUMN REGION VARCHAR(26)
+CONSTRAINT NEW_CONSTRAINT CHECK (REGION IS NOT NULL);
+
+<span>-- æ¢åã®è¡¨ã«ä¸ææ§å¶ç´ã追å ããã
+-- éè¤ãããã¼ããã£ãå ´åãä¾å¤ãçºçããã</span>
+ALTER TABLE SAMP.DEPARTMENT
+ADD CONSTRAINT NEW_UNIQUE UNIQUE (DEPTNO);
+
+<span>-- Cities表ã«å¤é¨ãã¼å¶ç´ã追å ããã
+-- è¡ãå¶ç´ãæºãããæ¤è¨¼ããã¦ã
+-- ããå¶ç´ãæºãããªãè¡ãè¦ã¤ãã£ãå ´åã
+-- å¶ç´ã¯è¿½å ãããªãã</span>
+ALTER TABLE CITIES ADD CONSTRAINT COUNTRY_FK
+Foreign Key (COUNTRY) REFERENCES COUNTRIES (COUNTRY);
+
+<span>-- 主ãã¼å¶ç´ã表ã«è¿½å ããã
+-- æåã«è¡¨ã使ãããã</span>
+CREATE TABLE ACTIVITIES (CITY_ID INT NOT NULL,
+SEASON CHAR(2), ACTIVITY VARCHAR(32) NOT NULL);
+<span>-- ãã主ãã¼ã¨ããåã«nullãéè¤ããå¤ãããå ´åã
+-- ãã®å¶ç´ã追å ãããã¨ã¯ã§ããªãã</span>
+ALTER TABLE Activities ADD PRIMARY KEY (city_id, activity);
+
+<span>-- ããä¾åããæ
å ±ãç¡ããã°ãcity_idåãç ´æ£ãããã</span>
+ALTER TABLE Cities DROP COLUMN city_id RESTRICT;
+<span>-- ä¾åããæ
å ±ã¨ä½µãã¦ãcity_idåãç ´æ£ãããã</span>
+ALTER TABLE Cities DROP COLUMN city_id CASCADE;
+
+<span>-- CITIES表ã®ä¸»ãã¼å¶ç´ãç ´æ£ããã</span>
+ALTER TABLE Cities DROP CONSTRAINT Cities_PK;
+<span>-- CITIES表ã®å¤é¨ãã¼å¶ç´ãç ´æ£ããã</span>
+ALTER TABLE Cities DROP CONSTRAINT COUNTRIES_FK;
+<span>-- æ¢å®å¤ã1ã«ã¨ãDEPTNOåã追å ããã</span>
+ALTER TABLE SAMP.EMP_ACT ADD COLUMN DEPTNO INT DEFAULT 1;
+<span>-- VARCHARåã®åå¹
ãå¢ããã</span>
+ALTER TABLE SAMP.EMP_PHOTO ALTER PHOTO_FORMAT SET DATA TYPE VARCHAR(30);
+<span>-- 表ã®ããã¯ç²åº¦ã夿´ããã</span>
+ALTER TABLE SAMP.SALES LOCKSIZE TABLE;
+
+<span>-- MANAGERåã®NOT NULLå¶ç´ãç ´æ£ããã</span>
+ALTER TABLE Employees ALTER COLUMN Manager NULL;
+<span>-- SSNåã«NOT NULLå¶ç´ã追å ããã</span>
+ALTER TABLE Employees ALTER COLUMN ssn NOT NULL;
+
+<span>-- SALARYåã®æ¢å®å¤ã夿´ããã</span>
+ALTER TABLE Employees ALTER COLUMN Salary DEFAULT 1000.0
+
+</strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æã®çµæ</h4><p>ALTER TABLE æã«ãã夿´ãã表ã«ä¾åããå
¨ã¦ã®æã¯ã次åã®å®è¡ã«ã¦åã³ã³ãã¤ã«ããã¾ãããã夿´ãã表ãåç
§ãããéããã«ã¼ã½ã«ãããå ´åãALTER TABLEã¯è¨±å¯ããã¾ããã</p>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj39374.html" title="">æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj81859.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj89752.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj89752.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj89752.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="åç
§ç¯" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj43125.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj89752" 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="rrefsqlj89752"><a name="rrefsqlj89752"><!-- --></a>
+
+
+<h1 class="topictitle1">åç
§ç¯</h1>
+
+<div>
+<div class="example"> <pre><strong>REFERENCING
+{
+{ OLD | NEW } [ ROW ] [ AS ] correlation-Name [ { OLD | NEW } [ ROW ] [ AS ] correlation-Name ] |
+{ OLD TABLE | NEW TABLE } [ AS ] Identifier [ { OLD TABLE | NEW TABLE } [AS] Identifier ] |
+{ OLD_TABLE | NEW_TABLE } [ AS ] Identifier [ { OLD_TABLE | NEW_TABLE } [AS] Identifier ]
+}</strong></pre>
+
+<div class="note"><span class="notetitle">注: </span>
+<samp class="codeph"><strong>OLD_TABLE | NEW_TABLE</strong></samp>ã¯ã徿¹äºææ§åã³DB2ã¨ã®äºææ§ã®ããã®æ§æã§ããããã¯SQLæ¨æºã«æ²¿ã£ã¦ããªãã®ã§éæ¨å¥¨ã§ãã
+</div>
+
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefsqlj43125.html" title="">CREATE TRIGGER æ</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj89752.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj91438.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj91438.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj91438.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,65 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="æ¤ç´¢æ¡ä»¶" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj13590.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj16095.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj42154.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj16357.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj91438" 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="rrefsqlj91438"><a name="rrefsqlj91438"><!-- --></a>
+
+
+<h1 class="topictitle1">æ¤ç´¢æ¡ä»¶</h1>
+
+<div>
+<div class="section"><p>A <em>æ¤ç´¢æ¡ä»¶</em> ã¨ã¯ã<a href="rrefsqlj13590.html#rrefsqlj13590__sqlj57077">æ¤ç´¢æ¡ä»¶ã®è¦ä»¶</a>ã«ã¦è¨è¿°ãããè¦ä»¶ãæºããã<a href="rrefsqlj23075.html#rrefsqlj23075">çå½å¼</a>ã§ãã</p>
+</div>
+
+<div class="section"><p><em>å¶ç´å</em>ãæç¤ºãããªãã£ãå ´åã<span>Derby</span>ã¯ä¸ææ§å¶ç´åã(åã®å¶ç´ã«ã表ã®å¶ç´ã«ã)çæãã¾ãã</p>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefsqlj13590.html" title="">CONSTRAINT ç¯</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefsqlj16095.html" title="">忝ã®å¶ç´</a></div>
+<div><a href="rrefsqlj42154.html" title="">表ãã¨ã®å¶ç´</a></div>
+<div><a href="rrefsqlj16357.html" title="">åç
§å®ç¾©</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj91438.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj93082.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj93082.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj93082.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,88 @@
+<!--
+ 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="SUBSTR颿°" />
+<meta content="functions, SUBSTR, SUBSTR function" name="DC.subject" />
+<meta content="functions, SUBSTR, SUBSTR function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj93082" 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>SUBSTR颿°</title>
+</head>
+<body id="rrefsqlj93082"><a name="rrefsqlj93082"><!-- --></a>
+
+
+<h1 class="topictitle1">SUBSTR颿°</h1>
+
+
+<div>
+<div class="section">
+<p>SUBSTR颿°ã¯æååå¼ãããã¯ãããåå¼ã«ä½ç¨ãã¾ãã
+çµæã®ãã¼ã¿åã¯ãããããåè
ã®å ´åã¯<a href="rrefsqlj41207.html#rrefsqlj41207">VARCHAR</a>ã§ãå¾è
ã®å ´åã¯<a href="rrefsqlj32714.html#rrefsqlj32714">VARCHAR FOR
+BIT DATA</a>ã§ãã
+çµæã®æå¤§é·ã¯å
ã®å¼æ°ã®åã®æå¤§é·ã§ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4><pre>SUBSTR({ <em>æåå¼</em> },
+ <em>éå§ä½ç½®</em> [, <em>åã®é·ã</em> ] )</pre>
+
+<p>弿°ã®<em>éå§ä½ç½®</em>ã¨çç¥å¯è½ãª<em>åã®é·ã</em>ã¯ã©ã¡ããæ´æ°å¼ã§ãã
+å
é ã®æåãããã¯ãããã®<em>éå§ä½ç½®</em>ã¯1ã§ãã
+ãã0ãä¸ããããå ´åã<span>Derby</span>ã¯1ãä¸ãããããã®ã¨ã¿ãªãã¾ãã</p>
+
+<p><em>æåå¼</em>ã®ãã¼ã¿åã¯CHARãVARCHARãLONG VARCHARããããã¯(ãããå¼ã§ã¯ãªã)æååã«æé»ã®ãã¡ã«å¤æå¯è½ãªçµã¿è¾¼ã¿åã®ä½ããã§ãã</p>
+
+<p>æåå¼ã§ã¯<em>éå§ä½ç½®</em>ããã³<em>åã®é·ã</em>ã¨ãããã©ã¡ã¼ã¿ã¯æåãããã¾ãããããå¼ã«ã¤ãã¦ã¯ã<em>éå§ä½ç½®</em>ããã³<em>åã®é·ã</em>ã¨ãããã©ã¡ã¼ã¿ã¯ããããããã¾ãã</p>
+
+<p>ãã<em>éå§ä½ç½®</em>ãæ£ã§ããã°ããã®æ°ã¯åºã¨ãªãå¼ã®å
é ããæ°ããä½ç½®ãæãã¾ãã(å
é ã®æåã¯1ã¨æ°ãã¾ãã)<em>éå§ä½ç½®</em>ã¯è² ã¨ãããã¨ãã§ãã¾ããã</p>
+
+<p>ãã<em>åã®é·ã</em>ãæå®ãããªãã£ãå ´åãSUBSTRã¯å¼ã®<em>éå§ä½ç½®</em>ããæ«å°¾ã¾ã§ã®é¨ååãè¿ãã¾ãããã<em>åã®é·ã</em>ãæå®ãããå ´åãSUBSTRã¯<em>éå§ä½ç½®</em>ããå§ã¾ã<em>åã®é·ã</em>ã®ãVARCHARãããã¯VARBITãè¿ãã¾ãã
+ãã<em>åã®é·ã</em>ã«è² ã®æ°ãä¸ããããå ´åãSUBSTR颿°ã¯ã¨ã©ã¼ãè¿ãã¾ãã</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4>
+<div class="p"><samp class="codeph">hello</samp>ã¨ããåèªã®äºã¤ç®ã®æåããæå¾ã¾ã§ã®é¨ååãè¿ãã«ã¯ã次ã®ãããªç¯ãæ¸ãã¾ãã<pre>VALUES SUBSTR('hello', 2)</pre>
+
+çµæã¯'<samp class="codeph">ello</samp>'ã¨ãªãã¾ãã</div>
+
+<div class="p"><samp class="codeph">hello</samp>ã¨ããåèªã®æåã®æåããäºã¤ç®ã®æåã¾ã§ã®é¨ååãè¿ãã«ã¯ã次ã®ãããªç¯ãæ¸ãã¾ãã<pre>VALUES SUBSTR('hello',1,2)</pre>
+
+çµæã¯'<samp class="codeph">he</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/rrefsqlj93082.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj95598.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj95598.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj95598.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,74 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="RENAME INDEX æ" />
+<meta content="RENAME INDEX statement" name="DC.subject" />
+<meta content="RENAME INDEX statement" 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="rrefsqljrenametablestatement.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj95598" 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>RENAME INDEX æ</title>
+</head>
+<body id="rrefsqlj95598"><a name="rrefsqlj95598"><!-- --></a>
+
+
+<h1 class="topictitle1">RENAME INDEX æ</h1>
+
+
+<div>
+<div class="section"> <p>ãã®æã§ãç¾å¨ã®ã¹ãã¼ãã«ããç´¢å¼ã®ååã夿´ã§ãã¾ãã
+ã¦ã¼ã¶ã¯<em>SYS</em>ã¹ãã¼ãã«ããç´¢å¼ã®ååã夿´ã§ãã¾ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>RENAME INDEX <em>ç´¢å¼å</em> TO <em>æ°ç´¢å¼å</em></strong></pre>
+ </div>
+
+<div class="example"> <pre><strong>RENAME INDEX DESTINDEX TO ARRIVALINDEX</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æã®ä¾å</h4>
+<p>éããã«ã¼ã½ã«ãããç´¢å¼ã«ã¯ãRENAME INDEX ãå®è¡ã§ãã¾ããã</p>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqljrenamestatements.html" title="">RENAME æ</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefsqljrenamecolumnstatement.html" title="RENAME COLUMN æã§è¡¨ã«ããåã®ååã夿´ã§ãã¾ãã">RENAME COLUMN æ</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/rrefsqlj95598.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj97870.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj97870.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj97870.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,67 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="LTRIM颿°" />
+<meta content="LTRIM function" name="DC.subject" />
+<meta content="LTRIM function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj97870" 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>LTRIM颿°</title>
+</head>
+<body id="rrefsqlj97870"><a name="rrefsqlj97870"><!-- --></a>
+
+
+<h1 class="topictitle1">LTRIM颿°</h1>
+
+
+<div>
+<div class="section"> <p>LTRIMã¯æååå¼ããå
é ã«ããç©ºç½æåã®åãåãé¤ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>LTRIM(<em>æåå¼</em>)</strong></pre>
+ <p>A <em>æåå¼</em>ã®ãã¼ã¿åã¯ãCHARãVARCHARãããã¯LONG VARCHARãããã¯æé»ã«æååã«å¤æå¯è½ãªçµè¾¼ã¿ã®åã§ãã</p>
+
+<p>ãã<em>æåå¼</em>ã®è©ä¾¡ã空ãªããLTRIMã¯NULLãè¿ãã¾ãã</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- 'asdf 'ãè¿ãã¾ãã</span>
+VALUES LTRIM(' asdf ')</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/rrefsqlj97870.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj98067.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj98067.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj98067.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,67 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="ABSã¨ABSVAL颿°" />
+<meta content="ABS or ABSVAL function" name="DC.subject" />
+<meta content="ABS or ABSVAL function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj98067" 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>ABSã¨ABSVAL颿°</title>
+</head>
+<body id="rrefsqlj98067"><a name="rrefsqlj98067"><!-- --></a>
+
+
+<h1 class="topictitle1">ABSã¨ABSVAL颿°</h1>
+
+
+<div>
+<div class="section"> <p>ABS 㨠ABSVALã¯æ°å¼ã®çµ¶å¯¾å¤ãè¿ãã¾ãã
+帰ãå¤ã®åã¯å¼æ°ã®åã¨åãã§ããçµè¾¼ã¿ã®æ°å¤åã¯å
¨ã¦ä½¿ããã¨ãã§ãã¾ãã
+(<a href="rrefsqlj15260.html#rrefsqlj15260">DECIMAL</a>, <a href="rrefsqljdoubleprecision.html#rrefsqljdoubleprecision">DOUBLE PRECISION</a>, <a href="rrefsqlj27281.html#rrefsqlj27281">FLOAT</a>, <a href="rrefsqlj10696.html#rrefsqlj10696">INTEGER</a>ã <a href="rrefsqlj30435.html#rrefsqlj30435">BIGINT</a>ã <a href="rrefsqlj12362.html#rrefsqlj12362">NUMERIC</a>ã <a href="rrefsqlj14122.html#rrefsqlj14122">REAL</a>
+ããã¨<a href="rrefsqlj16221.html#rrefsqlj16221">SMALLINT</a>)ã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre id="rrefsqlj98067__i1195049"><a name="rrefsqlj98067__i1195049"><!-- --></a><strong>ABS(<em>æ°å¼</em>)</strong></pre>
+ </div>
+
+<div class="example"> <pre><strong><span>-- 3ãè¿ãã</span>
+VALUES ABS(-3)</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/rrefsqlj98067.html
------------------------------------------------------------------------------
svn:eol-style = native