show_condensed_text

Syntax

show_condensed_text(statement_id, option)

Parameters

• statement_id – is ID of the statement. Derived from the SSQLID column of monCachedStatement.
• option – is a string constant, enclosed in quotes. One of:
  • text – returns the condensed text
  • hash – return the hash value for the condensed text

Examples

• Example 1 – displays condensed text for cached SQL text:

  select show_condensed_text(SSQLID, 'text') from monCachedStatement
  
   -------------------------------------------------------------
   SELECT SHOW_CONDENSED_TEXT(SSQLID,$) FROM monCachedStatement
  

• Example 2 – displays the hash value of the condensed text for cached SQL text: 1:

   select show_condensed_text(SSQLID, 'hash') from monCachedStatement
  
   -------------------------------------------------------------
  1331016445

Usage

show_condensed_text:

• Returns a text datatype
• Supports long SQL text (greater than 16KB)
• Returns NULL for invalid option values

Permissions

• Granular permissions enabled – you must have the mon_role, or have monitor qp performance permission to execute show_condensed_text.
• Granular permissions disabled – you must have the mon_role or sa_role to execute show_condensed_text.