SMC_NAME_CUR_STMT_QUERY_PLAN_TEXT

Description

Reports the text of the query plan for a particular query being executed for a particular connection.

If the text is not available (because Adaptive Server has removed this plan from its catalog of query plans), then this text is a null-terminated empty string ("").

Version compatibility

11.5 and later

Data item type

Result

Server level

Required keys

SMC_NAME_SPID

Optional keys

None

Statistic types and datatypes

VALUE_ SAMPLE	VALUE_ SESSION	RATE_ SAMPLE	RATE_ SESSION	AVG_ SAMPLE	AVG_ SESSION
LONG	LONG	DOUBLE	DOUBLE