I am using DB2 version 7.
I am trying to execute the following stmnt on the table open_select1:

ALTER TABLE "DB2ADMIN"."OPEN_SELECT1"
ADD CONSTRAINT "FK_FORMNO" FOREIGN KEY ("FORMNO")
REFERENCES "DB2ADMIN"."COLL_GEN" ("FORMNO")
ON DELETE NO ACTION
ON UPDATE NO ACTION
ENFORCED ENABLE QUERY OPTIMIZATION;

for which i am getting the following error:

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 "ENFORCED ENABLE QUERY OPTIMIZATION" was found

following "ON UPDATE NO ACTION". Expected tokens may include: "<space>".

SQLSTATE=42601

Any help will be appreciated.

It looks like you are using V8 syntax. You need to look up the V7 syntax. This might be hard, since V7 has been out of service and support for quite some time.

Andy

Hi Andy,
thanks for the reply. Your reply has confirmed what i suspected. I was sure the problem was because of version mismatch. The scripts have been generated in version 8 and now i am trying to create the db in version 7 and i am stuck now because of this problem. I have also tried to take a backup of the version 8 db and restore in version 7 where again i have failed. Please suggest.

You will have to manually edit each script to make sure that it is compatible with V7. Either that or upgrade you V7 systems to V8 or V9.

Andy

Restoring a V8 backup on V7 is not supported - just the other way around.

I highly recommend that you move to V8 (better V9) because you won't get any real help (and no support from IBM) for V7 any longer.

Hi,
"Enforced enable query optimization" is not supported in v7. Why don't you use just:
I don't think this should be a reason for migration to newer version. This "enforced" statement is just performance string. There are a couple of other thinks that is interesting in v8 and v9 to migrate.
Hope this helps,
Grofaty