disabling indexing and contraints on informix 5.04.uc1

Posted in 2005

spaz — 30 Mar 2005 00:58:48 -0800 — source: Usenet: comp.databases.informix

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 1Near 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.