Compiled Objects in ASE

September 22nd, 2011 Leave a comment Go to comments

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:
  1. Check constraints
  2. Defaults
  3. Rules
  4. Stored procedures
  5. Extended stored procedures
  6. Triggers
  8. Functions
  9. Computed columns
  10. 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:

  • 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.
Check the Sybase Wiki @
  1. No comments yet.
  1. No trackbacks yet.