Re: SET CONSTRAINTS statement

Vadim Park (pivot@taxpol.krasnoyarsk.su) wrote: : I use I4GL RDS v.4.10 and Online v.5.0. : ... : set constraints all deferred : |______________^ : | : | A grammatical error has been found on line 4, character 16. : | The construct is not understandable in its context. : | See error number -4373. Much of the "new" syntax related to engine commands is not directly accessable to 4GL (EXECUTE PROCEDURE, for example). I suspect this is what you're running into. What you can to is send it as a PREPARED statement: PREPARE st_set FROM "SET CONSTRAINTS ALL DEFERRED" EXECUTE st_set Since I brought it up, you EXECUTE stored procedures the same way; PREPARING a statement (with ? for place holders as required). If the SPL does NOT return values, you can EXECUTE ... USING .... If the SPL DOES return values, you DECLARE, OPEN ... USING ..., and FETCH (i.e.: treat is as a SELECT CURSOR). ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Senior Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer.