PM17160: SYNTAX ERROR WHEN USING WITH UR.

Obtain the fix for this APAR.

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 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.