'DQ118E - THE LOGICAL PAGE SIZE OF YOUR REPORT EXCEEDS THE MAXIMUM ALLOWED' and error PRT01F on batch DQL query

Products

• Datacom
• DATACOM - AD

Issue/Introduction

A batch DQL query fails with error:

DQ118E - THE LOGICAL PAGE SIZE OF YOUR REPORT EXCEEDS THE MAXIMUM ALLOWED

DQ358E - THE EXECUTION OF YOUR QUERY TERMINATED DUE TO AN ERROR PRT01F

 

Cause

The logical page size limit it set to 64K, this is the largest piece of temporary storage we can acquire at a time. 

The LOGICAL PAGE SIZE is the length of data you are printing which is the length of ALL the fields specified on the PRINT statement. or heading lengths if they are longer than the field length multiplied by the number of lines on the printer device. 

LOGICAL PAGE SIZE = length of all fields  x number of lines per page

The value of this formula can’t be greater than 64,000 in length.

Line printer lines per page is specified in the Dataquery System Option Table (DQOPTLST) in parameter LINPRTP.

For network printers, lines per page is specified in the NETPRTP parameter.

Resolution

The solution is to either reduce the number of fields you print or reduce the number of lines per page in the DQOPTLST LINPRTP or NETPRTP parameter.

Try lowering the value from the default of 66 to 40 first, if this is not enough then reduce further.