Suppress Control Break Totals

Ask/Clarify the questions on EASYTRIEVE

Moderators: DikDude, Moderator Group

Post Reply
ScotchRocks
Member
Posts: 2
Joined: Tue Feb 16, 2010 7:55 pm

Suppress Control Break Totals

Post by ScotchRocks » Tue Feb 16, 2010 7:59 pm

Can numeric field totalling be suppressed at control break time? I am breaking on an alphanumeric field in my detail line and the numeric fields in the detail line are being summed. They are packed decimal date fields on the file I'm reading and I do not need date fields summed.

If anyone knows the magic EZTrieve command to suppress field totalling at control break time, please let me know. Thanks.

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Wed Feb 17, 2010 12:48 pm

Let us know how you declared the numeric field in your easytrieve program?

Based on your declaration , we can control this.
Natarajan
Chennai

ScotchRocks
Member
Posts: 2
Joined: Tue Feb 16, 2010 7:55 pm

Post by ScotchRocks » Wed Feb 17, 2010 11:40 pm

On my detail line, there is an account number (ACCT-NUM) that I am breaking on along with four date fields that are defined in the file as PIC 9(9) COMP-3. I have CONTROL ACCT-NUM in my report definition.

When I encounter a new account number, I am breaking and listing the TALLY of the number of segments I have read for that account number. It is putting a sum field for each of the four date fields on the TALLY line.

Those date fields are the the sum fields that I want suppressed. I have SUMCTL NONE in my REPORT line but that does not do the trick.

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

EASYTRIEVE TALLY SUM

Post by Natarajan » Thu Feb 18, 2010 11:24 am

Make sure that non control fields ( ex. date fields in your case) are not defined with decimal part...


incorrect format is...

Code: Select all

WS-DATE1   5 P 0
Correct format is

Code: Select all

WS-DATE1    5 P 
Natarajan
Chennai

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others