Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SUM FIELDS of ZONED DECIMAL as DISPLAY without SIGN

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
mrgnndhmk

New User


Joined: 01 Feb 2006
Posts: 50
Location: India

PostPosted: Mon Aug 11, 2014 9:16 pm    Post subject: SUM FIELDS of ZONED DECIMAL as DISPLAY without SIGN
Reply with quote

Hi All,
I did a quite a bit of search to find if the output of SUM FIELDS of ZONED DECIMAL return a display number instead of a SIGNED number but could not find the exact solution.

Any help is greatly appreciated.

Code:

SORT FIELDS=COPY,WORK=1,FILES=4
OPTION PRINT=ALL,FILNM=(,)
RECORD TYPE=F,LENGTH=10           
SUM FIELDS=(1,10,ZD)
INPFIL BLKSIZE=27990
OUTFIL BLKSIZE=27990


I/P:
0000055641
0000108870
0000055894
0000091030

O/P Expected:
0000311435

O/P Arrived:
000031143E



Using CA-SORT 9.0 and I am not sure if OVERLAY can be used in CA SORT.
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7312

PostPosted: Mon Aug 11, 2014 9:27 pm    Post subject: Reply to: SUM FIELDS of ZONED DECIMAL as DISPLAY without SIG
Reply with quote

You're going to have to hit your manuals, talk to colleagues, local support, CA Support. I don't think many here use CA-SORT currently.

In DFSORT, option ZDPRINT would control this. It is an installation option, which can be overriden by an OPTION statement at run-time.

I'd say your best bet is the discussion of SUM in the manual, or the options which can be set at installation (often a different manual for those).

If you get an answer, please post it, as it may help someone in the future.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Adding FIND to ISPF Panel display of ... Harold Barnes TSO/ISPF 3 Mon Oct 07, 2019 5:46 pm
No new posts Formatting bit fields IanWorthington DFSORT/ICETOOL 9 Thu Sep 19, 2019 6:14 pm
No new posts Convert Numeric to Packed decimal and... anand1204 DFSORT/ICETOOL 5 Thu Aug 08, 2019 3:53 am
No new posts Training on numeric fields data formats sergeyken SYNCSORT 12 Thu Aug 01, 2019 8:15 pm
No new posts Need to get the SUM of two fields usi... Poha Eater DFSORT/ICETOOL 7 Tue Jun 18, 2019 1:27 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us