Capturing the SQL command sent to Cache for an external system

Question

Question

Don Mangold · Jul 10

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

Product version: Caché 2017.1

$ZV: Cache for UNIX (Red Hat Enterprise Linux for x86-64 U2/M) 2017.2.2 (Build 865_3_19827U) Mon Mar 30 2020 14:14:50 EDT [HealthShare Modules:Core:15.032.9688 + Linkage Engine:15.032.9688]

Discussion (4)2

Log in or sign up to continue

Alexander Koblov · Jul 10

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

https://docs.intersystems.com/ens201817/csp/docbook/DocBook.UI.Page.cls?...

0 0

score 0 · Answer 1 · 2024-07-10T11:31:09-04:00

But I cannot see the SQL statement which I expected to see in the Audit Data. Would it be some place else? Thanks

score 0 · Answer 2 · 2024-07-10T15:30:19-04:00

Alexander Koblov · Jul 10

Please double-check that you enabled Audit itself, and these events particularly

0 0

score 0 · Answer 3 · 2024-07-10T13:29:23-04:00

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

clicking on one in the list you get the details

Tab SQL Statements shows much more details

Click on SQL Statement Text offers a further drill down into details