Re: Is the type text missing in Informix-SE?

Les Clowney wrote: > I recently obtained Informix-SE Welcome to Linux. > and when loading the stores7 database the table catalog isn't > created. When running he esqldemo7 the following message is given: > > "...Based on the server information in sqlhosts, the database engine > does not support the data types varchar, text and byte, so the > table "catalog" has not been installed." > > In fact it isn't installed, [...] > > While running dbaccess if I try to explicitly create the table catalog > with the sql commands > [...] > I get following error message: > > "554: Syntax disallowed in this database server" > > Can anyone shed any light on this type anomaly? Informix-SE does not support the BYTE, TEXT or VARCHAR data types. It only supports fixed length data types (everything else). If you need these types, you need IDS, aka OnLine. This will be available soon if it is not already available -- check the recent announcements and the Informix web site. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>