Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Adding Fields having datatype ZZ,ZZZ,ZZ9

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Puspojit

New User


Joined: 10 Mar 2008
Posts: 34
Location: Pune

PostPosted: Thu Nov 26, 2009 12:28 am    Post subject: Adding Fields having datatype ZZ,ZZZ,ZZ9
Reply with quote

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 !
Back to top
View user's profile Send private message

Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Thu Nov 26, 2009 12:49 am    Post subject: Reply to: Adding Fields having datatype ZZ,ZZZ,ZZ9
Reply with quote

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

http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000088
Back to top
View user's profile Send private message
Puspojit

New User


Joined: 10 Mar 2008
Posts: 34
Location: Pune

PostPosted: Thu Nov 26, 2009 2:01 am    Post subject: Reply to: Adding Fields having datatype ZZ,ZZZ,ZZ9
Reply with quote

Thanks Kolusu........Your solution worked perfectly.
Puspojit
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm
No new posts Sort two file having same field, one ... himanshu malik DFSORT/ICETOOL 7 Thu Feb 02, 2017 10:09 am
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts Access SQLCA fields inside a stored p... gangapd DB2 6 Thu Oct 27, 2016 10:20 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us