show_cached_text_long

Displays the SQL text for cached statements longer than 16K.

Syntax

show_cached_text_long(statement_id)

Parameters

Examples

Usage

  • show_cached_text_long displays up to 2M of SQL text.

  • show_cached_text_long returns a text datatype.

  • Using show_cached_text_long requires you to configure set textsize value at a large value. If you configure a value that is too small, SAP ASE clients (for example, isql) truncate the show_cached_text_long result set.

Permissions

The permission checks for show_cached_text_long differ based on your granular permissions settings.

Granular PermissionsDescription
Enabled

With granular permissions enabled, you must be a user with mon_role, or have monitor qp performance permission to execute show_cached_text_long.

Disabled

With granular permissions disabled, you must be a user with mon_role or sa_role to execute show_cached_text_long.