Re: invalid datatype error when creating primary key

From: Jonathan G Gennick <jgennick_at_kpmg.com>
Date: 1997/04/02
Message-ID: <3347ca03.1861156_at_news.kweb.us.kpmg.com>#1/1

"Steve Miller" <smiller_at_gers.com> wrote:

>I'm trying to create some named primary keys on some tables in a 7.3.2.2
>database and I'm getting the following error:
>
>comex> alter table service.gp_cd2emp add constraint pk_gp_cd2emp1_c01
> 2 primary key (user_cd, emp_cd);
>alter table service.gp_cd2emp add constraint pk_gp_cd2emp1_c01

The syntax I usually use is:

	alter table service.gp_cd2emp 
          add (constraint pk_gp_cd2emp1_c01 primary key (x,x)
              );

Have you tried that?

jonathan

---

Jonathan Gennick "Brighton the corner where you are." jgennick_at_kpmg.com Received on Wed Apr 02 1997 - 00:00:00 CEST