Informix table creatin script | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Informix table creatin script

Hi Can I get an example of a table creation script in Informix.
I know a bit of SQL, and have tried to create a table with a DateTime field.
In IDS I get a incorrect syntax when I use a script like this: CREATE TABLE informix.customer (
last_name VARCHAR(10) NOT NULL,
birth_day DATETIME,
Bearing in mind that this is an SQL Server forum, you might want to try to find an informix forum to get an authoritative answer! Tom Pullen
DBA, Oxfam GB
See This is free informix book I found usefull while I was working on Informix.