Return
-
Title
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.