Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
is there a way to display DB2 SQL with dynamic values instead of a question mark?
Description
In a DB2 database; under Activities | Top SQLS | SQL Statement details, the complete SQL is not available.
A question mark is shown, is there a setting to change to see this as a value?
Cause
Parameter markers are question marks (?) inserted into portions of the SQL and act as placeholders. These are meant to be used for select, insert, update, and delete statements.
Resolution
The values are not available to be displayed in the Foglight as this is how DB2 stores the text and it does not save the parameters themselves anywhere.
Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2
Topic(s):
How To
Article History:
Created on: 2/10/2015 Last Update on: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
