Example scenario using precedence rules

This section presents an example that illustrates how the system administrator interprets execution class attributes, including:

Figure 4-4 shows two client applications, OLTP and isql, and three Adaptive Server logins, “L1”, “sa”, and “L2”.

sp_xyz is a stored procedure that both the OLTP application and the isql application need to execute.

Figure 4-4: Conflict resolution

Image shows three clients. One connected to L1, one to SA, and one to L2. All are part of the Adaptive Server environment. Inside the Adaptive Server environment, stored procedure sp_xyz runs and is available to all clients whether they are running isql or part of the OLTP environment.