Compiled objects

Adaptive Server uses compiled objects to contain vital information about each database and to help you access and manipulate data. A compiled object is any object that requires entries in the sysprocedures table, including:

• 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, Adaptive Server:

1. Parses the source text, catching any syntactic errors, to generate a parsed tree.

2. Normalizes the parsed tree to create a normalized tree, which represents the user statements in a binary tree format. This is the compiled object.

3. Stores the compiled object in the sysprocedures table.

4. Stores the source text in the syscomments table.

   If you are upgrading from Adaptive Server version 11.5 or earlier, and you have deleted source text from syscomments, you must restore the deleted portions before you upgrade. To do so, follow the process in the installation documentation for your platform.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF