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 [14/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/rrefcreatefunctionstatement.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcreatefunctionstatement.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcreatefunctionstatement.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,211 @@
+<!--
+ 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="CREATE FUNCTION æ" />
+<meta name="abstract" content="CREATE FUNCTIONæã«ãããå¼ã§å©ç¨ã§ããJavaé¢æ°ãä½æã§ãã¾ãã" />
+<meta name="description" content="CREATE FUNCTIONæã«ãããå¼ã§å©ç¨ã§ããJavaé¢æ°ãä½æã§ãã¾ãã" />
+<meta content="CREATE FUNCTION statement, CREATE FUNCTION, SQL statements, functions, creating" name="DC.subject" />
+<meta content="CREATE FUNCTION statement, CREATE FUNCTION, SQL statements, functions, creating" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj95081.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj20937.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefcreateprocedurestatement.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj31580.html" />
+<meta scheme="URI" name="DC.Relation" content="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="rrefcreatefunctionstatement" 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>CREATE FUNCTION æ</title>
+</head>
+<body id="rrefcreatefunctionstatement"><a name="rrefcreatefunctionstatement"><!-- --></a>
+
+
+<h1 class="topictitle1">CREATE FUNCTION æ</h1>
+
+
+
+<div><p>CREATE FUNCTIONæã«ãããå¼ã§å©ç¨ã§ããJavaé¢æ°ãä½æã§ãã¾ãã</p>
+
+<div class="section"><p>é¢æ°ã®ææè
ããã³ã<a href="rrefattrib26867.html#rrefattrib26867">ãã¼ã¿ãã¼ã¹ã®ææè
</a>ã¯ãèªåçã«é¢æ°ã¸ã®EXECUTE権éãæã«å
¥ãã¾ããå ãã¦ãä»ã®ã¦ã¼ã¶ã¸ã®æ¨©éä»ä¸ã®æ¨©éãæã«å
¥ãã¾ããé¢æ°ã¨ãã¼ã¿ãã¼ã¹ã®ææè
ãããé¢æ°ã®å®è¡æ¨©éãå¥å¥ªãããã¨ã¯ã§ãã¾ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>CREATE FUNCTION <em><a href="rrefcreatefunctionstatement.html#rrefcreatefunctionstatement__rrefcrprofunctionname">é¢æ°å</a></em> ( [ <a href="rrefcreatefunctionstatement.html#rrefcreatefunctionstatement__rrefcrprofunctionparameter">é¢æ°ã®å¼æ°</a>
+ [, <a href="rrefcreatefunctionstatement.html#rrefcreatefunctionstatement__rrefcrprofunctionparameter">FunctionParameter</a>] ] * ) RETURNS <a href="rrefcreatefunctionstatement.html#rrefcreatefunctionstatement__rrefcrfunctionreturntype">è¿å´ãã¼ã¿å</a> [ <a href="rrefcreatefunctionstatement.html#rrefcreatefunctionstatement__rrefcrprofunctionelement">é¢æ°ã®è¦ç´ </a> ] *</strong></pre>
+</div>
+
+<div class="example" id="rrefcreatefunctionstatement__rrefcrprofunctionname"><a name="rrefcreatefunctionstatement__rrefcrprofunctionname"><!-- --></a><h4 class="sectiontitle">é¢æ°å</h4><pre><strong>[ <em><a href="rrefschemaname.html#rrefschemaname">ã¹ãã¼ãå</a>.</em> ] <em><a href="crefsqlj34834.html#crefsqlj34834">SQL92èå¥å</a></em></strong></pre>
+
+<p>ã¹ãã¼ãåãä¸ããããªãã£ãå ´åãããã©ã«ãã¯ç¾å¨ã®ã¹ãã¼ãã¨ãªãã¾ããéå®ãããé¢æ°åã«ã¦ãã¹ãã¼ãåã¯SYSã§å§ã¾ã£ã¦ã¯ãªãã¾ããã</p>
+</div>
+
+<div class="example" id="rrefcreatefunctionstatement__rrefcrprofunctionparameter"><a name="rrefcreatefunctionstatement__rrefcrprofunctionparameter"><!-- --></a><h4 class="sectiontitle">é¢æ°ã®å¼æ°</h4><pre><strong>[ å¼æ°å ] <em>ãã¼ã¿å</em></strong></pre>
+</div>
+
+<div class="section"><p>å¼æ°åã¯é¢æ°ã«ã¦ä¸æã§ããå¿
è¦ãããã¾ãã</p>
+<p><em>ãã¼ã¿å</em>ã®æ§æã¯ã<a href="crefsqlj31068.html#crefsqlj31068">ãã¼ã¿å</a>ã«æ¸ããã¦ãã¾ãã</p>
+
+<div class="note"><span class="notetitle">注: </span>CREATE FUNCTIONæã®ãã©ã¡ã¼ã¿ã«ã§ããªããã¼ã¿åãããã¾ããããã¯ãBLOBãCLOBãLONG VARCHARãLONG VARCHAR FOR BIT DATAãXMLçã§ãã</div>
+</div>
+
+
+<div class="example" id="rrefcreatefunctionstatement__rrefcrfunctionreturntype"><a name="rrefcreatefunctionstatement__rrefcrfunctionreturntype"><!-- --></a><h4 class="sectiontitle">è¿å´ãã¼ã¿å</h4>
+<pre><strong><a href="rrefcreatefunctionstatement.html#rrefcreatefunctionstatement__rrefcrfunctiontabletype">表å</a> | <em>ãã¼ã¿å</em></strong></pre>
+</div>
+
+<div class="section"><p>ãã¼ã¿åã®æ§æã¯<a href="crefsqlj31068.html#crefsqlj31068">ãã¼ã¿å</a>ã«è¨è¿°ããã¦ãã¾ãã</p>
+</div>
+
+
+<div class="example" id="rrefcreatefunctionstatement__rrefcrfunctiontabletype"><a name="rrefcreatefunctionstatement__rrefcrfunctiontabletype"><!-- --></a><h4 class="sectiontitle">表å</h4>
+<pre><strong>TABLE( <a href="rrefcreatefunctionstatement.html#rrefcreatefunctionstatement__rrefcrfunctioncolelement">åè¦ç´ </a> [, <a href="rrefcreatefunctionstatement.html#rrefcreatefunctionstatement__rrefcrfunctioncolelement">åè¦ç´ </a> ]* )</strong></pre>
+</div>
+
+<div class="section"><p>表é¢æ°ã®è¿ãå¤ã®åã§ããç¾å¨å©ç¨ã§ããã®ã¯Derbyã®è¡¨é¢æ°ã®å½¢å¼ã®ã¿ã§ãã
+ãããã¯JDBCã®<em>ResultSet</em>ãè¿ãé¢æ°ã§ãã
+ãã詳細ãªæ
å ±ã¯ã<cite><span><em>Derby ãã£ããããã¼ãº ã¬ã¤ã</em></span></cite>ã«è¨è¿°ããããDerbyã®è¡¨é¢æ°ã®ããã°ã©ãã³ã°ããåç
§ãã¦ãã ããã</p>
+</div>
+
+
+<div class="example" id="rrefcreatefunctionstatement__rrefcrfunctioncolelement"><a name="rrefcreatefunctionstatement__rrefcrfunctioncolelement"><!-- --></a><h4 class="sectiontitle">åè¦ç´ </h4>
+<pre><strong><em><a href="crefsqlj34834.html#crefsqlj34834">SQL92èå¥å</a></em> <em>ãã¼ã¿å</em></strong></pre>
+</div>
+
+<div class="section"><p><em>ãã¼ã¿å</em>ã®æ§æã¯ã<a href="crefsqlj31068.html#crefsqlj31068">ãã¼ã¿å</a>ã«è¨è¿°ããã¦ãã¾ãã</p>
+
+<div class="note"><span class="notetitle">注: </span>表é¢æ°ããè¿å´ããæ
å ±ã®åã®åããXMLã¨ãããã¨ã¯ã§ãã¾ããã</div>
+</div>
+
+
+<div class="example" id="rrefcreatefunctionstatement__rrefcrprofunctionelement"><a name="rrefcreatefunctionstatement__rrefcrprofunctionelement"><!-- --></a><h4 class="sectiontitle">é¢æ°ã®è¦ç´ </h4> <pre><strong> {
+| LANGUAGE { JAVA }
+| EXTERNAL NAME <em>æåå</em>
+| PARAMETER STYLE <a href="rrefcreatefunctionstatement.html#rrefcreatefunctionstatement__rrefcrfunctionparameterstyle">ãã©ã¡ã¼ã¿ã®ç¨®é¡</a>
+| { NO SQL | CONTAINS SQL | READS SQL DATA }
+| { RETURNS NULL ON NULL INPUT | CALLED ON NULL INPUT }
+ }</strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">LANGUAGE</h4><p><strong>JAVA</strong>- é¢æ°ã¯Javaã®ã¯ã©ã¹ã«ããpublic staticãªã¡ã½ããã¨ãã¦å¼ã°ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">EXTERNAL NAME <em>string</em></h4><div class="p"><em>æåå</em>ã«ãããé¢æ°ãå®è¡ãããã¨ãã«å¼ã°ããJavaã®ã¡ã½ãããè¨è¿°ããã¾ãããã®æååã¯æ¬¡ã®æ¸å¼ã§ãã<pre>ã¯ã©ã¹å.ã¡ã½ããå</pre>
+ããã¯ç©ºç½ãå«ãã§ã¯ãªãã¾ããã</div>
+</div>
+
+
+<div class="example" id="rrefcreatefunctionstatement__rrefcrfunctionparameterstyle"><a name="rrefcreatefunctionstatement__rrefcrfunctionparameterstyle"><!-- --></a><h4 class="sectiontitle">ãã©ã¡ã¼ã¿ã®ç¨®é¡</h4>
+<pre><strong>JAVA | DERBY_JDBC_RESULT_SET</strong></pre>
+</div>
+
+<div class="section">
+<p>
+é¢æ°ã¯Javaè¨èªããã³SQLã«ã¼ãã³ã®ä»æ§ã«æ²¿ã£ã¦ãå¼æ°ãå¤æ¸¡ããã¾ããINOUTã¨OUTã®å¼æ°ã¯å¤æ´å¾ã®å¤ãè¿ããããã«ãè¦ç´ ãã²ã¨ã¤ã®é
åã¨ãã¦æ¸¡ããã¾ããããã«çµæã»ããã¯Javaã®ã¡ã½ããã®ãã©ã¡ã¼ã¿ãçµã¦ãé
åã«æ¸¡ããjava.sql.ResultSet[]åã®è¦ç´ ã«ããè¿ããã¨ãã§ãã¾ãã</p>
+<p><span>Derby</span> ã¯é·ãåã®å(ããã¯ä¾ãã°Long VarcharãBLOBçã®ãã¨ã§ãã)ããµãã¼ããã¾ããã
+ãããã®é·ãåã®åã使ããã¨ããã¨ãã¨ã©ã¼ãçºçãã¾ãã</p>
+
+<p>Derbyã®è¡¨é¢æ°ã®å ´åãPARAMETER STYLEã¯å¸¸ã«DERBY_JDBC_RESULT_SETã§ããã以å¤ã®å¤ã¨ãããã¨ã¯ã§ãã¾ããã表é¢æ°ã¨ã¯<a href="rrefcreatefunctionstatement.html#rrefcreatefunctionstatement__rrefcrfunctiontabletype">表å</a>ãè¿ãé¢æ°ã§ãJDBCã®<em>ResultSet</em>ãè¿ãã¡ã½ããã«å¯¾å¿ãã¾ãã
+ãã以å¤ã®å ´åã¯ãPARAMETER STYLEã¯å¸¸ã«JAVAã§ãã
+</p>
+
+</div>
+
+<div class="section"><h4 class="sectiontitle">NO SQL, CONTAINS SQL, READS SQL DATA</h4> <p>ã«ããé¢æ°ãSQLãçºè¡ãããå¦ãããããããªãã©ã®ãããªSQLãçºè¡ããããè¨è¿°ãã¾ãã</p>
+ <dl>
+
+<dt class="dlterm">CONTAINS SQL</dt>
+
+<dd>é¢æ°ã«ããå¤æ´ãæ´æ°ãè¡ããªãSQLæãå®è¡ã§ãã¾ãã
+é¢æ°ã«ã¦è¨±å¯ããã¦ããªãæãå®è¡ãããå ´åãéãã¨ããã¨ã©ã¼ãè¿ãã¾ãã</dd>
+
+
+<dt class="dlterm">NO SQL</dt>
+
+<dd>é¢æ°ã¯SQLãå®è¡ã§ãã¾ããã</dd>
+
+
+<dt class="dlterm">READS SQL DATA </dt>
+
+<dd>é¢æ°ã¯æ
å ±ã®æ´æ°ãè¡ããªãSQLãå®è¡ãããã¨ãã§ãã¾ãã
+é¢æ°ã«ã¦è¨±å¯ããã¦ããªãæãå®è¡ãããå ´åãéãã¨ããã¨ã©ã¼ãè¿ãã¾ãã
+ããã¯æ¢å®ã§ãã</dd>
+
+</dl>
+</div>
+
+<div class="section"><h4 class="sectiontitle">RETURNS NULL ON NULL INPUT or CALLED ON NULL INPUT</h4>
+<div class="p">å
¥åã®å¼æ°ãnullã«ãã¦é¢æ°ãå¼ã°ããããããããã¾ãããã®å ´åã¯nullå¤ã¨æ±ãã¾ãã<dl>
+<dt class="dlterm">RETURNS NULL ON NULL INPUT</dt>
+
+<dd>å
¥åã®å¼æ°ã®ãã¡ãããããnullã§ãã£ãå ´åãé¢æ°ã¯å¼ã°ãã¾ããããã®ã¨ãã®å¸°ãå¤ã¯nullã¨ãªãã¾ãã</dd>
+
+
+<dt class="dlterm">CALLED ON NULL INPUT</dt>
+
+<dd>é¢æ°ã¯å
¥åã®å¼æ°ãnullã«ãã¦å¼ã¶ãã¨ãã§ãã¾ãããã®å ´åã¯é¢æ°ãnullã®å¼æ°ãã¨ã£ã¦ãåä½ããããã«ã³ã¼ãã£ã³ã°ããã¦ããªããã°ãªãã¾ãããé¢æ°ã¯nullãããã¯ãã以å¤ã®å¤ãè¿ããã¨ãã§ãã¾ããããã¯æ¢å®ã§ãã</dd>
+
+</dl>
+</div>
+</div>
+
+<div class="section"><div class="p">é¢æ°ã®è¦ç´ ã¯ã©ã®ãããªé åºã§ç¾ãã¦ããã¾ãã¾ããããããããã®è¦ç´ ã¯ä¸åããç¾ãã¦ã¯ãªãã¾ãããé¢æ°ã®å®ç¾©ã«ã¯ãããã®è¦ç´ ãå¿
è¦ã§ãã<ul>
+<li><strong>LANGUAGE</strong></li>
+
+<li><strong>PARAMETER STYLE</strong></li>
+
+<li><strong>EXTERNAL NAME</strong></li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">Example</h4><pre><strong>CREATE FUNCTION TO_DEGREES(RADIANS DOUBLE) RETURNS DOUBLE
+PARAMETER STYLE JAVA NO SQL LANGUAGE JAVA
+EXTERNAL NAME 'java.lang.Math.toDegrees'</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj95081.html" title="">CREATE æ</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefsqlj20937.html" title="">CREATE INDEX æ</a></div>
+<div><a href="rrefcreateprocedurestatement.html" title="">CREATE PROCEDURE æ</a></div>
+<div><a href="rrefsqlj31580.html" title="">CREATE SCHEMA æ</a></div>
+<div><a href="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/rrefcreatefunctionstatement.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcreateprocedurestatement.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcreateprocedurestatement.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcreateprocedurestatement.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,163 @@
+<!--
+ 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="CREATE PROCEDURE æ" />
+<meta content="CREATE PROCEDURE statement, CREATE PROCEDURE, SQL statements, procedures, creating" name="DC.subject" />
+<meta content="CREATE PROCEDURE statement, CREATE PROCEDURE, SQL statements, procedures, 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="rrefsqlj31580.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="rrefcreateprocedurestatement" 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>CREATE PROCEDURE æ</title>
+</head>
+<body id="rrefcreateprocedurestatement"><a name="rrefcreateprocedurestatement"><!-- --></a>
+
+
+<h1 class="topictitle1">CREATE PROCEDURE æ</h1>
+
+
+<div>
+<div class="section"><p>CREATE PROCEDUREæã«ããCALL PROCEDUREã§å®è¡å¯è½ãªãJavaã®æç¶ããä½æã§ãã¾ãã</p>
+<p>æç¶ãã<a href="rrefattrib26867.html#rrefattrib26867">ãã¼ã¿ãã¼ã¹ã®ææè
</a>ã¯èªåçã«EXECUTE権éãæã¤ãã®ã¨ãããã¾ãä»ã®ã¦ã¼ã¶ã«æ¨©éãä»ä¸ãããã¨ãã§ãã¾ããEXECUTE権éã¯æç¶ãããã¼ã¿ãã¼ã¹ã®ææè
ããå¥å¥ªã§ãã¾ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4><pre><strong>CREATE PROCEDURE <em><a href="rrefcreateprocedurestatement.html#rrefcreateprocedurestatement__rrefcrproprocedurename">æç¶å</a></em> ( [ <a href="rrefcreateprocedurestatement.html#rrefcreateprocedurestatement__rrefcrproprocedureparameter">æç¶ãã®å¼æ°</a>
+ [, <a href="rrefcreateprocedurestatement.html#rrefcreateprocedurestatement__rrefcrproprocedureparameter">æç¶ãã®å¼æ°</a>] ] * )
+[ <a href="rrefcreateprocedurestatement.html#rrefcreateprocedurestatement__rrefcrproprocedureelement">æç¶ãã®è¦ç´ </a> ] *</strong></pre>
+</div>
+
+<div class="example" id="rrefcreateprocedurestatement__rrefcrproprocedurename"><a name="rrefcreateprocedurestatement__rrefcrproprocedurename"><!-- --></a><h4 class="sectiontitle">æç¶å</h4><pre><strong>[ <em><a href="rrefschemaname.html#rrefschemaname">ã¹ãã¼ãå</a>.</em> ] <em><a href="crefsqlj34834.html#crefsqlj34834">SQL92èå¥å</a></em></strong></pre>
+</div>
+
+<div class="section"><p>ã¹ãã¼ãåãæå®ãããªãã£ãå ´åãç¾å¨ã®ã¹ãã¼ããæ¢å®ã¨ãªãã¾ããæç¶åãéå®ããå ´åãã¹ãã¼ãåã¯SYSã§å§ã¾ã£ã¦ã¯ãªãã¾ããã</p>
+</div>
+
+<div class="example" id="rrefcreateprocedurestatement__rrefcrproprocedureparameter"><a name="rrefcreateprocedurestatement__rrefcrproprocedureparameter"><!-- --></a><h4 class="sectiontitle">æç¶ã®å¼æ°</h4> <pre><strong>[ { IN | OUT | INOUT } ] [ å¼æ°å ] <em>ãã¼ã¿å</em></strong></pre>
+</div>
+
+<div class="section"><p>å¼æ°ã®æ¢å®ã¯INã§ããå¼æ°åã¯æç¶ã«ã¦ä¸æã§ããå¿
è¦ãããã¾ãã</p>
+
+<p><em>ãã¼ã¿å</em>ã®æ§æã¯<a href="crefsqlj31068.html#crefsqlj31068">ãã¼ã¿å</a>ã«è¨è¿°ããã¦ãã¾ãã</p>
+<div class="note"><span class="notetitle">注: </span>BLOBãCLOBãLONG VARCHARãLONG VARCHAR FOR BIT DATAãXMLã®ãããªãã¼ã¿åã¯CREATE PROCEDUREæã«ã¦å¼æ°ã¨å®ç¾©ã§ãã¾ããã</div>
+</div>
+
+<div class="example" id="rrefcreateprocedurestatement__rrefcrproprocedureelement"><a name="rrefcreateprocedurestatement__rrefcrproprocedureelement"><!-- --></a><h4 class="sectiontitle">æç¶ã®è¦ç´ </h4> <pre><strong> {
+| [ DYNAMIC ] RESULT SETS <em><a href="rrefsqlj10696.html#rrefsqlj10696">INTEGER</a></em>
+| LANGUAGE { JAVA }
+| EXTERNAL NAME <em>string</em>
+| PARAMETER STYLE JAVA
+| { NO SQL | MODIFIES SQL DATA | CONTAINS SQL | READS SQL DATA }
+ }
+</strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">DYNAMIC RESULT SETS <em>æ°å¤</em></h4> <p>æç¶ã«è¦ç©ããããçµæã®ä¸éãä¸ãã¾ããæ¢å®ã¯çµæç¡ã(0)ã§ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">LANGUAGE</h4> <p><strong>JAVA</strong>- æç¶ã¯Javaã®ã¯ã©ã¹ã«ããpublic staticãªã¡ã½ããã¨ãã¦å¼ã°ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">EXTERNAL NAME <em>æåå</em></h4> <div class="p"><em>æåå</em> ã«ããæç¶ãå®æ½ãããã¨ãã®Javaã®ã¡ã½ãããè¨è¿°ããã¾ããããã¯æ¬¡ã®æ¸å¼ã¨ãªãã¾ãã<pre>ã¯ã©ã¹å.ã¡ã½ããå</pre>
+ãã®ååã«ã¯ç©ºç½ããã£ã¦ã¯ãªãã¾ããã</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">PARAMETER STYLE</h4> <p><strong>JAVA</strong> - æç¶ã¯Javaã¨SQLã«ã¼ãã³ã®ä»æ§ã«æ²¿ã£ã¦ãå¤æ¸¡ãã«ããå¼æ°ãæ±ãã¾ããINOUTããã³OUTã®å¼æ°ã¯å¤ãå¼ã³åºãå´ã«æ»ããããã«ãè¦ç´ ãä¸ã¤ã ãæã¤é
åã«ãã渡ããã¾ããçµæã¯Javaã®ã¡ã½ããã«java.sql.ResultSet[]ã®åã§è¿½å ããããå¯ä¸ã¤ã®è¦ç´ ãæã¤ãã©ã¡ã¼ã¿ã«ããå¼ã³åºãå´ã«æ»ããã¾ãã</p>
+ <p><span>Derby</span> ã¯é·ãåã®å(ä¾ãã°Long Varchar, BLOBçã®ãã¨ã§ãã)ããµãã¼ããã¾ããã
+ãããããã®é·ãåã®åã®ãã¡ã®ä¸ã¤ã使ãã¨ä¾å¤ãçºçãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">NO SQL, CONTAINS SQL, READS SQL DATA, MODIFIES SQL DATA </h4> <p>
+æç¶ãSQLæãçºè¡ãããå¦ããã¾ããããªãã°ã©ã®ãããªSQLæãçºè¡ãããã表ãã¾ãã</p>
+ <dl>
+
+<dt class="dlterm">CONTAINS SQL</dt>
+
+<dd>èªã¿è¾¼ã¿ãå¤æ´ãè¡ããªãSQLæãæç¶ã«æããããã¨ãã§ãããã¨ã表ãã¾ãããµãã¼ãããã¦ããªãæã§ã¯ç°ãªãã¨ããã¨ã©ã¼ãçºçãã¾ããããã¯æ¢å®ã§ãã</dd>
+
+
+<dt class="dlterm">NO SQL</dt>
+
+<dd>æç¶ã§ã¯ãããªãSQLæãå®è¡ã§ãã¾ããã</dd>
+
+
+<dt class="dlterm">READS SQL DATA </dt>
+
+<dd>
+å¤æ´ãè¡ããªãSQLæãæç¶ã«æããããã¨ãã§ãããã¨ãããããã¾ãããµãã¼ãããã¦ããªãæã§ã¯ç°ãªãã¨ããã¨ã©ã¼ãçºçãã¾ãã</dd>
+
+
+<dt class="dlterm">MODIFIES SQL DATA</dt>
+
+<dd>æç¶ã§ãµãã¼ãããã¦ããªããããããSQLæãæç¶ããå®è¡ã§ãããã¨ã表ãã¾ãã</dd>
+
+</dl>
+</div>
+
+<div class="section"><div class="p">æç¶ã®è¦ç´ ã¯ã©ã®ãããªé åºã§ãåºç¾ãããã¨ãã§ãã¾ãããããããã®ç¨®é¡ã®è¦ç´ ã¯ä¸åº¦ã¾ã§ããç¾ãã¦ã¯ãªãã¾ãããæç¶ã«ã¯ãããã®å®ç¾©ãç¡ããã°ãªãã¾ããã<ul>
+<li><strong>LANGUAGE</strong></li>
+
+<li><strong>PARAMETER STYLE</strong></li>
+
+<li><strong>EXTERNAL NAME</strong></li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ä¾</h4> <pre><strong>CREATE PROCEDURE SALES.TOTAL_REVENUE(IN S_MONTH INTEGER,
+IN S_YEAR INTEGER, OUT TOTAL DECIMAL(10,2))
+PARAMETER STYLE JAVA READS SQL DATA LANGUAGE JAVA EXTERNAL NAME
+'com.acme.sales.calculateRevenueByMonth'</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj95081.html" title="">CREATE æ</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</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="rrefsqlj31580.html" title="">CREATE SCHEMA æ</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/rrefcreateprocedurestatement.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcrsrgpc1.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcrsrgpc1.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcrsrgpc1.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,117 @@
+<!--
+ 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="getProcedureColumnsããè¿ãçµæã»ããã«ããåã«ã¤ãã¦" />
+<meta scheme="URI" name="DC.Relation" content="rrefjdbc15905.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdmrs.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefgpc1.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefpgc1.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdmdfns1.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefcrsrgpc1" 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>getProcedureColumnsããè¿ãçµæã»ããã«ããåã«ã¤ãã¦</title>
+</head>
+<body id="rrefcrsrgpc1"><a name="rrefcrsrgpc1"><!-- --></a>
+
+
+<h1 class="topictitle1"><strong><em>getProcedureColumns</em></strong>ããè¿ãçµæã»ããã«ããåã«ã¤ãã¦</h1>
+
+<div>
+<div class="section"><div class="p"><em>getProcedureColumns</em>ããè¿ã<em>ResultSet</em>ã®åã¯APIã«ã¦æ¢å®ããã¦ãã¾ããããã§ã¯ãAPIã«ã¦å®ãããã¦ããªã詳細ãå¹¾ã¤ãã®åã«ã¤ãã¦è¨è¿°ãã¾ãã<ul>
+<li>PROCEDURE_CAT <p><span>Derby</span>ã§ã¯å¸¸ã«ãnullãã§ãã</p>
+</li>
+
+<li>PROCEDURE_SCHEM <p>Javaã®æç¶ãã®ã¹ãã¼ãã§ãã</p>
+</li>
+
+<li>PROCEDURE_NAME <p>æç¶ãã®ååã§ãã</p>
+</li>
+
+<li>COLUMN_NAME <p>å¼æ°ã®ååã§ãã(<a href="rrefpgc1.html#rrefpgc1__jdbc95532">column-Name-Pattern</a>ãåç
§ãã¦ãã ããã)</p>
+</li>
+
+<li>COLUMN_TYPE <p>shortã§è¡ãè¨è¿°ãã¾ããé
åã§ã¯ãªãã¡ã½ããã®å¼æ°ãªãã°ã常ã«<em>DatabaseMetaData.procedureColumnIn</em>ã§ããããé
åã§ããã¡ã½ããã®å¼æ°ãªãã<em>DatabaseMetaData.procedureColumnInOut</em>ã§ããè¿ãå¤ã§ããã°ã常ã«<em>DatabaseMetaData.procedureColumnReturn</em>ã§ãã</p>
+</li>
+
+<li>TYPE_NAME <p><span>Derby</span>åºæã®ååã§ãã</p>
+</li>
+
+<li>NULLABLE <p>ããªããã£ããªå¼æ°ãªã常ã«<em>DatabaseMetaData.procedureNoNulls</em>ã§ããªãã¸ã§ã¯ãã®å¼æ°ãªã<em>DatabaseMetaData.procedureNullable</em>ã§ãã</p>
+</li>
+
+<li>REMARKS <p>a String describing the java type of the method parameter</p>
+</li>
+
+<li>COLUMN_DEF <p>åã®æ¢å®å¤ã表ãæååã§ãã(nullã§ããå ´åãããã¾ãã)</p>
+</li>
+
+<li>SQL_DATA_TYPE <p>å°æ¥å©ç¨ãããããJDBCã«ã¦äºç´ããã¦ãã¾ãã</p>
+</li>
+
+<li>SQL_DATETIME_SUB <p>å°æ¥å©ç¨ãããããJDBCã«ã¦äºç´ããã¦ãã¾ãã</p>
+</li>
+
+<li>CHAR_OCTET_LENGTH <p>æåããã¤ããªåã®æ大é·ã§ãã(ä»ã®åã§ããã°å¤ã¯NULLã§ãã)</p>
+</li>
+
+<li>ORDINAL_POSITION <p>æç¶ãã®å
¥å/åºåããå¼æ°ã¸ã®ã1ããå§ã¾ãé çªã§ãã</p>
+</li>
+
+<li>IS_NULLABLE <p>å¼æ°ã空ã¨ãããã¨ãã§ãããã表ãæååã§ãã(YESãªãå¼æ°ã«NULLãå«ãããã¨ãã§ããNOãªãã§ãã¾ããã)</p>
+</li>
+
+<li>SPECIFIC_NAME <p>ã¹ãã¼ãã«ã¦æç¶ããä¸æã«ç¹å®ããååã§ãã</p>
+</li>
+
+<li>METHOD_ID <p><span>Derby</span>åºæã®åã§ãã</p>
+</li>
+
+<li>PARAMETER_ID <p><span>Derby</span>åºæã®åã§ãã</p>
+</li>
+
+</ul>
+</div>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefjdbc15905.html" title="">java.sql.DatabaseMetaData ã¤ã³ã¿ã¼ãã§ã¤ã¹</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefdmrs.html" title="">DatabaseMetaData çµæã»ãã</a></div>
+<div><a href="rrefgpc1.html" title="">java.sql.DatabaseMetaData.getProcedureColumnsã¡ã½ãã</a></div>
+<div><a href="rrefpgc1.html" title="">getProcedureColumnsã®å¼æ°</a></div>
+<div><a href="rrefdmdfns1.html" title="java.sql.DatabaseMetaData.getBestRowIdentifierã¡ã½ããã¯æ±ºããããåªå
é ä½ã§èå¥åãæ¢ãã¾ããå¿
ãããè¡ãç¹å®ã§ããæ
å ±ãè¦ã¤ããããã§ã¯ããã¾ããã">java.sql.DatabaseMetaData.getBestRowIdentifierã¡ã½ãã</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcrsrgpc1.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcurrentisolation.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcurrentisolation.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcurrentisolation.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,66 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="CURRENT ISOLATION é¢æ°" />
+<meta content="CURRENT ISOLATION function" name="DC.subject" />
+<meta content="CURRENT ISOLATION function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefcurrentisolation" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>CURRENT ISOLATION é¢æ°</title>
+</head>
+<body id="rrefcurrentisolation"><a name="rrefcurrentisolation"><!-- --></a>
+
+
+<h1 class="topictitle1">CURRENT ISOLATION é¢æ°</h1>
+
+<div>
+<div class="section">
+<p>CURRENT ISOLATIONã¯ãç¾å¨ã®åé¢ã¬ãã«ãchar(2)ã®åã§è¿ãã¾ããå¤ã¯æ¬¡ã®ããããã§ãã
+""(空ç½)ã"UR"ã"CS"ã"RS"ãããã¯"RR"ã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4>
+<pre><strong>CURRENT ISOLATION</strong></pre>
+
+</div>
+
+<div class="example">
+<pre><strong>VALUES CURRENT ISOLATION</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/rrefcurrentisolation.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcursorname.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcursorname.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcursorname.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="crefsqlj18919.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefcursorname" 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="rrefcursorname"><a name="rrefcursorname"><!-- --></a>
+
+
+<h1 class="topictitle1">ã«ã¼ã½ã«å</h1>
+
+<div>
+<div class="section"><p><em>ã«ã¼ã½ã«å</em>ã¯ã«ã¼ã½ã«ãããããã¾ããSQLè¨èªã«ããã«ã¼ã½ã«ã«ååã<em>å²ãå½ã¦ã</em>ãã¨ã¯ã§ãã¾ããããã®ä»£ãããJDBC APIã«ãã£ã¦ã«ã¼ã½ã«ã«ååãå²ãå½ã¦ãããã·ã¹ãã ãå½åããååãåå¾ãããã¨ãã§ãã¾ãããã詳細ã«ã¤ãã¦ã¯ã<cite><span><em>Derby ãã£ããããã¼ãº ã¬ã¤ã</em></span></cite>ãåç
§ãã¦ãã ããã
+ã«ã¼ã½ã«ã«ååãå²ãå½ã¦ãã°ãSQLæã«ã¦ãã®ååã使ããã¨ãã§ãã¾ãã</p>
+</div>
+
+<div class="section"><p><em>ã«ã¼ã½ã«å</em>ã¯éå®ã§ãã¾ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong><em><a href="crefsqlj34834.html#crefsqlj34834">SQL92èå¥å</a></em></strong></pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ä¾</h4> <pre><strong>stmt.executeUpdate("UPDATE SAMP.STAFF SET COMM = " +
+"COMM + 20 " + "WHERE CURRENT OF " + ResultSet.getCursorName());</strong></pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj18919.html" title="">SQLã®èå¥å</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefcursorname.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdatefunc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdatefunc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdatefunc.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,79 @@
+<!--
+ 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="DATEé¢æ°" />
+<meta name="abstract" content="DATEé¢æ°ã¯å¼æ°ããæ¥ä»ãè¿ãã¾ãã" />
+<meta name="description" content="DATEé¢æ°ã¯å¼æ°ããæ¥ä»ãè¿ãã¾ãã" />
+<meta content="DATE function" name="DC.subject" />
+<meta content="DATE function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefdatefunc" 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>DATEé¢æ°</title>
+</head>
+<body id="rrefdatefunc"><a name="rrefdatefunc"><!-- --></a>
+
+
+<h1 class="topictitle1">DATEé¢æ°</h1>
+
+
+
+<div><p>DATEé¢æ°ã¯å¼æ°ããæ¥ä»ãè¿ãã¾ãã</p>
+
+<div class="section"> <p>å¼æ°ã¯æ¥ä»ããã¿ã¤ã ã¹ã¿ã³ãã2,932,897以ä¸ã®æ£ã®æ´æ°ãCLOB/LONG VARCHAR/XML以å¤ã®æ¥ä»ãã¿ã¤ã ã¹ã¿ã³ãã¨ãã¦æå¹ãããã¯é·ã7ã®æååã§ãã
+ããã§é·ã7ã®æååã¯ãyyyynnnã¨ããæ¸å¼ãã¨ãã¾ããyyyyã¯å¹´ã示ã10é²ã®æ°ã§ãnnnã¯å¹´ã®æ¥ã示ã001ãã366ã¾ã§ã®10çã®æ°ã§ãããã®é¢æ°ã¯æ¥ä»ãè¿ãã¾ãããããã®å¼æ°ã§nullãã¨ããã¨ãã§ãããªãè¿ãå¤ãnullãã¨ããã¨ãã§ããå¼æ°ã®nullãªãè¿ãå¤ãnullã§ãã</p>
+
+<div class="p">ãã®ã»ããå¼æ°ã®ãã¼ã¿åã«ãã£ãã«ã¼ã«ãããã¾ãã<ul>
+<li>ããå¼æ°ãæ¥ä»ãã¿ã¤ã ã¹ã¿ã³ããããã¯æ¥ä»ãã¿ã¤ã ã¹ã¿ã³ãã¨ãã¦æå¹ãªæååã§ããã°ãå¼æ°ã®æ¥ä»ã®é¨åãè¿ãå¤ã¨ãªãã¾ãã</li>
+
+<li>ããå¼æ°ãæ°ã§ãããªãã°ããã®å¼æ°ãnã¨ãã¦ã西æ¦1å¹´1æ1æ¥ããn-1æ¥å¾ã®æ¥ä»ãè¿ãå¤ã¨ãªãã¾ãã</li>
+
+<li>ããå¼æ°ãé·ã7ã®æååã§ããã°ããã®æååã表ãæ¥ä»ãè¿ãå¤ã¨ãªãã¾ãã</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>DATE ( <em>å¼</em> )</strong></pre>
+ </div>
+
+<div class="example"> <p>ãã®ä¾ã§ã¯'1988/12/25'ã®å
é¨è¡¨ç¾ãçµæã¨ãªãã¾ãã</p>
+ <pre><strong>VALUES DATE('1988-12-25')</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/rrefdatefunc.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdayfunc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdayfunc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdayfunc.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,68 @@
+<!--
+ 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="DAY é¢æ°" />
+<meta name="abstract" content="DAYé¢æ°ã¯å¤ã®ãã¡æ¥ä»ã®é¨åãè¿ãã¾ãã" />
+<meta name="description" content="DAYé¢æ°ã¯å¤ã®ãã¡æ¥ä»ã®é¨åãè¿ãã¾ãã" />
+<meta content="DAY function" name="DC.subject" />
+<meta content="DAY function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefdayfunc" 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>DAY é¢æ°</title>
+</head>
+<body id="rrefdayfunc"><a name="rrefdayfunc"><!-- --></a>
+
+
+<h1 class="topictitle1">DAY é¢æ°</h1>
+
+
+
+<div><p>DAYé¢æ°ã¯å¤ã®ãã¡æ¥ä»ã®é¨åãè¿ãã¾ãã</p>
+
+<div class="section"> <p>å¼æ°ã¯æ¥ä»ãã¿ã¤ã ã¹ã¿ã³ãããããã¯CLOBãLONG VARCHARãXML以å¤ã®æ¥ä»ãã¿ã¤ã ã¹ã¿ã³ããæå¹ã«è¡¨ãæååã§ãªããã°ãªãã¾ãããé¢æ°ã®çµæã¯1ãã31ã®éã®æ´æ°ã§ããããå¼æ°ãnullã許ãåã§ãããªãçµæãnullã¨ãªããã¨ããããããå¼æ°ãnullãªãçµæã¯nullã§ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>DAY ( <em>å¼</em> )</strong></pre>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4> <pre><strong>values day('2006-08-02');</strong></pre>
+ <p>çµæã¯2ã¨ãªãã¾ãã</p>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefsqlj29026.html" title="">çµã¿è¾¼ã¿é¢æ°</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdayfunc.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdbmlimits.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdbmlimits.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdbmlimits.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,208 @@
+<!--
+ 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="rreflimits.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefdttlimits.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefidlengthlimits.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefnumericlimits.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefstringlimits.html" />
+<meta scheme="URI" name="DC.Relation" content="rreflimitsxml.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefdbmlimits" 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="rrefdbmlimits"><a name="rrefdbmlimits"><!-- --></a>
+
+
+<h1 class="topictitle1">ãã¼ã¿ãã¼ã¹è¨å®å¤ã®å¶é</h1>
+
+<div>
+
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. ãã¼ã¿ãã¼ã¹è¨å®å¤ã®å¶é. 以ä¸ã®è¡¨ã§ã¯<span>Derby</span>ã«ãããæ§ã
ãªãã¼ã¿ãã¼ã¹è¨å®å¤ã®å¶éãæãã¾ãã</caption>
+
+<thead align="left">
+<tr>
+<th align="left" valign="top" width="50%" id="N1004E">å¤</th>
+
+<th align="left" valign="top" width="50%" id="N10056">å¶é</th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">表ã®æ大åæ°</td>
+
+<td valign="top" width="50%">1,012</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">ãã¥ã¼ã®æ大åæ°</td>
+
+<td valign="top" width="50%">5,000</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">æç¶ãå¼æ°ã®æ大æ°</td>
+
+<td valign="top" width="50%">90</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">表ã®æ大索å¼æ°</td>
+
+<td valign="top" width="50%">32,767 ãããã¯è¨æ¶é åã®ä¸é</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">SQLæãããã¯ãã¥ã¼ããåç
§ã§ãã表ã®æ大æ°</td>
+
+<td valign="top" width="50%">è¨æ¶é åã®ä¸é</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">é¸æé
ç®ã®æ大æ°</td>
+
+<td valign="top" width="50%">1,012</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">WHEREç¯ãHAVINGç¯ã®è¿°é¨ã®æ大æ°</td>
+
+<td valign="top" width="50%">è¨æ¶é åã®ä¸é</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">GROUP BYç¯ä¸ã®åã®æ大æ°</td>
+
+<td valign="top" width="50%">32,677</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">ORDER BYç¯ä¸ã®åã®æ大æ°</td>
+
+<td valign="top" width="50%">1,012</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">æºåæ¸ã¿æã®æ大æ°</td>
+
+<td valign="top" width="50%">è¨æ¶é åã®ä¸é</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">ããã°ã©ã ã«ã¦å®ç¾©å¯è½ãªã«ã¼ã½ã«ã®æ大æ°</td>
+
+<td valign="top" width="50%">è¨æ¶é åã®ä¸é</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">åæã«éããã¨ãã§ããã«ã¼ã½ã«ã®æ大æ°</td>
+
+<td valign="top" width="50%">è¨æ¶é åã®ä¸é</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">表ã«å®ç¾©ã§ããå¶ç´ã®æ大æ°</td>
+
+<td valign="top" width="50%">è¨æ¶é åã®ä¸é</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">å
¥ãåã«ã§ããå¯åãåããã®æ·±ãã®ä¸é</td>
+
+<td valign="top" width="50%">è¨æ¶é åã®ä¸é</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">æä¸ã®å¯åãåããæ°ã®ä¸é</td>
+
+<td valign="top" width="50%">è¨æ¶é åã®ä¸é</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">ä½æ¥åä½ã§å¤æ´ã§ããè¡æ°ã®ä¸é</td>
+
+<td valign="top" width="50%">è¨æ¶é åã®ä¸é</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">æä¸ã®å¶ç´æ°ã®ä¸é</td>
+
+<td valign="top" width="50%">è¨æ¶é åã®ä¸é</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="50%" headers="N1004E N10056 ">ããªã¬ã®é£éæ°ã®ä¸é</td>
+
+<td valign="top" width="50%">16</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rreflimits.html" title="">Derbyã®å¶éäºé
</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefdttlimits.html" title="">DATEãTIMEã¨TIMESTAMPã®å¶é</a></div>
+<div><a href="rrefidlengthlimits.html" title="">èå¥åã®é·ãå¶é</a></div>
+<div><a href="rrefnumericlimits.html" title="Derbyã§ã¯æ°å¤ã«å¶éãããã¾ãã">æ°å¤ã®å¶é</a></div>
+<div><a href="rrefstringlimits.html" title="">並ã³ã®å¶é</a></div>
+<div><a href="rreflimitsxml.html" title="">XMLã®å¶é</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdbmlimits.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdeclaretemptable.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdeclaretemptable.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdeclaretemptable.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,260 @@
+<!--
+ 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="DECLARE GLOBAL TEMPORARY TABLE æ" />
+<meta name="abstract" content="The DECLARE GLOBAL TEMPORARY TABLE statement defines a temporary table for the current connection." />
+<meta name="description" content="The DECLARE GLOBAL TEMPORARY TABLE statement defines a temporary table for the current connection." />
+<meta content="DECLARE GLOBAL TEMPORARY TABLE statement, tables, temporary, DECLARE GLOBAL TEMPORARY TABLE, SQL statements" name="DC.subject" />
+<meta content="DECLARE GLOBAL TEMPORARY TABLE statement, tables, temporary, DECLARE GLOBAL TEMPORARY TABLE, SQL statements" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj39374.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefdeclaretemptable" 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>DECLARE GLOBAL TEMPORARY TABLE æ</title>
+</head>
+<body id="rrefdeclaretemptable"><a name="rrefdeclaretemptable"><!-- --></a>
+
+
+<h1 class="topictitle1">DECLARE GLOBAL TEMPORARY TABLE æ</h1>
+
+
+
+<div><p>The DECLARE GLOBAL TEMPORARY TABLE statement defines a temporary
+table for the current connection. </p>
+
+<div class="section"><p>ãããã®è¡¨ã¯ã·ã¹ãã ã«ã¿ãã°ã«ãããã®ã§ã¯ãªãæ°¸ç¶çãªãã®ã§ã¯ããã¾ãããä¸æ表ã¯ä½æããæ¥ç¶ã®æéã®ã¿åå¨ãã¦ãä»ã®æ¥ç¶ããåç
§ãããã¨ã¯ã§ãã¾ãããæ¥ç¶ãéããã¨ãã
+表ä¸ã®è¡ã¯åé¤ãããä¸æ表ã«é¢ããã¡ã¢ãªä¸ã®è¨è¿°ã¯ç ´æ£ããã¾ãã</p>
+</div>
+
+<div class="section"><div class="p">ä¸æ表ã¯ä»¥ä¸ã®ãããªå ´åã«ä¾¿å©ã§ãã<ul>
+<li>表ã®æ§é ãã¢ããªã±ã¼ã·ã§ã³ã使ãåã§ã¯åãããªãå ´å</li>
+
+<li>ä»ã®ã¦ã¼ã¶ãåæ§ãªæ§é ã®è¡¨ãå¿
è¦ã¨ããªãå ´å</li>
+
+<li>ã¢ããªã±ã¼ã·ã§ã³ã使ã£ã¦ããå ´åã®ã¿ãä¸æ表ã®æ
å ±ãå¿
è¦ãªå ´å</li>
+
+<li>ã·ã¹ãã ã«ã¿ãã°ã«ããã¯ãæããã«ã表ã®å®ç¾©ã¨ç ´æ£ãå¯è½ãªå ´å</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>DECLARE GLOBAL TEMPORARY TABLE <em><a href="rrefdeclaretemptable.html#rrefdeclaretemptable__tempcoltablename">表å</a></em>
+ { åå®ç¾© [ , åå®ç¾© ] * }
+[ ON COMMIT {DELETE | PRESERVE} ROWS ]
+NOT LOGGED [ON ROLLBACK DELETE ROWS]
+ </strong></pre>
+</div>
+
+<div class="section" id="rrefdeclaretemptable__tempcoltablename"><a name="rrefdeclaretemptable__tempcoltablename"><!-- --></a><h4 class="sectiontitle">表å</h4>
+<p>ä¸æ表ã®ååã§ããSESSION以å¤ã®ã¹ãã¼ãåãæå®ãããå ´åãã¨ã©ã¼ãçºçãã¾ãã(SQLSTATE 428EK)
+ã¹ãã¼ãåãæå®ãããªãã£ãå ´åãSESSIONããã¦ããã¾ãã
+è¤æ°ã®æ¥ç¶ã§åãååã®ä¸æ表ãä½ããã¨ãã§ãã¾ãããªããªãããããã®æ¥ç¶ã¯åã
ã«ä¸æãªè¡¨ã®è¨è¿°åãæã¤ããã§ãã</p>
+
+<p>SESSIONãæ°¸ç¶çãªè¡¨ã®ã¹ãã¼ãã¨ãã¦ä½¿ã£ã¦ãã¨ã©ã¼ã«ã¯ãªãã¾ãããæ¨å¥¨ãã¾ããã
+SESSIONã¨ããã¹ãã¼ãåã¯ä¸æ表ã®ã¹ãã¼ãç¨ã«äºç´ããã¦ãã¾ãã</p>
+</div>
+
+<div class="section" id="rrefdeclaretemptable__tempcolcolumndef"><a name="rrefdeclaretemptable__tempcolcolumndef"><!-- --></a><h4 class="sectiontitle">åå®ç¾©</h4>
+<p><samp class="codeph">åå®ç¾©</samp>ã®è©³ç´°ã«ã¤ãã¦ã¯<a href="rrefsqlj30540.html#rrefsqlj30540">åå®ç¾©</a>ã®<samp class="codeph">CREATE TABLE</samp>ãåç
§ãã¦ãã ããã
+<samp class="codeph">DECLARE GLOBAL
+TEMPORARY TABLE</samp>ã§ã¯<samp class="codeph">åå®ç¾©</samp>ã«<samp class="codeph">çºçªåä»æ§</samp>ã¯ä¸å¯è½ã§ãã</p>
+</div>
+
+<div class="section" id="rrefdeclaretemptable__rreftemptabledatatype"><a name="rrefdeclaretemptable__rreftemptabledatatype"><!-- --></a><h4 class="sectiontitle">ãã¼ã¿å</h4>
+<div class="p">å¯è½ãªãã¼ã¿åã¯ä»¥ä¸ã®ã¨ããã§ãã<ul>
+<li>BIGINT</li>
+
+<li>CHAR</li>
+
+<li>DATE</li>
+
+<li>DECIMAL</li>
+
+<li>DOUBLE</li>
+
+<li>DOUBLE PRECISION</li>
+
+<li>FLOAT</li>
+
+<li>INTEGER</li>
+
+<li>NUMERIC</li>
+
+<li>REAL</li>
+
+<li>SMALLINT</li>
+
+<li>TIME</li>
+
+<li>TIMESTAMP</li>
+
+<li>VARCHAR</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section" id="rrefdeclaretemptable__rreftemptableoncommit"><a name="rrefdeclaretemptable__rreftemptableoncommit"><!-- --></a><h4 class="sectiontitle">ON COMMIT</h4>
+<p>COMMITãè¡ãããã¨ãã®ã¢ã¯ã·ã§ã³ãæå®ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">DELETE ROWS</h4>
+<p>表ã«éããã«ã¼ã½ã«ãç¡ããã°ã表ä¸ã®å
¨ã¦ã®è¡ãåé¤ããã¾ããããã¯ON COMMITã®æ¢å®ã§ãã
+ããON ROLLBACK DELETE ROWSãæå®ããå ´åã¯ãä¸æ表ã使ãããå ´åã®ã¿å
¨ã¦ã®è¡ãåé¤ããã¾ãã
+ON COMMIT DELETE ROWSãæå®ããå ´åã¯ãä¸æ表ã使ãããªãã£ãå ´åã§ã表ã®è¡ãåé¤ããã¾ã(éããã«ã¼ã½ã«ãç¡ãã£ãå ´åã§ãã)ã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">PRESERVE ROWS</h4><p>表ã®è¡ã¯çãç½®ããã¾ãã</p>
+</div>
+
+<div class="section" id="rrefdeclaretemptable__rreftemptablenotlogged"><a name="rrefdeclaretemptable__rreftemptablenotlogged"><!-- --></a><h4 class="sectiontitle">NOT LOGGED</h4>
+<p>
+ãã©ã³ã¶ã¯ã·ã§ã³ããã¼ã«ããã¯ãããã¨ããä¸æ表ã«è¡ãããã¢ã¯ã·ã§ã³ãæå®ãã¾ãã
+ROLLBACK(ãããã¯ROLLBACK TO SAVEPOINT)ãè¡ãããã¨ãä½æ¥åä½(ãããã¯ã»ã¼ããã¤ã³ã)ã«ã¦è¡¨ãä½ããã¦ããã°ããã®è¡¨ã¯ç ´æ£ããã¾ããããä½æ¥åä½(ãããã¯ã»ã¼ããã¤ã³ã)ã«ã¦è¡¨ãç ´æ£ãããå ´åãè¡ã®ãªã表ã復å
ããã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ON ROLLBACK DELETE ROWS</h4>
+<p>ããã¯NOT LOGGEDã®æ¢å®ã§ããNOT LOGGED [ON ROLLBACK DELETE ROWS ]]ã«ãããROLLBACKãããã¯ROLLBACK TO SAVEPOINTãè¡ãããã¨ãä¸æ表ã«è¡ãããå¦çãæå®ããã¾ãããã表ã®æ
å ±ãå¤æ´ããã¦ããã°ãå
¨è¡ãåé¤ããã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ä¾</h4><pre><strong>set schema myapp;
+
+create table t1(c11 int, c12 date);
+
+declare global temporary table SESSION.t1(c11 int) not logged;</strong>
+-- ä¸æ表ã¯SESSIONã¹ãã¼ãã«ããç½®ãããªãã®ã§ã
+-- SESSIONã«ããéå®ã¯åé·ã§ãã
+<strong>declare global temporary table t2(c21 int) not logged;</strong>
+-- ä¸æ表ã¯SESSIONã¹ãã¼ãã«ããç½®ãããªãã®ã§ã
+-- ãã®ä¾ã§ã¯SESSIONã«ããéå®ãã¾ããã
+
+<strong>insert into SESSION.t1 values (1); </strong>
+-- ç¾å¨ã®ã¹ãã¼ãã"myapp."ãªã®ã§ãä¸æ表ã使ãã«ã¯SESSIONã«ããéå®ãå¿
é ã§ãã
+
+<strong>select * from t1;</strong>
+-- 表ãSESSIONã«ããéå®ããã¦ããªãã®ã§ã
+-- ãã®selectæã®"myapp.t1"ã¯å®è¡¨ãåç
§ãã¾ãã
+
+</pre>
+ <div class="note"><span class="notetitle">注: </span>ä¸æ表ã¯SESSIONã¹ãã¼ãã«ã®ã¿å®ç¾©ã§ãã¾ãã
+ã¦ã¼ã¶ã¯SESSIONã¨ããååã®å®ã¹ãã¼ããå®ç¾©ããã¹ãã§ã¯ããã¾ããã</div>
+
+<div class="p">次ã®DB2 UDBã«ã¦å¯è½ãªDECLARE GLOBAL TEMPORARY TABLEé¢æ°ã¯ã<span>Derby</span>ã«ã¦ä½¿ãã¾ããã<ul>
+<li>IDENTITY column-options </li>
+
+<li>IDENTITY attribute in copy-options</li>
+
+<li>AS (fullselect) DEFINITION ONLY</li>
+
+<li>NOT LOGGED ON ROLLBACK PRESERVE ROWS</li>
+
+<li>IN tablespace-name</li>
+
+<li>PARTITIONING KEY</li>
+
+<li>WITH REPLACE </li>
+
+</ul>
+ </div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">Declared Global Temporary Tablesã®å¶éäºé
</h4>
+<p><span>Derby</span>ã§ã¯ä¸æ表ã«æ¬¡ã®æ©è½ãæä¾ãã¦ãã¾ããã
+ãããã®æ©è½ã®å¹¾ã¤ãã¯ä¸æ表ç¹æã®ãã®ã§ãããå¹¾ã¤ãã¯<span>Derby</span>ç¹æã®ãã®ã§ãã</p>
+
+<div class="p">以ä¸ã®æã§ã¯ä¸æ表ãæå®ã§ãã¾ããã<ul>
+<li>ALTER TABLE </li>
+
+<li>CREATE INDEX</li>
+
+<li>CREATE SYNONYM</li>
+
+<li>CREATE TRIGGER</li>
+
+<li>CREATE VIEW</li>
+
+<li>GRANT</li>
+
+<li>LOCK TABLE</li>
+
+<li>RENAME</li>
+
+<li>REVOKE</li>
+
+</ul>
+</div>
+
+<p>ä¸æ表ã«ã¯æ¬¡ã®æ©è½ã使ãã¾ããã</p>
+<ul>
+<li>SESSIONã¹ãã¼ãã«ãã表(å®è¡¨ã¨ä¸æ表ãå«ã¿ã¾ã)ã¸ã®å¥åãããªã¬ããã¥ã¼</li>
+
+<li>SESSIONã¹ãã¼ãã«ãã表ãåç
§ããæã®ãã£ãã·ã¥</li>
+
+<li>ä¸æ表ã¯å¤é¨ãã¼å¶ç´ã主ãã¼å¶ç´ã§æå®ã§ããªãã</li>
+
+<li>ããªã¬ãããSQLæã§ã¯ä¸æ表ãåç
§ã§ãã¾ããã</li>
+
+<li>åã®ãã§ãã¯å¶ç´</li>
+
+<li>çºçªåä»æ§</li>
+
+<li>ä¸æ表ã¸ã®ã¤ã³ãã¼ã</li>
+
+</ul>
+ <p>ä¸æ表ã¸ã®æ¿å
¥ãæ´æ°ãåé¤ã®æã«ã¦ã¨ã©ã¼ãèµ·ããå ´åãä¸æ表ã®å
¨ã¦ã®è¡ã¯åé¤ããã¾ãã</p>
+
+<div class="p">ä¸æ表ã«ã¦ä»¥ä¸ã®ãã¼ã¿åã¯å©ç¨ã§ãã¾ããã<ul>
+<li>BLOB</li>
+
+<li>CHAR FOR BIT DATA</li>
+
+<li>CLOB</li>
+
+<li>LONG VARCHAR</li>
+
+<li>LONG VARCHAR FOR BIT DATA</li>
+
+<li>VARCHAR FOR BIT DATA</li>
+
+<li>XML</li>
+
+</ul>
+</div>
+</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/rrefdeclaretemptable.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdisablelogproc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdisablelogproc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdisablelogproc.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,82 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODEã·ã¹ãã æç¶ã" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlbuiltinsystemprocedures.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefdisablelogproc" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODEã·ã¹ãã æç¶ã</title>
+</head>
+<body id="rrefdisablelogproc"><a name="rrefdisablelogproc"><!-- --></a>
+
+
+<h1 class="topictitle1">SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODEã·ã¹ãã æç¶ã</h1>
+
+<div>
+<div class="section"><p><samp class="codeph">SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE</samp>ã·ã¹ãã æç¶ãã«ããããã°ã¢ã¼ã«ã¤ãã¢ã¼ãã¯ç¡å¹ã«ãªãã¾ãããã®ã¨ãå¼æ°ã®<samp class="codeph">DELETE_ARCHIVED_LOG_FILES</samp>ã«é¶ä»¥å¤ã®å¤ãä¸ãã¦ããã°ããªã³ã©ã¤ã³ã¢ã¼ã«ã¤ããã°ã¯åé¤ããã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4><pre>SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(IN SMALLINT DELETE_ARCHIVED_LOG_FILES) </pre>
+
+<p>ãã®æç¶ãããã¯çµæã¯è¿ãã¾ããã</p>
+<dl>
+<dt class="dlterm">DELETE_ARCHIVED_LOG_FILES</dt>
+
+<dd>ããDELETE_ARCHIVED_LOG_FILESã¸ã®å¼æ°ã®å¤ãé¶ã§ãªããã°ãåå¨ããã¢ã¼ã«ã¤ããã°ã¯åé¤ããã¾ãã
+ããå¼æ°ã®å¤ãé¶ãªããåå¨ããã¢ã¼ã«ã¤ããã°ã¯åé¤ããã¾ããã</dd>
+
+</dl>
+</div>
+
+<div class="section"><h4 class="sectiontitle">JDBCã®ä¾</h4>
+<p>以ä¸ã®ä¾ã§ã¯ãã¼ã¿ãã¼ã¹ã®ãã°ã¢ã¼ã«ã¤ãã¯ç¡å¹ã¨ãªããåå¨ãããã°ã¢ã¼ã«ã¤ãã®ãã¡ã¤ã«ã¯åé¤ããã¾ãã</p>
+<pre>CallableStatement cs = conn.prepareCall
+("CALL SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(?)");
+cs.setInt(1, 1);
+cs.execute();
+cs.close();</pre>
+</div>
+
+<div class="section"><h4 class="sectiontitle">SQLã®ä¾</h4>
+<p>以ä¸ã®ä¾ã§ã¯ãã¼ã¿ãã¼ã¹ã®ãã°ã¢ã¼ã«ã¤ãã¢ã¼ãã¯ç¡å¹ã¨ãªãã¾ããåå¨ãããã°ã¢ã¼ã«ã¤ãã®ãã¡ã¤ã«ã¯ãã®ã¾ã¾æ®ãã¾ãã</p>
+<pre>CALL SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE DELETE_ARCHIVED_LOG_FILES(0);</pre>
+<p>以ä¸ã®ä¾ã§ã¯ãã¼ã¿ãã¼ã¹ã®ãã°ã¢ã¼ã«ã¤ãã¢ã¼ãã¯ç¡å¹ã¨ãªããåå¨ãããã°ã¢ã¼ã«ã¤ãã®ãã¡ã¤ã«ã¯åé¤ããã¾ãã</p>
+<pre>CALL SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE DELETE_ARCHIVED_LOG_FILES(1);</pre>
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlbuiltinsystemprocedures.html" title="">çµã¿è¾¼ã¿ã·ã¹ãã æç¶ã</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefdisablelogproc.html
------------------------------------------------------------------------------
svn:eol-style = native