IBM Support

Message QRY1058

News


Abstract

Details on getting QRY1058 when using query/400.

Content

When a query is saved, the access plan of the query (how the query will be implemented when ran) is stored with the query. This is referred to as the QDT. Part of the QDT is information about the file the query was built over. At run time if the file being used does not match the file stored in the QDT the query will fail with QRY1058. Users would then need to Edit and re-save the query using the new file layout.

At R710 and higher the system will look closer at the differences of the file in the QDT and the file being used. If the differences are minimal and the query can run as expected with the different file, the system will now rebuild the QDT and run the query with no error messages. The system will no longer issue QRY1058 and the end user no longer needs to re-save the query.

For upgrade paths, if a user wants to continue to get the error you can use QQURUNOPTS data area. See the below URL for details. This is only valid when the query object had been created at a release other than what is currently running on.


http://www.ibm.com/support/docview.wss?uid=nas8N1010668

NOTE: This can not always be done. If the system finds the file has too many differences that will affect the query output, error QRY1058 may still be issued at R710 and higher.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"}]

Document Information

Modified date:
18 December 2019

UID

nas8N1021145