PH07751: ERROR DUE TO COGNOS SQL WITH WHERE CLAUSE

APAR status

• Closed as fixed if next.

Error description

• Defining a database object in Cognos SQL with where clause, but
  without alias definition for the table object, will result in
  error XQE-DAT-0001 Data source adapter error:
  com.ibm.db2.jcc.am.SqlSyntaxErrorException: "table.column" is
  not valid in the context where it is used.. SQLCODE=-206,
  SQLSTATE=42703, DRIVER=4.19.66 against DB2.
  
  Example:
  Select   * from  [great_outdoors_sales].ORDER_METHOD
  where ORDER_METHOD_CODE in (1,2,3,4,5,6)
  

Local fix

• Include alias in the Cognos SQL
  Select   * from  [great_outdoors_sales].ORDER_METHOD a
  where a.ORDER_METHOD_CODE in (1,2,3,4,5,6)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.1.4                       *
  ****************************************************************
  

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