Easytrieve sum file

Hi , How do we eliminate duplicates using easytreive sort. I have a file with records that has mutiple duplicate records. I want to to sort them and elminate teh duplucates. I want this sorting and eliminating to be done in file not in report. Back to top. Hello, If you are determined to eliminate duplicates "in the sort", suggest you use an external sort rather than Easytrieve. If the process work better all within Easytrieve, compare the current record with the previous and skip the duplicates.

Dick, this is an Ezytrieve CLass homework assignment or there is some data manipulation that the TS did not feel necessary to divulge. In above statement, just mentioning JOB is mandatory. And if we have any input files to be used for processing, then we must mention those files here. Once all the conditions are executed on a record that has been read, then we need to print it in the report.

If we skip the report name, then the first report in the program will be executed. A linesize of 80 restricts report output to 80 characters per printed line. For descending order, you just put a D after the field name separated by a space. It automatically totals all quantitative fields fields with decimal positions at the time of the control break and grand totals at the end of the report.

The SUM statement specifies the quantitative fields you want totaled on a control break. When used, any fields not specified on the SUM statement are not totaled. You can omit the title number when you have only one title; it simply defaults to The system date and the page number automatically print on the same line. The LINE statement defines the contents of a printed line detail line in your report.

The LINE statement is the only report definition statement you are required to include in your report declaration. It could be a file definition that you want to use in more than one program without typing it more than once, or it could be a piece of program logic or a report declaration that you use often in different programs.

The main goal of a macro is to save you from duplicating your effort. From there, many programs could access them. To do this, you store the code you want saved in the designated macro storage area at your site. Re: Control totals using control sequence sum by dick scherrer » Tue Jun 17, pm Hello, The attached output is the "normal" way to group totals. What you show as the desired output is not at all typical. You want "summaries", but you want them in a sort of nested sequence.

I'm not aware of this being a capability of Easytrieve. What you could do is read the output from the summary job and create a new set of totals based on your requirement.