Create Alias -- Fields and controls

Alias schema

Alias name

Object schema

Object name

Comment

Apply

Reset

Close

Show SQL

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.

Alias name

Type the alias without its qualifier. The value that you type:

• Must not duplicate any table name, view name, or other alias in the alias's schema
• Can contain from 1 to 128 characters
• Can be an ordinary or delimited identifier

Examples

Suppose that SMITH is the schema that you specified in the Alias Schema box. If you want the fully-qualified alias to be SMITH.TIMETABLE, type:

timetable

(If you type undelimited lowercase letters, they are converted to uppercase.)

If you want the fully-qualified alias to be SMITH.turntable, type:

 "turntable"

(If you enclose lowercase letters with double quotes, the letters are not converted to uppercase.)

Object schema

Use this box to specify the schema of the table or view that you're creating an alias for, or the schema of another alias for this table or view. The table, view, or other alias can be one that exists or one that you plan to create. If you plan to create it, you can specify either an existing schema or a new one.

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. If you want a new schema, its name:
  • Can contain from 1 to 8 characters
  • Cannot be one of the following reserved schema names:
    • SYSCAT
    • SYSFUN
    • SYSIBM
    • SYSSTAT
  • Can be an ordinary or delimited identifier

Object name

Type the name of the table or view that you're creating an alias for, or type another alias for this table or view. Do not type a qualifier.

The table, view, or other alias can be one that exists or one that you plan to create. If you plan to create it, the value that you type:

• Cannot duplicate the name or alias of any other object in the schema that you specify in the Object schema box
• Can contain from 1 to 18 characters
• Can be an ordinary or delimited identifier

Example

Suppose that you're creating an alias for a view that you plan to create, and that JONES is the schema that you specified in the Object schema field. If you want the fully-qualified name of the view to be JONES.user IDs, type:

"user IDs"

Attention: If you specify a table, view, or alias that doesn't exist yet, you need to create the table, view, or alias before SQL statements can reference it with the alias that you're creating. You can create a table and create a view from the Control Center.

Comment

Optional: Type a comment to document the alias that you're creating. You can type up to 254 characters, including embedded blanks.

If you don't want to add a comment now, you can do so later on the Alter Alias window. If you do add a comment now, you can change or remove it later on the Alter Alias window.