A synonym provides an alternate name for a table or view. This functionality lets you refer to the DB2 object represented by the synonym without using a fully qualified name. Users create synonyms to refer to tables by names that are easier to remember than their fully qualified names. These alternate names can also be used in applications to reference tables without tying the source code to the physical object.
A table and its synonyms must exist within the same DB2 subsystem and can be accessed by their creator only. When a table is dropped, the synonyms are also dropped.
When you select synonyms from the Investigator, CA Chorus displays a list of all defined synonyms within the DB2 system and their corresponding table and view names.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|