Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How do you view Focus Generated SQL?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How do you view Focus Generated SQL?
 Login/Join
 
secret
Platinum Member
posted
In old FOCUS you could allocate fstrace. Is there an equiilaant method in WEBFOCUS?
 
Posts: 103 | Location: ricmmond va | Registered: September 30, 2004Report This Post
<JG>
posted
If you have access to the webconsole and admin privileges then you can turn on the tracing dynamically there. When viewing the traces you can filter them so that you can just look at the SQl.
 
Report This Post
RB
Gold member
posted Hide Post
These commands would help view the SQL in view source.

SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = STMTRACE//CLIENT
SET TRACEUSER = ON
 
Posts: 76 | Registered: October 28, 2003Report This Post
dwf
Platinum Member
posted Hide Post
Try this:

SET TRACEOFF = ALL
SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = STMTRACE/2/CLIENT
SET TRACEUSER = ON

Then View Source after your run
 
Posts: 135 | Location: Portland, OR | Registered: March 23, 2005Report This Post
<JG>
posted
add

SET XRETRIEVAL=OFF

It will generate the SQL without actually running the request and the SQL will come directly back to the browser.
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How do you view Focus Generated SQL?

Copyright © 1996-2020 Information Builders