Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\doc\ohj\defining_flatfiles017.htm

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\doc\ohj\defining_flatfiles017.htm

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja" lang="ja">
<script src="./callback.js" type="text/javascript"></script>
<noscript>??????????????avaScript???????????????????????????????????????????????JavaScript??????????</noscript>
</head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Script-Type" content="text/javascript" />

<meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" />
<meta name="date" content="2009-06-04T0:46:15Z" />
<meta name="robots" content="noarchive" />
<meta name="doctitle" content="Reinterpreting COBOL Data Structures Into Relational Data Structures" />
<meta name="relnum" content="11g Release 2 (11.2)" />
<meta name="partnum" content="E10582-01" />
<link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" />
<link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" />
<link rel="contents" href="toc.htm" title="Contents" type="text/html" />
<link rel="prev" href="defining_flatfiles016.htm" title="Previous" type="text/html" />
<link rel="next" href="defining_flatfiles018.htm" title="Next" type="text/html" />
<title>COBOL???????????????????????????????????????</title>
</head>
<body>
<div class="zz-skip-header"><a href="#BEGIN">??????????????</a></div>
<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
<col width="86%" />
<col width="*" />
<tr valign="bottom">
<td align="left"></td>
<td align="center"><a href="defining_flatfiles016.htm"> <img src="./dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a>&nbsp;</td>
<td align="center"><a href="defining_flatfiles018.htm"> <img src="./dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</span></a></td>
</tr>
</table>
<div class="sect2"><a id="sthref87" name="sthref87"></a>
<h1>COBOL???????????????????????????????????????</h1>
<a name="BEGIN" id="BEGIN"></a>
<p>COBOL????????????????????????????????????????????????????????????????????????????????????????????????????????????</p>
<a id="sthref88" name="sthref88"></a>
<p class="subhead2">??????</p>
<p>??????????????????????????????????01???????????????????????????????????????????????????°?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????°??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????</p>
<a id="sthref89" name="sthref89"></a>
<p class="subhead2">???</p>
<p>Warehouse Builder??????????????????????????????????????????????????????????????????????????????????????????????QL*Loader?????????????????????????????????????????????????????????????????????????QL*Loader??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????<a href="defining_flatfiles019.htm#BABDAAHF">???: ??????????????????????????????????????????????</a>????????????????</p>
<a id="sthref90" name="sthref90"></a>
<p class="subhead2">COBOL????????QL?????????????????</p>
<p><code>USAGE</code>???<code>PICTURE</code>???????????????????????????????????????????ICTURE???USAGE??????????????????????????????????????????????????????????<a href="#BABHICEJ">???: COBOL???????????????SQL*Loader????????</a>?????OBOL?????????????????????????????????????????????????????????????????????QL*Loader??????????????????????????????????????ICTURE??????????????????????????????????????????????PICTURE??????????????????????????(n)?? = 5???????????????????????5?????????????????</p>
<div class="tblformal"><a id="sthref91" name="sthref91"></a><a id="BABHICEJ" name="BABHICEJ"></a>
<p class="titleintable">COBOL???????????????SQL*Loader??????</p>
<table class="Formal" title="COBOL???????????????SQL*Loader??????" summary="COBOL???????????????SQL*Loader??????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0">
<col width="21%" />
<col width="30%" />
<col width="*" />
<thead>
<tr align="left" valign="top">
<th align="left" valign="bottom" id="r1c1-t7">COBOL??????</th>
<th align="left" valign="bottom" id="r1c2-t7">SQL*Loader??????</th>
<th align="left" valign="bottom" id="r1c3-t7">???</th>
</tr>
</thead>
<tbody>
<tr align="left" valign="top">
<td align="left" id="r2c1-t7" headers="r1c1-t7">
<p>X(n)</p>
</td>
<td align="left" headers="r2c1-t7 r1c2-t7">
<ul>
<li>
<p>CHAR(n)</p>
</li>
<li>
<p>?????????????????????????????ATE(n)????????????</p>
</li>
<li>
<p>TIME</p>
</li>
<li>
<p>TIMESTAMP</p>
</li>
<li>
<p>INTERVAL</p>
</li>
</ul>
</td>
<td align="left" headers="r2c1-t7 r1c3-t7">
<p>????????????X????????????????????????????????1?????????????</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r3c1-t7" headers="r1c1-t7">
<p>A(n)</p>
</td>
<td align="left" headers="r3c1-t7 r1c2-t7">
<p>CHAR(n)</p>
</td>
<td align="left" headers="r3c1-t7 r1c3-t7">
<p>????????????????????A?????????°??????????????????????????????</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r4c1-t7" headers="r1c1-t7">
<p>9(n)</p>
</td>
<td align="left" headers="r4c1-t7 r1c2-t7">
<ul>
<li>
<p>INTEGER EXTERNAL(n)</p>
</li>
<li>
<p>DECIMAL EXTERNAL(n)</p>
</li>
<li>
<p>ZONED EXTERNAL(n)</p>
</li>
<li>
<p>?????????????????????????????ATE(n)????????????</p>
</li>
</ul>
</td>
<td align="left" headers="r4c1-t7 r1c3-t7">
<p>???????????9????1???????????</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r5c1-t7" headers="r1c1-t7">
<p>+- mantissa +- exponent</p>
</td>
<td align="left" headers="r5c1-t7 r1c2-t7">
<p>FLOAT EXTERNAL (length)</p>
</td>
<td align="left" headers="r5c1-t7 r1c3-t7">
<p>?????????????????</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r6c1-t7" headers="r1c1-t7">
<p>S9(n)v9(m) SIGN TRAILING</p>
</td>
<td align="left" headers="r6c1-t7 r1c2-t7">
<p>ZONED(precision, scale)??recision = n+m??cale = m</p>
</td>
<td align="left" headers="r6c1-t7 r1c3-t7">
<p>???????????9????1???????????????????????????????????????????????????????????????</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r7c1-t7" headers="r1c1-t7">
<p>9(n)v9(m)</p>
</td>
<td align="left" headers="r7c1-t7 r1c2-t7">
<p>ZONED(precision, scale)??recision = n+m??cale = m</p>
</td>
<td align="left" headers="r7c1-t7 r1c3-t7">
<p>???????????9????1????????????????????????????????????</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r8c1-t7" headers="r1c1-t7">
<p>9(n)v9(m)</p>
<p>S9(n)v9(m)</p>
</td>
<td align="left" headers="r8c1-t7 r1c2-t7">
<p>SMALLINT</p>
<p>INTEGER(length 2??4?????8)</p>
<p>SIGNED|??????????????????</p>
<p>UNSIGNED</p>
<p>BYTEORDER??????????????????</p>
<p>?????????????????</p>
</td>
<td align="left" headers="r8c1-t7 r1c3-t7">
<p>2???????????????????????</p>
<p>????????????????????????????</p>
<p>n+m = 1-4??ength = 2</p>
<p>n+m = 5-9??ength = 4</p>
<p>n+m = 10-18??ength =8</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r9c1-t7" headers="r1c1-t7">
<p>??????</p>
</td>
<td align="left" headers="r9c1-t7 r1c2-t7">
<p>FLOAT</p>
<p>BYTEORDER????????????????????</p>
</td>
<td align="left" headers="r9c1-t7 r1c3-t7">
<p>????????????????4??????</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r10c1-t7" headers="r1c1-t7">
<p>??????</p>
</td>
<td align="left" headers="r10c1-t7 r1c2-t7">
<p>DOUBLE</p>
<p>BYTEORDER????????????????????</p>
</td>
<td align="left" headers="r10c1-t7 r1c3-t7">
<p>????????????????8??????</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r11c1-t7" headers="r1c1-t7">
<p>9(n)v9(m)</p>
<p>S9(n)v9(m)</p>
</td>
<td align="left" headers="r11c1-t7 r1c2-t7">
<p>DECIMAL (precision, scale)??recision = n+m??cale = m</p>
</td>
<td align="left" headers="r11c1-t7 r1c3-t7">
<p>10????????????????????????????????????????????????????????????????????????????????????????2????????????????????????????????????????</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r12c1-t7" headers="r1c1-t7">
<p>X(n)</p>
<p>9(n)v9(m)</p>
<p>S9(n)v9(m)</p>
</td>
<td align="left" headers="r12c1-t7 r1c2-t7">
<p>???????????????</p>
</td>
<td align="left" headers="r12c1-t7 r1c3-t7">
<p>????????????????????????????????INARY?????????????????????????????????????????????</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r13c1-t7" headers="r1c1-t7">
<p>G(n)</p>
</td>
<td align="left" headers="r13c1-t7 r1c2-t7">
<p>GRAPHIC(n)</p>
</td>
<td align="left" headers="r13c1-t7 r1c3-t7">
<p>???????????????????????????????????????????????</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r14c1-t7" headers="r1c1-t7">
<p>05 V</p>
<p>49 V-LN PIC S9(4)</p>
<p>COMP</p>
<p>05 V-DATA PIC X(n)</p>
</td>
<td align="left" headers="r14c1-t7 r1c2-t7">
<p>VARCHAR(max length)????MALLINT??????????????????????????????????????</p>
</td>
<td align="left" headers="r14c1-t7 r1c3-t7">
<p>???????????????</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r15c1-t7" headers="r1c1-t7">
<p>05 V</p>
<p>49 V-LN PIC S9(4)</p>
<p>COMP</p>
<p>05 V-DATA PIC G(n)</p>
</td>
<td align="left" headers="r15c1-t7 r1c2-t7">
<p>VARGRAPHIC(max length)????MALLINT????????????????????????????????????????</p>
</td>
<td align="left" headers="r15c1-t7 r1c3-t7">
<p>???????????????????????????????????????????????????</p>
</td>
</tr>
</tbody>
</table>
<br /></div>
</div>

<div class="footer">
<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td align="left" width="86%"><a href="topicid:help_legalnotices_html"> <span class="copyrightlogo">Copyright&nbsp;(C)&nbsp;2009,&nbsp;Oracle&nbsp;and/or&nbsp;its&nbsp;affiliates.&nbsp;All&nbsp;rights&nbsp;reserved.</span></a>
</td>
</tr>
</table>
</div>
</body>
</html>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de