Examples: determining precedence

Each row in Table 4-3 contains a combination of execution objects and their conflicting execution attributes.

The “Execution Class Attributes” columns show execution class values assigned to a process application “AP” belonging to login “LG”.

The remaining columns show how Adaptive Server resolves precedence.

Table 4-3: Conflicting attribute values and Adaptive Server assigned values

Execution class attributes

Adaptive Server-assigned values

Application (AP)

Login (LG)

Stored procedure (sp_ec)

Application

Login base priority

Stored procedure base priority

EC1

EC2

EC1

(EC3)

EC2

Medium

High

(Medium)

EC1

EC3

EC1

(EC2)

EC3

Low

High

(Medium)

EC2

EC1

EC2

(EC3)

EC1

High

High

(High)

EC2

EC3

EC1

(EC2)

EC3

Low

High

(Medium)

EC3

EC1

EC2

(EC3)

EC1

High

High

(High)

EC3

EC2

EC1

(EC3)

EC2

Medium

High

(Medium)

To test your understanding of the rules of precedence and scope, cover the “Adaptive Server-Assigned Values” columns in Table 4-3, and predict the values in those columns. Following is a description of the scenario in the first row, to help get you started:

At run time: