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

Change the format of a field


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

New User


Joined: 10 Aug 2006
Posts: 23

PostPosted: Fri Feb 23, 2007 11:42 am
Reply with quote

Hi,

I need to do a change in a particular field of my FB dataset of LRECL say 10.

The file has data for only one field (amount) of LRECL 10.

That field is in Numeric edited format (eg: PIC 99.99).
the outcome should be of Implicit decimal format (eg: PIC 99V99). The output file should have same LRECL.

Sample input records:
0000206.00
0000105.00

Can you please help me out with a DFSORT or ICETOOL?
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India

PostPosted: Fri Feb 23, 2007 11:52 am
Reply with quote

Hi there,

I think u can use this but i have not tested it since my shop does not have DFSORT
Code:
//SYSIN DD *
  OPTION COPY
  INREC OVERLAY=(1:5,10,SFF,TO=ZD,LENGTH=10)
/*
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: Fri Feb 23, 2007 9:21 pm
Reply with quote

Ekta,

Actually, that should be:

Code:

  INREC BUILD=(1,10,UFF,TO=ZD,LENGTH=10)


pattabiraman.baskaran,

Your post is rather confusing. You say the input field is PIC 99.99 (5 bytes) and the output field is PIC 99V99 (4 bytes), but then you show the input records with 10-byte numeric fields as PIC 9999999.99. So it's difficult to tell what you really want.
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 Populate last day of the Month in MMD... SYNCSORT 2
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts InfoSphere OPTIM CSV ouput vs DSNTIUA... IBM Tools 3
Search our Forums:

Back to Top