Using Siebel Tools > Compiling, Testing, and Troubleshooting Your Customizations > Compiling Your Modifications >

Overview of Compiling

After you modify objects you must compile these modifications to the repository. The compile adds any new objects you create to the repository. These objects are then available to the Siebel client. Siebel Tools can compile projects or an individual top-level object:

• Compile projects. More efficient if you modify many objects in one or more projects.
• Compile objects. More efficient if you modify only a few objects. For information about top-level object types, see Displaying Object Types in the Object Explorer.

Differences in SQL Code That Might Affect Your Database Customizations

If you compile a new repository, and then recompile this same repository, then the two versions of this repository are logically and functionally the same but they might contain slight differences in the SQL code. For example, a new compile might include the following SQL code:

select col1, col2
from
table
where col1 = 'ABC'

A recompile of this repository might include the following SQL code:

select col2, col1
from
table
where col1 = 'ABC'

Functionality for these repositories is identical but the SQL code is slightly different. These differences do not impact Siebel CRM but they might affect customizations you make to an Oracle database that expects the SQL code to remain identical for different compilations. It is important that your customizations accommodate this variability in the SQL code.