Ansicht
Dokumentation

QRY5052 - Query run failed. &28 records added to member &16. ( OS/400 )

ROGBILLS - Synchronize billing plans   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.


Message : QRY5052
Query run failed. &28 records added to member &16.

Message Long Text :

Cause . . . . . : At least one field used to select/omit the next record contains incorrect data, data which could not be converted, or an unexpected null value; or subselect processing for an SQL view returned other than a single record. The data added to the file could be incomplete.
Recovery . . . : To determine which fields are in error, remove field selections (if any), and run the query (or SQL SELECT statement) with output to display. Query for i5/OS fills a numeric field with plus (+) signs if the field contains incorrect decimal or floating-point data, or if the field is affected by a divide by zero error. Query for i5/OS fills a non-numeric field with plus (+) signs if the field has a conversion error running to the display or if the field contains data that is not correct. However, the conversions needed to run to the display may differ from those needed to put records in the member.
In Query for i5/OS, go to the Select Output Type and Output Form display, then type a 1 in the Output type prompt or press F5 on any display to see the report.
In interactive SQL, use PF13 to enter the Interactive SQL Session Services panel. Choose the Change Session Attributes option, then take the SELECT Output Device option to make the change.
Or, to display the output using the RUNQRY command, you can specify *DISPLAY on the OUTTYPE parameter.
After you have determined which fields are in error in which records, make any changes necessary to avoid the bad data or failing conversions and run the query again.

Message File : QQRYMSG
Library Message File : QSYS2924


Fill RESBD Structure from EBP Component Structure   PERFORM Short Reference  
This documentation is copyright by IBM.

Length: 3240 Date: 20240427 Time: 063115     sap01-206 ( 3 ms )