CODEWITHSUNDEEP
sqldatabasedelphiodbcinformix
Leandro Ferreira
Leandro Ferreira

Reputation: 25

Dump ERP queries in informix

We have a closed source application here, that connect to an informix database ( using odbc ) is there any way I can see the queries being executed by this application?

Upvotes: 0

Views: 180

Answers (2)

Gaetan
Gaetan

Reputation: 16

Multiple possibilities : those give all the statements

  • like mentioned above odbc tracing.
  • set explain on as pre sql (generates huge files with the sqls and query plans).

those the current running statements.

  • using onstat commands on the server running the database (onstat -g sql ).
  • connecting to the monitoring database (sysmonitor) and querying the session tables .

Upvotes: 0

Otávio Décio
Otávio Décio

Reputation: 74290

Turn on ODBC tracing. Some information can be found here.

Upvotes: 2

Related Questions