Ansicht
Dokumentation

QRY1157 - Omit bad or useless data to make query run faster. ( OS/400 )

CL_GUI_FRONTEND_SERVICES - Frontend Services   Addresses (Business Address Services)  
This documentation is copyright by IBM.


Message : QRY1157
Omit bad or useless data to make query run faster.

Message Long Text :

Cause . . . . . : The buffer used to get data records for report formatting was returned unfilled (in order to process an individual record) &9 times. Individual record processing is required for null values and data with mapping errors, and also occurs when so much data has been selected that only one record fits in the buffer. If &9 is a large number, removing the need to return the buffer unfilled could make the query run faster.
&10 replacement character strings were used instead of data to help you determine the records requiring error handling.
Recovery . . . :
Move about in a displayed report to see null value indicators (single dashes), and replacement strings. Read the diagnostic information in the job log (character substitution warnings, mapping error details, messages identifying columns with replacement strings,...).
Remove the need for individual record handling, then run the query again. For example:
-- Use record selections to omit records with null values.
-- Fix decimal data errors in input files or remove the records.
-- Specify field selections that exclude columns with bad data.
-- Use a processing option to ignore decimal data errors.
-- Use a processing option to ignore character substitution warnings.
-- Change a job attribute (such as CCSID or date format) that is causing data mapping errors.
-- Change a result expression to avoid a divide by 0 problem.
-- Specify field selections that exclude columns with data that does not need to be in your report.

Message File : QQRYMSG
Library Message File : QSYS2924


SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.

Length: 3254 Date: 20240419 Time: 142138     sap01-206 ( 2 ms )