is there a way to display DB2 SQL with dynamic values instead of a question mark? (4308652)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

is there a way to display DB2 SQL with dynamic values instead of a question mark?
Beschreibung

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?
Ursache

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.
Lösung

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.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2; Foglight
6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2, 5.9.1, 5.7.5, 5.7.1, 5.6.11, 5.6.10, 5.6.7, 5.6.5, 5.6.4, 5.6.3, 5.6.2

Titel