CASE Dictionary DDL Problems

We are using CASE Dictionary 5.0. When I run the DDL script generated by Dictionary, I get errors messages when DDL commands creating Primary Keys and Foreign Keys are executed. The errors say that the command is missing the right parenthesis. An example is:

ALTER TABLE ALTER_SOURCES ADD (
  PRIMARY KEY (CODE)
  CONSTRAINT ALTSRCE_PK
)
;

When I switch the PRIMARY KEY and CONSTRAINT lines, the command works fine.

Has anyone encountered this problem? Is there a way to modify the DDL generator to format the command correctly? I can fix the problem by manually changing switching the lines, but this is rather cumbersome.

Thanks,
Jim Anderson
anderson_at_mrd.usace.army.mil Received on Fri Aug 18 1995 - 00:00:00 CEST