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