PM88738: EXTRA TABLES ASSOCIATED WITH A DOUBLE JOINED ALIAS QUERY SUBJECT

APAR status

• Closed as program error.

Error description

• If two query subjects are joined by two keys the resulting SQL
  is correct.  However, if the aliases to those same query
  subjects have extra SQL attached to it.??Regular Query
  Subjects:?select ?       Order_Header4.ORDER_NUMBER  as
  ORDER_NUMBER,?       Order_Details5.QUANTITY  as  QUANTITY? from
  ?       great_outdoors_sales.GOSALES102.gosales.ORDER_HEADER
  Order_Header4,?
  great_outdoors_sales.GOSALES102.gosales.ORDER_DETAILS
  Order_Details5? where ?       ((Order_Details5.ORDER_NUMBER =
  Order_Header4.ORDER_NUMBER) and (Order_Details5.SHIP_DATE =
  Order_Header4.ORDER_CLOSE_DATE))??Alias Query Subjects:?select ?
        Shortcut_to_Order_Header.ORDER_NUMBER  as  ORDER_NUMBER,?
       Shortcut_to_Order_Details.QUANTITY  as  QUANTITY? from ?
     great_outdoors_sales.GOSALES102.gosales.ORDER_HEADER
  Shortcut_to_Order_Header,?
  great_outdoors_sales.GOSALES102.gosales.ORDER_DETAILS
  Shortcut_to_Order_Details,?
  great_outdoors_sales.GOSALES102.gosales.ORDER_HEADER
  Order_Header8,?
  great_outdoors_sales.GOSALES102.gosales.ORDER_DETAILS
  Order_Details9? where ?
  ((Shortcut_to_Order_Details.ORDER_NUMBER =
  Order_Header8.ORDER_NUMBER) and (Order_Details9.SHIP_DATE =
  Shortcut_to_Order_Header.ORDER_CLOSE_DATE))
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
  * 1                                                            *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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

• Fixed component name

  COG FRAMEWRK MG

• Fixed component ID

  5724W12FM

Applicable component levels

• RA21 PSN

     UP