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

---

Seehttp://docs.rinet.ru:8083/InforSmes/ This is free informix book I found usefull while I was working on Informix.

---

]]>