Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Subtract the ZD fields to provide neg... Balaryan DFSORT/ICETOOL 4 Wed Oct 11, 2017 10:51 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts Select numeric portion from CHAR data... balaji81_k DB2 6 Sat Aug 19, 2017 1:51 am
No new posts Adding a userid to SMTP Security table Yolanda Harvey JCL & VSAM 1 Sun Aug 13, 2017 6:16 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us