Aliases

Like a DB2 synonym, a DB2 alias is an alternate name for a table or view. However, an alias can name remote (and local) tables or views, whereas synonyms can only name local tables or views. Synonyms and aliases also differ in that synonyms can be accessed only by their creators. Aliases allow flexibility and familiarity by letting all users access them. Aliases can be used to simplify the remote name of a table or view.
carcudb2
Like a DB2 synonym, a DB2 alias is an alternate name for a table or view. However, an alias can name remote (and local) tables or views, whereas synonyms can only name local tables or views. Synonyms and aliases also differ in that synonyms can be accessed only by their creators. Aliases allow flexibility and familiarity by letting all users access them. Aliases can be used to simplify the remote name of a table or view.
You can use the alias options to simplify DB2 alias processes. You can create, modify, and drop alias with minimal effort. The alias option includes the following features.
  • Table Selection Help. Instead of entering a specific table name, enter selection criteria (*, %, _) to receive a list of tables meeting the criteria.
  • Alter Alias. You can alter existing aliases. With DB2, only comment and label fields can be altered. There is no ALTER ALIAS statement within DB2.
  • Template Alias. This option lets you create a new alias based on an existing alias.
  • Compare Feature. The COMPARE mode of alias lets you check present changes to the original alias to see exactly what has been modified.
  • Drop Alias. This option lets you drop an existing alias.