CREATE TABLE error
Posted in 1998
Topics: Connectivity: ODBC / JDBC / .NET, Data Types & Schema Design, Platform-Specific Issues
This is a multi-part message in MIME format.
--------------54E0D7A6014CF8976E79F90C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
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.
Svetlin
--------------54E0D7A6014CF8976E79F90C
Content-Type: text/x-vcard; charset=us-ascii;
name="sm.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Svetlin Manavski
Content-Disposition: attachment;
filename="sm.vcf"
begin:vcard
n:Manavski;Svetlin
x-mozilla-html:TRUE
org:CS International srl
adr:;;Galleria Spagna 28;Padova;PD;35131;Italy
version:2.1
email;internet:sm@csinternational.it
title:Software Engineer
tel;fax:+39498703463
tel;work:+39498703470
x-mozilla-cpt:;0
fn:Svetlin Manavski
end:vcard
--------------54E0D7A6014CF8976E79F90C--