Is there a way to see prepared statements for a connection

[Former Member]

Is there a way in SA 12.0.1 to see the prepared statements that a connection has created via dbisql or dbconsole?  I know Oracle has a table that can be queried to see the prepared statements a connection has and was wondering if SA has something similar.

Thanks

[former_member244518 · Accepted solution]

The PrepStmt connection property can be used to determine the number of prepared statements on a specific connection. If you enable the -zl switch, the sa_conn_activity procedure contains information on the last prepared statement for each connection. Beyond the last prepare, I don't believe the SQL statements for previous prepares are retained.

[Former Member · Accepted solution]

Thanks for the info.

I have been using the PrepStmt property but hoping to get something that would actually show the statements.