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

How to split the records using the amount field


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

New User


Joined: 12 Jan 2010
Posts: 34
Location: New York

PostPosted: Wed Nov 02, 2016 12:40 pm
Reply with quote

I have also tried putting the subtracted value in a separate subsequent position. Its still the same. Subtraction is not working fine here. Please advise what am I am doing wrong.

Code:

249000024900000000000052730M01
249000049800000000000077630M02
249000074700000000000102530M03
249000099600000000000127430M04
249000124500000000000152330M05
249000149400000000000177230M06
249000174300000000000202130M07
249000199200000000000227030M08
249000224100000000000251930M09
249000249000000000000276830M10
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Wed Nov 02, 2016 2:00 pm
Reply with quote

Yes, on a re-count you are correct. I have a presctiption for new glasses, but I threw it away thinking it was an old receipt from the supermarket...

Your "M" simply indicates you have calculated a negative number. Find the value of M in EBCDIC, the "D" there is the sign, and the number-looking thing is the number.
Back to top
View user's profile Send private message
vnktrrd

New User


Joined: 12 Jan 2010
Posts: 34
Location: New York

PostPosted: Wed Nov 02, 2016 6:51 pm
Reply with quote

Hi,

I still don't why I am negative number. I am subtracting smaller number from greater number. But I am still getting negative values.

Could someone help me ?

Thanks,
Ramana.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Wed Nov 02, 2016 7:16 pm
Reply with quote

vnktrrd,

Apart from the negative sign, the number itself does not seem to be what you expected. Maybe the actual value presented to the computation was different from what you have shown.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Nov 02, 2016 7:24 pm
Reply with quote

Quote:
278304-249000 which is 29304


but the info You posted before shows ---

Code:
249000000000000052730M01



a quick and dirty computation shows that
278304 + 249000 ==> 527304
and that
( -278304 ) - 249000 ==> - 527304
which is exactly what You got
( any decent IT practitioner would have noticed that )
Quote:
I am subtracting smaller number from greater number

Your analysis could not be more wrong ...

subtracting a negative number from a negative number gives a MORE negative number

and a negative number was what You had in some preceding computations

again ... the topic is becoming a waste of time for everybody and it should be locked as I did before
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 Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
Search our Forums:

Back to Top