IBM Support

How to add values that only differ in letter case to the same reference list in a case-sensitive ClearQuest database

Troubleshooting


Problem

By default, when you work with a ClearQuest database that is configured as case sensitive, you cannot add more than one value to the same reference list where the only difference is the letter case. No error message is reported if you try to do this.

Cause

When you add a new value to a reference list, ClearQuest checks to determine whether the value is already in the list. By default, ClearQuest performs a case-insensitive comparison, even if the database is configured as case sensitive. If the new value is evaluated as a duplicate, it is not added to the reference list and no error message is reported.

Resolving The Problem

You can override the default ClearQuest behavior by setting the CHECK_CASE_IN_REFLIST schema property. Set this property value to 1 to have ClearQuest perform a case-sensitive check for duplicate reference list values and allow values that only differ in letter case to be added to the same reference list.

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"General Information","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0.1.10;7.1.1.3;7.1.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Product Synonym

ClearQuest

Document Information

Modified date:
16 November 2018

UID

swg21442967