is there a way to display DB2 SQL with dynamic values instead of a question mark?
说明
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?
原因
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.
解决办法
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.