Compiled Objects

SAP^® Adaptive Server^® Enterprise (ASE) uses compiled objects to hold vital information about each database and to help you access and manipulate data.

A compiled object requires entries in the sysprocedures table and includes:

Check constraints
Defaults
Rules
Stored procedures
Extended stored procedures
Triggers
Views
Functions
Computed columns
Partition conditions

Compiled objects are created from source text, which are SQL statements that describe and define the compiled object. When a compiled object is created, SAP^® ASE:

Parses the source text, catching any syntactic errors, to generate a parsed tree.
Normalizes the parsed tree to create a normalized tree, which represents the user statements in a binary tree format. This is the compiled object.
Stores the compiled object in the sysprocedures table.
Stores the source text in the syscomments table.

Save or Restore Source Text
If a compiled object does not have matching source text in the syscomments table, you can restore the source text to syscomments.
Verify and Encrypt Source Text
Use these commands to verify the existence of source text and encrypt the source text of a compiled object.
Replacing Object Definitions
Replace existing compiled object definitions with new definitions while preserving the original names, object IDs, security attributes—such as auditing options and permissions— and replication attributes.

Parent topic: SQL Building Blocks