Alter table foreign key sqlcode -104

[login to unmask email]

Alter table foreign key sqlcode -104
I am trying to run the following DDL:

add foreign key (REGION_ID,
TMR_LABEL)
references POLICY_REGION (REGION_ID,
TMR_LABEL)
on delete cascade;

I get the following error:

DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE
<IDENTIFIER> .

The SQL Guide states that the constraint name is optional. Any ideas on what the problem is? TIA.

Kurt Sahlberg

Re: Alter table foreign key sqlcode -104
(in response to jchimes@PARKER.COM)
TRY
add foreign key (REGION_ID,
TMR_LABEL)
references POLICY_REGION
on delete cascade;
HTH
Kurt

>>> <[login to unmask email]> 10/08/99 02:54PM >>>
I am trying to run the following DDL:

add foreign key (REGION_ID,
TMR_LABEL)
references POLICY_REGION (REGION_ID,
TMR_LABEL)
on delete cascade;

I get the following error:

DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE
<IDENTIFIER> .

The SQL Guide states that the constraint name is optional. Any ideas on what the problem is? TIA.