Return-Path:
Delivered-To: apmail-db-derby-commits-archive@www.apache.org
Received: (qmail 67028 invoked from network); 5 Jan 2008 08:27:31 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
by minotaur.apache.org with SMTP; 5 Jan 2008 08:27:31 -0000
Received: (qmail 36579 invoked by uid 500); 5 Jan 2008 08:27:20 -0000
Delivered-To: apmail-db-derby-commits-archive@db.apache.org
Received: (qmail 36551 invoked by uid 500); 5 Jan 2008 08:27:20 -0000
Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help:
list-unsubscribe:
List-Post:
Reply-To: "Derby Development"
List-Id:
Delivered-To: mailing list derby-commits@db.apache.org
Received: (qmail 36540 invoked by uid 99); 5 Jan 2008 08:27:20 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 05 Jan 2008 00:27:20 -0800
X-ASF-Spam-Status: No, hits=-100.0 required=10.0
tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.3] (HELO eris.apache.org) (140.211.11.3)
by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 05 Jan 2008 08:27:03 +0000
Received: by eris.apache.org (Postfix, from userid 65534)
id C31131A9864; Sat, 5 Jan 2008 00:26:21 -0800 (PST)
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Subject: svn commit: r609101 [25/26] - in /db/derby/docs/trunk: ./ src/ja_JP/
src/ja_JP/ref/
Date: Sat, 05 Jan 2008 08:25:38 -0000
To: derby-commits@db.apache.org
From: tmnk@apache.org
X-Mailer: svnmailer-1.0.8
Message-Id: <20080105082621.C31131A9864@eris.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org
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 @@
+
+
+
+
+ RENAME COLUMN æ
+RENAME COLUMN æã§è¡¨ã«ããåã®ååãå¤æ´ã§ãã¾ãã
+
+RENAME COLUMN statement
+SQL statementsRENAME COLUMN
+columnsrenaming
+
+
+
+ RENAME COLUMNæã«ããå
¨ã¦ã®ã¹ãã¼ãã«ããæ¢å表ã®æ¢ååã®ååãå¤æ´ã§ãã¾ãã(SYSã®ã¹ãã¼ããé¤ãã¾ãã)
+åã®ååãå¤ãããã¨ãã§ããã®ã¯ããã¼ã¿ãã¼ã¹ã®ææè
ãããã¯è¡¨ã®ææè
ã®ã¿ã§ãã
+表ã¸ã®ä»ã®å®ç¾©å¤æ´ã¯å¯è½ã§ãã詳細ã¯ããåç
§ãã¦ãã ããã
+
+æ§æ
+ RENAME COLUMN 表å.åç´åå TO åç´åå
+
+
+ä¾
+employeeã¨ãã表ã«ããmanagerã¨ããåã®ååã
+supervisorã«å¤æ´ããã«ã¯æ¬¡ã®ããã«ãã¾ãã
+RENAME COLUMN EMPLOYEE.MANAGER TO SUPERVISOR
+
+ALTER TABLEã¨RENAME COLUMNã使ã£ã¦ãåã®ãã¼ã¿åãå¤æ´ã§ãã¾ãã
+tã¨ãã表ã«ããc1ã¨ããåã®ãã¼ã¿åãNEWTYPEã«å¤æ´ããããã«ã¯ã次ã®ããã«ãã¾ãã
+
+ 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
+
+
+å©ç¨ä¸ã®çæç¹
+åãåç
§ãããã¥ã¼ãããªã¬ããã§ãã¯å¶ç´ãå¤é¨ãã¼å¶ç´ãããå ´åãååã®å¤æ´ã¯å¤±æãã¾ãã
+
+å称ãå¤æ´ããåãåç
§ãããéããã«ã¼ã½ã«ãããå ´åãRENAME COLUMNæã¯å®è¡ã§ãã¾ããã
+åã¸ã®ç´¢å¼ããã£ã¦ããåã®ååã¯å¤æ´ã§ãã¾ããç´¢å¼ã¯æ´æ°ããã¦ãå¤æ´å¾ã®ååã§åç
§ããããã«ãªãã¾ãã
+
+
+
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 @@
+
+
+
+
+RENAME TABLE æ
+
+RENAME TABLE statementSQL
+statementsRENAME TABLEtablesrenaming
+
+
+
+ RENAME TABLEã«ããããããã¹ãã¼ãã«ããæ¢åã®è¡¨ã®ååãå¤æ´ã§ãã¾ãã(ãã ãSYSã®ã¹ãã¼ãã¯é¤ãã¾ãã)
+表ã®ååãå¤æ´ã§ããã®ã¯ãã¼ã¿ãã¼ã¹ã®ææè
ã¨è¡¨ã®ææè
ã§ãã
+æ§æ RENAME TABLE 表å TO æ°è¡¨å
+表ãåç
§ãããã¥ã¼ãå¤é¨ãã¼ããã£ãå ´åãååãå¤ãããã¨ããã¨ã¨ã©ã¼ãçºçãã¾ãã
+ããã«ã表ã«ããªã¬ããã§ãã¯å¶ç´ããã£ãå ´åããååãå¤ãããã¨ããã¨ã¨ã©ã¼ãçºçãã¾ãã
+ RENAME TABLE SAMP.EMP_ACT TO EMPLOYEE_ACT
+詳細ã«ã¤ãã¦ã¯ããåç
§ãã¦ãã ããã
+æã®ä¾å
+表ã«ç´¢å¼ãå®ç¾©ããã¦ãã¦ãã表ã®ååã¯å¤æ´å¯è½ã§ãã
+ååãå¤æ´ãããã¨ãã表ã«ãéããã«ã¼ã½ã«ããã£ãå ´åãRENAME TABLEæã¯å¤±æãã¾ãã
+
+
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 @@
+
+
+
+
+
+REVOKE æ
+REVOKEæã使ã£ã¦ãæå®ããã¦ã¼ã¶ãããã¯å
¨ã¦ã¼ã¶ããããã¼ã¿ãã¼ã¹ã®æ
å ±ã«å¯¾ãã¦æä½ãè¡ã権éãå¥å¥ªãããã¨ãã§ãã¾ãã
+
+REVOKE statementsyntax
+SQL statementsREVOKEREVOKE
+statementlimitationsprivilegestables
+and columns, revoking
+
+
+ å¥å¥ªã§ãã権éã«ã¯æ¬¡ã®ç¨®é¡ãããã¾ãã
+- 表ããæ
å ±ãåé¤ããã
+- 表ã«æ
å ±ãæ¿å
¥ããã
+- 表ã表ã«ããåã®é¨åéåã«å¯¾ãã¦ãå¤é¨ãã¼åç
§ãä½æããã
+- 表ããã¥ã¼ã表ã®åã®é¨åéåãããæ
å ±ãé¸æããã
+- 表ã«ããªã¬ãä½æãã
+- 表ã表ã«ããåã®é¨åéåã«ããæ
å ±ãæ´æ°ããã
+- é¢æ°ãæç¶ããªã©ã®ããã°ã©ã ã«ã¼ãã³ãå®è¡ããã
+
REVOKEæãçºè¡ããåã«ãderby.database.sqlAuthorizationå±æ§ãtrueã§ãããã¨ã確èªãã¦ãã ãããderby.database.sqlAuthorizationå±æ§ã«ãããSQLèªè¨¼ãæå¹ã«ãªãã¾ãã
+æ
å ±ã®ææè
ããã¼ã¿ãã¼ã¹ã®ææè
ã§ããã°ããã®æ
å ±ã¸ã®æ¨©éãå¥å¥ªããäºãã§ãã¾ãã
+REVOKEæã®ä½¿ãæ¹ã¯ã表ã¸ã®æ¨©éãå¥å¥ªããã®ããããã°ã©ã ã«ã¼ãã³ã¸ã®æ¨©éãå¥å¥ªããã®ãã«ããç°ãªãã¾ãã
+表ã®å ´åã®ä½¿ãæ¹
+REVOKE 権éã¿ã¤ã ON [ TABLE ] { | } FROM 権éãä¸ãããã¦ãã人åã®ä¸è¦§ãæå®ããã«æ¨©éãå¥å¥ªããå ´åã表ã®å
¨ã¦ã®åã¸ã®æ¨©éãå¥å¥ªããã¾ãã
+ããã°ã©ã ã«ã¼ãã³ã®å ´åã®ä½¿ãæ¹REVOKE EXECUTE ON { FUNCTION | PROCEDURE } ããã°ã©ã ã«ã¼ãã³ã®æ示å FROM 権éãä¸ãããã¦ãã人 RESTRICTããã°ã©ã ã«ã¼ãã³ã«REVOKEæã使ãå ´åãRESTRICTç¯ãå¿
è¦ã§ããRESTRICTç¯ã¯ãå®è¡æ¨©éããã¥ã¼ã表ãå¶ç´ããã¯å¥å¥ªãããªãä¸æ¹ã§ããã¥ã¼ã表ãå¶ç´ã®ææè
ããã¯å¥å¥ªããããã¨ã表ãã¾ãã
+権éã¿ã¤ãALL PRIVILEGES |
+ å種権é
+å種権é
+表権é {, 表権é }*
+表権é DELETE |
+ INSERT |
+ REFERENCES [åä¸è¦§] |
+ SELECT [åä¸è¦§] |
+ TRIGGER |
+ UPDATE [åä¸è¦§]
+åä¸è¦§ ( åèå¥å {, åèå¥å}* ) 権éã¿ã¤ãã®ALL PRIVILEGESã¯ã表ã¸ã®å
¨ã¦ã®æ¨©éãã¦ã¼ã¶ããå¥å¥ªããæã«ä½¿ãã¾ããå種権éãæå®ãã¦ã表ã¸ã®ä¸ã¤ä»¥ä¸ã®æ¨©éãå¥å¥ªãããã¨ãã§ãã¾ãã
+DELETEã®æ¨©éã¿ã¤ãã¯ã表ã®è¡ãåé¤ãã権éãå¥å¥ªããããã«ä½¿ãã¾ãã
+INSERTã®æ¨©éã¿ã¤ãã¯ã表ã«è¡ãæ¿å
¥ãã権éãå¥å¥ªããããã«ä½¿ãã¾ãã
+REFERENCESã®æ¨©éã¿ã¤ãã¯ã表ã¸ã®å¤é¨ãã¼åç
§ãä½æãã権éãå¥å¥ªããããã«ä½¿ãã¾ããåä¸è¦§ãæå®ãããå ´åããã®å群ã¸ã®å¤é¨ãã¼åç
§ãä½æãã権éã ããå¥å¥ªããã¾ãã
+SELECTã®æ¨©éã¿ã¤ãã¯ã表ã¾ãã¯ãã¥ã¼ã®æ
å ±ãé¸æãã権éãå¥å¥ªããã¨ãã«ä½¿ãã¾ããåä¸è¦§ãæå®ãããå ´åããã®å群ã¸ã®æ¨©éã ããå¥å¥ªããã¾ããåä¸è¦§ãæå®ãããªãã£ãå ´åã表ã®å
¨åã«å¯¾ãã¦æä½ãæå¹ã§ãã
+TRIGGERã®æ¨©éã¿ã¤ãã¯ã表ã«ããªã¬ãä½æãã権éãå¥å¥ªããã¨ãã«ä½¿ãã¾ãã
+UPDATEã®æ¨©éã¿ã¤ãã¯ã表ã«UPDATEæãå®è¡ãã権éãå¥å¥ªããããã«ä½¿ãã¾ããåä¸è¦§ãæå®ãããå ´åããã®å群ã¸ã®æ¨©éã ããå¥å¥ªããã¾ãã
+権éãä¸ãããã¦ãã人{ èªè¨¼èå¥å | PUBLIC } [,{ authorization ID | PUBLIC } ] *
+æå®ããã¦ã¼ã¶ãããã¯å
¨ã¦ã¼ã¶ããã権éã®å¥å¥ªãè¡ããã¨ãã§ãã¾ããå
¨ã¦ã¼ã¶ãæå®ããã¨ãã¯ãPUBLICã¨ãããã¼ã¯ã¼ãã使ãã¾ããPUBLICã§å¥å¥ªããã権éã¨ãã¦ã¼ã¶ãæå®ãã¦å¥å¥ªããã権éã¯ç¬ç«ããç©ã§ããä¾ãæãã¾ãããã表tã¸ã®SELECT権éããPUBLICã¨harryã¨ããèªè¨¼èå¥åã®ä¸¡æ¹ã«ä¸ãããã¦ããã¨ãã¾ãã
+ããã§ãharryã¨ããèªè¨¼èå¥åããSELECT権éãå¥å¥ªãããã¨ãã¦ããharryã¨ããèªè¨¼èå¥åã¯PUBLIC権éãéãã¦ã表tãæä½å¯è½ã§ãã
+æ
å ±ã®ææè
ã®æ¨©éãå¥å¥ªãããã¨ã¯ã§ãã¾ããã
+ããã°ã©ã ã«ã¼ãã³ã®æ示å {
+ qualified-name [ signature ]
+ }
+å¥å¥ªããã権éã«é£ãªãä¾åé¢ä¿
+å¥å¥ªããã権éã«ä¾åãã¦ãããã¥ã¼ãããªã¬ãå¶ç´çã¯èªåçã«åé¤ããã¾ãããã®ã¨ã ã¯ãå¥å¥ªããã権éãä»ã®æ¨©éã§ä»£æ¿ãããã¨ãã¾ããã詳ããã¯ãDerby Developer's Guideã®"SQL standard authorization"ãåç
§ãã¦ãã ããã
+
+
+å¶éäºé
REVOKEæã«ã¯æ¬¡ã®å¶éäºé
ãããã¾ãã
+
+- 表æ¯ã®æ¨©éã«é¢é£ãã権é
+- 表æ¯ã®æ¨©éã«å¯¾å¿ãã¦ãSYSTABLEPERMSã·ã¹ãã 表ã«è¡¨IDã¨æ¨©éã®ä»ä¸å
ãè¨é²ããã¾ãããã¨ãã°ãuser2ã«ã表user1.t1ã®SELECTã¨DELETEã®æ¨©éãä»ä¸ãããå ´åãSYSTABLEPERMS表ã«ã¯å¯¾å¿ããè¡ãã²ã¨ã¤è¿½å ããã¾ãããã®è¡ã«ã®GRANTEEæ¬ã¯user2ã¨ããå¤ãã¨ã£ã¦ãTABLEIDæ¬ã¯user1.t1ã¨ããå¤ãã¨ãã¾ããããã«SELECTPRIVã¨DELETEPRIVã®ããããã®æ¬ã®å¤ã¯Yãã¨ãã¾ãããã以å¤ã®æ¨©éã«å¯¾å¿ããæ¬ã®
å¤ã¯Nã§ãã
権éãä»ä¸ãããã¦ã¼ã¶ã表ã¸ã®ããããã®æ¨©éãå¿
è¦ã¨ããæ
å ±ããã¼ã¿ãã¼ã¹ã«ä½æããã¨ã ã®ã¨ã³ã¸ã³ã¯ããã®æ
å ±ãSYSTABLEPERMSã«ããç¹å®ã®è¡ã¸ä¾åãã¦ãããã¨ãç解ãã¾ãã
+ä¾ãã°ãuser2ãSELECT * FROM
+user1.t1ã¨ããæã§v1ã¨ãããã¥ã¼ãä½æããã¨ããã¥ã¼ã®v1ã¨ãGRANTEEæ¬ãuser2ã§TABLEIDæ¬ãuser1.t1ã§ããSYSTABLEPERMSã®è¡ã¨ã®éã«ã管ç対象ã¨ãªãä¾åé¢ä¿ãããã¨ããã°ã©ã ã¯ç解ãã¾ããããã§ãããã°ã©ã ã¯ãã¥ã¼ãç¹å®ã®è¡ã«ä¾åãã¦ãããã¨ãç解ãã¾ããããã®è¡ã«ãã権éã«å¯¾å¿ããæ¬ã®ãã¡ãã©ã®æ¬ã«ä¾åãã¦ããã®ãã¯ç解ãã¦ãã¾ããã
+ãã®ããã§ã表æ¯ã®æ¨©éãå¥å¥ªããREVOKEæãçºè¡ãããã¨ããã®æ¨©éã¨åã表IDã¨ã¦ã¼ã¶ã®çµã¿åãããæã¤æ¨©éã«ä¾åãããã¼ã¿ãã¼ã¹ä¸ã®æ
å ±ã¯å
¨ã¦åé¤ããã¦ãã¾ãã¾ããä¾ã§èª¬æããã¨ãuser1ãuser2ãã表t1ã®DELETE権éãå¥å¥ªããã¨ãSYSTABLEPERMS表ã®GRANTEEæ¬ã«user2ãã¨ãTABLEIDæ¬ã«user1.t1ãã¨ãè¡ãREVOKEæã«ããæ´æ°ããã¾ãããã®ã¨ãä¾åé¢ä¿ã®ç®¡çæ©è½ã«�
�ãããã®è¡ã«è¨é²ãããDELETE権éã«ã¯ä¾åãã¦ããªãã«ããããããã権éã®å¥å¥ªã«ããç¡å¹åã®ã¡ãã»ã¼ã¸ãuser2.v1ã«ãéä¿¡ãããã®ã§ããã®ãã¥ã¼ã¯åé¤ããã¦ãã¾ãã¾ãã
+
+- åæ¯ã®æ¨©éã«é¢é£ããå¶é
+- SYSCOLPERMSã·ã¹ãã 表ã®è¡æ¯ã«ã権éã®ä»ä¸å
ã¨è¡¨IDã®çµã¿åããã«è¨±å¯ããã権éãã²ã¨ã¤ã ãè¨é²ãããã¨ãã§ãã¾ãããã¨ãã°ãuser2ã«è¡¨user1.t1ã«ããc12ã¨c13ã¨ããåã®SELECT権éãä¸ããããå ´åãSYSCOLPERMSã«ã¯è¡ãã²ã¨ã¤è¿½å ããã¾ãããã®è¡ã¯GRANTEEæ¬ã®å¤ã«user2ãã¨ããTABLEIDæ¬ã®å¤ã«user1.t1ãã¨ããTYPEæ¬ã®å¤ã«Sãã¨ããCOLUMNSæ¬ã®å¤ã«ã¯c12, c13ãã¨ãã¾ãã
+
表ã®åã®éåã«æ¨©éãä»ä¸ãããã¦ã¼ã¶ãããã®æ¨©éã«ä¾åããæ
å ±ããã¼ã¿ãã¼ã¹ã«ä½æããå ´åãã¯ããã®æ
å ±ã¨SYSCOLPERMS表ã®å¯¾å¿ããè¡ã®éã®ä¾åé¢ä¿ãç解ãã¦ç®¡çä¸ã«èµ·ãã¾ããä¾ãã°user2ãSELECT c11 FROM user1.t1ã¨ããæã«ãããv1ã¨ããè¡ãä½æããã¨ãããã°ã©ã ã¯GRANTEEæ¬ãuser2ã§TABLEIDæ¬ãuser1.t1ãTYPEæ¬ãSã§ããSYSCOLPERMS表ã®è¡ã«ãv1ãä¾åãããã¨ãç解ãã¦ããã®ä¾åé¢ä¿ã管çä¸ã«ç½®ãã¾ãããã®ã¨ããããã°ã©ã ã¯ãã¥ã¼ãSELECT権éã«ä¾åãããã¨ã¯ç解ãã¾ããããã¥ã¼ãã©ã®ã«ã©ã ã«ä¾åãã¦ãããã¯è¿½è·¡ãã¾ããã
+REVOKEæãã«ã©ã ãã¨ã®æ¨©éã«å¯¾ãã¦çºè¡ãããã¨ããã®æ¨©éã®æ¨©éä»ä¸å
ããã¼ãã«IDã権éã®ç¨®é¡ã«ä¾åãããã¼ã¿ãã¼ã¹ä¸ã®æ
å ±ãåé¤ããã¾ããä¾ã§èª¬æããã¨ãuser1ãuser2ããã表user1.t1ã®åc12ã¸ã®SELECT権éãå¥å¥ªããã¨ãGRANTEEæ¬ãuser2ã§TABLEIDãuser1.t1ãTYPEæ¬ãSã®SYSCOLPERMSã«ããè¡ããREVOKEæã«ããæ´æ°ããã¾ãããã®ã¨ãä¾åé¢ä¿ã®ç®¡çæ©è½ã«ãããc12 ã¨ããåã«ã¯ä¾åãã¦ããªãã«ããããããã権éã®å¥å¥ªã«ããç¡å¹åã®ã¡ãã»ã¼ã¸ãuser2.v1ã¨ãããã¥ã¼ã«ãéä¿¡ãããã®ã§ããã®ãã¥ã¼ã¯åé¤ããã¦ãã¾ãã¾ãã
+
+
+
+ 権éå¥å¥ªã®ä¾è¡¨tã¸ã®SELECT権éããmariaã¨harryã¨ããèªè¨¼èå¥åããå¥å¥ªããå ´åã次ã®ããã«æãæ¸ãã¾ããREVOKE SELECT ON TABLE t FROM maria,harry
+
+表tã¸ã®UPDATEãTRIGGER権éãanitaã¨zhiã¨ããèªè¨¼èå¥åããå¥å¥ªããå ´åã次ã®ããã«æãæ¸ãã¾ããREVOKE UPDATE, TRIGGER ON TABLE t FROM anita,zhi
+
+表s.vã¸ã®SELECT権éãå
¨ã¦ã¼ã¶ããå¥å¥ªããå ´åã次ã®ããã«æãæ¸ãã¾ããREVOKE SELECT ON TABLE s.v FROM PUBLIC
+
+表s.vã®c1ã¨c2ã¨ããåã¸ã®UPDATE権éãå
¨ã¦ã®ã¦ã¼ã¶ããå¥å¥ªããå ´åã次ã®ããã«æãæ¸ãã¾ããREVOKE UPDATE (c1,c2) ON TABLE s.v FROM PUBLIC
+
+pã¨ããæç¶ãã¸ã®EXECUTE権éããgeorgeã¨ããèªè¨¼èå¥åããå¥å¥ªããå ´åã次ã®ããã«æãæ¸ãã¾ãã
REVOKE EXECUTE ON PROCEDURE p FROM george RESTRICT
+
+
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 @@
+
+
+
+
+
+表é¢æ°ã®å¼ã³åºã
+
+
+
+TABLE é¢æ°å( [ [ é¢æ°ã®å¼æ° ] [, é¢æ°ã®å¼æ° ]* ] )
+
+
+
+
+ä½ãæ¸ã 表é¢æ°ãå¼ã³åºãã¨ãã¯ãç¸é¢åãå²ãå½ã¦ãå¿
è¦ãããã¾ããä¾ãæãã¾ãã
+
+
+
+
+
+
+SELECT s.*
+FROM TABLE( externalEmployees( 42 ) ) s
+
+
+
+
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 data type
+The XML data type is used for Extensible Markup Language (XML)
+documents.
+
+XML data type
+
+
+ XMLãã¼ã¿åã¯ä»¥ä¸ã®ããã«ä½¿ãã¾ãã
+- SQL/XMLã«å®ç¾©ããããæ´å½¢ãããXML(DOCUMENT(ANY))ã®å¤ãè¨é²ããã
+- ä¸æçã«æ´å½¢ãããXML(DOCUMENT(ANY))ã®å¤ã§ã¯ãªããXML(SEQUENCE)ã®å¤ãæ±ãã
+
XMLãã¼ã¿ã®å¤ããåå¾ã»æ´æ°ã»ååãçãä½ããã®æ¹æ³ã§æä½ããã¢ããªã±ã¼ã·ã§ã³ã§ã¯ãJAXPæ§æ解æå¨ã¨Xalanã®ã¯ã©ã¹ãã¯ã©ã¹ãã¹ã«æããªããã°ãªãã¾ããããããæ§æ解æå¨ã»Xalanã®ä½ãããè¦ã¤ãããªããã°ãã¯ã¨ã©ã¼ãçºè¡ãã¾ãã
+ã§ã¯JDBCã«ã¦ãSQL/XMLãæ±ãæ©è½ãå®è£
ããã¦ããªãã®ã§ãXMLã®å¤ãç´æ¥ãã¤ã³ãããããJDBCã®çµæã»ããããç´æ¥XMLã®å¤ãåå¾ãããã¨ã¯ä¸å¯è½ã§ãã
+ãã®ä»£ããã«ãXMLPARSEãXMLSERIALIZEçã®é©åãªXMLã®æ¼ç®åãæ示çã«SQLã«æ¸ãã¦ãXMLã®æ
å ±ãJavaã®æååãæåã®ã¹ããªã¼ã ã¨ãã¦ããã¤ã³ããããåå¾ããå¿
è¦ãããã¾ãã
+æ§æXML
+対å¿ããã³ã³ãã¤ã«æã®Javaã®åç¡ã
+XMLã®å¤ã«å¯¾å¿ããJavaã®åã®java.sql.SQLXMLã¯åå¨ãã¾ããããããjava.sql.SQLXMLåã¯ã«ã¦ãµãã¼ãããã¦ãã¾ããã
+JDBC ã¡ã¿ãã¼ã¿å (java.sql.Types)ç¡ã
+XMLã®å¤ã«å¯¾å¿ããã¡ã¿ãã¼ã¿åã®SQLXMLã¯åå¨ãã¾ããããããSQLXMLã¯ã«ã¦ãµãã¼ãããã¦ãã¾ããã
+ã®ãã¼ã¿ãã¼ã¹ããXMLã®å¤ãåå¾ããã¨ãã«ã¯ãååãã®SQLã«ã¦XMLSERIALIZEæ¼ç®åã使ã£ã¦ãã ããã
+ä¾ãæãã¾ããSELECT XMLSERIALIZE (xcol as CLOB) FROM myXmlTable ãããããã¨ã§ãç´ååããåã«å¯¾å¿ããgetXXXã¡ã½ããã使ã£ã¦ãXMLã®å¤ããåå¾ãããã¨ãã§ãã¾ãããã®ä¾ã§ã¯CLOBåã¨ãªãã¾ãã
+ã®ãã¼ã¿ãã¼ã¹ã«JDBCã使ã£ã¦XMLã®å¤ãè¨é²ããã¨ãã¯ãSQLæã«ã¦XMLPARSEæ¼ç®åã使ã£ã¦ãã ããã
+ä¾ãæãã¾ããINSERT INTO myXmlTable(xcol) VALUES XMLPARSE(
+ DOCUMENT CAST (? AS CLOB) PRESERVE WHITESPACE)
+ããã¦ãæååã®åã¨äºææ§ã®ããsetXXXã¡ã½ããã使ã£ã¦ãã ããã
+ãã®ä¾ã§ã¯PreparedStatement.setStringã¾ãã¯PreparedStatement.setCharacterStreamã¡ã½ããã使ã£ã¦ãæ¼ç®åã«å¤ãä¸ãã¾ãã
+
+
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 @@
+
+
+
+
+
+並ã³ã®å¶é
+
+æååã®å¶é
+以ä¸ã®è¡¨ã«ãã«ããã並ã³ã®å¤ã®å¶éãè¨ãã¾ãã
+
+
+
+
+å¤
+ä¸é
+
+
+
+
+CHARã®é·ã
+254æå
+
+
+VARCHARã®é·ã
+32,672æå
+
+
+LONG VARCHARã®é·ã
+32,700æå
+
+
+CLOBã®é·ã
+2,147,483,647æå
+
+
+BLOBã®é·ã
+2,147,483,647æå
+
+
+æåå®æ°ã®é·ã
+32,672
+
+
+çµåãããæååã®é·ã
+2,147,483,647
+
+
+ãã¤ããªä¸¦ã³ã®é·ã
+2,147,483,647
+
+
+16é²æ´æ°ã®å®æ°
+16,336
+
+
+DOUBLEã®å®æ°ã®é·ã
+30 characters
+
+
+
+
+
+
+
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 @@
+
+
+
+
+å¥å
+
+表ããã¥ã¼ã¯å¥åã§ããããäºãã§ãã¾ãã
+å¥åã¯ã¹ãã¼ãåã§éå®ãããã¨ãã§ãã¾ãã
+æ§æ [ ã¹ãã¼ãå. ] SQL92èå¥å
+
+
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 @@
+
+
+
+
+
+SYSCS_UTIL.SYSCS_CHECK_TABLEã·ã¹ãã é¢æ°
+
+
+SYSCS_UTIL.SYSCS_CHECK_TABLEé¢æ°ã¯å¼æ°ã«æå®ãã表ãæ¤è¨¼ãã¦ããã®å
¨ã¦ã®ç´¢å¼ã¨æ´åãåãã¦ãããã¨ã確ããã¾ãããã表ã¨ç´¢å¼ãæ´åãã¦ããã°ãã¡ã½ããã¯SMALLINTã®1ãè¿ãã¾ãã
+ãã表ã¨ç´¢å¼ãä¸æ´åã§ããã°ãé¢æ°ã¯ä¾å¤ãæãã¾ãã
+æ§æ SMALLINT SYSCS_UTIL.SYSCS_CHECK_TABLE(IN SCHEMANAME VARCHAR(128),
+IN TABLENAME VARCHAR(128)) SCHEMANAMEãããã¯TABLENAMEãnullã§ããå ´åãã¨ã©ã¼ãçºçãã¾ãã
+ä¾ VALUES SYSCS_UTIL.SYSCS_CHECK_TABLE('SALES', 'ORDERS');
+
+
+
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 @@
+
+
+
+
+
+SYSCS_DIAG 診æ表ããã³é¢æ°
+ã«ã¯ã·ã¹ãã 表å¼ãç¨æããã¦ããããã¼ã¿ãã¼ã¹ã®ç¶æ
ããã¼ã¿ãã¼ã¹ã¸ã®æ¥ç¶ã®è¨ºææ
å ±ãåå¾ã§ãã¾ãã
+
+diagnostic table functionsSYSCS_DIAG.ERROR_LOG_READER
+SYSCS_DIAG.ERROR_LOG_READER diagnostic table function
+diagnostic tablesSYSCS_DIAG.ERROR_MESSAGES
+SYSCS_DIAG.ERROR_MESSAGES diagnostic tablediagnostic
+table functionsSYSCS_DIAG.LOCK_TABLESYSCS_DIAG.LOCK_TABLE
+diagnostic tablediagnostic table functionsSYSCS_DIAG.SPACE_TABLE
+SYSCS_DIAG.SPACE_TABLE diagnostic table functiondiagnostic
+tablesSYSCS_DIAG.STATEMENT_CACHESYSCS_DIAG.STATEMENT_CACHE
+diagnostic tablediagnostic table functionsSYSCS_DIAG.STATEMENT_DURATION
+SYSCS_DIAG.STATEMENT_DURATION diagnostic table functions
+diagnostic tablesSYSCS_DIAG.TRANSACTION_TABLE
+SYSCS_DIAG.TRANSACTION_TABLE diagnostic table
+
+
+ ã«ã¯äºç¨®é¡ã®è¨ºæ表å¼ãããã¾ãã
+
+- 診æ表
+- ã®ä¸è¬çãªè¡¨ã¨åæ§ãªãã®ã§ãã
+表åãç½®ããã¨ãã§ããå ´æãªãã©ãã«ã§ã診æ表ã®ååãããã¾ãã
+
+- 診æ表é¢æ°
+- ã®ä¸è¬çãªé¢æ°ã¨åæ§ãªãã®ã§ãã診æ表é¢æ°ã«ã¯é¢æ°ã«å¿ãã¦ã0ãããã¯ãã以ä¸ã®å¼æ°ãåããã¨ãã§ãã¾ããSQLã«å®ç¾©ããã表é¢æ°ã®æ§æã«åºã¥ãããããã®é¢æ°ã使ãå¿
è¦ãããã¾ãã
+
+以ä¸ã®è¡¨ã«ã¯ã®è¨ºæ表å¼ã®å称ã¨ç¨®é¡ãè¨ãã¾ãã
+ã®ã·ã¹ãã 診æ表å¼
+
+
+
+診æ表å¼
+å¼ã®ç¨®é¡
+
+
+
+
+SYSCS_DIAG.ERROR_LOG_READER
+表é¢æ°
+
+
+SYSCS_DIAG.ERROR_MESSAGES
+表
+
+
+SYSCS_DIAG.LOCK_TABLE
+表
+
+
+SYSCS_DIAG.SPACE_TABLE
+表é¢æ°
+
+
+SYSCS_DIAG.STATEMENT_CACHE
+表
+
+
+SYSCS_DIAG.STATEMENT_DURATION
+表é¢æ°
+
+
+SYSCS_DIAG.TRANSACTION_TABLE
+表
+
+
+
+
DDLãå§ç¸®ã®æç¶ãã«ã¦è¨ºæ表ãåç
§ããå ´åãã¯ä¾å¤ãè¿ãã¾ãã
+SYSCS_DIAG.ERROR_LOG_READER 診æ表é¢æ°
+SYSCS_DIAG.ERROR_LOG_READER診æ表é¢æ°ããã¯ãderby.logãã¡ã¤ã«ãæå®ããä»»æã®ãã°ãã¡ã¤ã«ã«ããå
¨ã¦ã®SQLæãå¾ããã¾ãã
+ãã®è¨ºæ表é¢æ°ã使ããã¨ã§ãæ´»åä¸ã®ãã©ã³ã¶ã¯ã·ã§ã³ããã³ä»»æã®æç¹ã®ãã©ã³ã¶ã¯ã·ã§ã³ãç¥ããã¨ãã§ãã¾ãããã¨ãã°ãããããã¯ãããã¯ã®æéåããçºçããå ´åãã¨ã©ã¼ãã°ããã¿ã¤ã ã¹ã¿ã³ã(timestampConstant)ãè¦ã¤ãããã¨ãã§ãã¾ãã
+SYSCS_DIAG.ERROR_LOG_READER診æ表é¢æ°ã使ãã«ã¯ãSQL表é¢æ°ã®æ§æã«åºã¥ãå¿
è¦ãããã¾ãã
+ä¾ãæãã¾ãã:SELECT *
+ FROM TABLE (SYSCS_DIAG.ERROR_LOG_READER())
+ AS T1
+ããã§T1ã¯ã¦ã¼ã¶ãæå®ãã表ã®ååã§ãããã¯ä»»æã®èå¥åã§ãã
+SYSCS_DIAG.ERROR_LOG_READER診æ表é¢æ°ã«ã¯ãéæã§æå®ããå¼æ°ã¨ãã¦ãã°ãã¡ã¤ã«ã®ååãä¸ãããã¨ãã§ãã¾ãããã°ãã¡ã¤ã«ã®ååãæå®ããå ´åããã¡ã¤ã«åã¯Javaã§æååã¨ã¿ãªããå¼ã§ãªããã°ãªãã¾ããã
+For example:SELECT *
+ FROM TABLE (SYSCS_DIAG.ERROR_LOG_READER('myderbyerrors.log'))
+ AS T1
+ æ¢å®ã§ã¯ã®ãã°ãã¡ã¤ã«ã«ã¯èµ·åãçµäºãã¨ã©ã¼ã¡ãã»ã¼ã¸ããããã¾ããã
+ãã詳細ãªæ
å ±ãã®ãã°ãã¡ã¤ã«ã«åºåããæ¹æ³ã¯ãã¬ã¤ãã®derby.stream.error.logSeverityLevelå±æ§ã¨ãderby.language.logStatementTextå±æ§ãèªãã§ãã ããã
+SYSCS_DIAG.ERROR_MESSAGES 診æ表
+SYSCS_DIAG.ERROR_MESSAGES診æ表ã«ã¯ãå
¨ã¦ã®SQLStateãå°åã«å¯¾å¿ããã¨ã©ã¼ã¡ãã»ã¼ã¸ã
+ãã¼ã¿ãã¼ã¹ã§ã®ä¾å¤æ·±å»åº¦ãè¨è¿°ããã¾ãã
+æã«ã¦ç´æ¥ã«SYSCS_DIAG.ERROR_MESSAGES診æ表ãåç
§ãããã¨ãã§ãã¾ãã
+ä¾ãæãã¾ããSELECT * FROM SYSCS_DIAG.ERROR_MESSAGES
+SYSCS_DIAG.LOCK_TABLE 診æ表
+SYSCS_DIAG.LOCK_TABLE診æ表ã«ã¯ãç¾å¨æç¹ã®ãã¼ã¿ãã¼ã¹ã®å
¨ããã¯ãè¨è¿°ããã¾ãã
+SYSCS_DIAG.LOCK_TABLE診æ表ã¯æã«ã¦ç´æ¥åç
§ãããã¨ãã§ãã¾ãã
+ä¾ãæãã¾ããSELECT * FROM SYSCS_DIAG.LOCK_TABLE
+SYSCS_DIAG.LOCK_TABLE診æ表ãæã«ã¦åç
§ãããå ´åã表ã®ããã¯ã®ã¹ãããã·ã§ãããæ®ããã¾ãã
+ãã®ã¹ãããã·ã§ããã¯è¨ºæ表ãåç
§ãã¦ããã¢ããªã±ã¼ã·ã§ã³ã®é常å¦çæéãå¦çã®æµãã«å½±é¿ãåºãªãããã«ç¨æããããã®ã§ãã
+ãã®ã¹ãããã·ã§ãããæ®ãããæãããã¯ãç¶æ
é·ç§»ä¸ã§ããå¯è½æ§ãããã¾ãã
+SYSCS_DIAG.SPACE_TABLE 診æ表é¢æ°
+SYSCS_DIAG.SPACE_TABLE診æ表é¢æ°ã§ã¯ãæå®ãã表ã¨ãã®ç´¢å¼ãå©ç¨ãã¦ããé åã表示ã§ãã¾ãã
+ãã®è¨ºæ表é¢æ°ã«ãã表ãç´¢å¼ãå§ç¸®ãããã¨ã§ãã©ãã ãé åãç¯ç´ã§ãããç¥ããã¨ãã§ãã¾ãã
+SYSCS_DIAG.SPACE_TABLE診æ表é¢æ°ã使ãã«ã¯ãSQL表é¢æ°ã®æ§æã«å¾ãå¿
è¦ãããã¾ãã
+ãã®è¨ºæ表é¢æ°ã¯äºã¤ã®å¼æ°ãã¨ãã¾ããã¹ãã¼ãåã¨è¡¨åã§ãã
+表åã¯å¿
é ã§ããã¹ãã¼ãåãæå®ããªãã£ãå ´åãç¾å¨ã®ã¹ãã¼ããé©ç¨ããã¾ãã
+ãã¨ãã°ä»¥ä¸ã®åãåããã§ã¯ããã¼ã¿ãã¼ã¹ã«ããå
¨ã¦ã¼ã¶è¡¨ã¨ç´¢å¼ã®å©ç¨ããé åãè¿ãã¾ããSELECT T2.*
+ FROM
+ SYS.SYSTABLES systabs,
+ TABLE (SYSCS_DIAG.SPACE_TABLE(systabs.tablename)) AS T2
+ WHERE systabs.tabletype = 'T'
+ããã§T2ã¯ã¦ã¼ã¶æå®ã®è¡¨åã§ãä»»æã®èå¥åãæå®ã§ãã¾ãã
+ã¹ãã¼ãåã¨è¡¨åã¯ãä½ããJavaã®æåååã¨ã¿ãªãããå¼ã§ãªããã°ãªãã¾ããã
+ã¹ãã¼ãåã¨è¡¨åãããªãããããªãèå¥åã§ãã£ãå ´åãååã¯å¤§æåã§æå®ããªããã°ãªãã¾ããã
+ä¾ãæãã¾ããSELECT *
+ FROM TABLE (SYSCS_DIAG.SPACE_TABLE('MYSCHEMA', 'MYTABLE'))
+ AS T2
+SYSCS_DIAG.STATEMENT_CACHE 診æ表
+SYSCS_DIAG.STATEMENT_CACHE診æ表ã«ã¯SQLæãã£ãã·ã¥ã®å
容ãè¨è¿°ããã¾ãã
+SYSCS_DIAG.STATEMENT_CACHE診æ表ã¯æããç´æ¥åç
§ã§ãã¾ãã
+ä¾ãæãã¾ããSELECT * FROM SYSCS_DIAG.STATEMENT_CACHE
+SYSCS_DIAG.STATEMENT_DURATION 診æ表é¢æ°
+SYSCS_DIAG.STATEMENT_DURATION診æ表é¢æ°ã使ã£ã¦ãderby.logãã¡ã¤ã«ãæå®ãããã°ãã¡ã¤ã«ã«ããSQLæã®å®è¡æéãç¥ããã¨ãã§ãã¾ãã
+ãã®è¨ºæé¢æ°ã使ããã¨ã§ãã¢ããªã±ã¼ã·ã§ã³ã®JDBCã³ã¼ãã®ã©ãã«ããã«ããã¯ããããã®ãæããããå¾ããã¨ãã§ãã¾ãã
+SYSCS_DIAG.STATEMENT_DURATION診æ表é¢æ°ã使ãã«ã¯ãSQLã®è¡¨é¢æ°æ§æã«åºã¥ãå¿
è¦ãããã¾ãã
+ä¾ãæãã¾ããSELECT *
+ FROM TABLE (SYSCS_DIAG.STATEMENT_DURATION())
+ AS T1
+ããã§T1ã¯ã¦ã¼ã¶ãæå®ãã表åã§ãä»»æã®èå¥åãæå®ã§ãã¾ãã
+ãã®è¡¨ã§ã¯ãåã
ã®ãã©ã³ã¶ã¯ã·ã§ã³IDã«ãããæå¾ã®ææ¯ã«ãè¡ã対å¿ãã¦ãã¾ããããã©ã³ã¶ã¯ã·ã§ã³ã«ããæ
å ±ã®å¤æ´ããã£ãå ´åããã©ã³ã¶ã¯ã·ã§ã³IDã¯ã³ãããããã¼ã«ãã³ã¯ã®åå¾ã§å¤ãå¤ããã¾ãã
+SYSCS_DIAG.STATEMENT_DURATION診æ表é¢æ°ã«ã¯éæã®å¼æ°ã¨ãã¦ãã°ãã¡ã¤ã«ãæå®ã§ãã¾ãã
+ãã°ãã¡ã¤ã«åãæå®ããå ´åããã¡ã¤ã«åã¯Javaã®æååã¨ã¿ãªããå¼ã§ãªããã°ãªãã¾ããã
+ä¾ãæãã¾ããSELECT *
+ FROM TABLE (SYSCS_DIAG.STATEMENT_DURATION('somederby.log'))
+ AS T1
+ æ¢å®ã§ã¯ã®ãã°ãã¡ã¤ã«ã«ã¯èµ·åãçµäºãã¨ã©ã¼ã¡ãã»ã¼ã¸ã ããåºåããã¾ãã
+ãã詳細ãªæ
å ±ãã®ãã°ãã¡ã¤ã«ã«åºåããæ¹æ³ã¯ãã¬ã¤ãã®derby.stream.error.logSeverityLevelå±æ§ã¨ãderby.language.logStatementTextå±æ§ãèªãã§ãã ããã
+ãã以å¤ã®æ
å ±ãããã°ãSYSCS_DIAG.STATEMENT_DURATION診æ表é¢æ°ã§åãåããå¯è½ã§ãã
+SYSCS_DIAG.TRANSACTION_TABLE 診æ表
+SYSCS_DIAG.TRANSACTION_TABLE診æ表ã«ã¯ç¾å¨ãã¼ã¿ãã¼ã¹ã«åå¨ããå
¨ãã©ã³ã¶ã¯ã·ã§ã³ãè¨è¿°ããã¾ããSYSCS_DIAG.TRANSACTION_TABLE診æ表ã¯æããç´æ¥åç
§ã§ãã¾ãã
+ä¾ãæãã¾ããSELECT * FROM SYSCS_DIAG.TRANSACTION_TABLE
+æã«ã¦SYSCS_DIAG.TRANSACTION_TABLE診æ表ãåç
§ãããã¨ããã©ã³ã¶ã¯ã·ã§ã³è¡¨ã®ã¹ãããã·ã§ãããæ®ããã¾ããã¹ãããã·ã§ããã¯è¨ºæ表ãåç
§ãã¦ããã¢ããªã±ã¼ã·ã§ã³ã®é常å¦çæéãå¦çã®æµãã«å½±é¿ãåºãªãããç¨æããã¾ãããã©ã³ã¶ã¯ã·ã§ã³ã¯ã¹ãããã·ã§ããã®ä½ææã«ç¶æ
é·ç§»ä¸ã§ããå ´åãããã¾ãã
+
+
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 @@
+
+
+
+
+
+SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS ã·ã¹ãã é¢æ°
+
+
+SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICSé¢æ°ã¯ãjava.sql.ResultSetã«å¯¾ããååãã®å®è¡è¨ç»ããã³å¦çæéã®çµ±è¨ã表ããVARCHAR(32762)ã®å¤ãè¿ãã¾ãã
+ååãã®å®è¡è¨ç»ã¯å®è¡ãã¼ããããªãæ¨æ§é ã®æ
å ±ã§ãã
+ãã®ãã¼ãã«ã¯å¹¾ã¤ãã®ç¨®é¡ãããã¾ãã
+çµ±è¨ã¯ããããã®ãã¼ããå®è¡ããããã³ã«åè¨ããã¦ããã¾ããçµ±è¨ãããå¤ã«ã¯ãç¹å®ã®å¦çã«ããã£ãæéã®åè¨ããã¼ãã®åãã渡ãããè¡æ°ããã®ãã¼ããã親ã«è¿ãããè¡æ°çããã¾ãã(å®éã«ä½ãéè¨ãããã®ãã¯ãããããã®ãã¼ãã®ç¨®é¡ã«ãã決ã¾ãã¾ãã)
+SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICSãæãææ義ã«æ©è½ããã®ã¯ãSELECTãINSERTãUPDATEçã®DMLæã«å¯¾ãã¦ã§ãã
+
+æ§æ VARCHAR(32762) SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()
+ä¾ VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()
+
+
+
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 @@
+
+
+
+
+TableExpression
+
+表å¼
+
+
+
+
+表å¼ã«ãã表ããã¥ã¼ãããã¯é¢æ°ããFROM ç¯ã«ã¦æå®ãã¾ããããããé¸æå¼ã«ã¦çµæãé¸æããã¾ãã
+åãéå®ããããã«ãç¸é¢åã表å¼ã«é©ç¨ãããã¨ãã§ãã¾ãã
+ç¸é¢åãä¸ããããªãå ´åã表åãååãéå®ãã¾ãã
+ãã表ã«ç¸é¢åãä¸ããããå ´åã表åã«ããåãéå®ãããã¨ã¯ã§ãããååãç¸é¢åã§éå®ããªããã°ãªãã¾ããã
+FROMç¯ã«ããé
ç®ã¯ãåãååã®ç¸é¢åãæã¤ãã¨ãã§ãã¾ãããã¾ãç¸é¢åã¯FROMç¯ã«ãã表ã®éå®ãããªãååã¨åãååã§ãã£ã¦ã¯ãªãã¾ããã
+ããã«ASç¯ã使ã£ã¦è¡¨ã®åã«ååãä¸ãããã¨ãã§ãã¾ããããã¯ä»¥ä¸ã®ç¶æ³ã§ä¾¿å©ã§ãã
+- VALUESå¼ã表å¯ååãã§ä½¿ããã¦ããå ´åãVALUESå¼ã®åã«ååãä¸ããæ¹æ³ã¯ãä»ã«ã¯ç¡ãã§ãã
+- ååãä»ã®è¡¨ã®ååã¨åãå ´åãå¥ã®ååãä¸ãããã¨ã§éå®ã®å¿
è¦ããªããªãã¾ãã
+
+Fromã®é
ç®ã«ãã表å¯ååãã®ååãã«ã¯ãè¤æ°åãç½®ããã¨ãã§ããè¤æ°è¡ãè¿ããã¨ãã§ãã¾ãããåç
§ãã¦ãã ããã
+ã¦ã¼ã¶ãæé©åã®ããä½ãæå®ã§ãããã«ã¤ãã¦ã¯ããåç
§ãã¦ãã ããã
+æ§æ
+{
+表ããã¥ã¼ãããã¯é¢æ°å¼ | çµåå¼
+}
+
+
+ä¾
+-- çµåå¼ããé¸æã§ãã¾ãã
+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
+
+
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 @@
+
+
+
+
+
+表å
+
+表åã¯è¡¨ãããããã¾ãã表åã¯ã¹ãã¼ãåã§éå®ãããã¨ãã§ãã¾ãã
+æ§æ [ ã¹ãã¼ãå. ] SQL92èå¥å
+ä¾ -- SAMP.PROJECT ã¯ã¹ãã¼ãåã®ãã表åã§ãã
+SELECT COUNT(*) FROM SAMP.PROJECT
+
+
+
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 @@
+
+
+
+
+表å¯ååã
+
+TableSubquery
+
+
+
+
+表å¯ååãã¯è¤æ°ã®è¡ãè¿ãå¯ååãã§ãã
+ã¹ã«ã©ã¼å¯ååãã¨ã¯ç°ãªãã表å¯ååãã¯ä»¥ä¸ã®æèã«ã¦ã®ã¿å¯è½ã§ãã
+
+- FROM ç¯ã®è¡¨å¼
+- EXISTSãINãéã®æ¯è¼
+
+FROM ç¯ã®è¡¨å¼ã«ã¦ä½¿ãããå ´åãè¤æ°ã®åãè¿ããã¨ãã§ãã¾ãã
+EXISTSã§ã¯ã*ã使ãå ´åã®ã¿è¤æ°ã®åãè¿ããã¨ãã§ãã¾ãã
+INãéå®æ¡ä»¶ã§ã¯ãååã®ã¿è¿ããã¨ãã§ãã¾ãã
+æ§æ
+(ååã)
+
+ä¾-- FROMç¯ã®è¡¨å¼ã¨ãã¦ãå¯ååãã使ãã
+SELECT VirtualFlightTable.flight_ID
+FROM
+ (SELECT flight_ID, orig_airport, dest_airport
+ FROM Flights
+ WHERE (orig_airport = 'SFO' OR dest_airport = 'SCL') )
+AS VirtualFlightTable
+-- FROMç¯ã®è¡¨å¼ã¨ãã¦ãå¯ååã(valueså¼)ã使ãã
+SELECT mycol1
+FROM
+ (VALUES (1, 2), (3, 4))
+AS mytable (mycol1, mycol2)
+-- EXISTSã«ã¦å¯ååãã使ã
+SELECT *
+FROM Flights
+WHERE EXISTS
+ (SELECT * FROM Flights WHERE dest_airport = 'SFO'
+ AND orig_airport = 'GRU')
+-- INã«ã¦å¯ååãã使ã
+SELECT flight_id, segment_number
+FROM Flights
+WHERE flight_id IN
+ (SELECT flight_ID
+ FROM Flights WHERE orig_airport = 'SFO'
+ OR dest_airport = 'SCL')
+-- å®éæ¯è¼ã«ã¦å¯ååãã使ã
+SELECT NAME, COMM
+FROM STAFF
+WHERE COMM >
+(SELECT AVG(BONUS + 800)
+ FROM EMPLOYEE
+ WHERE COMM < 5000)
+
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 @@
+
+
+
+
+
+TIME é¢æ°
+TIMEé¢æ°ã¯å¤ã®æå»ã®é¨åãè¿ãã¾ãã
+
+TIME function
+
+
+ å¼æ°ã¯æå»ãã¿ã¤ã ã¹ã¿ã³ããCLOBã»LONG VARCHARã»XML以å¤ã®æå»ãã¿ã¤ã ã¹ã¿ã³ãã表ãæå¹ãªæååã§ããå¿
è¦ãããã¾ãã
+ãã®é¢æ°ã®çµæã¯æå»ã§ããå¼æ°ã«nullãã¨ããã¨ãããå ´åãè¿ãå¤ãnullãã¨ããã¨ãããã¾ãã
+å¼æ°ãnullãªããè¿ãå¤ã¯nullã§ãã
+
+
+å¼æ°ã®ãã¼ã¿åã«å¿ãã¦ã以ä¸ã®è¦åãããã¾ãã
+
+- å¼æ°ãæå»ãªããè¿ãå¤ã¯ãã®æå»ã§ãã
+- å¼æ°ãã¿ã¤ã ã¹ã¿ã³ããªããè¿ãå¤ã¯ã¿ã¤ã ã¹ã¿ã³ãã®æå»ã®é¨åã§ãã
+- ããå¼æ°ãæååãªããè¿ãå¤ã¯æååã表ãæå»ã§ãã
+
+æ§æ TIME ( å¼ )
+ values time(current_timestamp)
+ããç¾å¨æå»ãåå¾5:03ãªããè¿ãå¤ã¯17:03:00ã§ãã
+
+
Propchange: db/derby/docs/trunk/src/ja_JP/ref/rreftimefunc.dita
------------------------------------------------------------------------------
svn:svn:eol-style = native