Re: Help On Stored Procedure Lang

praveen@qsun2.ho.att.com wrote: > > Hello Informix experts, > > I have a situation, where I am updating/Inserting a > row through stored procedure, I want to write the same > SQL statement to a file with the values. Well, perhaps through SPL it's even easier - use the statements SET DEBUG FILE TO "..."; and TRACE ON; before your insert and issue a TRACE OFF; afterwards. This will trace your statement to the specified file. I'm not sure, wether the values of the INSERT will also be traced automatically, but I think you could use a statement of the form TRACE <variable>; Bernhard Rawein Alphatron GmbH Munich