Changing options for nicknames

Use the Nickname Options window to change the default nickname values of your data source tables and views. When DB2 populates the Create Nicknames window, it defaults to using your user ID in the Schema column and using the data source table or view name in the Nicknames column. You change the default values for allitems in the Create Nicknames window using the Nickname Options window, not just the items whose check boxes were selected.

These steps are part of the larger task of creating nicknames. When you complete the steps for changing nickname options, return to creating nicknames.

Fields and controls

To change default nickname values:

1. In the Schema box specify what you want to substitute for the default schema. You can select a schema substitute from the pull-down list or you can type a new schema value.

2. In the Nickname box specify what you want to substitute for the default nickname. You can select a nickname substitute from the pull-down list or you can type a new nickname value.

3. If you want all upper case values displayed in the Nicknames and Schema columns of the Create Nicknames window, check the Fold options to uppercase check box.

4. Click OK to refresh and populate the Create Nicknames window with your selected options.

   Note:

   ImportantAll items in the Create Nicknames window will be refreshed with the values specified in the Nicknames Options window regardless of whether their check boxes are selected or cleared.

[Return to main task]