PM80233: OPEN DATABASE WIZARD PASTING THE WRONG SQL QUERY WITH INFORMIX DRIVER

APAR status

• Closed as program error.

Error description

• You were using the Open Database wizard in Statistics 20.0 with
  the SDAP 6.1 ODBC driver for Informix database and all was well.
  you used the same query in statistics 21.0 and the pasted /SQL
  subcommand mangles the FROM and WHERE clauses such that they are
  unusable.  The problem is easily fixed by editing the pasted
  /SQL= line, but it is still annoying.
  

Local fix

• This issue will be addressed in the next Fix Pack. Please refer
  to the Fix Pack schedule at
  http://www-01.ibm.com/support/docview.wss?uid=swg21599157 for
  information on upcoming Fix Packs.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of SPSS Statistics and SPSS Data Access Pack 6, SP 3   *
  * Informix ODBC driver.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * You were using the Open Database wizard in Statistics 20.0   *
  * with                                                         *
  * the SDAP 6.1 ODBC driver for Informix database and all was   *
  * well.                                                        *
  * You used the same query in statistics 21.0 and the pasted    *
  * /SQL                                                         *
  * subcommand mangles the FROM and WHERE clauses such that they *
  * are                                                          *
  * unusable.  The problem is easily fixed by editing the pasted *
  * /SQL= line, but it is still annoying.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Statistics 21.0 Fix Pack 1.                       *
  ****************************************************************
  

Problem conclusion

• This issue has been addressed in Statistics 21.0 Fix Pack 1.
  

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

  SPSS STATISTICS

• Fixed component ID

  5725A54ST

Applicable component levels

• RL00 PSN

     UP

• RL00 PSY

     UP