PI95599: ERROR ISSUED SAVING A QUERY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Error issued saving a query, for example the following.
  
   Error processing SAVE command
   COMMAND ===> SAVE QUERY AS "MY-TEST"
  
  SQL error at or before . <IDENTIFIER> JOIN INNER LEFT RIGHT FULL
  CROSS, HAVING GROUP SAVE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V12.1 users.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users issuing the SAVE, DISPLAY, DRAW,  *
  *                      PRINT, EDIT, IMPORT or RENAME commands  *
  *                      involving quoted object names may       *
  *                      receive errors or no error at all. The  *
  *                      command will not execute when it        *
  *                      should.  For example, SAVE QUERY AS "MY *
  *                      QUERY" or SAVE QUERY AS "MY-QUERY" will *
  *                      receive: 'Error processing SAVE         *
  *                      command. Press the HELP key for more    *
  *                      information.' Some commands will just   *
  *                      not function and just display blanks    *
  *                      above the command line with no error    *
  *                      message seen. Commands involving quoted *
  *                      object names worked in prior QMF        *
  *                      releases.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  For QMF sessions running with the default setting
  DSQEC_DS_SUPPORT='0', QMF module DSQIGSQL has
  been fixed to allow proper processing of commands
  with quoted object names. When running with
  global variable DSQEC_DS_SUPPORT='1', existing
  quoted object names may be used. It is not
  recommended to use quoted object names when
  running with DSQEC_DS_SUPPORT='1'.
  

Problem conclusion

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:

  UI54772

Modules/Macros

•    DSQIGSQL
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RC10 PSY UI54772

     UP18/03/29 P F803

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.