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:
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:
  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.