Skip to Content
0
Dec 07, 2011 at 10:56 PM

altering index command fails - because of ~ and ^ in index

58 Views

I have this weird issue when wanting to use a alter index command . see below. I cannot get it to work. Please help.

db2 -tvf another.sql

connect to dbe

Database Connection Information

Database server = DB2/AIX64 9.7.4

SQL authorization ID = DB2DBE

Local database alias = DBE

ALTER INDEX "SAPDBE "."SLGSK~0" COMPRESSION YES

DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL0104N An unexpected token "COMPRESSION" was found following ""SAPDBE

"."SLGSK~0"". Expected tokens may include: "COMPRESS". SQLSTATE=42601