CREATE INDEX on a VARGRAPHIC column

[nshen]

Hi! We are creating a set of tables for our Japanese customers who are using DB2 V7 in codepage 932 (Shift-JIS).
Some of the tables that we created need to have index built on the VARGRAPHIC(254) columns. Those columns are meant to store up to 254 characters.
But DB2 has a 255 bytes limit on columns within an index.

How do people get around this limit?

Thanks!
Regards, Nancy

 

[Shaixpeare]

Hi Nancy,
DB2 UDB v7.2 allows columns with a length > 255 bytes to be specified as part of the index key. You have to set the registry variable DB2_INDEX_2BYTEVARLEN to ON to activate it. Hope this helps...

Todd