Limit the size of a Query output file

We found a way to limit the size of a physical file that is generated by query.
It is done by creating a data area in QGPL that looks like this:

 Data area . . . . . . . :   QQUPRFOPTS
   Library . . . . . . . :     QGPL
 Type  . . . . . . . . . :   *CHAR
 Length  . . . . . . . . :   80
 Text  . . . . . . . . . :   Query/400 User Profile Options

            Value
 Offset      *...+....1....+....2....+....3....+....4....+....5
     0      '                                   QUERY400       '
    50      '     200000                   '


The above data area tells query to limit the output file to 200000 records and to send all batch
queries to Jobq QUERY400.   We have been using this for about 6mos and it seems to work well.

Vance Stanley
Devon
Houston,Texas

[report a broken link by clicking here]