I have a DB2 table whose primary key SLNO is 5 character alphanumeric with the following data.
SLNO SLTYPE
F1aCr C
F1ACR C
F1ABB M
F1aCr C
F1ACR C
F1ABB M
Currently SLNO is defined as case sensitive, i.e. F1aCr is not equal to F1ACR. I have a requirement to make the SLNO case insensitive, i.e. F1aCr should be treated same as F1ACR.
One option suggested to me was to define a INSERT/UPDATE trigger to convert all lower case characters to uppercase while inserting or updating values in table. But this might impact performance as every time this table is updated the trigger will be executed.
Could someone suggest me other possible ways to implement this.
Regards,
Neelu Soni