When you create a new inline default, Adaptive Server looks for an existing shareable inline default having the same value in the database belonging to the same user. If one exists, Adaptive Server binds this object to the column instead of creating a new default. However, if Adaptive Server does not find an existing shareable inline default, it creates a new default.
Adaptive Server shares inline defaults between tables only within the same database.
Enable shared inline defaults by setting enable functionality group to a value greater than 0. See Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide, Volume 1.