Re: Trigger action in file system

Irina Kotlova wrote: > I create TRIGGER on INSERT. TRIGGER invokes STORED PROCEDURE. > How can I write variable from STORED PROCEDURE into flat file > in operating system? With difficulty. Mainly by using variants on: LET str = "echo '" || variable || "' >>/path/to/flat/file"; SYSTEM str; There are no other functions available in non-IUS systems. With IUS, you could probably write yourself a DataBlade or equivalent to do the job for you, though you'd have to be very careful -- I/O calls block and blocking isn't good for IUS performance. Yours, Jonathan Leffler (jleffler@earthlink.net) #include <many-aliases.h>