Hi,

Trying the following SQL syntax on Informix 5.04.UC1 (running on Sol8
x86) but it is not working

echo "SET INDEXES, CONSTRAINTS FOR TABLENAME DISABLED" |dbaccess
DATABASE

But get an error:

201: A syntax error has occurred.
Error in line 1
Near character position 5

I have the exact same line working on Informix Online 7.31.UC2 and it
works 100%

Is the systax different for v5.04 or is there another way to disable
indexing and contraints for this version of Informix?

Any help appreciated.

Thanks.

spaz wrote:
> Hi,
>
> Trying the following SQL syntax on Informix 5.04.UC1 (running on Sol8
> x86) but it is not working
>
> echo "SET INDEXES, CONSTRAINTS FOR TABLENAME DISABLED" |dbaccess
> DATABASE
>
> But get an error:
>
> 201: A syntax error has occurred.
> Error in line 1
> Near character position 5
>
> I have the exact same line working on Informix Online 7.31.UC2 and it
> works 100%

Read the 5.04 manual - it doesn't include that option; it was added
around version 7.10.

> Is the systax different for v5.04 or is there another way to disable
> indexing and contraints for this version of Informix?

Yes - the syNtax is different. No, there (almost certainly) isn't an
alternative way to disable constraints in 5.0x.

You can download the 5.20 manuals from

http://www.ibm.com/software/data/informix/library

follow the links to the online manuals.


--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/

might also be in 5.20. can't remember