Space announcement

   

The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

GROUPMETHOD parameter

The GROUPMETHOD parameter specifies the sort method used by the report.

The following sort methods are available:

  • The SORT keyword specifies that the report should process the output using the traditional sort.

  • The MEMORY keyword specifies that the report should bypass the traditional sort and build the output in memory buffers.

The MEMORY keyword is more efficient when there are a large number of input records and a small number of output records.

The following figure shows the syntax of the GROUPMETHOD parameter.


Note

The GROUPMETHOD parameter is valid only for the following reports:

  • BACCPKSR - Accounting Package Summary

  • BACCTDR - Accounting Detail

  • BACCTSR - Accounting Summary

The following table displays the values for the GROUPMETHOD parameter.

Keyword

Description

GROUPMETHOD

Specifies the method the report uses to sort the output

Valid abbreviation: GM

SORT (optional)

Runs the sort as it traditionally ran

SORT is the default.

Valid abbreviation: S

MEMORY (optional)

Specifies that output records are to be built in memory buffers and the traditional sort bypassed

The default is 64 megabytes of ATB memory when the size keyword is not specified.

Note

If you are using the MEMORY keyword, comment out the TRACEWRK DD statement in the JCL.

Valid abbreviations: MEM, M

size (optional)

Specifies the amount of ATB (64-bit) memory available to build the memory buffers

Valid values include any number from 0-9999. Using 0 specifies 64 megabytes of ATB memory. Using 1-9999 specifies the amount (in megabytes) of ATB memory.


Examples

The following example runs the BACCTDR report in the same manner as in the past:

REPORT(NAME(BACCTDR) GROUPMETHOD(SORT))

The following example runs the BACCTDR report without sorting the normalized records and builds group records in 64-bit storage, using a maximum of 64 MB of ATB (64-bit) memory:

REPORT(NAME(BACCTDR) GROUPMETHOD(MEM))

The following example runs the BACCTDR report without sorting the normalized records and builds group records in 64-bit storage, using a maximum of 1024 MB of ATB memory:

REPORT(NAME(BACCTDR) GM(M(1024)))



Related topic



This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments