Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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/
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.