PK68527: GETTING SQL ERROR IN DRLERDIR: DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "&". SOME SYMBOLS THAT MIGHT BE LEGAL ARE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• after installation of PTFs for PK57882 and creating reports via
  the TDS panels that contain a variable you get error message:
  SQL Error occurred in module 'DRLERDIR'. SQL return code -104 at
  line
  361 :
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "&". SOME
  SYMBOLS THAT
  MIGHT BE LEGAL ARE: ( + - ? : ALL ANY CASE CAST SOME USER
  <FLOAT>
  CURRENT NEXTVAL
  

Local fix

• An interim workaround is to manually INSERT a row into
  DRLREPORT_VARS
  for the variable fields (DATE in this case).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Decision Support customers        *
  *                 that customizer SQL queries.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When creating new a TDS report          *
  *                      customer receives the following error   *
  *                      when executing it:                      *
  *                                                              *
  *                      The existing SQL SELECT statement       *
  *                      could not be verified or cannot be      *
  *                      used because:                           *
  *                      DSNT408I SQLCODE = -104, ERROR:         *
  *                      ILLEGAL SYMBOL  "&". SOME               *
  *                      SYMBOLS THAT MIGHT BE LEGAL ARE:        *
  *                      + - AS <IDENTIFIER>.                    *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY THE PTF FIXING THIS APAR               *
  ****************************************************************
  When a Report Definition is created, TDS saves the report
  variables in the DRLREPORT_VARS system table.
  This information is used when the report is run, to display
  the Data Selection window.
  
  When saving the new report, TDS issues a DB2 DESCRIBE command
  with the query in order to validate the query, and also to
  build up the new form, using the column information
  retrieved by the DESCRIBE command.
  TDS first needs to remove the variables from the query for the
  DESCRIBE to execute successfully.
  
  PK57882 introduced using parameter markers and default values
  based on the DRLREPORT_VARS system table, to replace the
  report variables for the DESCRIBE command. However, this
  introduced a problem where the new report variables are not
  always saved, and thus the new report will not run successfully.
  

Problem conclusion

• When a report query is saved, TDS will now not be using the
  DESCRIBE command to validate the query. Instead, DB2 will
  validate the query when the report is run.
  TDS will still issue the DESCRIBE command, but only to
  retrieve the column information in order to build up the
  new report form.
  
  Variables will be replaced, as far as possible, by the
  column name in question (in order for the DESCRIBE to execute
  successfully), instead of using the DRLREPORT_VARS system table
  or default values.
  
  If the query is very complex, and TDS cannot interpret it
  successfully, an information message will be displayed on the
  Report Form window, advising the user to manually create/update
  the form.
  
  6B1Y
  6B2Y
  601Y
  7B1Y
  7B2Y
  701Y
  71BY
  710Y
  72BY
  8B1Y
  8B2Y
  801Y
  DRLA87
  DRLEREPQ
  DRLHR3R
  

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:

  UK39210 UK39211 UK39212 UK39213 UK39214 UK39215 UK39216 UK39217
  UK39218 UK39219 UK39220 UK39221

Modules/Macros

• DRLA87   DRLEREPQ DRLHR3R
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R6B1 PSY UK39214

     UP08/08/30 P F808

• R6B2 PSY UK39215

     UP08/08/30 P F808

• R601 PSY UK39210

     UP08/08/30 P F808

• R7B1 PSY UK39216

     UP08/08/30 P F808

• R7B2 PSY UK39217

     UP08/08/30 P F808

• R701 PSY UK39211

     UP08/08/30 P F808

• R71B PSY UK39218

     UP08/08/30 P F808

• R710 PSY UK39212

     UP08/08/30 P F808

• R72B PSY UK39219

     UP08/08/30 P F808

• R8B1 PSY UK39220

     UP08/08/30 P F808

• R8B2 PSY UK39221

     UP08/08/30 P F808

• R801 PSY UK39213

     UP08/08/30 P F808

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.