PI85850: QUERYING INFORMIX SYNONYMS BY USING UPPERCASE WILL NOT ERROR OUTVALIDATION WILL FAIL WITH BMT-MD-5002: THE OBJECT DOES NOT EXIST

APAR status

• Closed as fixed if next.

Error description

• Database Query subjects based on synonyms (Informix) errors out
  due to case sensitivity.
  
  Database views work no matter whether the name is given in upper
  case or lower case, but synonyms error out if given in upper
  case.
  
  If query subject passes commands in uppercase then the following
  errors will be displayed:
  
  
  BMT-MD-5002: The object 'synonym name' of type 'table' or 'view'
  does not exist in the data source
  
  If this same object ( synonym ) is queried by using lower case
  then no errors are displayed.
  

Local fix

Problem summary

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

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

• RB06 PSN

     UP