111 lines
6.3 KiB
HTML
111 lines
6.3 KiB
HTML
|
<?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 http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 2005" />
|
||
|
|
<meta name="DC.rights.owner" content="(C) Copyright IBM Corporation 2005" />
|
||
|
|
<meta name="security" content="public" />
|
||
|
|
<meta name="Robots" content="index,follow" />
|
||
|
|
<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 name="DC.Type" content="reference" />
|
||
|
|
<meta name="DC.Title" content="Fixed formatted import file" />
|
||
|
|
<meta name="abstract" content="This topic gives an example of a Field Definition File that describes the fixed formatted file." />
|
||
|
|
<meta name="description" content="This topic gives an example of a Field Definition File that describes the fixed formatted file." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal3usingcpyfrm.htm" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="rbal3fixfor" />
|
||
|
|
<meta name="DC.Language" content="en-us" />
|
||
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
||
|
|
<!-- US Government Users Restricted Rights -->
|
||
|
|
<!-- Use, duplication or disclosure restricted by -->
|
||
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
||
|
|
<title>Fixed formatted import file</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbal3fixfor"><a name="rbal3fixfor"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Fixed formatted import file</h1>
|
||
|
|
<div><p>This topic gives an example of a Field Definition File that describes
|
||
|
|
the fixed formatted file.</p>
|
||
|
|
<div class="example"> <pre> - *********************************************************/
|
||
|
|
- **** Field Definition File */
|
||
|
|
- *********************************************************/
|
||
|
|
- Description: This Field Definition File
|
||
|
|
- defines the import's file */
|
||
|
|
- (FROMFILE) field start and end positions. */
|
||
|
|
- *********************************************************/
|
||
|
|
- (FROMFILE) field start and end positions. */
|
||
|
|
-FILE MYLIB/MYFILE */
|
||
|
|
field1 1 12 13
|
||
|
|
field2 14 24 0
|
||
|
|
field3 25 55 56
|
||
|
|
field4 78 89 90
|
||
|
|
field5 100 109 0
|
||
|
|
field6 110 119 120
|
||
|
|
field7 121 221 0
|
||
|
|
*END
|
||
|
|
|
||
|
|
|
||
|
|
The following is a brief explanation of the
|
||
|
|
Field Definition File format:
|
||
|
|
|
||
|
|
- = Comment line
|
||
|
|
*END = End of definition, this must be included
|
||
|
|
|
||
|
|
Field Starting Ending Null
|
||
|
|
Name Position Position Character Position
|
||
|
|
_________________________________________________________
|
||
|
|
|
||
|
|
field1 1 12 13
|
||
|
|
field2 14 24 None
|
||
|
|
field3 25 55 56
|
||
|
|
field4 78 89 90
|
||
|
|
field5 100 109 None
|
||
|
|
field6 110 119 120
|
||
|
|
field7 121 221 None
|
||
|
|
|
||
|
|
</pre>
|
||
|
|
</div>
|
||
|
|
<div class="section"> <dl><dt class="dlterm">Field Name</dt>
|
||
|
|
<dd>This name is the name of the to-file field name.</dd>
|
||
|
|
<dt class="dlterm">Starting Position</dt>
|
||
|
|
<dd>This is the starting position for the field in the import file of each
|
||
|
|
record. This is the byte position.</dd>
|
||
|
|
<dt class="dlterm">Ending Position</dt>
|
||
|
|
<dd>This is the ending position for the field in the import file of each record.
|
||
|
|
This is the byte position.</dd>
|
||
|
|
<dt class="dlterm">Null Character Position</dt>
|
||
|
|
<dd>This is the position for the NULL value for the field in the import file
|
||
|
|
of each record. The value zero specifies that NULL does not have a value.
|
||
|
|
The value in the import file can be 'Y' or 'N'. <p>'Y' means the field is
|
||
|
|
NULL. 'N' means the field is not NULL.</p>
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
<p>Each column must be separated by a blank character.</p>
|
||
|
|
<p>Each
|
||
|
|
row must be sequentially ordered.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><img src="./delta.gif" alt="Start of change" />An alternative for creating the Field
|
||
|
|
Definition File is using the *COL keyword instead of the actual column names.
|
||
|
|
*COL indicates the positions of the data in the stream file for all the columns
|
||
|
|
in the target files listed in order. The following example shows how to describe
|
||
|
|
fixed formatted files using the *COL keyword:<pre>*COL 1 12 13
|
||
|
|
*COL 14 24 0
|
||
|
|
*COL 25 55 56
|
||
|
|
*COL 78 89 90
|
||
|
|
*COL 100 109 0
|
||
|
|
*COL 110 119 120
|
||
|
|
*COL 121 221 0
|
||
|
|
*END</pre>
|
||
|
|
<img src="./deltaend.gif" alt="End of change" /></div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal3usingcpyfrm.htm" title="The Copy From Import File (CPYFRMIMPF) command maps or parses the data from ("import") an import file to the to-file.">Use the Copy From Import File (CPYFRMIMPF) command to copy between different servers</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|