1. Arcady Abramov
  2. PowerBuilder
  3. Sunday, 13 February 2022 08:43 AM UTC

Hello,

I would like to know if it is possible to trace the PB application using PB profiler and get the actual select strings for embedded SQLs. All I get in the trace file is "DB Select" for the name.

I am working with PB2017 R3

Thank you

 

Miguel Leeuwe Accepted Answer Pending Moderation
  1. Sunday, 13 February 2022 17:05 PM UTC
  2. PowerBuilder
  3. # 1

Instead of using the profiler tool, what you can do is specify the word "TRACE" in front of your sqlca.DBMS value.

For example when using ODBC:

sqlca.dbms = "TRACE ODBC..."

Oracle:

sqlca.dbms = "TRACE ORA"

It will generate a file with all of your sql statements

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.