Triggers and Dynamic SQL... Pre-Version 9

Posted in 2000

Greg Bird — Wed, 5 Jul 2000 10:26:28 +1000 — source: Informix-list mailing list archive (1991-1998)

Hi, Problem: I have to create triggers on a database that will execute stored procedures utilising dynamic SQL and cursors etc. Because the triggers are essential this would seem to rule out ESQL\\C. Also, I have looked at the info for the Dynamic SQL blade that can downloaded to allow Dynamic SQL in SPL and it seems to me to assume Version 9. I am restricted to using Version 7.2 and 7.3... The blade (as far as I can tell) requires the CREATE FUNCTION command (to install the blade) which doesn't seem to be supported in the above Versions. Does anybody know of any way to use Dynamic SQL in this situation? Any ideas would be much appreciated... CHEERS, Greg