Alias Create Option
The Create Alias option enables creation of an alternative name for an existing table or view.
The Create Alias option enables creation of an alternative name for an existing table or view. The Alias Create screen has several blank fields. Select the table or view for the alias to reference. If selection criteria are entered in the Table Name or Creator fields, a Table/View selection panel appears. The Table/View selection panel lists the tables and views and their creators. Select one table or view from the selection panel.
After selecting the base table, complete the alias definition by filling in the remaining blank fields. A Confirmation screen asks for a decision: accept, edit, or reject the alias being created.
The Alias Create screen provides an easy way to supply the information necessary for the alias creation. For more information about the fields, press F1 (Help).
After information has been entered for all fields, press F3 (End) to process the alias creation. The Creation Confirmation screen appears.
Confirming the Alias Creation
The Creation Confirmation screen shows the DDL to be used to create an alias. Use the scrolling keys (F7 and F8) to view all the DDL. Accept the DDL to be used to create the alias by pressing Enter. Edit the DDL by entering E for Edit in the command line. Reject the DDL by pressing F3 (End).
The DDL is executed if Enter is pressed. When the Batch Processor is complete, press F3 (End) to return to the Main Menu.