You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by tm...@apache.org on 2008/01/05 09:25:38 UTC
svn commit: r609101 [25/26] - in /db/derby/docs/trunk: ./ src/ja_JP/
src/ja_JP/ref/
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrenamecolumnstatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrenamecolumnstatement.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrenamecolumnstatement.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrenamecolumnstatement.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,59 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<reference id="rrefsqljcolumnstatements" xml:lang="en-us">
+ <title>RENAME COLUMN æ</title>
+<shortdesc>RENAME COLUMN æã§è¡¨ã«ããåã®ååãå¤æ´ã§ãã¾ãã</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>RENAME COLUMN statement</indexterm>
+<indexterm><indexterm>SQL statements</indexterm>RENAME COLUMN</indexterm>
+<indexterm><indexterm>columns</indexterm>renaming</indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>RENAME COLUMNæã«ããå
¨ã¦ã®ã¹ãã¼ãã«ããæ¢å表ã®æ¢ååã®ååãå¤æ´ã§ãã¾ãã(<i>SYS</i>ã®ã¹ãã¼ããé¤ãã¾ãã)</p>
+<p>åã®ååãå¤ãããã¨ãã§ããã®ã¯ããã¼ã¿ãã¼ã¹ã®ææè
ãããã¯è¡¨ã®ææè
ã®ã¿ã§ãã</p>
+<p>表ã¸ã®ä»ã®å®ç¾©å¤æ´ã¯å¯è½ã§ãã詳細ã¯ã<xref href="rrefsqlj81859.dita#rrefsqlj81859"></xref>ãåç
§ãã¦ãã ããã</p>
+</section>
+<refsyn><title>æ§æ</title>
+ <codeblock><b>RENAME COLUMN <i><xref href="rreftablename.dita">表å</xref></i>.<i><xref href="rrefsimplecolumnname.dita">åç´åå</xref></i> TO <i><xref href="rrefsimplecolumnname.dita">åç´åå</xref></i></b></codeblock>
+</refsyn>
+<example id="renamecolumnexamples">
+<title>ä¾</title>
+<p><i>employee</i>ã¨ãã表ã«ãã<i>manager</i>ã¨ããåã®ååã
+<i>supervisor</i>ã«å¤æ´ããã«ã¯æ¬¡ã®ããã«ãã¾ãã
+<codeblock><b>RENAME COLUMN EMPLOYEE.MANAGER TO SUPERVISOR</b></codeblock>
+</p>
+<p>ALTER TABLEã¨RENAME COLUMNã使ã£ã¦ãåã®ãã¼ã¿åãå¤æ´ã§ãã¾ãã
+<i>t</i>ã¨ãã表ã«ãã<i>c1</i>ã¨ããåã®ãã¼ã¿åã<i>NEWTYPE</i>ã«å¤æ´ããããã«ã¯ã次ã®ããã«ãã¾ãã
+<codeblock><b>
+ ALTER TABLE t ADD COLUMN c1_newtype NEWTYPE
+ UPDATE t SET c1_newtype = c1
+ ALTER TABLE t DROP COLUMN c1
+ RENAME COLUMN t.c1_newtype TO c1
+</b></codeblock></p>
+</example>
+<section><title>å©ç¨ä¸ã®çæç¹</title>
+<note id="restriction">åãåç
§ãããã¥ã¼ãããªã¬ããã§ãã¯å¶ç´ãå¤é¨ãã¼å¶ç´ãããå ´åãååã®å¤æ´ã¯å¤±æãã¾ãã
+</note>
+<note id="restriction">å称ãå¤æ´ããåãåç
§ãããéããã«ã¼ã½ã«ãããå ´åãRENAME COLUMNæã¯å®è¡ã§ãã¾ããã</note>
+<note>åã¸ã®ç´¢å¼ããã£ã¦ããåã®ååã¯å¤æ´ã§ãã¾ããç´¢å¼ã¯æ´æ°ããã¦ãå¤æ´å¾ã®ååã§åç
§ããããã«ãªãã¾ãã</note>
+</section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrenamecolumnstatement.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrenametablestatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrenametablestatement.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrenametablestatement.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrenametablestatement.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,40 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<reference id="rrefsqljrenamestatements" xml:lang="en-us">
+<title>RENAME TABLE æ</title>
+<prolog><metadata>
+<keywords><indexterm>RENAME TABLE statement</indexterm><indexterm><indexterm>SQL
+statements</indexterm>RENAME TABLE</indexterm><indexterm><indexterm>tables</indexterm>renaming</indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>RENAME TABLEã«ããããããã¹ãã¼ãã«ããæ¢åã®è¡¨ã®ååãå¤æ´ã§ãã¾ãã(ãã ã<i>SYS</i>ã®ã¹ãã¼ãã¯é¤ãã¾ãã)</p>
+<p>表ã®ååãå¤æ´ã§ããã®ã¯<xref href="rrefattrib26867.dita#rrefattrib26867">ãã¼ã¿ãã¼ã¹ã®ææè
</xref>ã¨è¡¨ã®ææè
ã§ãã</p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>RENAME TABLE <i>表å</i> TO <i><xref
+href="rrefnewtablename.dita#rrefnewtablename">æ°è¡¨å</xref></i></b></codeblock>
+<p>表ãåç
§ãããã¥ã¼ãå¤é¨ãã¼ããã£ãå ´åãååãå¤ãããã¨ããã¨ã¨ã©ã¼ãçºçãã¾ãã
+ããã«ã表ã«ããªã¬ããã§ãã¯å¶ç´ããã£ãå ´åããååãå¤ãããã¨ããã¨ã¨ã©ã¼ãçºçãã¾ãã</p> </refsyn>
+<example> <codeblock><b>RENAME TABLE SAMP.EMP_ACT TO EMPLOYEE_ACT</b></codeblock>
+<p>詳細ã«ã¤ãã¦ã¯ã<xref href="rrefsqlj81859.dita#rrefsqlj81859"></xref>ãåç
§ãã¦ãã ããã</p> </example>
+<section><title>æã®ä¾å</title>
+<p>表ã«ç´¢å¼ãå®ç¾©ããã¦ãã¦ãã表ã®ååã¯å¤æ´å¯è½ã§ãã</p>
+<p>ååãå¤æ´ãããã¨ãã表ã«ãéããã«ã¼ã½ã«ããã£ãå ´åãRENAME TABLEæã¯å¤±æãã¾ãã</p> </section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrenametablestatement.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrevoke.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrevoke.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrevoke.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrevoke.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,106 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.-->
+<reference id="rrefsqljrevoke" xml:lang="ja">
+<title>REVOKE æ </title>
+<shortdesc>REVOKEæã使ã£ã¦ãæå®ããã¦ã¼ã¶ãããã¯å
¨ã¦ã¼ã¶ããããã¼ã¿ãã¼ã¹ã®æ
å ±ã«å¯¾ãã¦æä½ãè¡ã権éãå¥å¥ªãããã¨ãã§ãã¾ãã</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>REVOKE statement<indexterm>syntax</indexterm></indexterm>
+<indexterm>SQL statements<indexterm>REVOKE</indexterm></indexterm><indexterm>REVOKE
+statement<indexterm>limitations</indexterm></indexterm><indexterm>privileges<indexterm>tables
+and columns, revoking</indexterm></indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>å¥å¥ªã§ãã権éã«ã¯æ¬¡ã®ç¨®é¡ãããã¾ãã<ul>
+<li>表ããæ
å ±ãåé¤ããã</li>
+<li>表ã«æ
å ±ãæ¿å
¥ããã</li>
+<li>表ã表ã«ããåã®é¨åéåã«å¯¾ãã¦ãå¤é¨ãã¼åç
§ãä½æããã</li>
+<li>表ããã¥ã¼ã表ã®åã®é¨åéåãããæ
å ±ãé¸æããã</li>
+<li>表ã«ããªã¬ãä½æãã</li>
+<li>表ã表ã«ããåã®é¨åéåã«ããæ
å ±ãæ´æ°ããã</li>
+<li>é¢æ°ãæç¶ããªã©ã®ããã°ã©ã ã«ã¼ãã³ãå®è¡ããã</li>
+</ul></p><p>REVOKEæãçºè¡ããåã«ã<codeph>derby.database.sqlAuthorization</codeph>å±æ§ã<codeph>true</codeph>ã§ãããã¨ã確èªãã¦ãã ããã<codeph>derby.database.sqlAuthorization</codeph>å±æ§ã«ãããSQLèªè¨¼ãæå¹ã«ãªãã¾ãã</p>
+<p>æ
å ±ã®ææè
ã<xref href="rrefattrib26867.dita#rrefattrib26867">ãã¼ã¿ãã¼ã¹ã®ææè
</xref>ã§ããã°ããã®æ
å ±ã¸ã®æ¨©éãå¥å¥ªããäºãã§ãã¾ãã</p>
+<p>REVOKEæã®ä½¿ãæ¹ã¯ã表ã¸ã®æ¨©éãå¥å¥ªããã®ããããã°ã©ã ã«ã¼ãã³ã¸ã®æ¨©éãå¥å¥ªããã®ãã«ããç°ãªãã¾ãã</p></section>
+<section><title>表ã®å ´åã®ä½¿ãæ¹</title>
+<codeblock><b>REVOKE <i><xref href="rrefsqljrevoke.dita#rrefsqljrevoke/revokeptype">権éã¿ã¤ã</xref
+></i> ON [ TABLE ] { <i><xref href="rreftablename.dita#rreftablename"></xref></i> | <i><xref
+href="rrefviewname.dita#rrefviewname"></xref></i> } FROM <i><xref href="rrefsqljrevoke.dita#rrefsqljrevoke/revokegrantees">権éãä¸ãããã¦ãã人</xref></i></b
+></codeblock><p>åã®ä¸è¦§ãæå®ããã«æ¨©éãå¥å¥ªããå ´åã表ã®å
¨ã¦ã®åã¸ã®æ¨©éãå¥å¥ªããã¾ãã</p></section>
+<section><title>ããã°ã©ã ã«ã¼ãã³ã®å ´åã®ä½¿ãæ¹</title><codeblock><b>REVOKE EXECUTE ON { FUNCTION | PROCEDURE } <i><xref
+href="rrefsqljrevoke.dita#rrefsqljrevoke/revokeroutinename">ããã°ã©ã ã«ã¼ãã³ã®æ示å</xref></i> FROM <i><xref
+href="rrefsqljrevoke.dita#rrefsqljrevoke/revokegrantees">権éãä¸ãããã¦ãã人</xref> </i> RESTRICT</b></codeblock><p>ããã°ã©ã ã«ã¼ãã³ã«REVOKEæã使ãå ´åãRESTRICTç¯ãå¿
è¦ã§ããRESTRICTç¯ã¯ãå®è¡æ¨©éããã¥ã¼ã表ãå¶ç´ããã¯å¥å¥ªãããªãä¸æ¹ã§ããã¥ã¼ã表ãå¶ç´ã®ææè
ããã¯å¥å¥ªããããã¨ã表ãã¾ãã</p></section>
+<section id="revokeptype"><title>権éã¿ã¤ã</title><codeblock><b>ALL PRIVILEGES |
+ å種権é </b></codeblock></section>
+<section id="revokeprivlist"><title>å種権é</title><codeblock><b>
+表権é {, 表権é }* </b></codeblock></section>
+<section id="revoketablepriv"><title>表権é</title><codeblock><b> DELETE |
+ INSERT |
+ REFERENCES [<i>åä¸è¦§</i>] |
+ SELECT [<i>åä¸è¦§</i>] |
+ TRIGGER |
+ UPDATE [<i>åä¸è¦§</i>] </b></codeblock></section>
+<section id="revokecollist"><title>åä¸è¦§</title><codeblock><b> ( åèå¥å {, åèå¥å}* ) </b></codeblock></section><section><p>権éã¿ã¤ãã®ALL PRIVILEGESã¯ã表ã¸ã®å
¨ã¦ã®æ¨©éãã¦ã¼ã¶ããå¥å¥ªããæã«ä½¿ãã¾ããå種権éãæå®ãã¦ã表ã¸ã®ä¸ã¤ä»¥ä¸ã®æ¨©éãå¥å¥ªãããã¨ãã§ãã¾ãã</p>
+<p>DELETEã®æ¨©éã¿ã¤ãã¯ã表ã®è¡ãåé¤ãã権éãå¥å¥ªããããã«ä½¿ãã¾ãã</p>
+<p>INSERTã®æ¨©éã¿ã¤ãã¯ã表ã«è¡ãæ¿å
¥ãã権éãå¥å¥ªããããã«ä½¿ãã¾ãã</p>
+<p>REFERENCESã®æ¨©éã¿ã¤ãã¯ã表ã¸ã®å¤é¨ãã¼åç
§ãä½æãã権éãå¥å¥ªããããã«ä½¿ãã¾ããåä¸è¦§ãæå®ãããå ´åããã®å群ã¸ã®å¤é¨ãã¼åç
§ãä½æãã権éã ããå¥å¥ªããã¾ãã</p>
+<p>SELECTã®æ¨©éã¿ã¤ãã¯ã表ã¾ãã¯ãã¥ã¼ã®æ
å ±ãé¸æãã権éãå¥å¥ªããã¨ãã«ä½¿ãã¾ããåä¸è¦§ãæå®ãããå ´åããã®å群ã¸ã®æ¨©éã ããå¥å¥ªããã¾ããåä¸è¦§ãæå®ãããªãã£ãå ´åã表ã®å
¨åã«å¯¾ãã¦æä½ãæå¹ã§ãã</p>
+<p>TRIGGERã®æ¨©éã¿ã¤ãã¯ã表ã«ããªã¬ãä½æãã権éãå¥å¥ªããã¨ãã«ä½¿ãã¾ãã</p>
+<p>UPDATEã®æ¨©éã¿ã¤ãã¯ã表ã«UPDATEæãå®è¡ãã権éãå¥å¥ªããããã«ä½¿ãã¾ããåä¸è¦§ãæå®ãããå ´åããã®å群ã¸ã®æ¨©éã ããå¥å¥ªããã¾ãã</p></section>
+<section id="revokegrantees"><title>権éãä¸ãããã¦ãã人</title><codeblock><b>{ <i>èªè¨¼èå¥å</i> | PUBLIC } [,{ <i>authorization ID</i> | PUBLIC } ] *</b
+></codeblock>
+<p>æå®ããã¦ã¼ã¶ãããã¯å
¨ã¦ã¼ã¶ããã権éã®å¥å¥ªãè¡ããã¨ãã§ãã¾ããå
¨ã¦ã¼ã¶ãæå®ããã¨ãã¯ãPUBLICã¨ãããã¼ã¯ã¼ãã使ãã¾ããPUBLICã§å¥å¥ªããã権éã¨ãã¦ã¼ã¶ãæå®ãã¦å¥å¥ªããã権éã¯ç¬ç«ããç©ã§ããä¾ãæãã¾ãããã表<codeph>t</codeph>ã¸ã®SELECT権éããPUBLICã¨<codeph>harry</codeph>ã¨ããèªè¨¼èå¥åã®ä¸¡æ¹ã«ä¸ãããã¦ããã¨ãã¾ãã
+ããã§ã<codeph>harry</codeph>ã¨ããèªè¨¼èå¥åããSELECT権éãå¥å¥ªãããã¨ãã¦ãã<codeph>harry</codeph>ã¨ããèªè¨¼èå¥åã¯PUBLIC権éãéãã¦ã表<codeph>t</codeph>ãæä½å¯è½ã§ãã</p>
+<note type="restriction">æ
å ±ã®ææè
ã®æ¨©éãå¥å¥ªãããã¨ã¯ã§ãã¾ããã</note></section>
+<section id="revokeroutinename"><title>ããã°ã©ã ã«ã¼ãã³ã®æ示å</title><codeblock><b> {
+ <i>qualified-name</i> [ signature ]
+ }</b></codeblock></section>
+<section><title>å¥å¥ªããã権éã«é£ãªãä¾åé¢ä¿</title>
+<p>å¥å¥ªããã権éã«ä¾åãã¦ãããã¥ã¼ãããªã¬ãå¶ç´çã¯èªåçã«åé¤ããã¾ãããã®ã¨ã<ph conref="../conrefs.dita#prod/productshortname"></ph> ã¯ãå¥å¥ªããã権éãä»ã®æ¨©éã§ä»£æ¿ãããã¨ãã¾ããã詳ããã¯ã<ph conref="../conrefs.dita#pub/citdevelop">Derby Developer's Guide</ph>ã®"SQL standard authorization"ãåç
§ãã¦ãã ããã</p></section>
+
+
+<section><title>å¶éäºé
</title><p>REVOKEæã«ã¯æ¬¡ã®å¶éäºé
ãããã¾ãã</p>
+<dl><dlentry>
+<dt>表æ¯ã®æ¨©éã«é¢é£ãã権é</dt>
+<dd>表æ¯ã®æ¨©éã«å¯¾å¿ãã¦ãSYSTABLEPERMSã·ã¹ãã 表ã«è¡¨IDã¨æ¨©éã®ä»ä¸å
ãè¨é²ããã¾ãããã¨ãã°ã<codeph>user2</codeph>ã«ã表<codeph>user1.t1</codeph>ã®SELECTã¨DELETEã®æ¨©éãä»ä¸ãããå ´åãSYSTABLEPERMS表ã«ã¯å¯¾å¿ããè¡ãã²ã¨ã¤è¿½å ããã¾ãããã®è¡ã«ã®GRANTEEæ¬ã¯<codeph>user2</codeph>ã¨ããå¤ãã¨ã£ã¦ãTABLEIDæ¬ã¯<codeph>user1.t1</codeph>ã¨ããå¤ãã¨ãã¾ããããã«SELECTPRIVã¨DELETEPRIVã®ããããã®æ¬ã®å¤ã¯Yãã¨ãã¾ãããã以å¤ã®æ¨©éã«å¯¾å¿ããæ¬ã®
å¤ã¯Nã§ãã<p>権éãä»ä¸ãããã¦ã¼ã¶ã表ã¸ã®ããããã®æ¨©éãå¿
è¦ã¨ããæ
å ±ããã¼ã¿ãã¼ã¹ã«ä½æããã¨ã<ph
+conref="../conrefs.dita#prod/productshortname"></ph> ã®ã¨ã³ã¸ã³ã¯ããã®æ
å ±ãSYSTABLEPERMSã«ããç¹å®ã®è¡ã¸ä¾åãã¦ãããã¨ãç解ãã¾ãã
+ä¾ãã°ã<codeph>user2</codeph>ã<codeph>SELECT * FROM
+user1.t1</codeph>ã¨ããæã§<codeph>v1</codeph>ã¨ãããã¥ã¼ãä½æããã¨ããã¥ã¼ã®<codeph>v1</codeph>ã¨ãGRANTEEæ¬ã<codeph>user2</codeph>ã§TABLEIDæ¬ã<codeph>user1.t1</codeph>ã§ããSYSTABLEPERMSã®è¡ã¨ã®éã«ã管ç対象ã¨ãªãä¾åé¢ä¿ãããã¨ããã°ã©ã ã¯ç解ãã¾ããããã§ãããã°ã©ã ã¯ãã¥ã¼ãç¹å®ã®è¡ã«ä¾åãã¦ãããã¨ãç解ãã¾ããããã®è¡ã«ãã権éã«å¯¾å¿ããæ¬ã®ãã¡ãã©ã®æ¬ã«ä¾åãã¦ããã®ãã¯ç解ãã¦ãã¾ããã</p>
+<p>ãã®ããã§ã表æ¯ã®æ¨©éãå¥å¥ªããREVOKEæãçºè¡ãããã¨ããã®æ¨©éã¨åã表IDã¨ã¦ã¼ã¶ã®çµã¿åãããæã¤æ¨©éã«ä¾åãããã¼ã¿ãã¼ã¹ä¸ã®æ
å ±ã¯å
¨ã¦åé¤ããã¦ãã¾ãã¾ããä¾ã§èª¬æããã¨ã<codeph>user1</codeph>ã<codeph>user2</codeph>ãã表<codeph>t1</codeph>ã®DELETE権éãå¥å¥ªããã¨ãSYSTABLEPERMS表ã®GRANTEEæ¬ã«<codeph>user2</codeph>ãã¨ãTABLEIDæ¬ã«<codeph>user1.t1</codeph>ãã¨ãè¡ãREVOKEæã«ããæ´æ°ããã¾ãããã®ã¨ãä¾åé¢ä¿ã®ç®¡çæ©è½ã«�
�ãããã®è¡ã«è¨é²ãããDELETE権éã«ã¯ä¾åãã¦ããªãã«ããããããã権éã®å¥å¥ªã«ããç¡å¹åã®ã¡ãã»ã¼ã¸ã<codeph>user2.v1</codeph>ã«ãéä¿¡ãããã®ã§ããã®ãã¥ã¼ã¯åé¤ããã¦ãã¾ãã¾ãã</p></dd>
+</dlentry><dlentry>
+<dt>åæ¯ã®æ¨©éã«é¢é£ããå¶é</dt>
+<dd>SYSCOLPERMSã·ã¹ãã 表ã®è¡æ¯ã«ã権éã®ä»ä¸å
ã¨è¡¨IDã®çµã¿åããã«è¨±å¯ããã権éãã²ã¨ã¤ã ãè¨é²ãããã¨ãã§ãã¾ãããã¨ãã°ã<codeph>user2</codeph>ã«è¡¨<codeph>user1.t1</codeph>ã«ããc12ã¨c13ã¨ããåã®SELECT権éãä¸ããããå ´åãSYSCOLPERMSã«ã¯è¡ãã²ã¨ã¤è¿½å ããã¾ãããã®è¡ã¯GRANTEEæ¬ã®å¤ã«<codeph>user2</codeph>ãã¨ããTABLEIDæ¬ã®å¤ã«<codeph>user1.t1</codeph>ãã¨ããTYPEæ¬ã®å¤ã«<codeph>S</codeph>ãã¨ããCOLUMNSæ¬ã®å¤ã«ã¯<codeph>c12, c13</codeph>ãã¨ãã¾ãã
+<p>表ã®åã®éåã«æ¨©éãä»ä¸ãããã¦ã¼ã¶ãããã®æ¨©éã«ä¾åããæ
å ±ããã¼ã¿ãã¼ã¹ã«ä½æããå ´åã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ããã®æ
å ±ã¨SYSCOLPERMS表ã®å¯¾å¿ããè¡ã®éã®ä¾åé¢ä¿ãç解ãã¦ç®¡çä¸ã«èµ·ãã¾ããä¾ãã°<codeph>user2</codeph>ã<codeph>SELECT c11 FROM user1.t1</codeph>ã¨ããæã«ããã<codeph>v1</codeph>ã¨ããè¡ãä½æããã¨ãããã°ã©ã ã¯GRANTEEæ¬ã<codeph>user2</codeph>ã§TABLEIDæ¬ã<codeph>user1.t1</codeph>ãTYPEæ¬ãSã§ããSYSCOLPERMS表ã®è¡ã«ã<cod
eph>v1</codeph>ãä¾åãããã¨ãç解ãã¦ããã®ä¾åé¢ä¿ã管çä¸ã«ç½®ãã¾ãããã®ã¨ããããã°ã©ã ã¯ãã¥ã¼ãSELECT権éã«ä¾åãããã¨ã¯ç解ãã¾ããããã¥ã¼ãã©ã®ã«ã©ã ã«ä¾åãã¦ãããã¯è¿½è·¡ãã¾ããã</p>
+<p>REVOKEæãã«ã©ã ãã¨ã®æ¨©éã«å¯¾ãã¦çºè¡ãããã¨ããã®æ¨©éã®æ¨©éä»ä¸å
ããã¼ãã«IDã権éã®ç¨®é¡ã«ä¾åãããã¼ã¿ãã¼ã¹ä¸ã®æ
å ±ãåé¤ããã¾ããä¾ã§èª¬æããã¨ã<codeph>user1</codeph>ã<codeph>user2</codeph>ããã表<codeph>user1.t1</codeph>ã®å<codeph>c12</codeph>ã¸ã®SELECT権éãå¥å¥ªããã¨ãGRANTEEæ¬ã<codeph>user2</codeph>ã§TABLEIDã<codeph>user1.t1</codeph>ãTYPEæ¬ãSã®SYSCOLPERMSã«ããè¡ããREVOKEæã«ããæ´æ°ããã¾ãããã®ã¨ãä¾åé¢ä¿ã®ç®¡çæ©è½ã«ããã<c
odeph>c12</codeph> ã¨ããåã«ã¯ä¾åãã¦ããªãã«ããããããã権éã®å¥å¥ªã«ããç¡å¹åã®ã¡ãã»ã¼ã¸ã<codeph>user2.v1</codeph>ã¨ãããã¥ã¼ã«ãéä¿¡ãããã®ã§ããã®ãã¥ã¼ã¯åé¤ããã¦ãã¾ãã¾ãã</p></dd>
+</dlentry></dl></section>
+
+
+<example> <title>権éå¥å¥ªã®ä¾</title><p>表<codeph>t</codeph>ã¸ã®SELECT権éãã<codeph>maria</codeph>ã¨<codeph>harry</codeph>ã¨ããèªè¨¼èå¥åããå¥å¥ªããå ´åã次ã®ããã«æãæ¸ãã¾ãã<codeblock><b>REVOKE SELECT ON TABLE t FROM maria,harry</b> </codeblock></p>
+
+<p>表<codeph>t</codeph>ã¸ã®UPDATEãTRIGGER権éã<codeph>anita</codeph>ã¨<codeph>zhi</codeph>ã¨ããèªè¨¼èå¥åããå¥å¥ªããå ´åã次ã®ããã«æãæ¸ãã¾ãã<codeblock><b>REVOKE UPDATE, TRIGGER ON TABLE t FROM anita,zhi</b> </codeblock></p>
+
+<p>表<codeph>s.v</codeph>ã¸ã®SELECT権éãå
¨ã¦ã¼ã¶ããå¥å¥ªããå ´åã次ã®ããã«æãæ¸ãã¾ãã<codeblock><b>REVOKE SELECT ON TABLE s.v FROM PUBLIC</b></codeblock></p>
+
+<p>表<codeph>s.v</codeph>ã®<codeph>c1</codeph>ã¨<codeph>c2</codeph>ã¨ããåã¸ã®UPDATE権éãå
¨ã¦ã®ã¦ã¼ã¶ããå¥å¥ªããå ´åã次ã®ããã«æãæ¸ãã¾ãã<codeblock><b>REVOKE UPDATE (c1,c2) ON TABLE s.v FROM PUBLIC</b></codeblock></p
+>
+
+<p><codeph>p</codeph>ã¨ããæç¶ãã¸ã®EXECUTE権éãã<codeph>george</codeph>ã¨ããèªè¨¼èå¥åããå¥å¥ªããå ´åã次ã®ããã«æãæ¸ãã¾ãã</p><codeblock><b>REVOKE EXECUTE ON PROCEDURE p FROM george RESTRICT</b> </codeblock
+></example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljrevoke.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljtfinvoke.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljtfinvoke.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljtfinvoke.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljtfinvoke.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,43 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqljtfinvoke" xml:lang="ja">
+<title>表é¢æ°ã®å¼ã³åºã</title>
+<refbody>
+<example>
+<codeblock>
+<b>TABLE <i>é¢æ°å</i>( [ [ é¢æ°ã®å¼æ° ] [, é¢æ°ã®å¼æ° ]* ] )
+</b></codeblock></example>
+
+<section>
+<p>
+ä½ãæ¸ã 表é¢æ°ãå¼ã³åºãã¨ãã¯ãç¸é¢åãå²ãå½ã¦ãå¿
è¦ãããã¾ããä¾ãæãã¾ãã
+</p>
+</section>
+
+<example>
+<codeblock>
+<b>
+SELECT s.*
+FROM TABLE( externalEmployees( 42 ) ) s
+</b></codeblock></example>
+
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljtfinvoke.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljtypexml.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsqljtypexml.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsqljtypexml.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsqljtypexml.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,49 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<reference id="rrefsqljtypexml" xml:lang="ja">
+<title>XML data type</title>
+<shortdesc>The XML data type is used for Extensible Markup Language (XML)
+documents.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>XML data type</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>XMLãã¼ã¿åã¯ä»¥ä¸ã®ããã«ä½¿ãã¾ãã<ul>
+<li>SQL/XMLã«å®ç¾©ããããæ´å½¢ãããXML(DOCUMENT(ANY))ã®å¤ãè¨é²ããã</li>
+<li>ä¸æçã«æ´å½¢ãããXML(DOCUMENT(ANY))ã®å¤ã§ã¯ãªããXML(SEQUENCE)ã®å¤ãæ±ãã</li>
+</ul></p><note>XMLãã¼ã¿ã®å¤ããåå¾ã»æ´æ°ã»ååãçãä½ããã®æ¹æ³ã§æä½ããã¢ããªã±ã¼ã·ã§ã³ã§ã¯ãJAXPæ§æ解æå¨ã¨Xalanã®ã¯ã©ã¹ãã¯ã©ã¹ãã¹ã«æããªããã°ãªãã¾ããããããæ§æ解æå¨ã»Xalanã®ä½ãããè¦ã¤ãããªããã°ã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ã¨ã©ã¼ãçºè¡ãã¾ãã
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph>ã§ã¯JDBCã«ã¦ãSQL/XMLãæ±ãæ©è½ãå®è£
ããã¦ããªãã®ã§ãXMLã®å¤ãç´æ¥ãã¤ã³ãããããJDBCã®çµæã»ããããç´æ¥XMLã®å¤ãåå¾ãããã¨ã¯ä¸å¯è½ã§ãã
+ãã®ä»£ããã«ãXMLPARSEãXMLSERIALIZEçã®é©åãªXMLã®æ¼ç®åãæ示çã«SQLã«æ¸ãã¦ãXMLã®æ
å ±ãJavaã®æååãæåã®ã¹ããªã¼ã ã¨ãã¦ããã¤ã³ããããåå¾ããå¿
è¦ãããã¾ãã</p></note></section>
+<refsyn><title>æ§æ</title><codeblock><b>XML</b></codeblock> </refsyn>
+<section><title>対å¿ããã³ã³ãã¤ã«æã®Javaã®å</title><p>ç¡ã</p>
+<p>XMLã®å¤ã«å¯¾å¿ããJavaã®åã®java.sql.SQLXMLã¯åå¨ãã¾ããããããjava.sql.SQLXMLåã¯<ph conref="../conrefs.dita#prod/productshortname"></ph>ã«ã¦ãµãã¼ãããã¦ãã¾ããã</p> </section>
+<section><title>JDBC ã¡ã¿ãã¼ã¿å (java.sql.Types)</title><p>ç¡ã</p>
+<p>XMLã®å¤ã«å¯¾å¿ããã¡ã¿ãã¼ã¿åã®SQLXMLã¯åå¨ãã¾ããããããSQLXMLã¯<ph conref="../conrefs.dita#prod/productshortname"></ph>ã«ã¦ãµãã¼ãããã¦ãã¾ããã</p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph>ã®ãã¼ã¿ãã¼ã¹ããXMLã®å¤ãåå¾ããã¨ãã«ã¯ãååãã®SQLã«ã¦XMLSERIALIZEæ¼ç®åã使ã£ã¦ãã ããã
+ä¾ãæãã¾ãã<codeblock>SELECT XMLSERIALIZE (xcol as CLOB) FROM myXmlTable </codeblock
+>ãããããã¨ã§ãç´ååããåã«å¯¾å¿ããgetXXXã¡ã½ããã使ã£ã¦ãXMLã®å¤ããåå¾ãããã¨ãã§ãã¾ãããã®ä¾ã§ã¯CLOBåã¨ãªãã¾ãã</p>
+<p><ph conref="../conrefs.dita#prod/productshortname"></ph>ã®ãã¼ã¿ãã¼ã¹ã«JDBCã使ã£ã¦XMLã®å¤ãè¨é²ããã¨ãã¯ãSQLæã«ã¦XMLPARSEæ¼ç®åã使ã£ã¦ãã ããã
+ä¾ãæãã¾ãã<codeblock>INSERT INTO myXmlTable(xcol) VALUES XMLPARSE(
+ DOCUMENT CAST (? AS CLOB) PRESERVE WHITESPACE)
+</codeblock>ããã¦ãæååã®åã¨äºææ§ã®ããsetXXXã¡ã½ããã使ã£ã¦ãã ããã
+ãã®ä¾ã§ã¯PreparedStatement.setStringã¾ãã¯PreparedStatement.setCharacterStreamã¡ã½ããã使ã£ã¦ãæ¼ç®åã«å¤ãä¸ãã¾ãã</p> </section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsqljtypexml.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefstringlimits.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefstringlimits.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefstringlimits.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefstringlimits.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,80 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefstringlimits" xml:lang="ja">
+<title>並ã³ã®å¶é</title>
+<refbody>
+<table frame="all"><title>æååã®å¶é</title>
+<desc>以ä¸ã®è¡¨ã«ã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã«ããã並ã³ã®å¤ã®å¶éãè¨ãã¾ãã</desc>
+<tgroup cols="2" colsep="1" rowsep="1"><colspec colname="colspec0" colwidth="228*"/>
+<colspec colname="colspec1" colwidth="228*"/>
+<thead>
+<row>
+<entry align="left" valign="top">å¤</entry>
+<entry align="left" colname="colspec1" valign="top">ä¸é</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="colspec0">CHARã®é·ã</entry>
+<entry colname="colspec1">254æå</entry>
+</row>
+<row>
+<entry colname="colspec0">VARCHARã®é·ã</entry>
+<entry colname="colspec1">32,672æå</entry>
+</row>
+<row>
+<entry colname="colspec0">LONG VARCHARã®é·ã</entry>
+<entry colname="colspec1">32,700æå</entry>
+</row>
+<row>
+<entry colname="colspec0">CLOBã®é·ã</entry>
+<entry colname="colspec1">2,147,483,647æå</entry>
+</row>
+<row>
+<entry colname="colspec0">BLOBã®é·ã</entry>
+<entry colname="colspec1">2,147,483,647æå</entry>
+</row>
+<row>
+<entry colname="colspec0">æåå®æ°ã®é·ã</entry>
+<entry colname="colspec1">32,672</entry>
+</row>
+<row>
+<entry colname="colspec0">çµåãããæååã®é·ã</entry>
+<entry colname="colspec1">2,147,483,647</entry>
+</row>
+<row>
+<entry colname="colspec0">ãã¤ããªä¸¦ã³ã®é·ã</entry>
+<entry colname="colspec1">2,147,483,647</entry>
+</row>
+<row>
+<entry colname="colspec0">16é²æ´æ°ã®å®æ°</entry>
+<entry colname="colspec1">16,336</entry>
+</row>
+<row>
+<entry colname="colspec0">DOUBLEã®å®æ°ã®é·ã</entry>
+<entry colname="colspec1">30 characters</entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefstringlimits.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsynonymname.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsynonymname.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsynonymname.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsynonymname.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,28 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<reference id="rrefsynonymname" xml:lang="ja">
+<title>å¥å</title>
+<refbody>
+<section><p>表ããã¥ã¼ã¯<i>å¥å</i>ã§ããããäºãã§ãã¾ãã
+<i>å¥å</i>ã¯<i>ã¹ãã¼ãå</i>ã§éå®ãããã¨ãã§ãã¾ãã</p></section>
+<section><title>æ§æ</title> <codeblock><b>[ <i><xref href="rrefschemaname.dita#rrefschemaname">ã¹ãã¼ãå</xref>.</i> ] <i><xref
+href="crefsqlj34834.dita#crefsqlj34834">SQL92èå¥å</xref></i></b></codeblock></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsynonymname.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsyscschecktablefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsyscschecktablefunc.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsyscschecktablefunc.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsyscschecktablefunc.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,32 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsyscschecktablefunc" xml:lang="ja">
+<title>SYSCS_UTIL.SYSCS_CHECK_TABLEã·ã¹ãã é¢æ°</title>
+<refbody>
+<section>
+<p><codeph>SYSCS_UTIL.SYSCS_CHECK_TABLE</codeph>é¢æ°ã¯å¼æ°ã«æå®ãã表ãæ¤è¨¼ãã¦ããã®å
¨ã¦ã®ç´¢å¼ã¨æ´åãåãã¦ãããã¨ã確ããã¾ãããã表ã¨ç´¢å¼ãæ´åãã¦ããã°ãã¡ã½ããã¯SMALLINTã®1ãè¿ãã¾ãã
+ãã表ã¨ç´¢å¼ãä¸æ´åã§ããã°ãé¢æ°ã¯ä¾å¤ãæãã¾ãã</p></section>
+<section><title>æ§æ</title> <codeblock>SMALLINT SYSCS_UTIL.SYSCS_CHECK_TABLE(IN SCHEMANAME VARCHAR(128),
+IN TABLENAME VARCHAR(128)) </codeblock> <p>SCHEMANAMEãããã¯TABLENAMEãnullã§ããå ´åãã¨ã©ã¼ãçºçãã¾ãã</p></section>
+<section><title>ä¾</title> <codeblock>VALUES SYSCS_UTIL.SYSCS_CHECK_TABLE('SALES', 'ORDERS');</codeblock></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsyscschecktablefunc.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsyscsdiagtables.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsyscsdiagtables.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsyscsdiagtables.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsyscsdiagtables.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,160 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<reference id="rrefsyscsdialgtables" xml:lang="ja">
+<title>SYSCS_DIAG 診æ表ããã³é¢æ°</title>
+<shortdesc><ph conref="../conrefs.dita#prod/productshortname"></ph>ã«ã¯ã·ã¹ãã 表å¼ãç¨æããã¦ããããã¼ã¿ãã¼ã¹ã®ç¶æ
ããã¼ã¿ãã¼ã¹ã¸ã®æ¥ç¶ã®è¨ºææ
å ±ãåå¾ã§ãã¾ãã</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>diagnostic table functions<indexterm>SYSCS_DIAG.ERROR_LOG_READER</indexterm></indexterm>
+<indexterm>SYSCS_DIAG.ERROR_LOG_READER diagnostic table function</indexterm>
+<indexterm>diagnostic tables<indexterm>SYSCS_DIAG.ERROR_MESSAGES</indexterm></indexterm>
+<indexterm>SYSCS_DIAG.ERROR_MESSAGES diagnostic table</indexterm><indexterm>diagnostic
+table functions<indexterm>SYSCS_DIAG.LOCK_TABLE</indexterm></indexterm><indexterm>SYSCS_DIAG.LOCK_TABLE
+diagnostic table</indexterm><indexterm>diagnostic table functions<indexterm>SYSCS_DIAG.SPACE_TABLE</indexterm></indexterm>
+<indexterm>SYSCS_DIAG.SPACE_TABLE diagnostic table function</indexterm><indexterm>diagnostic
+tables<indexterm>SYSCS_DIAG.STATEMENT_CACHE</indexterm></indexterm><indexterm>SYSCS_DIAG.STATEMENT_CACHE
+diagnostic table</indexterm><indexterm>diagnostic table functions<indexterm>SYSCS_DIAG.STATEMENT_DURATION</indexterm></indexterm>
+<indexterm>SYSCS_DIAG.STATEMENT_DURATION diagnostic table functions</indexterm>
+<indexterm>diagnostic tables<indexterm>SYSCS_DIAG.TRANSACTION_TABLE</indexterm></indexterm>
+<indexterm>SYSCS_DIAG.TRANSACTION_TABLE diagnostic table</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p><ph conref="../conrefs.dita#prod/productshortname"></ph>ã«ã¯äºç¨®é¡ã®è¨ºæ表å¼ãããã¾ãã<dl>
+<dlentry>
+<dt>診æ表</dt>
+<dd><ph conref="../conrefs.dita#prod/productshortname"></ph>ã®ä¸è¬çãªè¡¨ã¨åæ§ãªãã®ã§ãã
+表åãç½®ããã¨ãã§ããå ´æãªãã©ãã«ã§ã診æ表ã®ååãããã¾ãã</dd>
+</dlentry><dlentry>
+<dt>診æ表é¢æ°</dt>
+<dd><ph conref="../conrefs.dita#prod/productshortname"></ph>ã®ä¸è¬çãªé¢æ°ã¨åæ§ãªãã®ã§ãã診æ表é¢æ°ã«ã¯é¢æ°ã«å¿ãã¦ã0ãããã¯ãã以ä¸ã®å¼æ°ãåããã¨ãã§ãã¾ããSQLã«å®ç¾©ããã表é¢æ°ã®æ§æã«åºã¥ãããããã®é¢æ°ã使ãå¿
è¦ãããã¾ãã</dd>
+</dlentry></dl> </p>
+<p>以ä¸ã®è¡¨ã«ã¯<ph conref="../conrefs.dita#prod/productshortname"></ph>ã®è¨ºæ表å¼ã®å称ã¨ç¨®é¡ãè¨ãã¾ãã</p><table>
+<title><ph conref="../conrefs.dita#prod/productshortname"></ph>ã®ã·ã¹ãã 診æ表å¼</title>
+<tgroup cols="2"><colspec colname="col1" colwidth="50*"/><colspec colname="col2"
+colwidth="49*"/>
+<thead>
+<row valign="bottom">
+<entry colname="col1">診æ表å¼</entry>
+<entry colname="col2">å¼ã®ç¨®é¡</entry>
+</row>
+</thead>
+<tbody>
+<row>
+<entry colname="col1">SYSCS_DIAG.ERROR_LOG_READER</entry>
+<entry colname="col2">表é¢æ°</entry>
+</row>
+<row>
+<entry colname="col1">SYSCS_DIAG.ERROR_MESSAGES</entry>
+<entry colname="col2">表</entry>
+</row>
+<row>
+<entry colname="col1">SYSCS_DIAG.LOCK_TABLE</entry>
+<entry colname="col2">表</entry>
+</row>
+<row>
+<entry colname="col1">SYSCS_DIAG.SPACE_TABLE</entry>
+<entry colname="col2">表é¢æ°</entry>
+</row>
+<row>
+<entry colname="col1">SYSCS_DIAG.STATEMENT_CACHE</entry>
+<entry colname="col2">表</entry>
+</row>
+<row>
+<entry colname="col1">SYSCS_DIAG.STATEMENT_DURATION</entry>
+<entry colname="col2">表é¢æ°</entry>
+</row>
+<row>
+<entry colname="col1">SYSCS_DIAG.TRANSACTION_TABLE </entry>
+<entry colname="col2">表</entry>
+</row>
+</tbody>
+</tgroup>
+</table><p><note type="restriction">DDLãå§ç¸®ã®æç¶ãã«ã¦è¨ºæ表ãåç
§ããå ´åã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã¯ä¾å¤ãè¿ãã¾ãã</note></p></section>
+<section><title>SYSCS_DIAG.ERROR_LOG_READER 診æ表é¢æ°</title>
+<p>SYSCS_DIAG.ERROR_LOG_READER診æ表é¢æ°ããã¯ã<filepath>derby.log</filepath>ãã¡ã¤ã«ãæå®ããä»»æã®ãã°ãã¡ã¤ã«ã«ããå
¨ã¦ã®SQLæãå¾ããã¾ãã</p>
+<p>ãã®è¨ºæ表é¢æ°ã使ããã¨ã§ãæ´»åä¸ã®ãã©ã³ã¶ã¯ã·ã§ã³ããã³ä»»æã®æç¹ã®ãã©ã³ã¶ã¯ã·ã§ã³ãç¥ããã¨ãã§ãã¾ãããã¨ãã°ãããããã¯ãããã¯ã®æéåããçºçããå ´åãã¨ã©ã¼ãã°ããã¿ã¤ã ã¹ã¿ã³ã(timestampConstant)ãè¦ã¤ãããã¨ãã§ãã¾ãã</p>
+<p>SYSCS_DIAG.ERROR_LOG_READER診æ表é¢æ°ã使ãã«ã¯ãSQL表é¢æ°ã®æ§æã«åºã¥ãå¿
è¦ãããã¾ãã</p>
+<p>ä¾ãæãã¾ãã:<codeblock>SELECT *
+ FROM TABLE (SYSCS_DIAG.ERROR_LOG_READER())
+ AS T1</codeblock>
+ããã§T1ã¯ã¦ã¼ã¶ãæå®ãã表ã®ååã§ãããã¯ä»»æã®èå¥åã§ãã</p>
+<p>SYSCS_DIAG.ERROR_LOG_READER診æ表é¢æ°ã«ã¯ãéæã§æå®ããå¼æ°ã¨ãã¦ãã°ãã¡ã¤ã«ã®ååãä¸ãããã¨ãã§ãã¾ãããã°ãã¡ã¤ã«ã®ååãæå®ããå ´åããã¡ã¤ã«åã¯Javaã§æååã¨ã¿ãªããå¼ã§ãªããã°ãªãã¾ããã</p>
+<p>For example:<codeblock>SELECT *
+ FROM TABLE (SYSCS_DIAG.ERROR_LOG_READER('myderbyerrors.log'))
+ AS T1</codeblock></p>
+<p><note type="tip"> æ¢å®ã§ã¯<ph conref="../conrefs.dita#prod/productshortname"></ph>ã®ãã°ãã¡ã¤ã«ã«ã¯èµ·åãçµäºãã¨ã©ã¼ã¡ãã»ã¼ã¸ããããã¾ããã
+ãã詳細ãªæ
å ±ã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã®ãã°ãã¡ã¤ã«ã«åºåããæ¹æ³ã¯ã<cite><ph conref="../conrefs.dita#pub/cittuning"></ph>ã¬ã¤ã</cite>ã®<parmname>derby.stream.error.logSeverityLevel</parmname>å±æ§ã¨ã<parmname>derby.language.logStatementText</parmname>å±æ§ãèªãã§ãã ããã</note></p></section>
+<section><title>SYSCS_DIAG.ERROR_MESSAGES 診æ表</title>
+<p>SYSCS_DIAG.ERROR_MESSAGES診æ表ã«ã¯ãå
¨ã¦ã®SQLStateãå°åã«å¯¾å¿ããã¨ã©ã¼ã¡ãã»ã¼ã¸ã
+<ph conref="../conrefs.dita#prod/productshortname"></ph>ãã¼ã¿ãã¼ã¹ã§ã®ä¾å¤æ·±å»åº¦ãè¨è¿°ããã¾ãã
+æã«ã¦ç´æ¥ã«SYSCS_DIAG.ERROR_MESSAGES診æ表ãåç
§ãããã¨ãã§ãã¾ãã</p>
+<p>ä¾ãæãã¾ãã<codeblock>SELECT * FROM SYSCS_DIAG.ERROR_MESSAGES</codeblock></p></section>
+<section><title>SYSCS_DIAG.LOCK_TABLE 診æ表</title>
+<p>SYSCS_DIAG.LOCK_TABLE診æ表ã«ã¯ãç¾å¨æç¹ã®<ph
+conref="../conrefs.dita#prod/productshortname"></ph>ãã¼ã¿ãã¼ã¹ã®å
¨ããã¯ãè¨è¿°ããã¾ãã
+SYSCS_DIAG.LOCK_TABLE診æ表ã¯æã«ã¦ç´æ¥åç
§ãããã¨ãã§ãã¾ãã</p>
+<p>ä¾ãæãã¾ãã<codeblock>SELECT * FROM SYSCS_DIAG.LOCK_TABLE</codeblock></p>
+<p>SYSCS_DIAG.LOCK_TABLE診æ表ãæã«ã¦åç
§ãããå ´åã表ã®ããã¯ã®ã¹ãããã·ã§ãããæ®ããã¾ãã
+ãã®ã¹ãããã·ã§ããã¯è¨ºæ表ãåç
§ãã¦ããã¢ããªã±ã¼ã·ã§ã³ã®é常å¦çæéãå¦çã®æµãã«å½±é¿ãåºãªãããã«ç¨æããããã®ã§ãã
+ãã®ã¹ãããã·ã§ãããæ®ãããæãããã¯ãç¶æ
é·ç§»ä¸ã§ããå¯è½æ§ãããã¾ãã</p></section>
+<section><title>SYSCS_DIAG.SPACE_TABLE 診æ表é¢æ°</title>
+<p>SYSCS_DIAG.SPACE_TABLE診æ表é¢æ°ã§ã¯ãæå®ãã表ã¨ãã®ç´¢å¼ãå©ç¨ãã¦ããé åã表示ã§ãã¾ãã
+ãã®è¨ºæ表é¢æ°ã«ãã表ãç´¢å¼ãå§ç¸®ãããã¨ã§ãã©ãã ãé åãç¯ç´ã§ãããç¥ããã¨ãã§ãã¾ãã</p>
+<p>SYSCS_DIAG.SPACE_TABLE診æ表é¢æ°ã使ãã«ã¯ãSQL表é¢æ°ã®æ§æã«å¾ãå¿
è¦ãããã¾ãã
+ãã®è¨ºæ表é¢æ°ã¯äºã¤ã®å¼æ°ãã¨ãã¾ãã<parmname>ã¹ãã¼ãå</parmname>ã¨<parmname>表å</parmname>ã§ãã
+<parmname>表å</parmname>ã¯å¿
é ã§ãã<parmname>ã¹ãã¼ãå</parmname>ãæå®ããªãã£ãå ´åãç¾å¨ã®ã¹ãã¼ããé©ç¨ããã¾ãã</p>
+<p>ãã¨ãã°ä»¥ä¸ã®åãåããã§ã¯ããã¼ã¿ãã¼ã¹ã«ããå
¨ã¦ã¼ã¶è¡¨ã¨ç´¢å¼ã®å©ç¨ããé åãè¿ãã¾ãã<codeblock>SELECT T2.*
+ FROM
+ SYS.SYSTABLES systabs,
+ TABLE (SYSCS_DIAG.SPACE_TABLE(systabs.tablename)) AS T2
+ WHERE systabs.tabletype = 'T'</codeblock>
+ããã§T2ã¯ã¦ã¼ã¶æå®ã®è¡¨åã§ãä»»æã®èå¥åãæå®ã§ãã¾ãã</p>
+<p><parmname>ã¹ãã¼ãå</parmname>ã¨<parmname>表å</parmname>ã¯ãä½ããJavaã®æåååã¨ã¿ãªãããå¼ã§ãªããã°ãªãã¾ããã
+<parmname>ã¹ãã¼ãå</parmname>ã¨<parmname>表å</parmname>ãããªãããããªãèå¥åã§ãã£ãå ´åãååã¯å¤§æåã§æå®ããªããã°ãªãã¾ããã</p>
+<p>ä¾ãæãã¾ãã<codeblock>SELECT *
+ FROM TABLE (SYSCS_DIAG.SPACE_TABLE('MYSCHEMA', 'MYTABLE'))
+ AS T2</codeblock></p></section>
+<section><title>SYSCS_DIAG.STATEMENT_CACHE 診æ表</title>
+<p>SYSCS_DIAG.STATEMENT_CACHE診æ表ã«ã¯SQLæãã£ãã·ã¥ã®å
容ãè¨è¿°ããã¾ãã
+SYSCS_DIAG.STATEMENT_CACHE診æ表ã¯æããç´æ¥åç
§ã§ãã¾ãã</p>
+<p>ä¾ãæãã¾ãã<codeblock>SELECT * FROM SYSCS_DIAG.STATEMENT_CACHE</codeblock></p></section>
+<section><title>SYSCS_DIAG.STATEMENT_DURATION 診æ表é¢æ°</title>
+<p>SYSCS_DIAG.STATEMENT_DURATION診æ表é¢æ°ã使ã£ã¦ã<filepath>derby.log</filepath>ãã¡ã¤ã«ãæå®ãããã°ãã¡ã¤ã«ã«ããSQLæã®<term>å®è¡æé</term>ãç¥ããã¨ãã§ãã¾ãã</p>
+<p>ãã®è¨ºæé¢æ°ã使ããã¨ã§ãã¢ããªã±ã¼ã·ã§ã³ã®JDBCã³ã¼ãã®ã©ãã«ããã«ããã¯ããããã®ãæããããå¾ããã¨ãã§ãã¾ãã</p>
+<p>SYSCS_DIAG.STATEMENT_DURATION診æ表é¢æ°ã使ãã«ã¯ãSQLã®è¡¨é¢æ°æ§æã«åºã¥ãå¿
è¦ãããã¾ãã</p>
+<p>ä¾ãæãã¾ãã<codeblock>SELECT *
+ FROM TABLE (SYSCS_DIAG.STATEMENT_DURATION())
+ AS T1</codeblock>
+ããã§T1ã¯ã¦ã¼ã¶ãæå®ãã表åã§ãä»»æã®èå¥åãæå®ã§ãã¾ãã</p>
+<note type="restriction">ãã®è¡¨ã§ã¯ãåã
ã®ãã©ã³ã¶ã¯ã·ã§ã³IDã«ãããæå¾ã®ææ¯ã«ãè¡ã対å¿ãã¦ãã¾ããããã©ã³ã¶ã¯ã·ã§ã³ã«ããæ
å ±ã®å¤æ´ããã£ãå ´åããã©ã³ã¶ã¯ã·ã§ã³IDã¯ã³ãããããã¼ã«ãã³ã¯ã®åå¾ã§å¤ãå¤ããã¾ãã</note>
+<p>SYSCS_DIAG.STATEMENT_DURATION診æ表é¢æ°ã«ã¯éæã®å¼æ°ã¨ãã¦ãã°ãã¡ã¤ã«ãæå®ã§ãã¾ãã
+ãã°ãã¡ã¤ã«åãæå®ããå ´åããã¡ã¤ã«åã¯Javaã®æååã¨ã¿ãªããå¼ã§ãªããã°ãªãã¾ããã</p>
+<p>ä¾ãæãã¾ãã<codeblock>SELECT *
+ FROM TABLE (SYSCS_DIAG.STATEMENT_DURATION('somederby.log'))
+ AS T1</codeblock></p>
+<p><note type="tip"> æ¢å®ã§ã¯<ph conref="../conrefs.dita#prod/productshortname"></ph>ã®ãã°ãã¡ã¤ã«ã«ã¯èµ·åãçµäºãã¨ã©ã¼ã¡ãã»ã¼ã¸ã ããåºåããã¾ãã
+ãã詳細ãªæ
å ±ã<ph conref="../conrefs.dita#prod/productshortname"></ph>ã®ãã°ãã¡ã¤ã«ã«åºåããæ¹æ³ã¯ã<cite><ph conref="../conrefs.dita#pub/cittuning"></ph>ã¬ã¤ã</cite>ã®<parmname>derby.stream.error.logSeverityLevel</parmname>å±æ§ã¨ã<parmname>derby.language.logStatementText</parmname>å±æ§ãèªãã§ãã ããã
+ãã以å¤ã®æ
å ±ãããã°ãSYSCS_DIAG.STATEMENT_DURATION診æ表é¢æ°ã§åãåããå¯è½ã§ãã</note></p></section>
+<section><title>SYSCS_DIAG.TRANSACTION_TABLE 診æ表</title>
+<p>SYSCS_DIAG.TRANSACTION_TABLE診æ表ã«ã¯ç¾å¨ãã¼ã¿ãã¼ã¹ã«åå¨ããå
¨ãã©ã³ã¶ã¯ã·ã§ã³ãè¨è¿°ããã¾ããSYSCS_DIAG.TRANSACTION_TABLE診æ表ã¯æããç´æ¥åç
§ã§ãã¾ãã</p>
+<p>ä¾ãæãã¾ãã<codeblock>SELECT * FROM SYSCS_DIAG.TRANSACTION_TABLE</codeblock></p>
+<p>æã«ã¦SYSCS_DIAG.TRANSACTION_TABLE診æ表ãåç
§ãããã¨ããã©ã³ã¶ã¯ã·ã§ã³è¡¨ã®ã¹ãããã·ã§ãããæ®ããã¾ããã¹ãããã·ã§ããã¯è¨ºæ表ãåç
§ãã¦ããã¢ããªã±ã¼ã·ã§ã³ã®é常å¦çæéãå¦çã®æµãã«å½±é¿ãåºãªãããç¨æããã¾ãããã©ã³ã¶ã¯ã·ã§ã³ã¯ã¹ãããã·ã§ããã®ä½ææã«ç¶æ
é·ç§»ä¸ã§ããå ´åãããã¾ãã</p></section>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsyscsdiagtables.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rrefsyscsruntimestatsfunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rrefsyscsruntimestatsfunc.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rrefsyscsruntimestatsfunc.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rrefsyscsruntimestatsfunc.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,35 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsyscsruntimestatsfunc" xml:lang="ja">
+<title>SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS ã·ã¹ãã é¢æ°</title>
+<refbody>
+<section>
+<p><codeph>SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS</codeph>é¢æ°ã¯ãjava.sql.ResultSetã«å¯¾ããååãã®å®è¡è¨ç»ããã³å¦çæéã®çµ±è¨ã表ããVARCHAR(32762)ã®å¤ãè¿ãã¾ãã
+ååãã®å®è¡è¨ç»ã¯å®è¡ãã¼ããããªãæ¨æ§é ã®æ
å ±ã§ãã
+ãã®ãã¼ãã«ã¯å¹¾ã¤ãã®ç¨®é¡ãããã¾ãã
+çµ±è¨ã¯ããããã®ãã¼ããå®è¡ããããã³ã«åè¨ããã¦ããã¾ããçµ±è¨ãããå¤ã«ã¯ãç¹å®ã®å¦çã«ããã£ãæéã®åè¨ããã¼ãã®åãã渡ãããè¡æ°ããã®ãã¼ããã親ã«è¿ãããè¡æ°çããã¾ãã(å®éã«ä½ãéè¨ãããã®ãã¯ãããããã®ãã¼ãã®ç¨®é¡ã«ãã決ã¾ãã¾ãã)
+<codeph>SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS</codeph>ãæãææ義ã«æ©è½ããã®ã¯ãSELECTãINSERTãUPDATEçã®DMLæã«å¯¾ãã¦ã§ãã
+</p></section>
+<section><title>æ§æ</title> <codeblock>VARCHAR(32762) SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS() </codeblock></section>
+<section><title>ä¾</title> <codeblock>VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()</codeblock></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rrefsyscsruntimestatsfunc.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rreftableexpression.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rreftableexpression.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rreftableexpression.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rreftableexpression.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,52 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="ja" id="rreftableexpression">
+<title>TableExpression</title>
+<prolog><metadata>
+<keywords><indexterm>表å¼</indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section>
+<p><i>表å¼</i>ã«ãã表ããã¥ã¼ãããã¯é¢æ°ãã<xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM ç¯</xref>ã«ã¦æå®ãã¾ãããããã<i><xref href="rrefselectexpression.dita#rrefselectexpression">é¸æå¼</xref></i>ã«ã¦çµæãé¸æããã¾ãã</p>
+<p>åãéå®ããããã«ãç¸é¢åã<i>表å¼</i>ã«é©ç¨ãããã¨ãã§ãã¾ãã
+ç¸é¢åãä¸ããããªãå ´åã表åãååãéå®ãã¾ãã
+ãã表ã«ç¸é¢åãä¸ããããå ´åã表åã«ããåãéå®ãããã¨ã¯ã§ãããååãç¸é¢åã§éå®ããªããã°ãªãã¾ããã</p>
+<p>FROMç¯ã«ããé
ç®ã¯ãåãååã®ç¸é¢åãæã¤ãã¨ãã§ãã¾ãããã¾ãç¸é¢åã¯FROMç¯ã«ãã表ã®éå®ãããªãååã¨åãååã§ãã£ã¦ã¯ãªãã¾ããã</p>
+<p>ããã«ASç¯ã使ã£ã¦è¡¨ã®åã«ååãä¸ãããã¨ãã§ãã¾ããããã¯ä»¥ä¸ã®ç¶æ³ã§ä¾¿å©ã§ãã<ul>
+<li><xref href="rrefsqlj11277.dita#rrefsqlj11277">VALUESå¼</xref>ã<i><xref href="rreftablesubquery.dita#rreftablesubquery">表å¯ååã</xref></i>ã§ä½¿ããã¦ããå ´åã<xref href="rrefsqlj11277.dita#rrefsqlj11277">VALUESå¼</xref>ã®åã«ååãä¸ããæ¹æ³ã¯ãä»ã«ã¯ç¡ãã§ãã</li>
+<li>ååãä»ã®è¡¨ã®ååã¨åãå ´åãå¥ã®ååãä¸ãããã¨ã§éå®ã®å¿
è¦ããªããªãã¾ãã</li>
+</ul></p>
+<p><i>Fromã®é
ç®</i>ã«ãã<i><xref href="rreftablesubquery.dita#rreftablesubquery">表å¯ååã</xref></i>ã®ååãã«ã¯ãè¤æ°åãç½®ããã¨ãã§ããè¤æ°è¡ãè¿ããã¨ãã§ãã¾ãã<i><xref href="rreftablesubquery.dita#rreftablesubquery"></xref></i>ãåç
§ãã¦ãã ããã</p>
+<p>ã¦ã¼ã¶ãæé©åã®ããä½ãæå®ã§ãããã«ã¤ãã¦ã¯ã<cite><ph conref="../conrefs.dita#pub/cittuning"></ph></cite>ãåç
§ãã¦ãã ããã</p></section>
+<refsyn><title>æ§æ</title>
+<codeblock><b>{
+表ããã¥ã¼ãããã¯é¢æ°å¼ | çµåå¼
+}
+</b></codeblock>
+</refsyn>
+<example><title>ä¾</title><codeblock><b>
+<ph>-- çµåå¼ããé¸æã§ãã¾ãã</ph>
+SELECT E.EMPNO, E.LASTNAME, M.EMPNO, M.LASTNAME
+ FROM EMPLOYEE E LEFT OUTER JOIN
+ DEPARTMENT INNER JOIN EMPLOYEE M
+ ON MGRNO = M.EMPNO
+ ON E.WORKDEPT = DEPTNO
+</b></codeblock>
+</example></refbody></reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rreftableexpression.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rreftablename.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rreftablename.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rreftablename.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rreftablename.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,31 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rreftablename" xml:lang="ja">
+<title>表å</title>
+<refbody>
+<section><p><i>表å</i>ã¯è¡¨ãããããã¾ãã<i>表å</i>ã¯<i>ã¹ãã¼ãå</i>ã§éå®ãããã¨ãã§ãã¾ãã</p></section>
+<section><title>æ§æ</title> <codeblock><b>[ <i><xref href="rrefschemaname.dita#rrefschemaname">ã¹ãã¼ãå</xref>.</i> ] <i><xref
+href="crefsqlj34834.dita#crefsqlj34834">SQL92èå¥å</xref></i></b></codeblock></section>
+<section><title>ä¾</title> <codeblock><b><ph>-- SAMP.PROJECT ã¯ã¹ãã¼ãåã®ãã表åã§ãã</ph>
+SELECT COUNT(*) FROM SAMP.PROJECT</b></codeblock></section>
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rreftablename.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rreftablesubquery.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rreftablesubquery.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rreftablesubquery.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rreftablesubquery.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,71 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="ja" id="rreftablesubquery">
+<title>表å¯ååã</title>
+<prolog><metadata>
+<keywords><indexterm>TableSubquery</indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section>
+<p><i>表å¯ååã</i>ã¯è¤æ°ã®è¡ãè¿ãå¯ååãã§ãã</p>
+<p><i><xref href="rrefscalarsubquery.dita#rrefscalarsubquery">ã¹ã«ã©ã¼å¯ååã</xref></i>ã¨ã¯ç°ãªãã<i>表å¯ååã</i>ã¯ä»¥ä¸ã®æèã«ã¦ã®ã¿å¯è½ã§ãã
+<ul>
+<li><xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM ç¯</xref>ã®<i><xref href="rreftableexpression.dita#rreftableexpression">表å¼</xref></i></li>
+<li>EXISTSãINãéã®æ¯è¼</li>
+</ul></p>
+<p><xref href="rrefsqlj21583.dita#rrefsqlj21583">FROM ç¯</xref>ã®<i><xref href="rreftableexpression.dita#rreftableexpression">表å¼</xref></i>ã«ã¦ä½¿ãããå ´åãè¤æ°ã®åãè¿ããã¨ãã§ãã¾ãã</p>
+<p>EXISTSã§ã¯ã*ã使ãå ´åã®ã¿è¤æ°ã®åãè¿ããã¨ãã§ãã¾ãã</p>
+<p>INãéå®æ¡ä»¶ã§ã¯ãååã®ã¿è¿ããã¨ãã§ãã¾ãã</p></section>
+<refsyn><title>æ§æ</title>
+<codeblock><b>(<i><xref href="rrefsqlj21571.dita#rrefsqlj21571">ååã</xref></i>)</b></codeblock>
+</refsyn>
+<example><title>ä¾</title><codeblock><b><ph>-- FROMç¯ã®è¡¨å¼ã¨ãã¦ãå¯ååãã使ãã</ph>
+SELECT VirtualFlightTable.flight_ID
+FROM
+ (SELECT flight_ID, orig_airport, dest_airport
+ FROM Flights
+ WHERE (orig_airport = 'SFO' OR dest_airport = 'SCL') )
+AS VirtualFlightTable
+<ph>-- FROMç¯ã®è¡¨å¼ã¨ãã¦ãå¯ååã(valueså¼)ã使ãã</ph>
+SELECT mycol1
+FROM
+ (VALUES (1, 2), (3, 4))
+AS mytable (mycol1, mycol2)
+<ph>-- EXISTSã«ã¦å¯ååãã使ã</ph>
+SELECT *
+FROM Flights
+WHERE EXISTS
+ (SELECT * FROM Flights WHERE dest_airport = 'SFO'
+ AND orig_airport = 'GRU')
+<ph>-- INã«ã¦å¯ååãã使ã</ph>
+SELECT flight_id, segment_number
+FROM Flights
+WHERE flight_id IN
+ (SELECT flight_ID
+ FROM Flights WHERE orig_airport = 'SFO'
+ OR dest_airport = 'SCL')
+<ph>-- å®éæ¯è¼ã«ã¦å¯ååãã使ã</ph>
+SELECT NAME, COMM
+FROM STAFF
+WHERE COMM >
+(SELECT AVG(BONUS + 800)
+ FROM EMPLOYEE
+ WHERE COMM < 5000)</b></codeblock>
+</example></refbody></reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rreftablesubquery.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native
Added: db/derby/docs/trunk/src/ja_JP/ref/rreftimefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ja_JP/ref/rreftimefunc.dita?rev=609101&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ja_JP/ref/rreftimefunc.dita (added)
+++ db/derby/docs/trunk/src/ja_JP/ref/rreftimefunc.dita Sat Jan 5 00:25:17 2008
@@ -0,0 +1,43 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+<reference id="rreftimefunc" xml:lang="ja">
+<title>TIME é¢æ°</title>
+<shortdesc>TIMEé¢æ°ã¯å¤ã®æå»ã®é¨åãè¿ãã¾ãã</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>TIME function</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>å¼æ°ã¯æå»ãã¿ã¤ã ã¹ã¿ã³ããCLOBã»LONG VARCHARã»XML以å¤ã®æå»ãã¿ã¤ã ã¹ã¿ã³ãã表ãæå¹ãªæååã§ããå¿
è¦ãããã¾ãã
+ãã®é¢æ°ã®çµæã¯æå»ã§ããå¼æ°ã«nullãã¨ããã¨ãããå ´åãè¿ãå¤ãnullãã¨ããã¨ãããã¾ãã
+å¼æ°ãnullãªããè¿ãå¤ã¯nullã§ãã
+</p>
+<p>
+å¼æ°ã®ãã¼ã¿åã«å¿ãã¦ã以ä¸ã®è¦åãããã¾ãã
+<ul>
+<li>å¼æ°ãæå»ãªããè¿ãå¤ã¯ãã®æå»ã§ãã</li>
+<li>å¼æ°ãã¿ã¤ã ã¹ã¿ã³ããªããè¿ãå¤ã¯ã¿ã¤ã ã¹ã¿ã³ãã®æå»ã®é¨åã§ãã</li>
+<li>ããå¼æ°ãæååãªããè¿ãå¤ã¯æååã表ãæå»ã§ãã</li>
+</ul></p></section>
+<refsyn><title>æ§æ</title> <codeblock><b>TIME ( <i>å¼</i> )</b></codeblock> </refsyn>
+<example> <codeblock><b>values time(current_timestamp)</b></codeblock>
+<p>ããç¾å¨æå»ãåå¾5:03ãªããè¿ãå¤ã¯<codeph>17:03:00</codeph>ã§ãã</p> </example>
+</refbody>
+</reference>
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rreftimefunc.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native