Re: what is my error??
Chang-Woo Park wrote:
>
> create table ACTIVE_SESSIONS
> (
> SID varchar(32) not null,
> NAME varchar(32) not null,
> VAL text ,
> CHANGED varchar(14) not null,
> constraint PK_ACTIVE_SESSIONS primary key (SID, NAME)
> );
This is SQL-92 standard syntax; as a couple of other people
pointed out, Informix has the constraint names positioned
after the primary key definition. It boils down to read the
manual -- this is clearly documented in the CREATE TABLE section.
--
Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN
#include <disclaimer.h>