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

How to subract two fileds in the same file


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

Active User


Joined: 31 Jul 2007
Posts: 136
Location: india

PostPosted: Fri Jan 29, 2010 8:43 am
Reply with quote

I want to subract two fileds in the same file

say position 1 to 14 and 15 to 29 , but they are in the format below (with a decimal point )
ex => 0.681331908400 0.681331908403

I tried 1,14,SFF,SUB,15,14,SFF in outrec , but the output is like
spaces for 14 byts and the end 3- .

0.681331908400 0.681331908403 3-

I want it as 0.00000000003-

Can any one 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: Fri Jan 29, 2010 9:34 pm
Reply with quote

Since you didn't tell DFSORT how to edit the result, it used the default of M0. If you want DFSORT to edit the result in a specific way, you have to specify an edit mask. For example:

Code:

  OPTION COPY                                   
  INREC OVERLAY=(30:1,14,SFF,SUB,15,14,SFF,     
    EDIT=(T.TTTTTTTTTTTS),SIGNS=(,,,-))         
Back to top
View user's profile Send private message
cvishu

Active User


Joined: 31 Jul 2007
Posts: 136
Location: india

PostPosted: Mon Feb 01, 2010 2:20 pm
Reply with quote

thank u
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 Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top