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

How to use DIV arithmetic operation in DFSORT?


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

New User


Joined: 07 Nov 2006
Posts: 13
Location: Thiruvanathapuram

PostPosted: Wed Mar 28, 2007 4:56 pm
Reply with quote

Hi all.........

I tried to divide using DFSORT...............
using the following syntax....
OUTREC FIELDS=(1,4,2C' ',9,3,(9,3,ZD,DIV,+2))

but it dint work properly....

the expected result was 1.5(3div 2). But instead we got 0.01....

How to resolve this?

Please suggest a solution at the eraliest.......
Thanking you
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: Wed Mar 28, 2007 8:41 pm
Reply with quote

Quote:
the expected result was 1.5(3div 2). But instead we got 0.01


Huh? DFSORT's DIV returns an integer value. +3,DIV,+2 would give 1 as the result. I don't know why you say you got 0.01 unless you edited the result of 1 to get that. If you want a result with one decimal place, you need to multiply by +10 and then divide by +2, e.g. (+3,MUL,+10),DIV,+2 would give a result of 15 which you could then edit to 1.5.
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 Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
No new posts DFSORT - VB file RDW getting overridden DFSORT/ICETOOL 3
Search our Forums:

Back to Top