IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

ICETOOL help on converting the length of a field


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
venuhunev

New User


Joined: 26 May 2007
Posts: 70
Location: chennai

PostPosted: Fri Mar 04, 2011 12:17 pm
Reply with quote

Hi,

How can i convert the length of a field using ICETOOL EDIT Mask options.

Input record:
Code:
QWE456,789ABCD
GOE456,789EFGH


I used the following statement
Code:

INREC fields=(1:1,3,4:X,5:4,7,ZD,EDIT=(TTT,TTT,TTT),15:X,16:11,4)



Actual output
Code:

QWE 456,789     ABCD
GOE 23,456,789 EFGH




Desired Output:
Code:

QWE 000,456,789 ABCD
GOE 023,456,789 EFGH


Please help. Thanks.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Sat Mar 05, 2011 12:33 am
Reply with quote

You are using DFSORT edit masks, not ICETOOL edit masks.

Your example and explanation make no sense.

For the second record, how do you expect to get from an input value of 456,789 to an output value of 023,456,789? Where does the 023 come from?

Note that 456,789 is a UFF input field, not a ZD input field.

Before anyone can help you, you need to do a much better job of showing an example of what your input actually looks like, giving the starting position, length and format of each field, showing what you want the output to look like, and explaining the rules for getting from input to output.
Back to top
View user's profile Send private message
venuhunev

New User


Joined: 26 May 2007
Posts: 70
Location: chennai

PostPosted: Sun Mar 06, 2011 8:33 am
Reply with quote

Thanks.
It worked. I changed ZD to UFF.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Issues Converting From ZD to Signed N... DFSORT/ICETOOL 4
No new posts Store the data for fixed length COBOL Programming 1
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts PARSE Syntax for not fix length word ... JCL & VSAM 7
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
Search our Forums:

Back to Top