Fw: Re: sorry...previous news...
Posted in 1999
Topics: Data Types & Schema Design
Seems like you have a syntax error in the CREATE TABLE statement assuming you are using informix database.
It should be:
create table ACTIVE_SESSIONS
(
SID varchar(32) not null,
NAME varchar(32) not null,
VAL text ,
CHANGED varchar(14) not null,
primary key (SID, NAME) constraint PK_ACTIVE_SESSIONS
);
HTH,
Vijaya.
------------------------
From: Chang-Woo Park <soph@engineer.ajou.ac.kr>
Subject: sorry...previous news...
Date: 11 May 1999 16:09:30 GMT
To: informix-list@iiug.org
my mistake in previous news..^^;
what is my error??
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)# ^
);
dynamic server is ORDBMS?
------------------------------
e-mail to soph@doit.ajou.ac.kr
---------------End of Original Message-----------------
--------------------------------------------------------
Name: Vijaya Erabelli
E-mail: verabell@us.dhl.com
Phone: 281-875-1755 x5279
Date: 05/11/99
Time: 15:21:41
---------------End of Original Message-----------------
--------------------------------------------------------
Name: Vijaya Erabelli
E-mail: verabell@us.dhl.com
Phone: 281-875-1755 x5279
Date: 05/11/99
Time: 15:32:57