RE: why doesn't this create table work?

I think it might be the last comma after tkamx_comment char(50). Remove the comma and it should work - Howard -----Original Message----- From: Tony! [mailto:NoSpam@Thank.You.com] Sent: Friday, August 11, 2000 3:44 AM To: informix-list@iiug.org Subject: why doesn't this create table work? I've messed with queries etc, this is my first attempt to create a table to use myself.. Can anyone give me some pointers as to what's wrong with my sql? why do I get the errors at the end? Is it better to use "not null" after every char (xx), that I want no nulls accepted, or is how I put it in the unique index at the end good by itself? Is the isql < createme.sql way I'm trying to do this completely wrong? _________ database development; create table nightpost ( tkamx_site char(2), tkamx_project char(10), tkamx_calldte char (10), tkamx_startupl char(6), tkamx_stopupl char(6), tkamx_uplbytes char(9), tkamx_origrec char(8), tkamx_uplrec char(8), tkamx_ftpstart char(6), tkamx_ftpend char(6), tkamx_poststart char(6), tkamx_postend char(6), tkamx_stlstart char(6), tkamx_stlend char(6), tkamx_postallst char(6), tkamx_postallst char(6), tkamx_comment char(50), ); grant all on nightpost to "public"; create unique index tkamx_date on nightpost (tkamx_calldte,tkamx_site,tkamx_project) with disallow NULL; ___________________________________________ home/tony > isql < nightpost.sql Database selected. 201: A syntax error has occurred. Error in line 20Near character position 2 206: The specified table (nightpost) is not in the database. 111: ISAM error: no record found. Error in line 1Near character position 24 201: A syntax error has occurred. Error in line 2Near character position 42 /home/tony > ________________________________________ -Tony!-