Alias schema

Use this box to specify a schema for the alias that you're creating. The initial value in this box is the user ID under which you connected to the database. To specify a schema with a name that's different than this ID, use one of these methods:

• Click on the down arrow to display a list of existing schemas and select one.

• Type the name of the schema that you want. The schema can be an existing one or, if you have IMPLICIT_SCHEMA authority, it can be a new one. If it's new, its name:

  • Cannot be the same as the name of another schema

  • Can contain from 1 to 8 characters

  • Cannot be one of the following reserved schema names:

    • SYSCAT

    • SYSFUN

    • SYSIBM

    • SYSSTAT

  • Cannot begin with SYS

  • Can be an ordinary or delimited identifier

The alias will include the schema's name as a qualifier. For example, if you specify SCHEMA1 in the Alias schema box and NICKNAME in the Alias name field, the fully-qualified alias will be SCHEMA1.NICKNAME.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]