Puspojit
New User
Joined: 10 Mar 2008 Posts: 34 Location: Pune
|
|
|
|
Hi All,
Can we add fields defined as ZZ,ZZZ,ZZ9 using DF sort ?
The said datatype doesnot fall under ZD or PD. Is there any other
Option to do this through DFSORT ?
Thanks ! |
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
Puspojit,
You can use DFSORT's SFF (signed free form numeric) and UFF (unsigned free form numeric) data formats to extract numeric values from free form fields consisting of decimal digits and any other characters (e.g., decimal point, separators, letters, blanks, parens, etc). This allows you to directly process values containing decimal digits and other characters (e.g., '123,456.78-') in the same way you would process ZD values.
You can use the SFF and UFF formats in the SORT, MERGE, INCLUDE, OMIT, INREC, OUTREC and OUTFIL statements, and in the ON and BREAK parameters for all ICETOOL operators
Read about them here
www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000088 |
|