Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Powerbuild app profiler

  1. How-to
0
Votes
Undo
  1. Arcady Abramov
    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

 

  1. PowerBuilder (Appeon)
Strange performance issue in PB 2019 R3
Q&A notification of answering a question when you ...
Responses (1)
Miguel Leeuwe
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.