This view displays information about the statement that is currently being executed by Adaptive Server whether it is part of a stored procedure or batch text. Use a view such as this if you are trying to determine what an application is doing at a particular point in its execution.
SMC_SIZET cur_stmt_act_count = 11;
SMC_DATAITEM_STRUCT cur_stmt_act_view[] = {
{ SMC_NAME_SPID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_CUR_STMT_ACT_STP_DB_ID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_CUR_STMT_ACT_STP_DB_NAME, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_CUR_STMT_ACT_STP_ID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_CUR_STMT_ACT_STP_NAME, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_CUR_STMT_ACT_STP_TEXT, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_CUR_STMT_BATCH_ID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_CUR_STMT_CONTEXT_ID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_CUR_STMT_NUM, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_CUR_STMT_QUERY_PLAN_TEXT, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_CUR_STMT_START_TIME, SMC_STAT_VALUE_SAMPLE },
};
