Hello,
I switched on an SQL trace and Buffer trace.
If I use both, all SQL stmts targeting on buffered tables are logged.
I switched on the trace for some time and took a look at the list then...
For most statements that were executed on buffered tables (appearing with blue backgroud)only the OPEN stmts appear. Most of the corresponding PREPARE statements that precede the OPEN stmt do not appear. If I plan to reuse these statements I will have to use or develop an SQL parser (hope there exists already one) and/or I must search for the PREPARE stmts in the trace to get to know how the stmt looks like...which correspondes to an OPEN stmt...
Moreover each OPEN stmt shows only the variables or parameters. But it shows not the whole SQL stmt!
How can I see the corresponding SQL stmts?
Thanks very much...