DB21034E

[jacelyn Yswan via DBMonster.com]

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL20075 The index "SQL050303003553230" cannot be created or altered
because
the length of "CDE_DESC" is more than 255 bytes. SQLSTATE=54008

PS: it occurs on Sun Solaris 7 and db2 version 6.1

please give me the solution..
thanks for your help...

jacelyn

--
Message posted via http://www.dbmonster.com

[Mark A]

"jacelyn Yswan via DBMonster.com" <fo***@DBMonster.com> wrote in message
news:58******************************@DBMonster.co m...

DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL20075 The index "SQL050303003553230" cannot be created or altered
because
the length of "CDE_DESC" is more than 255 bytes. SQLSTATE=54008

PS: it occurs on Sun Solaris 7 and db2 version 6.1

please give me the solution..
thanks for your help...

jacelyn

Solution:

Don't try to create or alter index using a column that is greater than 255
bytes.

[jacelyn Yswan via DBMonster.com]

but i need to alter index using a column that is greater than 255
bytes. so, what other solution you can give me?, if i really need to do
so...

please help!!

thanks..

--
Message posted via http://www.dbmonster.com

[Mark A]

"jacelyn Yswan via DBMonster.com" <fo***@DBMonster.com> wrote in message
news:ec******************************@DBMonster.co m...

but i need to alter index using a column that is greater than 255
bytes. so, what other solution you can give me?, if i really need to do
so...

please help!!

thanks..

In version 8, you can have up to 1024 bytes (including column overhead).

The only other solution that I know is to create a new column which contains
the first 255 bytes of the column you want to index, and index the new
column.

[Jean-Marc Blaise]

"jacelyn Yswan via DBMonster.com" <fo***@DBMonster.com> a écrit dans le
message de news:ec******************************@DBMonster.co m...

but i need to alter index using a column that is greater than 255
bytes. so, what other solution you can give me?, if i really need to do
so...

please help!!

thanks..

--
Message posted via http://www.dbmonster.com

DB2 Version 7.2 allows columns with a length greater than 255 bytes to be
specified as part of an index key. A larger index key has a positive effect
on the usefulness of an index. The DB2_INDEX_2BYTEVARLEN registry variable
allows for the use of two bytes instead of one to store the length of an
index key. To convert existing indexes to use larger index keys: drop the
indexes, set the DB2_INDEX_2BYTEVARLEN registry variable to ON, then
recreate the indexes (using the larger columns).

HTH,

Jean-Marc