PM70909: Unable to use Reserved words enclosed in quotes in SQL in a query subject for Framework Manager

APAR status

• Closed as fixed if next.

Error description

• Trying to bring in reserved word "LOOP" into a query subject
  through a sql script.  The documentation states to enclose the
  word in quotes in the SQL which is what he has done.    Select?
                 "LOOP"?from?
  [XXXXX].CUST_ERRORS?CUST_ERRORS??This is the error message
  issued:?RQP-DEF-0177 An error occurred while performing
  operation 'SqlPrepareWithOptions' status='-16' and UDA-SQL-0358
  line 4: syntax error near "LOOP"??In the Framework Manager Guide
  10.1.1 on page 12 and also in Appendix G, it states to enclose
  the reserved word in quotes in SQL.??Workaround is to change the
  column name in the table to not be a reserved word.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 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:

Fix information

Applicable component levels

• RA21 PSN

     UP