SqlDbx Forum

SqlDbx

You are not logged in.

#1 2012-11-25 01:47:03

BlueFin
Member

Create Index Scripting error

Using Pro evaluation version 3.58

When selecting DDL from Table Properties, the CREATE INDEX script is not differentiating columns defined as INCLUDE. It is listing all columns in the CREATE INDEX statement.

ie: a UNIQUE index defined as (COL1, COL2) INCLUDE (COL3)
produces a statement (COL1, COL2, COL3).

Very bad karma when trying to use SQLDBX to evaluate index definitions.

Offline

#2 2012-11-25 10:31:31

sqldbxhelp
Administrator

Re: Create Index Scripting error

What version of DB2?

Offline

#3 2012-11-25 23:00:29

BlueFin
Member

Re: Create Index Scripting error

LUW 10.1 Express-C

Offline

#4 2012-11-28 04:50:17

BlueFin
Member

Re: Create Index Scripting error

Any news ?

Offline

#5 2012-11-30 00:01:32

sqldbxhelp
Administrator

Re: Create Index Scripting error

Index scripting is not a trivial task and INCLUDE option got overlooked.

Offline

#6 2012-12-11 21:27:47

BlueFin
Member

Re: Create Index Scripting error

Any idea when the next version (including this fix) is going to be released ?

Offline

#7 2012-12-11 23:25:34

sqldbxhelp
Administrator

Re: Create Index Scripting error

Probably before the end of the year

Offline

Board footer

Powered by FluxBB