---------- Original Message -----------
From: "peixinhosdalua" <peixinhosdalua@...>

> Is it possible to make a output of the variable this_query to view if
> all newly formed variable is correct? Something like a send_to_log()
>
> send_to_log(this_query);
> for execute statement :this_query into :a, :b, :c, ..., :z do
> suspend;
> end

------- End of Original Message -------

a) Create a logging table, and insert into that logging table where you currently
have send_to_log(). (results won't be visible to other transactions until you
commit, so for testing, you may want to execute this procedure manually in your
database tool and then check the log table, all in the same transaction.)

b) There are probably UDF's to help you write to a filesystem log file. I wrote
my own for convenience, but you might check out

http://rfunc.sourceforge.net/rfunc.htm

which has some file-handling functions already written for you (they're pretty
raw, you'll have to open the file handle, then write, then ...)

-Philip