Capturing the SQL command sent to Cache for an external system
Is there a way to capture the SQL command that was sent to Cache ? I need to know how to do this. Any help would be appreciated. It is from an external application using JDBC or OBDC. Thanks
Comments
Cachè 2017.2 supports SQL Audit. There are three audit events:
- %System/%SQL/DynamicStatement — for Dynamic SQL Queries
- %System/%SQL/EmbeddedStatement — for Embedded SQL Queries
- %System/%SQL/XDBCStatement - for ODBC/JDBC Queries
But I cannot see the SQL statement which I expected to see in the Audit Data. Would it be some place else? Thanks
Please double-check that you enabled Audit itself, and these events particularly
Basically every SQL statement whether internal or external is cached for eventual reuse in future
You can find Cached Queries from SMP > System Explorer > SQL > Cached Query.png)
clicking on one in the list you get the details.png)
Tab SQL Statements shows much more details.png)
Click on SQL Statement Text offers a further drill down into details.png)