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 [36/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/rrefsqlj32613.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32613.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32613.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,71 @@
+<!--
+ 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="RTRIM颿°" />
+<meta content="RTRIM function" name="DC.subject" />
+<meta content="RTRIM function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj32613" 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>RTRIM颿°</title>
+</head>
+<body id="rrefsqlj32613"><a name="rrefsqlj32613"><!-- --></a>
+
+
+<h1 class="topictitle1">RTRIM颿°</h1>
+
+
+<div>
+<div class="section"> <p>RTRIMã¯æåå¼ã®æ«å°¾ã«ãã空ç½ãåãé¤ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4>
+<pre><strong>RTRIM(<em>æåå¼</em>)</strong></pre>
+ <p>A
+æåå¼ã¯CHARãVARCHARãLONG VARCHARããã³ãæååã«æé»ã«å¤æå¯è½ãªçµè¾¼ã¿ã®ãã¼ã¿åã§ãã</p>
+
+<p>ãã<em>æåå¼</em>ãnullãªããRTRIMã®çµæã¯nullã§ãã</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- ' asdf'ãè¿ãã¾ãã</span>
+VALUES RTRIM(' asdf ')
+<span>-- 'asdf'ãè¿ãã¾ãã</span>
+VALUES RTRIM('asdf ')</strong></pre>
+ </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/rrefsqlj32613.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32654.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32654.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32654.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,95 @@
+<!--
+ 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="GROUP BY ç¯" />
+<meta content="GROUP BY clause" name="DC.subject" />
+<meta content="GROUP BY clause" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj32654" 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>GROUP BY ç¯</title>
+</head>
+<body id="rrefsqlj32654"><a name="rrefsqlj32654"><!-- --></a>
+
+
+<h1 class="topictitle1">GROUP BY ç¯</h1>
+
+
+<div>
+<div class="section">
+<p>GROUP BY ç¯ã¯<em><a href="rrefselectexpression.html#rrefselectexpression">鏿å¼</a></em>ã®ä¸é¨ã¨ãããã¨ãã§ãã¾ãããã®ç¯ã«ããçµæãä¸å以ä¸ã®åã®éã§åãå¤ãæã¤ãçµæã®é¨åéåã«ã¾ã¨ãããã¨ãã§ãã¾ãã
+ããããã®é¨åéåã«ã¯ãåé¡åãåãå¤ãæã¤è¡ã¯ããã¾ããã
+NULLã¯é¨åéåã¸ã®ã¾ã¨ããè¡ãå ´åãåãå¤ã¨è¦ãªããã¾ãã</p>
+
+<p>å
¸åçã«ãã£ã¦ãGROUP BYç¯ã¯éç´å¼ã¨ä½µãã¦ä½¿ããã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>GROUP BY <em><a href="rrefcolumnname.html#rrefcolumnname">åå</a></em> [ , <em><a href="rrefcolumnname.html#rrefcolumnname">åå</a></em> ] *</strong></pre>
+ <p><em><a href="rrefcolumnname.html#rrefcolumnname">åå</a></em> ã¯åãåããã«ã¦å¯è¦ã§ãªããã°ãªãã¾ãããåãåããã«ã¦ä¸å¯è¦ãªåã§ãã£ã¦ã¯ãªãã¾ããã
+ä¾ãã°ãGROUP BYç¯ãå¯åãåããã«ãã£ãå ´åããã®ç¯ã¯å¯åãåããã®å¤ã«ããåãåããã®åãåç
§ãã¦ã¯ãªãã¾ããã
+</p>
+
+<p>GROUP BYç¯ãæã¤<em><a href="rrefselectexpression.html#rrefselectexpression">鏿å¼</a></em>ã«ãã<em>鏿é
ç®</em>ã¯éç´ãåé¡åã§ãªããã°ãªãã¾ããã</p>
+ </div>
+
+
+<div class="example"> <pre><strong><span>-- airportã§åé¡ãããflightsã®ã
+-- flying_timesã®å¹³åãæ¢ãã</span>
+SELECT AVG (flying_time), orig_airport
+FROM Flights
+GROUP BY orig_airport
+
+SELECT MAX(city_name), region
+FROM Cities, Countries
+WHERE Cities.country_ISO_code = Countries.country_ISO_code
+GROUP BY region
+<span>-- smallintã«ããåé¡</span>
+SELECT ID, AVG(SALARY)
+FROM SAMP.STAFF
+GROUP BY ID
+-- AVGSALARYãEMPCOUNTåã¨ãDEPTNOåãASç¯ã«ããåå¾ããã
+-- ããã«OTHERSã¨ããç¸é¢åã§ãWORKDEPTåã«ããåé¡ãè¡ãã
+SELECT OTHERS.WORKDEPT AS DEPTNO,
+AVG(OTHERS.SALARY) AS AVGSALARY,
+COUNT(*) AS EMPCOUNT
+FROM SAMP.EMPLOYEE OTHERS
+GROUP BY OTHERS.WORKDEPT
+</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>Parent topic:</strong> <a href="rrefclauses.html" title="">SQL ç¯</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32654.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32693.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32693.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32693.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,83 @@
+<!--
+ 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="AVG颿°" />
+<meta content="AVG aggregate function" name="DC.subject" />
+<meta content="AVG aggregate function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj32693" 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>AVG颿°</title>
+</head>
+<body id="rrefsqlj32693"><a name="rrefsqlj32693"><!-- --></a>
+
+
+<h1 class="topictitle1">AVG颿°</h1>
+
+
+<div>
+<div class="section"> <p>AVGã¯è¤æ°è¡ã«ãããå¼ã®å¹³åãè©ä¾¡ããéç´é¢æ°ã§ãã(<a href="rrefsqlj33923.html#rrefsqlj33923">éç´ (éå颿°)</a>ãåç
§ãã¦ãã ããã)
+AVGã¯æ°å¤åã«è©ä¾¡ãããå¼ã«å¯¾ãã¦ã®ã¿ä½ç¨ããããã¨ãã§ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>AVG ( [ DISTINCT | ALL ] <em>å¼</em> )</strong></pre>
+
+<p>DISTICTãæå®ããã¨ãéè¤ãåãé¤ããã¾ãã
+ALLãæå®ããã¨ãéè¤ãæ®ãã¾ããALLãDISTINCTãæå®ãããªãå ´åã®æ¢å®ã¯ALLã§ãã
+ä¾ãã°ãåã®å¤ã1.0ã1.0ã1.0ã1.0ã2.0ã ã£ãã¨ãã¾ãããã®å ´åãAVG(col)ã¯AVG(DISTINCT col)ããå°ããªå¤ãè¿ãã¾ãã</p>
+
+<div class="p">DISTINCTãªéç´å¼ã¯ã<em><a href="rrefselectexpression.html#rrefselectexpression">鏿å¼</a></em>ã«ä¸ã¤ã ãç½®ããã¨ãã§ãã¾ãã
+ä¾ãã°ã次ã®ååãã¯ç¡å¹ã§ãã<pre><strong>SELECT AVG (DISTINCT flying_time), SUM (DISTINCT miles)
+FROM Flights</strong></pre>
+</div>
+
+<p>å¼ã«ã¯è¤æ°åã¸ã®åç
§ãå¼ããã£ã¦ãã¾ãã¾ããããä»ã®éç´ãå¯ååãããã£ã¦ã¯ãªãã¾ããã
+ã¾ãè©ä¾¡çµæã¯SQL-92ã®æ°å¤åã§ãªããã°ãªãã¾ããããããã£ã¦SQL-92ã®åã«è©ä¾¡ããã颿°ãªãå¼ã¶ãã¨ãã§ãã¾ããããè©ä¾¡çµæãNULLã§ãã£ãå ´åãéç´ã«ã¦ãã®å¤ã¯çããã¾ãã</p>
+
+<div class="p">çµæã®ãã¼ã¿åã¯æä½ãããå¼ã¨åããã¼ã¿åã§ãã(ãªã¼ãã¼ããã¼ã¯ããã¾ãã)
+ä¾ãã°æ¬¡ã®ååãã¯äºæ³ã«åãã¦æ´æ°ã®<em>1</em>ãè¿ãã¾ãã
+<pre><strong>SELECT AVG(c1)
+FROM (VALUES (1), (1), (1), (1), (2)) AS myTable (c1)</strong></pre>
+</div>
+
+<div class="p">ãã精度ãå¿
è¦ã§ããã°ãå¼ããã£ã¹ããã¾ãã<pre><strong>SELECT AVG(CAST (c1 AS DOUBLE PRECISION))
+FROM (VALUES (1), (1), (1), (1), (2)) AS myTable (c1)</strong></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/rrefsqlj32693.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32714.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32714.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32714.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,76 @@
+<!--
+ 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="VARCHAR FOR BIT DATA ãã¼ã¿å" />
+<meta content="VARCHAR FOR BIT DATA type" name="DC.subject" />
+<meta content="VARCHAR FOR BIT DATA type" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="crefsqlj31068.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj32714" 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>VARCHAR FOR BIT DATA ãã¼ã¿å</title>
+</head>
+<body id="rrefsqlj32714"><a name="rrefsqlj32714"><!-- --></a>
+
+
+<h1 class="topictitle1">VARCHAR FOR BIT DATA ãã¼ã¿å</h1>
+
+
+<div>
+<div class="section"> <p>VARCHAR FOR BIT DATAã§ã¯æå®ãããé·ã以ä¸ã®ãã¤ããªåãè¨é²ãããã¨ãã§ãã¾ããããã¯ç»åã®ãããªæååã¨ãããã¨ãé©å½ã§ã¯ãªããæ§é ã®ãªãæ
å ±ãè¨é²ããã®ã«ä¾¿å©ã§ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>{ VARCHAR | CHAR VARYING | CHARACTER VARYING } (<em>é·ã</em>) FOR BIT DATA </strong></pre>
+
+<p><em>é·ã</em>ã¯ç¬¦å·ã®ãªãæ´æ°ã®ãªãã©ã«ã§ãé·ãããã¤ãæ°ã§æå®ãã¾ãã</p>
+
+<p>CHAR FOR BIT DATAã¨ã¯ç°ãªããVARCHAR FOR BIT DATAã«ã¯ãæ¢å®ã®<em>é·ã</em>ã¯åå¨ãã¾ããã<em>é·ã</em>ã¯æå¤§ã§32,672ãã¤ãã«ããäºãã§ãã¾ãã</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">JDBCã¡ã¿ãã¼ã¿å (java.sql.Types)</h4>
+<p>VARBINARY</p>
+
+<p>
+VARCHAR FOR BIT DATAã§ã¯å¯å¤é·ã®ãã¤ãåãè¨é²ããã¾ããCHAR FOR BIT DATAã¨ã¯ç°ãªããVARCHAR FOR BIT DATAã§ã¯é·ããããããããã®å¤è©°ãã¯ããã¾ããã</p>
+
+<p>å¤ã®é£çµãªã©ãVARCHAR FOR BIT DATAã¨CHAR FOR BIT DATAã®å¤ã«è¡ãã¨ãå¾ãããçµæã®å¤ã¯VARCHAR FOR BIT DATAã¨ãªãã¾ãã</p>
+ </div>
+
+<div class="example"> <p>ãã¤ãã®ãªãã©ã«å¤ã¯å¸¸ã«VARCHAR FOR BIT DATAã§ããCHAR FOR BIT DATAã§ã¯ããã¾ããã</p>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="crefsqlj31068.html" title="">ãã¼ã¿å</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj32714.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33215.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33215.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33215.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,63 @@
+<!--
+ 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="rreftableexpression.html" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqljtfinvoke.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj33215" 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="rrefsqlj33215"><a name="rrefsqlj33215"><!-- --></a>
+
+
+<h1 class="topictitle1">表ã¾ãã¯ãã¥ã¼ãããã¯é¢æ°å¼</h1>
+
+<div>
+<div class="example"> <pre><strong>{<em> <a href="rreftablename.html#rreftablename">表å</a></em> | <em> <a href="rrefviewname.html#rrefviewname">ãã¥ã¼å</a></em> | <em><a href="rrefsqljtfinvoke.html#rrefsqljtfinvoke">è¡¨é¢æ°å¼ã³åºã</a></em>}
+ [ [ AS ] <em><a href="rrefcorrelationname.html#rrefcorrelationname">ç¸é¢å</a></em>
+ [ (<em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åç´åå</a></em> [ , <em><a href="rrefsimplecolumnname.html#rrefsimplecolumnname">åç´åå</a></em>]* ) ] ] ]
+</strong></pre>
+</div>
+
+</div>
+
+<div>
+<ul class="ullinks">
+<li class="ulchildlink"><strong><a href="rrefsqljtfinvoke.html">è¡¨é¢æ°ã®å¼ã³åºã</a></strong><br />
+</li>
+</ul>
+
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rreftableexpression.html" title="">TableExpression</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33215.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33520.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33520.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33520.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,85 @@
+<!--
+ 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="MIN颿°" />
+<meta content="MIN aggregate function" name="DC.subject" />
+<meta content="MIN aggregate function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj33520" 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>MIN颿°</title>
+</head>
+<body id="rrefsqlj33520"><a name="rrefsqlj33520"><!-- --></a>
+
+
+<h1 class="topictitle1">MIN颿°</h1>
+
+
+<div>
+<div class="section"> <p>MINã¯éç´é¢æ°ã§ãå
¨è¡ã«æ¸¡ãå¼ã®æå°å¤ãæ±ãã¾ãã
+(<a href="rrefsqlj33923.html#rrefsqlj33923">éç´ (éå颿°)</a>ãåç
§ãã¦ãã ããã)
+MINã¯çµã¿è¾¼ã¿ã®ãã¼ã¿åã«å¯¾ãã¦ã®ã¿é©ç¨å¯è½ã§ãã(ããã«ã¯CHARãVARCHARãDATEãTIMEçãå«ã¾ãã¾ãã)</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>MIN ( [ DISTINCT | ALL ] <em>å¼</em> )</strong></pre>
+
+<div class="p">
+DISTINCTã¨ALLã¨ããéå®è©ã«ã¯ãéè¤ãåãé¤ããããéè¤ãæ®ãåããããã¾ããããããããã®éå®è©ã¯MINå¼ã§ã¯å¹æãããã¾ããã
+<em><a href="rrefselectexpression.html#rrefselectexpression">鏿å¼</a></em>ã«ã¯éå®è©ã¯å¯ä¸ã¤ããæ¸ããã¨ãã§ãã¾ããã
+ä¾ãã°æ¬¡ã®ååãã¯è¨±ããã¾ããã<pre><strong>SELECT COUNT (DISTINCT flying_time), MIN (DISTINCT miles)
+FROM Flights</strong></pre>
+</div>
+
+<p>ãã®<em>å¼</em>ã«ã¯è¤æ°ã®åã¸ã®åç
§ãå¼ãæ¸ããã¨ãã§ãã¾ããããããå¯ååããä»ã®éç´ãæ¸ããã¨ã¯ã§ãã¾ããã
+å¼ã¯çµè¾¼ã¿ã®ãã¼ã¿åã¨ãã¦è©ä¾¡ãããªããã°ãªãããå¾ã£ã¦ã¡ã½ãããå¼ã¶ãªãçµè¾¼ã¿ã®ãã¼ã¿åã«è©ä¾¡ãããªããã°ãªãã¾ããã(ä¾ãã°ã<em>java.lang.Integer</em>ã<em>int</em>ãè¿ãã¡ã½ããã§ãããªããINTEGERã¨è©ä¾¡ããã¾ãã)ããå¼ãNULLã¨è©ä¾¡ãããã®ã§ããã°ããã®å¤ã¯éç´ã«ã¦ç¡è¦ããã¾ãã</p>
+
+<p>åã«ããæå°å¤ã決ããè¦åã¯ç°ãªãã¾ããCHARãVARCHARã§ã¯ãMINã®è©ä¾¡çµæã¯å¤ã®æ«å°¾ã«ããç©ºç½æåæ°ã«å½±é¿ããã¾ãã
+ä¾ãã°'z'ã¨'z 'ãåã«è¨é²ããã¦ããã¨ãã¦ãã©ã¡ãã®å¤ãæå°å¤ã¨ãã¦è¿ãããããæ±ºããæ¹æ³ã¯ããã¾ããããªããªãã°æååã®æ¯è¼ã«ã¦ç©ºç½æåã¯ç¡è¦ãããããã§ãã</p>
+
+<p>çµæã®ãã¼ã¿åã¯å¦çããå¼ã®ãã¼ã¿åã¨åãã§ãã(ãªã¼ãã¼ããã¼ãããã¨ã¯ããã¾ããã)</p>
+ </div>
+
+<div class="example"> <pre><strong><span>-- æå¹ã§ã¯ããã¾ããã</span>
+SELECT DISTINCT flying_time, MIN(DISTINCT miles) from Flights
+<span>-- æå¹ã§ãã</span>
+SELECT COUNT(DISTINCT flying_time), MIN(DISTINCT miles) from Flights
+<span>-- æãè¥ãæ¥ä»ãæ¢ãã¾ãã</span>
+SELECT MIN (flight_date) FROM FlightAvailability;</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/rrefsqlj33520.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33562.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33562.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33562.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,1186 @@
+<!--
+ 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="CAST 颿°" />
+<meta name="abstract" content="CAST颿°ã«ããå¤ã®åãä»ã®åã«å¤æãã¾ããã¾ãåçãªå¼æ°(?)ãNULLå¤ã«åãä¸ãã¾ãã" />
+<meta name="description" content="CAST颿°ã«ããå¤ã®åãä»ã®åã«å¤æãã¾ããã¾ãåçãªå¼æ°(?)ãNULLå¤ã«åãä¸ãã¾ãã" />
+<meta content="CAST function, conversions, SQL-92 data types using CAST, CAST function (explicit)" name="DC.subject" />
+<meta content="CAST function, conversions, SQL-92 data types using CAST, CAST function (explicit)" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj33562" 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>CAST 颿°</title>
+</head>
+<body id="rrefsqlj33562"><a name="rrefsqlj33562"><!-- --></a>
+
+
+<h1 class="topictitle1">CAST 颿°</h1>
+
+
+
+<div><p>CAST颿°ã«ããå¤ã®åãä»ã®åã«å¤æãã¾ããã¾ãåçãªå¼æ°(?)ãNULLå¤ã«åãä¸ãã¾ãã</p>
+
+<div class="section"> <p>CASTã®å¼ã¯å¼ãç½®ããã¨ãã§ããå ´æãªãã©ãã«ã§ãç½®ããã¨ãã§ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>CAST ( [ <em>å¼</em> | NULL | ? ]
+ AS <em>ãã¼ã¿å</em>)</strong></pre>
+
+<p>å¼ããã£ã¹ãããå
ã®ãã¼ã¿åã®ãã¨ã<em>ç®æ¨å</em>ã¨ããã¾ãããã£ã¹ããããã¨ãã¦ããå¼ã®ãã¼ã¿åã®ãã¨ã<em>æºæ³å</em>ã¨ããã¾ãã</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">CASTã«ããSQL-92 ãã¼ã¿åéã®å¤æ</h4>
+<div class="p">以ä¸ã«ç¤ºã表ã¯SQLãã¼ã¿åã«ã¦æç¤ºçãªå¤æãæå¹ãªãæºæ³åã¨ç®æ¨åã示ãã¾ãã
+ãã®è¡¨ã¯ä½ãã®ãã¼ã¿åã®éã§æç¤ºçãªå¤æãæå¹ãªã®ãã示ãã¾ãã
+è¡¨ã®æåã®åã¯æºæ³åã示ãã¾ããè¡¨ã®æåã®è¡ã¯ç®æ¨åã示ãã¾ãã
+Yã¯æºæ³åããç®æ¨åã¸ã®åã®å¤æãæå¹ã§ãããã¨ã示ãã¾ãã
+ä¾ãã°ãäºè¡ç®ã®æåã®ã³ãã«ããæºæ³åã¯SMALLINTã¨è¨è¿°ããã¾ãã
+äºè¡ç®ã®ã»ãã®ã³ãã¯ãè¡¨ã®æåã®è¡ã«æ¸ããã¦ããåãç®æ¨åã¨ãã¦ãSMALLINTã®åã夿ã§ãããå¦ããè¨è¿°ãã¾ãã
+<div class="tablenoborder"><table summary="" cellspacing="0" cellpadding="4" frame="border" border="1" rules="all"><caption>表 1. SQL-92 ãã¼ã¿åéã«ã¦æç¤ºçãªå¤æãæå¹ãªãæºæ³åã¨ç®æ¨å</caption>
+<thead align="left">
+<tr>
+<th valign="top" width="17.1875%" id="N10126">Types</th>
+
+<th valign="top" width="4.375%" id="N1012E"> <p>S<br />
+M<br />
+A<br />
+L<br />
+L<br />
+I<br />
+N<br />
+T</p>
+</th>
+
+<th valign="top" width="4.375%" id="N1013C"> <p>I<br />
+N<br />
+T<br />
+E<br />
+G<br />
+E<br />
+R</p>
+</th>
+
+<th valign="top" width="4.375%" id="N1014A"> <p>B<br />
+I<br />
+G<br />
+I<br />
+N<br />
+T</p>
+</th>
+
+<th valign="top" width="4.375%" id="N10158"> <p>D<br />
+E<br />
+C<br />
+I<br />
+M<br />
+A<br />
+L</p>
+</th>
+
+<th valign="top" width="4.21875%" id="N10166"> <p>R<br />
+E<br />
+A<br />
+L</p>
+</th>
+
+<th valign="top" width="4.375%" id="N10174"> <p>D<br />
+O<br />
+U<br />
+B<br />
+L<br />
+E</p>
+</th>
+
+<th valign="top" width="4.375%" id="N10182"> <p>F<br />
+L<br />
+O<br />
+A<br />
+T</p>
+</th>
+
+<th valign="top" width="4.375%" id="N10190"> <p>C<br />
+H<br />
+A<br />
+R</p>
+</th>
+
+<th valign="top" width="4.375%" id="N1019E"> <p>V<br />
+A<br />
+R<br />
+C<br />
+H<br />
+A<br />
+R</p>
+</th>
+
+<th valign="top" width="4.21875%" id="N101AC"> <p>L<br />
+O<br />
+N<br />
+G<br />
+<br />
+V<br />
+A<br />
+R<br />
+C<br />
+H<br />
+A<br />
+R</p>
+</th>
+
+<th valign="top" width="4.375%" id="N101BA"> <p>C<br />
+H<br />
+A<br />
+R<br />
+ <br />
+F<br />
+O<br />
+R<br />
+ <br />
+B<br />
+I<br />
+T<br />
+<br />
+D<br />
+A<br />
+T<br />
+A</p>
+</th>
+
+<th valign="top" width="4.53125%" id="N101C8"> <p>V<br />
+A<br />
+R<br />
+C<br />
+H<br />
+A<br />
+R<br />
+ <br />
+F<br />
+O<br />
+R<br />
+ <br />
+B<br />
+I<br />
+T<br />
+<br />
+D<br />
+A<br />
+T<br />
+A</p>
+</th>
+
+<th valign="top" width="4.21875%" id="N101D6"> <p>L<br />
+O<br />
+N<br />
+G<br />
+ <br />
+V<br />
+A<br />
+R<br />
+C<br />
+H<br />
+A<br />
+R<br />
+ <br />
+F<br />
+O<br />
+R<br />
+ <br />
+B<br />
+I<br />
+T<br />
+<br />
+D<br />
+A<br />
+T<br />
+A</p>
+</th>
+
+<th valign="top" width="4.375%" id="N101E4"> <p>C<br />
+L<br />
+O<br />
+B</p>
+</th>
+
+<th valign="top" width="4.375%" id="N101F2"> <p>B<br />
+L<br />
+O<br />
+B</p>
+</th>
+
+<th valign="top" width="4.375%" id="N10200"> <p>D<br />
+A<br />
+T<br />
+E</p>
+</th>
+
+<th valign="top" width="4.375%" id="N1020E"> <p>T<br />
+I<br />
+M<br />
+E</p>
+</th>
+
+<th valign="top" width="4.375%" id="N1021C"> <p>T<br />
+I<br />
+M<br />
+E<br />
+S<br />
+T<br />
+A<br />
+M<br />
+P</p>
+</th>
+
+<th valign="top" width="4.375%" id="N1022A"> <p>X<br />
+M<br />
+L</p>
+</th>
+
+</tr>
+
+</thead>
+
+<tbody>
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">SMALLINT</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">INTEGER</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">BIGINT</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">DECIMAL</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">REAL</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">DOUBLE</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">FLOAT</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">CHAR</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">VARCHAR</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">LONG VARCHAR</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">CHAR FOR BIT DATA</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">Y</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">VARCHAR FOR BIT DATA</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">Y</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">LONG VARCHAR FOR BIT DATA</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">Y</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">CLOB</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">BLOB</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">DATE</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">TIME</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">TIMESTAMP</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">Y</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">Y</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">-</td>
+
+</tr>
+
+<tr>
+<td valign="top" width="17.1875%" headers="N10126 ">XML</td>
+
+<td valign="top" width="4.375%" headers="N1012E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1013C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1014A ">-</td>
+
+<td valign="top" width="4.375%" headers="N10158 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N10166 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10174 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10182 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10190 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1019E ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101AC ">-</td>
+
+<td valign="top" width="4.375%" headers="N101BA ">-</td>
+
+<td valign="top" width="4.53125%" headers="N101C8 ">-</td>
+
+<td valign="top" width="4.21875%" headers="N101D6 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101E4 ">-</td>
+
+<td valign="top" width="4.375%" headers="N101F2 ">-</td>
+
+<td valign="top" width="4.375%" headers="N10200 ">-</td>
+
+<td valign="top" width="4.375%" headers="N1020E ">-</td>
+
+<td valign="top" width="4.375%" headers="N1021C ">-</td>
+
+<td valign="top" width="4.375%" headers="N1022A ">Y</td>
+
+</tr>
+
+</tbody>
+
+</table>
+</div>
+</div>
+<p>夿ãæå¹ãªããCASTã¯å¯è½ã§ããæºæ³åã¨ç®æ¨åã®éã®å¤§ããã®éäºææ§ã¯ãå®è¡æã«ã¨ã©ã¼ãèµ·ãããã¨ãããã¾ãã</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">ä½ãæ¸ã</h4>
+<div class="p">ãã®è°è«ã§ã¯ã<span>Derby</span>ã«ã¦SQL-92ãã¼ã¿åã¯ã以ä¸ã®ããã«åé¡ããã¾ãã<ul>
+<li><em>æ°</em> <ul>
+<li>æ£ç¢ºãªæ° (<a href="rrefsqlj16221.html#rrefsqlj16221">SMALLINT</a>,
+<a href="rrefsqlj10696.html#rrefsqlj10696">INTEGER</a>,
+<a href="rrefsqlj30435.html#rrefsqlj30435">BIGINT</a>,
+<a href="rrefsqlj15260.html#rrefsqlj15260">DECIMAL</a>,
+<a href="rrefsqlj12362.html#rrefsqlj12362">NUMERIC</a>)</li>
+
+<li>è¿ä¼¼ã®æ° (<a href="rrefsqlj27281.html#rrefsqlj27281">FLOAT</a>,
+<a href="rrefsqlj14122.html#rrefsqlj14122">REAL</a>,
+<a href="rrefsqljdoubleprecision.html#rrefsqljdoubleprecision">DOUBLE PRECISION</a>)</li>
+
+</ul>
+</li>
+
+<li><em>å</em> <ul>
+<li>æåå (<a href="rrefclob.html#rrefclob">CLOB</a>,
+<a href="rrefsqlj13733.html#rrefsqlj13733">CHAR</a>,
+<a href="rrefsqlj41207.html#rrefsqlj41207">VARCHAR</a>,
+<a href="rrefsqlj15147.html#rrefsqlj15147">LONG VARCHAR</a>)</li>
+
+<li>ãããå (<a href="rrefblob.html#rrefblob">BLOB</a>,
+<a href="rrefsqlj57924.html#rrefsqlj57924">CHAR FOR BIT DATA</a>,
+<a href="rrefsqlj32714.html#rrefsqlj32714">VARCHAR FOR BIT DATA</a>,
+<a href="rrefsqlj30118.html#rrefsqlj30118">LONG VARCHAR FOR BIT DATA</a>)</li>
+
+</ul>
+</li>
+
+<li><em>æ¥æ</em> <ul>
+<li><a href="rrefsqlj18730.html#rrefsqlj18730">DATE</a></li>
+
+<li><a href="rrefsqlj21908.html#rrefsqlj21908">TIME</a></li>
+
+<li><a href="rrefsqlj27620.html#rrefsqlj27620">TIMESTAMP</a></li>
+
+</ul>
+</li>
+
+</ul>
+</div>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">æ°å¤åããã®å夿</h4>
+<p>æ°å¤åã¯ä»ã®ãããªãæ°å¤åã«ã夿ã§ãã¾ããããæ°ã®å°æ°é¨ã§ã¯ãªãé¨åãåãæ¨ã¦ãªããã°ã夿ããç®æ¨åã§æ±ããªããªãã°ä¾å¤ãçºçãã¾ããããæºæ³åã®å°æ°é¨ãç®æ¨åã§æ±ããªããªãã°ãç®æ¨åã«ã¦æ±ããããæé»è£¡ã«æºæ³åã®å¤ã¯åãæ¨ã¦ããã¾ãããã¨ãã°ã763.1234ãINTEGERã«å¤æããã¨763ã¨ãªãã¾ãã</p>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">ãããåã®åã¸ã®/ããã®å夿</h4>
+<p>ãããåã®åã¯ä»ã®ãããåã®åã«å¤æã§ãã¾ãããæååã«å¤æãããã¨ã¯ã§ãã¾ããã
+æååã®åããããåã®åã«å¤æããã¨ãç®æ¨ã®ãããåã®é·ãã«ä¼ãããã«ãæ«å°¾ã0ã§è©°ãããã¾ããBLOBåã¯ããéå®ããã¦ãããæç¤ºçãªå¤æãå¿
è¦ã¨ãã¾ãã ã»ã¨ãã©ã®å ´åãBLOBåããã¯/ã¸ã¯å夿ã§ãã¾ããã</p>
+ </div>
+
+<div class="section" id="rrefsqlj33562__sqlj75614"><a name="rrefsqlj33562__sqlj75614"><!-- --></a><h4 class="sectiontitle">æ¥/æã®å夿</h4>
+<p>æ¥/æã®å¤ã¯ãããªãå ´åã§ãTIMESTAMPã¸/ããå夿ã§ãã¾ãã
+DATEãTIMESTAMPã«å夿ãããå ´åãçµæã®TIMESTAMPã«ã¦TIMEã®é¨åã¯å¸¸ã«00:00:00ã§ãã
+ããTIMEãTIMESTAMPã«å夿ãããå ´åãçµæã®TIMESTAMPã«ã¦DATEã®é¨åã¯ãCASTãå®è¡ãããã¨ãã®CURRENT_DATEã®å¤ã¨ãªãã¾ãã
+TIMESTAMPãDATEã«å夿ãããå ´åãTIMEã®é¨åã¯æé»è£¡ã«åãæ¨ã¦ããã¾ãã
+TIMESTAMPãTIMEã«å夿ãããå ´åãDATEã®é¨åã¯æé»è£¡ã«åãæ¨ã¦ããã¾ãã
+</p>
+ </div>
+
+<div class="example"> <pre><strong>SELECT CAST (miles AS INT)
+FROM Flights
+-- timestampãæååã«å¤æãã
+INSERT INTO mytable (text_column)
+VALUES (CAST (CURRENT_TIMESTAMP AS VARCHAR(100)))
+-- NULLãé©åãªãã¼ã¿åã«å¤æããªããã°ãªããªãã
+SELECT airline
+FROM Airlines
+UNION ALL
+VALUES (CAST (NULL AS CHAR(2)))
+-- doubleãdecimalã«å¤æããã
+SELECT CAST (FLYING_TIME AS DECIMAL(5,2))
+FROM FLIGHTS
+-- SMALLINTãBIGINTã«å¤æãã
+VALUES CAST (CAST (12 as SMALLINT) as BIGINT)</strong></pre>
+ </div>
+
+<div class="section"><h4 class="sectiontitle">XMLå¤ã®å¤æ</h4>
+<p>æç¤ºçã«ãæé»çã«ããXMLã®å¤ã¯XML以å¤ã®å¦ä½ãªãåã¸ãå夿ã§ãã¾ãããXMLåãæåååã«ããå ´åã¯ã<a href="rreffuncxmlserialize.html#rreffuncxmlserialize">XMLSERIALIZE æ¼ç®å</a>ã使ã£ã¦ãã ããã</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/rrefsqlj33562.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33602.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33602.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33602.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,97 @@
+<!--
+ 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="WHERE ç¯" />
+<meta content="WHERE clause" name="DC.subject" />
+<meta content="WHERE clause" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefclauses.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj33602" 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>WHERE ç¯</title>
+</head>
+<body id="rrefsqlj33602"><a name="rrefsqlj33602"><!-- --></a>
+
+
+<h1 class="topictitle1">WHERE ç¯</h1>
+
+
+<div>
+<div class="section"> <p>WHEREç¯ã¯å¿
è¦ã«å¿ãã¦ã<em><a href="rrefselectexpression.html#rrefselectexpression">鏿å¼</a></em>ã<a href="rrefsqlj35981.html#rrefsqlj35981">DELETE æ</a>ã<a href="rrefsqlj26498.html#rrefsqlj26498">UPDATE æ</a>ã«ç½®ããã¨ãã§ãã¾ãã
+WHEREç¯ã®çå½å¼ã«åºã¥ãã¦è¡ã鏿ãããã¨ãã§ãã¾ãã
+å¼ãçã¨è©ä¾¡ãããè¡ã ãããçµæã«ã¦è¿ããã¾ãã
+ãããDELETEæã§ããã°åé¤ãããUPDATEæã§ããã°æ´æ°ããã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">æ§æ</h4> <pre><strong>WHERE <em><a href="rrefsqlj23075.html#rrefsqlj23075">çå½å¼</a></em></strong></pre>
+ <p>
+WHEREç¯ã«ã¯çå½å¼ãç½®ããã¨ãã§ãã¾ãã<a href="rrefsqlj19433.html#rrefsqlj19433__sqlj18370">ä¸è¬çãªå¼ã®è¡¨</a>ã«ä¸è¦§ãããä¸è¬å¼ã®ã»ã¨ãã©ã¯ãçå½å¤ã«ãªããã¨ãã§ãã¾ãã</p>
+
+<p>ããã«ãããä¸è¬çãªçå½å¼ãããã¾ãã表10ã«ä¸è¦§ãããç彿¼ç®åã¯ãä¸ã¤ãããã¯ãã以ä¸ã®ãªãã©ã³ããã¨ãããã®å¼ã¯çå½å¤ãè¿ãã¾ãã</p>
+ </div>
+
+<div class="example"><h4 class="sectiontitle">ä¾</h4><pre><strong>
+<span>-- ãã¸ãã¹ã¯ã©ã¹ã®å¸ãäºç´ããã¦ããªã
+-- 便ãè¦ã¤ããã</span>
+SELECT *
+FROM FlightAvailability
+WHERE business_seats_taken IS NULL
+OR business_seats_taken = 0
+<span>-- EMP_ACTã¨EMPLOYEEã¨ãã表ãçµåãã¦ã
+-- EMP_ACTã®å
¨åã«ãEMPLOYEEãã徿¥å¡ã®èå(LASTNAME)ãå ãã¦
+-- çµæè¡ã¨ãã¦è¿ãã</span>
+SELECT SAMP.EMP_ACT.*, LASTNAME
+ FROM SAMP.EMP_ACT, SAMP.EMPLOYEE
+ WHERE EMP_ACT.EMPNO = EMPLOYEE.EMPNO
+<span>-- 販売代ç人ã®ç¤¾å¡çªå·ã¨çµ¦æããå½¼ãã®é¨ç½²ã®å¹³åè³éã¨å¡æ°ã¨å
±ã«ã
+--è¿ãã
+-- ãã®ååãã§ã¯ãã¾ãååãã®ä¸é¨(DINFO)ã«ã¦ãASç¯ã§æ°ããååãä¸ãã¦ã
+-- AVGSALARYã¨EMPCOUNTåããã³WHEREç¯ã§ä½¿ããã¦ããDEPTNOã
+-- åå¾ã§ããããã«ããå¿
è¦ãããã</span>
+SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT
+ FROM EMPLOYEE THIS_EMP,
+ (SELECT OTHERS.WORKDEPT AS DEPTNO,
+ AVG(OTHERS.SALARY) AS AVGSALARY,
+ COUNT(*) AS EMPCOUNT
+ FROM EMPLOYEE OTHERS
+ GROUP BY OTHERS.WORKDEPT
+ )AS DINFO
+ WHERE THIS_EMP.JOB = 'SALESREP'
+ AND THIS_EMP.WORKDEPT = DINFO.DEPTNO</strong></pre>
+ </div>
+
+</div>
+
+<div>
+<div class="familylinks">
+<div class="parentlink"><strong>親ãããã¯:</strong> <a href="rrefclauses.html" title="">SQL ç¯</a></div>
+</div>
+</div>
+
+</body>
+</html>
Propchange: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33602.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33772.html
==============================================================================
--- websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33772.html (added)
+++ websites/production/db/content/derby/docs/10.4/ja_JP/ref/rrefsqlj33772.html Wed Mar 13 13:54:17 2013
@@ -0,0 +1,68 @@
+<!--
+ Licensed to the Apache Software Foundation (ASF) under one or more
+ contributor license agreements. See the NOTICE file distributed with
+ this work for additional information regarding copyright ownership.
+ The ASF licenses this file to You under the Apache License, Version 2.0
+ (the "License"); you may not use this file except in compliance with
+ the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing, software
+ distributed under the License is distributed on an "AS IS" BASIS,
+ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ See the License for the specific language governing permissions and
+ limitations under the License.
+-->
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html lang="ja" xml:lang="ja">
+<head>
+<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
+<meta name="copyright" content="(C) Copyright 2005" />
+<meta name="DC.rights.owner" content="(C) Copyright 2005" />
+<meta content="public" name="security" />
+<meta content="index,follow" name="Robots" />
+<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
+<meta content="reference" name="DC.Type" />
+<meta name="DC.Title" content="CURRENT_TIME颿°" />
+<meta content="CURRENT_TIME function" name="DC.subject" />
+<meta content="CURRENT_TIME function" name="keywords" />
+<meta scheme="URI" name="DC.Relation" content="rrefsqlj29026.html" />
+<meta content="XHTML" name="DC.Format" />
+<meta content="rrefsqlj33772" name="DC.Identifier" />
+<meta content="ja" name="DC.Language" />
+<link href="/export/home/tmp/derby/docs-10.4/out/ja_JP/reftemp/commonltr.css" type="text/css" rel="stylesheet" />
+<title>CURRENT_TIME颿°</title>
+</head>
+<body id="rrefsqlj33772"><a name="rrefsqlj33772"><!-- --></a>
+
+
+<h1 class="topictitle1">CURRENT_TIME颿°</h1>
+
+
+<div>
+<div class="section"> <p>CURRENT_TIMEã¯ç¾å¨ã®æå»ãè¿ãã¾ããä¸ã¤ã®æã®å
ã§ããã°ã颿°ã¯ä½åº¦å¼ã°ãã¦ãåãå¤ãè¿ãã¾ããã§ããããã«ã¼ã½ã«ã§è¡ãæ¾ãéã«çµéããæéã«ãããããããã®é¢æ°ã¯ä¸ã¤ã«æ±ºã¾ã£ãå¤ãè¿ãã¾ãã</p>
+</div>
+
+<div class="section"><h4 class="sectiontitle">åå¸</h4> <pre><strong>CURRENT_TIME</strong></pre>
+ <p>ãããã¯</p>
+ <pre><strong>CURRENT TIME</strong></pre>
+ </div>
+
+<div class="example"> <pre><strong>VALUES CURRENT_TIME
+<span>-- ã¾ãã¯ã</span>
+
+VALUES CURRENT TIME</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/rrefsqlj33772.html
------------------------------------------------------------------------------
svn:eol-style = native