Setting execution class attributes

You implement and manage execution hierarchy for client applications, logins, and stored procedures using the five categories of system procedures listed in the following table.

**Table 5-2: System procedures for managing execution object precedence**
Category	Description	System procedures
User-defined execution class	Create and drop a user-defined class with custom attributes or change the attributes of an existing class.	sp_addexeclass sp_dropexeclass
Execution class binding	Bind and unbind predefined or user-defined classes to client applications and logins.	sp_bindexeclass sp_unbindexeclass
For the session only (“on the fly”)	Set and clear attributes of an active session only.	sp_setpsexe sp_clearpsexe
Engines	Add engines to and drop engines from engine groups; create and drop engine groups.	sp_addengine sp_dropengine
Reporting	Report on engine group assignments, application bindings, execution class attributes.	sp_showcontrolinfo sp_showexeclass sp_showpsexe

See the Adaptive Server Enterprise Reference Manualfor complete descriptions of the system procedures in Table 5-2.