Aggregating Metrics from Syntactically Similar Queries

Adaptive Server 15.7 SP100 includes the show_condensed_text function, which lets you aggregate monitoring data for multiple statements in the statement cache that, although syntactically distinct (having individual comments or differences in their text format), represent semantically identical queries.

By providing a way to identify semantically equivalent statements, show_condensed_text allows you to aggregate the values from monCachedStatement into a single row in the query result.