IBM Support

JR31611: ENABLE CLI KEYWORD SETTING PATCH1=1 IN DB2 UDB VERSION 9.5

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

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 9.5.
    
    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
    9.5. This APAR will track the fact that support for this CLI
    keyword setting is being added to DB2 UDB version 9.5.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    PATCH1=1 is not enabled to replace COUNT(expression) with
    COUNT(*) for sql queries
    ****************************************************************
    PROBLEM 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
    9.
    
    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
    9. This APAR will track the fact that support for this CLI
    keyword setting is being added to DB2 UDB version
    9.
    ****************************************************************
    RECOMMENDATION:
    Upgrade to db2 v95fp4 or later.
    ****************************************************************
    

Problem conclusion

  • Fixed in db2 v95fp4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR31611

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-01-08

  • Closed date

    2009-01-29

  • Last modified date

    2009-04-10

  • APAR is sysrouted FROM one or more of the following:

    JR24008

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
10 April 2009