View Recently Run SQL Statements?

[Mykimus]

Hey, all -

I'm wondering if anyone knows of an SQL statement that can be run against OpenEdge to show recently executed SQL statements? (Or maybe a tool/utility of some kind?)

If I were querying against a SQL Server (and yes, I am fully aware that this is not SQL server), I might do something like this:

[FONT=Calibri]SELECTSUBSTRING(qt.text, (qs.statement_start_offset/2)+1,[/FONT][FONT=Calibri]        ((CASE qs.statement_end_offset[/FONT]
[FONT=Calibri]          WHEN -1 THEN DATALENGTH(qt.text)[/FONT]
[FONT=Calibri]         ELSE qs.statement_end_offset[/FONT]
[FONT=Calibri]         END - qs.statement_start_offset)/2)+1)as sql_text,[/FONT]
[FONT=Calibri]qs.last_execution_time[/FONT]
[FONT=Calibri]FROMsys.dm_exec_query_stats qs[/FONT]
[FONT=Calibri]CROSSAPPLY sys.dm_exec_sql_text(qs.sql_handle) qt[/FONT]
[FONT=Calibri]WHEREqt.encrypted=0[/FONT]
[FONT=Calibri]ANDPATINDEX('%ar_view%', SUBSTRING(qt.text, (qs.statement_start_offset/2)+1, [/FONT]
[FONT=Calibri]        ((CASE qs.statement_end_offset[/FONT]
[FONT=Calibri]          WHEN -1 THEN DATALENGTH(qt.text)[/FONT]
[FONT=Calibri]         ELSE qs.statement_end_offset[/FONT]
[FONT=Calibri]         END -qs.statement_start_offset)/2)+1)) > 0[/FONT]

Or possibly fire up the SQL Server Profiler and run a TSQL->SQL:BatchStarting trace. Does anyone know of any similar functionality for OpenEdge?

• The database I'm working with currently is running 10.2B.
• The database I'm working with belongs to one of my customers, which means I've got full JDBC access to the database (for running SQuirreL, etc.), but my access to the OpenEdge-specific tools may be somewhat limited.

I'm trying to get my hands on a SQL statement that is being run as a part of one of the canned reports that came with their operational software.

Thanks -

Mykimus

 

[TomBascom]

You want the "client statement cache" which is part of the _Connect VST.

What's That User Doing? The OpenEdge Client Request Statement Cache.