IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

How to identify +ve and -ve amounts


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

New User


Joined: 29 Jun 2006
Posts: 25

PostPosted: Thu Dec 04, 2014 8:25 pm
Reply with quote

Hi All,

I have a requirement to find the sign of each amount and aded to diff files.
one file with +Ve values and other with -ve values.

Could you please guide, how can we achieve this,

Thanks
Venkata.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8793
Location: Welsh Wales

PostPosted: Thu Dec 04, 2014 8:31 pm
Reply with quote

The sign is in column 8 of the relevant fields

That's the best guesstimate that you will get unless you can be bothered to give us some useful information to work with.

icon_evil.gif
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


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

PostPosted: Thu Dec 04, 2014 10:25 pm
Reply with quote

Two OUTFILs, one with INCLUDE= for the -ve amounts. One with SAVE. Decide where zero amounts should go.

Other than that, it is as expat has said.
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

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Identify the count from two diffrent ... DFSORT/ICETOOL 19
No new posts Identify the value if the SUM of the ... SYNCSORT 4
No new posts Identify who, from where, sign on CIC... CICS 1
No new posts REXX identify the last/latest created... CLIST & REXX 7
No new posts Need to identify top 10 costly or tim... DB2 4

Back to Top