JR24008: ENABLE CLI KEYWORD SETTING PATCH1=1 IN DB2 UDB VERSION 8

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

APAR status

• Closed as new function.

Error description

• The CLI keyword setting PATCH1=1 is used in DB2 UDB Version 7 to
  replace COUNT(expression) with COUNT(*) in SQL queries.  This
  setting has not been available in DB2 UDB Version 8.
  
  The setting is a workaround for applications that use
  COUNT(expression) in SQL queries with DB2 servers that do not
  support this syntax.
  
  For example, a query generated by Microsoft Access might contain
  the following syntax:
  
  SELECT COL1, COUNT(1) FROM TAB1 WHERE ...
  
  DB2 Version 7 on z/OS does not support the COUNT(1) syntax, thus
  returns error SQL0111N (column function does not include a
  column name).
  
  With PATCH1=1 set in the db2cli.ini file on the Version 7
  client, the query is changed to:
  
  SELECT COL1, COUNT(*) FROM TAB1 WHERE ...
  
  This syntax is accepted by DB2 z/OS Version 7 and no error
  occurs.
  
  The PATCH1=1 setting has not been available in DB2 UDB Version
  8. This APAR will track the fact that support for this CLI
  keyword setting is being added to DB2 UDB version 8.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See problem Description above.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 UDB version 8 fixpak 15.                      *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• First Fixed in DB2 UDB version 8 fixpak 15
  

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:

  JR27358 JR31611

Fix information

• Fixed component name

  DB2 CEE WINDOWS

• Fixed component ID

  5765F3001

Applicable component levels

• R820 PSN

     UP