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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.