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 [43/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/rreftableexpression.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftableexpression.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftableexpression.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,112 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="TableExpression" />
+<meta content="表å¼" name="DC.subject" />
+<meta content="表å¼" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj19433.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefselectexpression.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj11277.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj1080779.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj23075.html" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj29911.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj33215.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftableexpression" 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>TableExpression</title>
+</head>
+<body id="rreftableexpression"><a name="rreftableexpression"><!-- --></a>
+
+
+<h1 class="topictitle1">TableExpression</h1>
+
+<div>
+<div class="section">
+<p><em>表å¼</em>ã«ãã表ããã¥ã¼ãããã¯é¢æ°ãã<a href="rrefsqlj21583.html#rrefsqlj21583">FROM ç¯</a>ã«ã¦æå®ãã¾ãããããã<em><a href="rrefselectexpression.html#rrefselectexpression">é¸æå¼</a></em>ã«ã¦çµæãé¸æããã¾ãã</p>
+
+<p>åãéå®ããããã«ãç¸é¢åã<em>表å¼</em>ã«é©ç¨ãããã¨ãã§ãã¾ãã
+ç¸é¢åãä¸ããããªãå ´åã表åãååãéå®ãã¾ãã
+ãã表ã«ç¸é¢åãä¸ããããå ´åã表åã«ããåãéå®ãããã¨ã¯ã§ãããååãç¸é¢åã§éå®ããªããã°ãªãã¾ããã</p>
+
+<p>FROMç¯ã«ããé
ç®ã¯ãåãååã®ç¸é¢åãæã¤ãã¨ãã§ãã¾ãããã¾ãç¸é¢åã¯FROMç¯ã«ãã表ã®éå®ãããªãååã¨åãååã§ãã£ã¦ã¯ãªãã¾ããã</p>
+
+<div class="p">ããã«ASç¯ã使ã£ã¦è¡¨ã®åã«ååãä¸ãããã¨ãã§ãã¾ããããã¯ä»¥ä¸ã®ç¶æ³ã§ä¾¿å©ã§ãã<ul>
+<li><a href="rrefsqlj11277.html#rrefsqlj11277">VALUESå¼</a>ã<em><a href="rreftablesubquery.html#rreftablesubquery">表å¯ååã</a></em>ã§ä½¿ããã¦ããå ´åã<a href="rrefsqlj11277.html#rrefsqlj11277">VALUESå¼</a>ã®åã«ååãä¸ããæ¹æ³ã¯ãä»ã«ã¯ç¡ãã§ãã</li>
+
+<li>ååãä»ã®è¡¨ã®ååã¨åãå ´åãå¥ã®ååãä¸ãããã¨ã§éå®ã®å¿
è¦ããªããªãã¾ãã</li>
+
+</ul>
+</div>
+
+<p><em>Fromã®é
ç®</em>ã«ãã<em><a href="rreftablesubquery.html#rreftablesubquery">表å¯ååã</a></em>ã®ååãã«ã¯ãè¤æ°åãç½®ããã¨ãã§ããè¤æ°è¡ãè¿ããã¨ãã§ãã¾ãã<em><a href="rreftablesubquery.html#rreftablesubquery">表å¯ååã</a></em>ãåç
§ãã¦ãã ããã</p>
+
+<p>ã¦ã¼ã¶ãæé©åã®ããä½ãæå®ã§ãããã«ã¤ãã¦ã¯ã<cite><span><em>Derbyã®ãã¥ã¼ãã³ã°</em></span></cite>ãåç
§ãã¦ãã ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4>
+<pre><strong>{
+表ããã¥ã¼ãããã¯é¢æ°å¼ | çµåå¼
+}
+</strong></pre>
+
+</div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4><pre><strong>
+<span>-- çµåå¼ããé¸æã§ãã¾ãã</span>
+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
+</strong></pre>
+
+</div>
+</div>
+<div>
+<ul class="ullinks">
+<li class="ulchildlink"><strong><a href="rrefsqlj33215.html">表ã¾ãã¯ãã¥ã¼ãããã¯é¢æ°å¼</a></strong><br />
+</li>
+</ul>
+
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefsqlj19433.html" title="å¤ãã®æãå¼ã®æ§æã®èªå¥ã«ãå¼ã表å¯ååãã®ãããªå¼ã®ä¸ç¨®ãããã¾ãã å¼ã¯æã®å®ããããå ´æã«ç½®ããã¨ãã§ãã¾ãã">SQLå¼</a></div>
+</div>
+<div class="relconcepts"><strong>é¢é£æ¦å¿µ</strong><br />
+<div><a href="crefsqlj29911.html" title="">åçãã©ã¡ã¼ã¿</a></div>
+</div>
+<div class="relref"><strong>é¢é£è³æ</strong><br />
+<div><a href="rrefselectexpression.html" title="">é¸æå¼</a></div>
+<div><a href="rrefsqlj11277.html" title="">VALUESå¼</a></div>
+<div><a href="rrefsqlj1080779.html" title="">å¼ã«é¢ããåªå
é ä½</a></div>
+<div><a href="rrefsqlj23075.html" title="">çå½å¼</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftableexpression.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablename.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablename.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablename.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,61 @@
+<!--
+ 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="rreftablename" 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="rreftablename"><a name="rreftablename"><!-- --></a>
+
+
+<h1 class="topictitle1">表å</h1>
+
+<div>
+<div class="section"><p><em>表å</em>ã¯è¡¨ãããããã¾ãã<em>表å</em>ã¯<em>ã¹ãã¼ãå</em>ã§éå®ãããã¨ãã§ãã¾ãã</p>
+</div>
+
+<div class="section"><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"><h4 class="sectiontitle">ä¾</h4> <pre><strong><span>-- SAMP.PROJECT ã¯ã¹ãã¼ãåã®ãã表åã§ãã</span>
+SELECT COUNT(*) FROM SAMP.PROJECT</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/rreftablename.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablesubquery.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablesubquery.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablesubquery.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,110 @@
+<!--
+ 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 content="TableSubquery" name="DC.subject" />
+<meta content="TableSubquery" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefqueries.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftablesubquery" 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="rreftablesubquery"><a name="rreftablesubquery"><!-- --></a>
+
+
+<h1 class="topictitle1">表å¯ååã</h1>
+
+<div>
+<div class="section">
+<p><em>表å¯ååã</em>ã¯è¤æ°ã®è¡ãè¿ãå¯ååãã§ãã</p>
+
+<div class="p"><em><a href="rrefscalarsubquery.html#rrefscalarsubquery">ã¹ã«ã©ã¼å¯ååã</a></em>ã¨ã¯ç°ãªãã<em>表å¯ååã</em>ã¯ä»¥ä¸ã®æèã«ã¦ã®ã¿å¯è½ã§ãã
+<ul>
+<li><a href="rrefsqlj21583.html#rrefsqlj21583">FROM ç¯</a>ã®<em><a href="rreftableexpression.html#rreftableexpression">表å¼</a></em></li>
+
+<li>EXISTSãINãéã®æ¯è¼</li>
+
+</ul>
+</div>
+
+<p><a href="rrefsqlj21583.html#rrefsqlj21583">FROM ç¯</a>ã®<em><a href="rreftableexpression.html#rreftableexpression">表å¼</a></em>ã«ã¦ä½¿ãããå ´åãè¤æ°ã®åãè¿ããã¨ãã§ãã¾ãã</p>
+
+<p>EXISTSã§ã¯ã*ã使ãå ´åã®ã¿è¤æ°ã®åãè¿ããã¨ãã§ãã¾ãã</p>
+
+<p>INãéå®æ¡ä»¶ã§ã¯ãååã®ã¿è¿ããã¨ãã§ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4>
+<pre><strong>(<em><a href="rrefsqlj21571.html#rrefsqlj21571">ååã</a></em>)</strong></pre>
+
+</div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4><pre><strong><span>-- FROMç¯ã®è¡¨å¼ã¨ãã¦ãå¯ååãã使ãã</span>
+SELECT VirtualFlightTable.flight_ID
+FROM
+ (SELECT flight_ID, orig_airport, dest_airport
+ FROM Flights
+ WHERE (orig_airport = 'SFO' OR dest_airport = 'SCL') )
+AS VirtualFlightTable
+<span>-- FROMç¯ã®è¡¨å¼ã¨ãã¦ãå¯ååã(valueså¼)ã使ãã</span>
+SELECT mycol1
+FROM
+ (VALUES (1, 2), (3, 4))
+AS mytable (mycol1, mycol2)
+<span>-- EXISTSã«ã¦å¯ååãã使ã</span>
+SELECT *
+FROM Flights
+WHERE EXISTS
+ (SELECT * FROM Flights WHERE dest_airport = 'SFO'
+ AND orig_airport = 'GRU')
+<span>-- INã«ã¦å¯ååãã使ã</span>
+SELECT flight_id, segment_number
+FROM Flights
+WHERE flight_id IN
+ (SELECT flight_ID
+ FROM Flights WHERE orig_airport = 'SFO'
+ OR dest_airport = 'SCL')
+<span>-- å®éæ¯è¼ã«ã¦å¯ååãã使ã</span>
+SELECT NAME, COMM
+FROM STAFF
+WHERE COMM >
+(SELECT AVG(BONUS + 800)
+ FROM EMPLOYEE
+ WHERE COMM < 5000)</strong></pre>
+
+</div>
+</div>
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefqueries.html" title="">SQL åãåãã</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftablesubquery.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimefunc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimefunc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimefunc.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,84 @@
+<!--
+ 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="TIME é¢æ°" />
+<meta name="abstract" content="TIMEé¢æ°ã¯å¤ã®æå»ã®é¨åãè¿ãã¾ãã" />
+<meta name="description" content="TIMEé¢æ°ã¯å¤ã®æå»ã®é¨åãè¿ãã¾ãã" />
+<meta content="TIME function" name="DC.subject" />
+<meta content="TIME function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftimefunc" 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>TIME é¢æ°</title>
+</head>
+<body id="rreftimefunc"><a name="rreftimefunc"><!-- --></a>
+
+
+<h1 class="topictitle1">TIME é¢æ°</h1>
+
+
+
+<div><p>TIMEé¢æ°ã¯å¤ã®æå»ã®é¨åãè¿ãã¾ãã</p>
+
+<div class="section"> <p>å¼æ°ã¯æå»ãã¿ã¤ã ã¹ã¿ã³ããCLOBã»LONG VARCHARã»XML以å¤ã®æå»ãã¿ã¤ã ã¹ã¿ã³ãã表ãæå¹ãªæååã§ããå¿
è¦ãããã¾ãã
+ãã®é¢æ°ã®çµæã¯æå»ã§ããå¼æ°ã«nullãã¨ããã¨ãããå ´åãè¿ãå¤ãnullãã¨ããã¨ãããã¾ãã
+å¼æ°ãnullãªããè¿ãå¤ã¯nullã§ãã
+</p>
+
+<div class="p">
+å¼æ°ã®ãã¼ã¿åã«å¿ãã¦ã以ä¸ã®è¦åãããã¾ãã
+<ul>
+<li>å¼æ°ãæå»ãªããè¿ãå¤ã¯ãã®æå»ã§ãã</li>
+
+<li>å¼æ°ãã¿ã¤ã ã¹ã¿ã³ããªããè¿ãå¤ã¯ã¿ã¤ã ã¹ã¿ã³ãã®æå»ã®é¨åã§ãã</li>
+
+<li>ããå¼æ°ãæååãªããè¿ãå¤ã¯æååã表ãæå»ã§ãã</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>TIME ( <em>å¼</em> )</strong></pre>
+ </div>
+
+<div class="example"> <pre><strong>values time(current_timestamp)</strong></pre>
+
+<p>ããç¾å¨æå»ãåå¾5:03ãªããè¿ãå¤ã¯<samp class="codeph">17:03:00</samp>ã§ãã</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/rreftimefunc.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimestampfunc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimestampfunc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimestampfunc.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,90 @@
+<!--
+ 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="TIMESTAMPé¢æ°" />
+<meta name="abstract" content="TIMESTAMPé¢æ°ã¯ã¿ã¤ã ã¹ã¿ã³ãããå¤ãããã¯å¤ã®å¯¾ããè¿ãã¾ãã" />
+<meta name="description" content="TIMESTAMPé¢æ°ã¯ã¿ã¤ã ã¹ã¿ã³ãããå¤ãããã¯å¤ã®å¯¾ããè¿ãã¾ãã" />
+<meta content="functions, TIMESTAMP, TIMESTAMP function" name="DC.subject" />
+<meta content="functions, TIMESTAMP, TIMESTAMP function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftimestampfunc" 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>TIMESTAMPé¢æ°</title>
+</head>
+<body id="rreftimestampfunc"><a name="rreftimestampfunc"><!-- --></a>
+
+
+<h1 class="topictitle1">TIMESTAMPé¢æ°</h1>
+
+
+
+<div><p>TIMESTAMPé¢æ°ã¯ã¿ã¤ã ã¹ã¿ã³ãããå¤ãããã¯å¤ã®å¯¾ããè¿ãã¾ãã</p>
+
+<div class="section"> <div class="p">å¼æ°ã«ã¨ããã¨ãã§ããå¤ã¯ãäºã¤ç®ã®å¼æ°ããããã©ããã§æ±ºã¾ãã¾ãã<ul>
+<li>ããå¼æ°ãä¸ã¤ã§ããå ´åã¯ãå¼æ°ã¯ãã¿ã¤ã ã¹ã¿ã³ãããCLOBã»LONG VARCHARã»XML以å¤ã®ã¿ã¤ã ã¹ã¿ã³ããæå¹ã«è¡¨ã14æåã®æååã§ããå¿
è¦ãããã¾ãã14æåã®æååã¯ãæå¹ãªæ¥ä»ããã³æå»ã10é²æ°ã§<em>yyyyxxddhhmmss</em>ã¨ããæ¸å¼ã§è¡¨ãå¿
è¦ãããã¾ããããã§ã<em>yyyy</em>ã¯å¹´ã<em>xx</em>ã¯æã<em>dd</em>ã¯æ¥ã<em>hh</em>ã¯æã<em>mm</em>ã¯åã<em>ss</em>ã¯ç§ã§ãã</li>
+
+<li>ãã両æ¹ã®å¼æ°ãæå®ãããå ´åã¯ãæåã®å¼æ°ã¯æ¥ä»ãããã¯æ¥ä»ãæå¹ã«è¡¨ãæååã§ãäºã¤ç®ã®å¼æ°ã¯æå»ãããã¯æå»ãæå¹ã«è¡¨ãæååã§ãã</li>
+
+</ul>
+äºã¤ç®ã®å¼æ°ããããå¦ãã§æ¬¡ã®è¦åã決ã¾ãã¾ãã<ul>
+<li>ãã両æ¹ã®å¼æ°ãæå®ãããå ´åãçµæã¯æåã®å¼æ°ã§æå®ãããæ¥ä»ã¨ãäºã¤ç®ã®å¼æ°ã§æå®ãããæå»ã®ã¿ã¤ã ã¹ã¿ã³ãã§ãããªããã¿ã¤ã ã¹ã¿ã³ãã®ãã¤ã¯ãç§ã®é¨åã¯0ã¨ãªãã¾ãã</li>
+
+<li>ããå¼æ°ãä¸ã¤ã§ããããã¿ã¤ã ã¹ã¿ã³ãã§ãã£ãå ´åãçµæã¯ãã®ã¿ã¤ã ã¹ã¿ã³ãã§ãã</li>
+
+<li>ããå¼æ°ãä¸ã¤ã§ããããæååã§ãã£ãå ´åãçµæã¯ãã®æååã§ä¸ããããã¿ã¤ã ã¹ã¿ã³ãã§ãã14æåã®æååã«ããæå®ãããªããã¤ã¯ãç§ã®é¨åã¯0ã¨ãªãã¾ãã</li>
+
+</ul>
+</div>
+</div>
+
+<div class="section"><h4 class="sectiontitle">Syntax</h4><pre>TIMESTAMP ( <em>å¼</em> [, <em>å¼</em> ] )</pre>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4><div class="p"><samp class="codeph">records_table</samp>ã¨ãã表ã®äºã¤ç®ã®åã«ã¯(1998-12-25ã®ãããª)æ¥ä»ãæ ¼ç´ããã¦ãä¸ã¤ç®ã®åã«ã¯(17:12:30ã®ãããª)æå»ãæ ¼ç´ããã¾ãã
+ä¾ç¤ºããæã§ã¿ã¤ã ã¹ã¿ã³ããè¿ããã¨ãã§ãã¾ãã<pre>SELECT TIMESTAMP(col2, col3) FROM records_table</pre>
+</div>
+
+<div class="p">次ã®ç¯ã¯<samp class="codeph">1998-12-25-17:12:30.0</samp>ãè¿ãã¾ãã<pre>VALUES TIMESTAMP('1998-12-25', '17.12.30');
+1
+--------------------------
+1998-12-25 17:12:30.0
+</pre>
+</div>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefsqlj29026.html" title="">çµã¿è¾¼ã¿é¢æ°</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftimestampfunc.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrademderby.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrademderby.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrademderby.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="en-us" xml:lang="en-us">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="topic" name="DC.Type" />
+<meta name="DC.Title" content="Trademarks" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftrademderby" name="DC.Identifier" />
+<meta content="en-us" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>Trademarks</title>
+</head>
+<body id="rreftrademderby"><a name="rreftrademderby"><!-- --></a>
+
+
+<h1 class="topictitle1">Trademarks</h1>
+
+<div>
+<p>The following terms are trademarks or registered trademarks of other companies
+and have been used in at least one of the documents in the <span>Apache Derby</span> documentation
+library:</p>
+
+<p>Cloudscape, DB2, DB2 Universal Database, DRDA, and IBM are trademarks of
+International Business Machines Corporation in the United States, other countries,
+or both.</p>
+
+<p>Microsoft, Windows, Windows NT, and the Windows logo are trademarks of
+Microsoft Corporation in the United States, other countries, or both. </p>
+
+<p>Java and all Java-based trademarks are trademarks of Sun Microsystems,
+Inc. in the United States, other countries, or both.</p>
+
+<p>UNIX is a registered trademark of The Open Group in the United States and
+other countries.</p>
+
+<p>Other company, product, or service names may be trademarks or service marks
+of others.</p>
+
+</div>
+
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrademderby.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftriggername.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftriggername.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftriggername.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,60 @@
+<!--
+ 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="TriggerName" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj18919.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftriggername" 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>TriggerName</title>
+</head>
+<body id="rreftriggername"><a name="rreftriggername"><!-- --></a>
+
+
+<h1 class="topictitle1">TriggerName</h1>
+
+<div>
+<div class="section"><p><em>ããªã¬å</em>ã«ããã¦ã¼ã¶ãä½æããããªã¬ãåç
§ãããã¨ãã§ãã¾ãã</p>
+</div>
+
+<div class="section"><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"><h4 class="sectiontitle">ä¾</h4> <pre><strong>DROP TRIGGER TRIG1</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/rreftriggername.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrimfunc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrimfunc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrimfunc.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,138 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="en-us" xml:lang="en-us">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="TRIM é¢æ°" />
+<meta content="functions, TRIM, TRIM function" name="DC.subject" />
+<meta content="functions, TRIM, TRIM function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rreftrimfunc" name="DC.Identifier" />
+<meta content="en-us" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>TRIM é¢æ°</title>
+</head>
+<body id="rreftrimfunc"><a name="rreftrimfunc"><!-- --></a>
+
+
+<h1 class="topictitle1">TRIM é¢æ°</h1>
+
+
+<div>
+<div class="section">TRIMã¯æåå¼ãå¼æ°ã«ã¨ãé¢æ°ã§ãå¼æ°ããåãããã¯/ããã³å¾ã®è©°ããããæåãåãé¤ããå¤ãè¿ãã¾ããçç¥å¯è½ãªå¼æ°ã«æåãæå®ã§ãã¦ããã®æåã¯åãé¤ããããåãããã¯å¾ããããã¯ãã®ä¸¡æ¹ã«ããè©°ããããæåã§ãã</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æx</h4> <pre>TRIM( [ <em>trimOperands</em> ] <em>trimSource</em>)</pre>
+
+<div class="p">
+<pre>
+<em>trimOperands</em> ::= { <em>trimType</em> [ <em>trimCharacter ] </em> FROM | <em>trimCharacter</em> FROM }
+<em>trimType</em> ::= { LEADING | TRAILING | BOTH }
+<em>trimCharacter</em> ::= <em>æåå¼</em>
+<em>trimSource</em> ::= <em>æåå¼</em>
+</pre>
+
+</div>
+<div class="p">
+<em>trimType</em>ãæå®ãããªãã£ãå ´åãæ¢å®ã§BOTHã¨ã¿ãªããã¾ãã<em>trimCharacter</em>ãæå®ãããªãã£ãå ´åãæ¢å®ã§ç©ºç½æå(' ')ã¨ã¿ãªããã¾ãã<em>trimCharacter</em>ã®å¤ã¯ä»¥ä¸ã®ããããã«è©ä¾¡ãããªããã°ãªãã¾ããã
+ <ul>
+ <li>é·ãä¸æåã®æååãããã¯</li>
+
+ <li>NULL</li>
+
+ </ul>
+
+</div>
+<div class="p">
+<em>trimCharacter</em>ã¨<em>trimSource</em>ãNULLã¨è©ä¾¡ãããå ´åãTRIMé¢æ°ã®çµæã¯NULlã§ãããããªããã°TRIMé¢æ°ã®çµæã¯ä»¥ä¸ã®ããããã«ãªãã¾ãã
+ <ul>
+ <li>trimTypeãLEADINGãªããçµæã¯trimSourceã®å¤ã®åããtrimCharãåãé¤ããå¤ã§ãã</li>
+
+ <li>trimTypeãTRAILINGãªããçµæã¯trimSourceã®å¤ã®å¾ãããtrimCharãåãé¤ããå¤ã§ãã</li>
+
+ <li>trimTypeãBOTHãªããçµæã¯trimSourceã®å¤ã®å*ã¨*å¾ããtrimCharãåãé¤ããå¤ã§ãã</li>
+
+ </ul>
+
+</div>
+<p><em>trimSource</em>ã®ãã¼ã¿åãCHARãããã¯VARCHARãªããTRIMé¢æ°ã®è¿ãå¤ã®åã¯VARCHARã§ãããã以å¤ã®å ´åãTRIMé¢æ°ã®è¿ãå¤ã®åã¯CLOBã§ãã
+</p>
+
+</div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4>
+<div class="p">
+<pre><strong><span>-- 'derby'ãè¿ãã¾ãã(空ç½ã¯ããã¾ããã)</span>
+VALUES TRIM(' derby ')</strong></pre>
+
+</div>
+<div class="p">
+<pre><strong><span>-- 'derby'ãè¿ãã¾ãã (空ç½ã¯ããã¾ããã)</span>
+VALUES TRIM(BOTH ' ' FROM ' derby ')</strong></pre>
+
+</div>
+<div class="p">
+<pre><strong><span>-- 'derby 'ãè¿ãã¾ãã (æ«å°¾ã«ç©ºç½ãããã¾ãã)</span>
+VALUES TRIM(LEADING ' ' FROM ' derby ')</strong></pre>
+
+</div>
+<div class="p">
+<pre><strong><span>-- ' derby'ãè¿ãã¾ãã (å
é ã«äºã¤ç©ºç½ãããã¾ãã)</span>
+VALUES TRIM(TRAILING ' ' FROM ' derby ')</strong></pre>
+
+</div>
+<div class="p">
+<pre><strong><span>-- NULLãè¿ãã¾ãã</span>
+VALUES TRIM(cast (null as char(1)) FROM ' derby ')</strong></pre>
+
+</div>
+<div class="p">
+<pre><strong><span>-- NULLãè¿ãã¾ãã</span>
+VALUES TRIM(' ' FROM cast(null as varchar(30)))</strong></pre>
+
+</div>
+<div class="p">
+<pre><strong><span>-- ' derb'ãè¿ãã¾ãã(å
é ã«ç©ºç½ããããï½ãã)</span>
+VALUES TRIM('y' FROM ' derby')</strong></pre>
+
+</div>
+<div class="p">
+<pre><strong><span>-- <em>trimCharacter</em>ã«ã¯ä¸æåããæå®ã§ããªãã®ã§ã¨ã©ã¼ã¨ãªãã¾ãã</span>
+VALUES TRIM('by' FROM ' derby')</strong></pre>
+
+</div>
+
+</div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="rrefsqlj29026.html" title="">çµã¿è¾¼ã¿é¢æ°</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rreftrimfunc.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefunfreezedbproc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefunfreezedbproc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefunfreezedbproc.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,73 @@
+<!--
+ 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_UNFREEZE_DATABASE ã·ã¹ãã æç¶ã" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlbuiltinsystemprocedures.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefunfreezedbproc" 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_UNFREEZE_DATABASE ã·ã¹ãã æç¶ã</title>
+</head>
+<body id="rrefunfreezedbproc"><a name="rrefunfreezedbproc"><!-- --></a>
+
+
+<h1 class="topictitle1">SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE ã·ã¹ãã æç¶ã</h1>
+
+<div>
+<div class="section"><p>ããã¯ã¢ããå¾ã«ã<samp class="codeph">SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE</samp>ã·ã¹ãã æç¶ãã«ãããã¼ã¿ãã¼ã¹ã解åãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre>SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE()</pre>
+ <p>ãã®æç¶ãã¯çµæãè¿ãã¾ããã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">ä¾</h4> <pre>String backupdirectory = "c:/mybackups/" + JCalendar.getToday();
+CallableStatement cs = conn.prepareCall
+("CALL SYSCS_UTIL.SYSCS_FREEZE_DATABASE()");
+cs.execute();
+cs.close();
+// "backupdirectory"å
¨ä½ã®ããã¯ã¢ãããåãã¦ã¼ã¶ã®ã³ã¼ã
+// ããã¯ã¢ãããçµãã£ããããã¼ã¿ãã¼ã¹ã解åãã¾ãã
+now unfreeze the database once backup has completed:
+CallableStatement cs = conn.prepareCall
+("CALL SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE()");
+cs.execute();
+cs.close();
+</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/rrefunfreezedbproc.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefviewname.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefviewname.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefviewname.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,61 @@
+<!--
+ 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="rrefviewname" 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="rrefviewname"><a name="rrefviewname"><!-- --></a>
+
+
+<h1 class="topictitle1">ãã¥ã¼å</h1>
+
+<div>
+<div class="section"><p><em>ãã¥ã¼å</em>ã¯è¡¨ã¾ãã¯ãã¥ã¼ãããããã¾ãã<em>ãã¥ã¼å</em>ã¯<em>ã¹ãã¼ãå</em>ã§éå®ãããã¨ãã§ãã¾ãã</p>
+</div>
+
+<div class="section"><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"><h4 class="sectiontitle">Example</h4> <pre><strong><span>-- ããã¯ã¹ãã¼ãåã®ãããã¥ã¼åã§ãã</span>
+SELECT COUNT(*) FROM SAMP.EMP_RESUME</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/rrefviewname.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefyearfunc.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefyearfunc.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefyearfunc.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,72 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="YEARé¢æ°" />
+<meta content="YEAR function" name="DC.subject" />
+<meta content="YEAR function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefyearfunc" 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>YEARé¢æ°</title>
+</head>
+<body id="rrefyearfunc"><a name="rrefyearfunc"><!-- --></a>
+
+
+<h1 class="topictitle1">YEARé¢æ°</h1>
+
+
+<div>
+<div class="section">
+<p>YEARé¢æ°ã¯å¤ã®å¹´ã®é¨åãè¿ãã¾ããå¼æ°ã¯ãæ¥ä»ãã¿ã¤ã ã¹ã¿ã³ããããã³æ¥ä»ãã¿ã¤ã ã¹ã¿ã³ãã表ãæå¹ãªæååã§ãªããã°ãªãã¾ããã
+é¢æ°ã®è¿ãå¤ã¯1ãã9999ã¾ã§ã®éã®æ´æ°ã§ãã
+å¼æ°ãnullãã¨ãäºãããå ´åãè¿ãå¤ã¯nullã¨ãªããã¨ãããã¾ãã
+ããå¼æ°ãnullãªããè¿ãå¤ã¯nullã§ãã</p>
+
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>YEAR ( <em>å¼</em> )</strong></pre>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">Example</h4>
+<p>PROJECT表ã«ããããã¸ã§ã¯ããããéå§æ¥(PRSTDATE)ã¨å®äºæ¥(PRENDATE)ãæ¦ã®ä¸ã§åå¹´ã§ãããã®ãé¸æãã¾ãã</p>
+
+ <pre><strong>SELECT * FROM PROJECT
+WHERE YEAR(PRSTDATE) = YEAR(PRENDATE)</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/rrefyearfunc.html
------------------------------------------------------------------------------
svn:eol-style = native