Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 46
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: 7251

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 Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts Display ZEDLMSG without Pressing F1 &... anandgbe CLIST & REXX 8 Thu Dec 15, 2016 4:20 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am
No new posts How to display value of an exit param... lind sh CICS 2 Sun Oct 09, 2016 12:28 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us