friedkiwi/ibm-information-center
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
master
ibm-information-center/dist/eclipse/plugins/i5OS.ic.rzakc_5.4.0.1/rzakcmstdfedtcd.htm

576 lines
40 KiB
HTML
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?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="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="EDTCDE (Edit Code) keyword for display files" />
<meta name="abstract" content="Use this field-level keyword to edit output-capable numeric fields." />
<meta name="description" content="Use this field-level keyword to edit output-capable numeric fields." />
<meta name="DC.subject" content="EDTCDE (Edit Code) keyword, Edit Code (EDTCDE) keyword" />
<meta name="keywords" content="EDTCDE (Edit Code) keyword, Edit Code (EDTCDE) keyword" />
<meta name="DC.Relation" scheme="URI" content="rzakcmstkeyent.htm" />
<meta name="DC.Relation" scheme="URI" content="dfnoy.htm" />
<meta name="DC.Relation" scheme="URI" content="../rzahg/rzahgicbasic2.htm" />
<meta name="copyright" content="(C) Copyright IBM Corporation 2001, 2006" />
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 2001, 2006" />
<meta name="DC.Format" content="XHTML" />
<meta name="DC.Identifier" content="rzakcmstdfedtcd" />
<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>EDTCDE (Edit Code) keyword for display files</title>
</head>
<body id="rzakcmstdfedtcd"><a name="rzakcmstdfedtcd"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">EDTCDE (Edit Code) keyword for display files</h1>
<div><p>Use this field-level keyword to edit output-capable numeric fields.</p>
<div class="section"><p>The format of the keyword is:</p>
<pre>EDTCDE(edit-code [* |floating-currency-symbol])</pre>
<div class="p">Editing
includes the following changes to the appearance of displayed fields, depending
on which edit code is specified: <ul><li>Leading zeros are suppressed.</li>
<li>The field can be punctuated with commas and periods to show decimal position
and to group digits by threes.</li>
<li>Negative values can be displayed with a minus sign or CR to the right.</li>
<li>Zero values can be displayed as zero or blanks.</li>
<li>Asterisks can be displayed to the left of significant digits to provide
asterisk protection.</li>
<li>A currency symbol (corresponding to the system value QCURSYM) can be displayed
immediately to the left of the significant digit that is farthest to the left
(called <em>floating-currency symbol</em>). For fixed-currency symbols, use
the EDTWRD keyword.</li>
<li>The field can be further edited using a <a href="#rzakcmstdfedtcd__udec1">user-defined
edit code</a>.</li>
</ul>
</div>
<p>EDTCDE covers most editing requirements. Use EDTWRD when the EDTCDE
keyword is not sufficient.</p>
<p>You cannot specify both EDTCDE and EDTWRD
for the same field. If a field previously defined in a database file has EDTCDE
specified, you need not specify EDTCDE for that field in the display file.
You can specify R in position 29 to refer to the previously defined field.
The editing specified for the referenced field is included in the display
file. However, if you also specify length, data type, or decimal positions
for a display file field, editing specified for the referenced field is not
included in the display file, and you must specify editing again in the display
file.</p>
<p>The DFT and DFTVAL keywords cannot be specified with the EDTCDE
keyword.</p>
<p>Option indicators are not valid for this keyword.</p>
<p>The
rules for specifying edit codes and edit words are the same in all types of
files. You can specify two kinds of edit codes: <span class="keyword">i5/OS™</span> edit
codes and user-defined edit codes.</p>
<p>The EDTCDE keyword is valid only
for fields with Y or blank in position 35 (Data Type/Keyboard Shift). The
use of this keyword changes the default used for position 35 to a Y.</p>
</div>
<div class="section"><h4 class="sectiontitle"><span class="keyword">i5/OS</span> edit
codes</h4><p>The <span class="keyword">i5/OS</span> edit
codes are:</p>
<p>1 through 4<br />
A through D<br />
J through Q<br />
W through Z</p>
<div class="note"><span class="notetitle">Note:</span> The <span class="keyword">iSeries™</span> server
hardware operates with a preferred sign of F, which is equivalent to using
edit code X. Edit code X causes a blank keyboard shift (position 35) to default
to numeric-only (attribute Y). The display length of the field is determined
by the keyboard shift and not by edit code X (the default numeric only Y attribute
might add 1 position to the field for decimals). If the DATE or TIME keyword
is specified with edit code X, the separator character is not displayed.</div>
</div>
<div class="section"><h4 class="sectiontitle">Optionally specifying asterisk fill or floating currency symbol</h4><p>You
can optionally specify asterisk fill or floating currency symbol with edit
codes 1 through 4, A through D, and J through Q.</p>
<p>When you specify
asterisk fill, an asterisk (*) is printed for each zero that is suppressed.
A complete field of asterisks is printed for a zero balance field.</p>
<p>When
you specify floating currency symbol, the symbol appears to the left of the
first significant digit. The symbol does not print on a zero balance when
an edit code is used that suppresses the zero balance. (The symbol that you
specify must match the system value for the currency symbol (QCURSYM). The
symbol must match when the file is created. It need not match
when the file is used.)</p>
<div class="note"><span class="notetitle">Note:</span> If an edit code is changed after a file is
created, the editing specified at the time the file was created is used. The
new edit code is not used unless the file is recreated.</div>
<div class="p">The
following table summarizes the functions provided by <span class="keyword">i5/OS</span> edit
codes.
<div class="tablenoborder"><a name="rzakcmstdfedtcd__tbledit"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rzakcmstdfedtcd__tbledit" width="100%" frame="border" border="1" rules="all"><caption>Table 1. Summary chart
for <span class="keyword">i5/OS</span> edit codes</caption><thead align="left"><tr><th align="left" valign="bottom" width="12.626262626262626%" id="d0e126">Edit codes</th>
<th align="left" valign="bottom" width="12.373737373737374%" id="d0e128">Commas<sup>1</sup> displayed</th>
<th align="left" valign="bottom" width="12.626262626262626%" id="d0e133">Decimal points<sup>1</sup> displayed</th>
<th align="left" valign="bottom" width="12.373737373737374%" id="d0e138">Sign displayed when negative value</th>
<th align="left" valign="bottom" width="12.626262626262626%" id="d0e140">Blank value of QDECFMT system value</th>
<th align="left" valign="bottom" width="12.373737373737374%" id="d0e142">I value of QDECFMT system value</th>
<th align="left" valign="bottom" width="12.626262626262626%" id="d0e144">J value of QDECFMT system value</th>
<th align="left" valign="bottom" width="12.373737373737374%" id="d0e146">Leading Zero suppressed</th>
</tr>
</thead>
<tbody><tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">1</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">Yes</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">No sign</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">.00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">,00 or 0</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">0,00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">2</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">Yes</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">No sign</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">Blanks</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">3</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">No sign</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">.00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">,00 or 0</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">0,00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">4</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">No sign</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">Blanks</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">A</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">Yes</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">CR</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">.00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">,00 or 0</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">0,00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">B</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">Yes</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">CR</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">Blanks</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">C</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">CR</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">.00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">,00 or 0</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">0,00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">D</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">CR</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">Blanks</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">J</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">Yes</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">-(Minus)</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">.00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">,00 or 0</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">0,00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">K</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">Yes</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">-(Minus)</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">Blanks</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">L</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">-(Minus)</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">.00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">,00 or 0</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">0,00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">M</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">-(Minus)</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">Blanks</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">N</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">Yes</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">-(Minus)</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">.00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">,00 or 0</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">0,00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">O</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">Yes</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">-(Minus)</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">Blanks</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">P</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">-(Minus)</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">.00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">,00 or 0</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">0,00 or 0</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">Q</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">Yes</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">-(Minus)</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">Blanks</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">Blanks</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">W<sup>2</sup></td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">&nbsp;</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">&nbsp;</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">&nbsp;</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">Y<sup>3</sup></td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">&nbsp;</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">&nbsp;</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">&nbsp;</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td align="left" valign="top" width="12.626262626262626%" headers="d0e126 ">Z<sup>4</sup></td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e128 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e133 ">&nbsp;</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e138 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e140 ">&nbsp;</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e142 ">&nbsp;</td>
<td align="left" valign="top" width="12.626262626262626%" headers="d0e144 ">&nbsp;</td>
<td align="left" valign="top" width="12.373737373737374%" headers="d0e146 ">Yes</td>
</tr>
<tr><td colspan="8" align="left" valign="top" headers="d0e126 d0e128 d0e133 d0e138 d0e140 d0e142 d0e144 d0e146 "><div class="note"><span class="notetitle">Notes:</span> <ol><li>The QDECFMT system value determines the decimal point character (period
in U.S. usage), the character used to separate groups of three digits (comma
in U.S. usage), and the type of zero suppression (depending on comma and period
placement).</li>
<li>The W edit code suppresses the farthest left zero of a date field that
is five digits long. It also suppresses the three farthest left zeros of a
field that is six to eight digits long. The W edit code also inserts slashes
(/) between the month, day, and year according to the following pattern: <ul><li>nn/nnn</li>
<li>nnnn/nn</li>
<li>nnnn/nnn</li>
<li>nnnn/nn/nn</li>
</ul>
</li>
<li>The Y edit code suppresses the farthest left zero of a date field that
is three to six digits long or eight digits long. It also suppresses the two
farthest left zeros of a field that is seven positions long. The Y edit code
also inserts slashes (/) between the month, day, and year according to the
following pattern: <ul><li>nn/n</li>
<li>nn/nn</li>
<li>nn/nn/n</li>
<li>nn/nn/nn</li>
<li>nnn/nn/nn</li>
<li>nn/nn/nnnn</li>
</ul>
<p>If the DATE keyword is specified with EDTCDE(Y), the separator character
used is the job attribute, DATSEP at run time. The slash (/) is the default
DATSEP.</p>
</li>
<li>The Z edit code removes the sign (plus and minus) from a numeric field.
The sign of the units position is changed to a hexadecimal F before the field
is written.</li>
</ol>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<div class="section" id="rzakcmstdfedtcd__udec1"><a name="rzakcmstdfedtcd__udec1"><!-- --></a><h4 class="sectiontitle">User-defined edit codes</h4><p>Edit
codes 5 through 9 are user-defined edit codes. A user-defined edit code can
do more editing than an <span class="keyword">i5/OS</span> edit
code. For example, you might need to edit numbers that include hyphens (such
as telephone numbers) or more than one decimal point. You can use user-defined
edit codes for these functions. These edit codes are named QEDIT5, QEDIT6,
QEDIT7, QEDIT8, and QEDIT9, and can be referred to in DDS or a high-level
language program by number (5, 6, 7, 8, or 9).</p>
<p>A
user-defined edit code is an <span class="keyword">i5/OS</span> object
and must exist before display file creation. It is created using the Create
Edit Description (CRTEDTD) command. When you create a display file in which
a user-defined edit code is specified, editing information is extracted from
the previously created edit description. Changing a user-defined edit code
after display file creation does not affect the display file unless the display
file is re-created.</p>
<div class="p">The following table shows
edit codes, unedited source data, and edited output. Zero suppression and
decimal characters are determined by the system value QDECFMT. The date separator
character is determined by the job attribute DATSEP. In this figure, QDECFMT
is assumed to equal x (blank), and DATSEP is assumed to equal / (slash).
<div class="tablenoborder"><a name="rzakcmstdfedtcd__dfvec"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rzakcmstdfedtcd__dfvec" width="100%" frame="border" border="1" rules="all"><caption>Table 2. Valid edit codes, source
data, and edited output</caption><thead align="left"><tr><th align="left" valign="bottom" width="14.393939393939394%" id="d0e531">Edit codes</th>
<th align="left" valign="bottom" width="14.393939393939394%" id="d0e533">Positive number with two decimal positions</th>
<th align="left" valign="bottom" width="14.14141414141414%" id="d0e535">Positive number with no decimal positions</th>
<th align="left" valign="bottom" width="14.393939393939394%" id="d0e537">Negative number with three decimal positions<sup>1</sup></th>
<th align="left" valign="bottom" width="14.14141414141414%" id="d0e541">Negative number with no decimal positions<sup>1</sup></th>
<th align="left" valign="bottom" width="14.393939393939394%" id="d0e545">Zero balance with two decimal positions<sup>1</sup></th>
<th align="left" valign="bottom" width="14.14141414141414%" id="d0e549">Zero balance with no decimal positions<sup>1</sup></th>
</tr>
</thead>
<tbody><tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">Unedited</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">1234567</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1234567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">xxxx.125–</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125–</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">xxxxxx</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">xxxxxx</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">1</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12,345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1,234,567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">.125</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">.00</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">2</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12,345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1,234,567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">.125</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">&nbsp;</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">3</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1234567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">.125</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">.00</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">4</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1234567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">.125</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">&nbsp;</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">A</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12,345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1,234,567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">.125CR</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125CR</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">.00</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">B</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12,345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1,234,567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">.125CR</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125CR</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">&nbsp;</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">C</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1234567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">.125CR</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125CR</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">.00</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">D</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1234567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">.125CR</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125CR</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">&nbsp;</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">J</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12,345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1,234,567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">.125-</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125-</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">.00</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">K</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12,345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1,234,567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">.125-</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125-</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">&nbsp;</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">L</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1234567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">.125-</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125-</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">.00</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">M</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1234567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">.125-</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125-</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">&nbsp;</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">N</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12,345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1,234,567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">-.125</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">-125</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">.00</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">O</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12,345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1,234,567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">-.125</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">-125</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">&nbsp;</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">P</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1234567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">-.125</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">-125</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">.00</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">0</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">Q</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">12345.67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1234567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">-.125</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">-125</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">W<sup>2</sup></td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">1234/567</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1234/567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">0/125</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">0/125</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">0/000</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">0/000</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">Y<sup>3</sup></td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">123/45/67</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">123/45/67</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">0/01/25</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">0/01/25</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">0/00/00</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">0/00/00</td>
</tr>
<tr><td align="left" valign="top" width="14.393939393939394%" headers="d0e531 ">Z<sup>4</sup></td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e533 ">1234567</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e535 ">1234567</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e537 ">125</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e541 ">125</td>
<td align="left" valign="top" width="14.393939393939394%" headers="d0e545 ">&nbsp;</td>
<td align="left" valign="top" width="14.14141414141414%" headers="d0e549 ">&nbsp;</td>
</tr>
<tr><td colspan="7" align="left" valign="top" headers="d0e531 d0e533 d0e535 d0e537 d0e541 d0e545 d0e549 "><div class="note"><span class="notetitle">Notes:</span> <ol><li>The x represents a blank.</li>
<li>The W edit code suppresses the farthest left zero of a date field that
is five digits long. It also suppresses the three farthest left zeros of a
field that is six to eight digits long. For more information, see the second
footnote in <a href="#rzakcmstdfedtcd__tbledit">Table 1</a>.</li>
<li>The Y edit code suppresses the farthest left zero of a date field that
is three to six digits long or eight digits long. It also suppresses the two
farthest left zeros of a field that is seven positions long. For more information,
see the third footnote in <a href="#rzakcmstdfedtcd__tbledit">Table 1</a>.</li>
<li>The Z edit code removes the sign (plus or minus) and suppresses leading
zeros.</li>
</ol>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<div class="example"><h4 class="sectiontitle">Example</h4><p>The following example shows how to specify
the EDTCDE keyword.</p>
<pre>|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
00010A PRICE 5 2 1 10EDTCDE(J)
00020A SALES 7 2 2 10EDTCDE(K $)
00030A SALARY 8 2 3 10EDTCDE(1 *)
A</pre>
<div class="p">The display length for PRICE is 7 because the J edit
code is specified, causing the field to contain a decimal point and an ending
minus sign. It is edited as: <pre>ddd.dd-</pre>
where d represents
a digit.</div>
<div class="p">The display length for SALES is 11 because the K edit code
and floating currency symbol are specified. It is edited as: <pre>$dd,ddd.dd-</pre>
</div>
<div class="p">The
display length for SALARY is 10 because the edit code 1 is specified with
asterisk fill. It is edited as: <pre>ddd,ddd.dd</pre>
</div>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzakcmstkeyent.htm" title="You type the keyword entries that define display files in positions 45 through 80 (functions).">DDS keyword entries for display files (positions 45 through 80)</a></div>
</div>
<div class="relconcepts"><strong>Related concepts</strong><br />
<div><a href="dfnoy.htm" title="You can only type the numbers 0 through 9, plus (+), minus (-), period (.), comma (,), and space ( ) into the field. You can press any key to leave the field.">Numeric only (Y)</a></div>
</div>
<div class="relinfo"><strong>Related information</strong><br />
<div><a href="../rzahg/rzahgicbasic2.htm">i5/OS system values</a></div>
</div>
</div>
</body>
</html>
Reference in New Issue View Git Blame Copy Permalink