Program Invalidation and Automatic SQL
Recompilation
HP NonStop SQL/MP Programming Manual for C—429847-008
8-15
Preventing Automatic Recompilations
Collations
You do not have to explicitly enable the similarity check for a collation, because
collations always have the similarity check implicitly enabled. Two collations are similar
only if they are equal. NonStop SQL/MP uses the CPRL_COMPAREOBJECTS_
procedure to compare the two collations. Consequently, two tables that contain
character columns associated with collations are similar only if the collations are equal.