Path: utzoo!censor!geac!yunexus!ists!helios.physics.utoronto.ca!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!decwrl!ucbvax!hplabs!pyramid!infmx!aland
From: aland@infmx.UUCP (Colonel Panic)
Newsgroups: comp.databases
Subject: Re: Informix Bug
Summary: need to see your syntax
Keywords: MIPS
Message-ID: <5078@infmx.UUCP>
Date: 29 Aug 90 04:19:26 GMT
References: <12702@netcom.UUCP>
Reply-To: aland@infmx.UUCP (alan denney)
Organization: INFORMIX Professional Services ("Peace thru Normalization")
Lines: 30

In article <12702@netcom.UUCP> bobb@netcom.UUCP (Bob Beaulieu) writes:
>
>I am having problems adding a col to an already existing table in INFORMIX.
>The error message is : #201 A Syntax Error has occured.
>
>This happens whether or not I am in the query mode or in the menuing
>system; although, I am able to modify existing cols.

It's hard to tell what's happening without an example.  By "query
mode", do you mean that it fails when you try to use an ALTER TABLE
statement in the SQL processor?  If so, on what character position
does it see a problem?  (Enter your statement, run it, let it fail,
then immediately enter Modify or Use-editor -- it will point to the
start of the bad syntax).

>Informix doesn't have an answer and suspects it to be a bug with the
>version we have:
>INFORMIX-SQL 2.10.03K (MIPS M/120) RISC/OS UMIPS 4.01
>Has any other users of informix sql with mips boxes experienced this
>problem?
>bobb

It's not likely that this is machine-specific.  My best guess is that
you are trying to add a column with a name = a reserved word, or
you are already exceeding the maximum row length (not likely).

--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland

 "Girl, we couldn't get much higher."  -  Joe Isuzu