Re: disabling indexing and contraints on informix 5.04.uc1

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/