Re: CREATE TABLE error

Svetlin Manavski wrote: > I have INFORMIX-SE on RedHat Linux 5.1. > It seems to work now but when I try to create table like this: > > CREATE TABLE customer (cust_no int PRIMARY KEY, fname varchar(15), > lname varchar(15) > )> > I always get the error: > "554 Syntax disallowed in this database server". > > What's going on? Isn't it a normal sql statement that should work > on any SQL server? > I got this statement from the demos in the informix jdbc package. VARCHAR is not supported by SE; no variable length types are. You will either have to map that to CHAR(15), which won't waste very much space, or wait until IDS is available -- soon. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>