PQ33400: MSGDSNT408I SQLCODE -104 ILLEGAL SYMBOL"<END OF STATEMENT>" WHEN DEFINING A NEW REPORT WITH SQL STATEMENTS. QMF NOT USED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Generating a new report with SQL, gets msgDSNT408I SQLCODE -104
  "illegal symbol <end of statement>" when trying to save the new
  defined report. The report is nevertheless saved, nad can be exe
  cuted later.
  

Local fix

• as the report is saved, it can be executed later, but w/o
  editing the SQL statements (if edit is done, same error when
  saving the definitions).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Performance Reporter users creating a    *
  *                 New Report definition without QMF.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: DSNT408I SQLCODE= -104, ERROR:          *
  *                      ILLEGAL SYMBOL "<END-OF-STATEMENT>".    *
  *                      SOME SYMBOL MIGHT BE LEGAL ARE: ).      *
  ****************************************************************
  * RECOMMENDATION: APPLY THE PTF FIXING THIS APAR               *
  ****************************************************************
  The Performance Reporter Parser, when QMF is not used, doesn't
  hanlde correctly some Reports Queries like the following:
  Ex:
  SELECT HEURE
   ,FLOAT(SUM(MSGQ_TRANSIT_SEC)/SUM(MSGQ_TRANSACTIONS))
     FROM (SELECT DIGITS(HOUR(TIME)) AS HEURE,
            MSGQ_TRANSIT_SEC, MSGQ_TRANSACTIONS
       FROM DRL.IMS_SYSTEM_Q
          WHERE TRANSACTION_CLASS LIKE '_6%') AS TEMP
     GROUP BY
           HEURE;
  more in general the clause WHERE in a SUBSELECT followed by a
  parenthesis and GROUP BY is not handled correctly causing the
  following error:
  MSGDSNT408I SQLCODE -104 ILLEGAL SYMBOL"<END OF STATEMENT>".
  

Problem conclusion

• The problem has been addressed in module DRLEREPQ.
  201Y
  301Y
  401Y
  DRLEREPQ
  

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:

Modules/Macros

• DRLEREPQ
  

Fix information

• Fixed component name

  EPDM VERSION 1

• Fixed component ID

  569510100

Applicable component levels

• R201 PSY UQ40615

     UP00/04/11 P F004

• R301 PSY UQ40616

     UP00/04/11 P F004

• R401 PSY UQ40617

     UP00/04/11 P F004

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.