PM88891: UNION OF SQL STATEMENTS DOES NOT WORK WHEN CREATING A D-LINK BASED ON DB2 ODBC DATASOURCE

APAR status

• Closed as Permanent restriction.

Error description

• UNION of SQL statements does not work when creating a D-link
  based on DB2 ODBC datasource.??The Fetch is working and the
  correct data is displayed in the Preview, yet, an error arises
  when trying to perform the mapping :??[IBM][CLI Driver][DB2/NT]
  SQL0421N The operands of a set operator or a VALUES clause do
  not have the same number of columns. SQLSTATE=42826??Individual
  SQL statements without UNION are working.
  

Local fix

• Do not use UNION and create 2 distinct d-links instead of a sing
  le one.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * The issue will not be addressed due to the severity and and  *
  * age. It can be re-opened if new impacts are reported, as     *
  * appropriate.                                                 *
  ****************************************************************
  

Problem conclusion

• No Intent to 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

Applicable component levels