Re: How to change CASE NOT SPECIFIC to CASE SPECIFIC for PI fields
Do you really need to change this attribute in the PI column? I think that the only way to change that is recreating the table. Probably the case sensitive attribute might change the hash bucket for the PI column.
Anoter way is change the case sensitive attribute when performing the query. Below a simple example.
CREATE VOLATILE TABLE VT_TEST ( COL1 VARCHAR(10) CASESPECIFIC ) PRIMARY INDEX (COL1) ON COMMIT PRESERVE ROWS ;
INSERT INTO VT_TEST ('A'); INSERT INTO VT_TEST ('a');
SELECT * FROM VT_TEST WHERE COL1 (NOT CASESPECIFIC) = 'A';