Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#455 Support encoded vector index for AS400 DB2

General
open
Rob Manning
DB2 Plugin (12)
5
2012-12-29
2012-08-11
Roger Hill
No

On IBM AS400/iSeries/System i/IBM i - call it what you will - there are two types of index that can be created, a 'standard' binary radix index, and a distinct type called an 'encoded vector index'

This distinction is visible within Squirrel, when you use the DB2 plugin and view the index: the 'uniqueness' property says 'encoded vector index'.

So if you then use the create table script feature to generate the table and associated index, Squirrel has the info available to generate the SQL for an EVI correctly:

create encoded vector index ...

but at the moment you just generate

create index ...

which is wrong.

An enhancement to handle this case properly would be great.

Discussion