A fix is available
APAR status
Closed as program error.
Error description
Executing the following query that includes WITH UR gets a syntax error: SELECT * FROM SYSIBM.SYSDUMMY1 WITH UR SQL error at or before (line 2, position 3). Explanation: This error occurs when QMF encounters invalid SQL syntax in a query. (line 2, position 3) is the approximate location of the problem. Review the syntax of the statements in this area of the query. For information about valid SQL syntax, see the SQL reference information in the following information center: For a workaround remove the 'WITH UR' from the query itself and then set the QMF global variable DSQEC_ISOLATION = 0. QMF will append the 'WITH UR' under the covers (so it will achieve the same thing as typing 'WITH UR' in the actual query).
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All QMF for TSO/CICS V10.1 users running * * queries with the 'WITH UR' clause. * **************************************************************** * PROBLEM DESCRIPTION: Users running queries containing the * * 'WITH UR' clause as part of the query * * will receive error message MSGDSQ17104 * * (DSQ17104)'SQL error at or before' * * indicating invalid SQL syntax in the * * query. * **************************************************************** * RECOMMENDATION: * **************************************************************** A user ran the following query:SELECT * FROM SYSIBM.SYSDUMMY1 WITH UR and received the DSQ17104 'SQL error at or before (line 2, position 1).' The query is perfectly valid and should have run successfully through QMF. If the user removed the 'WITH UR' clause, the query ran fine.
Problem conclusion
QMF module DSQIQECP has been corrected to properly calculate the location of ending SQL clauses to prevent this error.
Temporary fix
Comments
APAR Information
APAR number
PM17160
Reported component name
QMF-QUERY MGMT
Reported component ID
566872101
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-06-23
Closed date
2010-07-01
Last modified date
2010-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK58500
Modules/Macros
DSQIQECP
Fix information
Fixed component name
QMF-QUERY MGMT
Fixed component ID
566872101
Applicable component levels
RA10 PSY UK58500
UP10/07/02 P F007
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCWRCK","label":"QMF for TSO\/CICS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
02 August 2010