IBM Support

IC88157: BTS QUERY FINDS NO ROWS WITH WILDCARD

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as documentation error.

Error description

  • Using a wildcard "*" in a SQL query returns no rows.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of version 11.70xC6 and earlier versions.              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description: BTS Query finds no rows with wildcard *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * To index hyphen characters, use the Whitespace analyzer.     *
    ****************************************************************
    

Problem conclusion

  • The Standard analyzer for basic text searching does not index
    hyphen characters. The documentation for the Standard analyzer
    is incorrect. To index hyphen characters, you can use the
    Whitespace analyzer.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88157

  • Reported component name

    IBM IDS ENTRP E

  • Reported component ID

    5724L2304

  • Reported release

    B15

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-12

  • Closed date

    2014-02-26

  • Last modified date

    2014-02-26

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
26 February 2014