Changing options for all nicknames

Use the Change All Nicknames window to change the default nickname values of your data source tables and views. When DB2 populates the Nicknames column of the Create Nicknames window, it suggests a default naming scheme consisting of your user ID and the remote table or view name. You can use this naming scheme to create nicknames or you can change them.

Note:

If you want to change the default values for a single item in the Create Nicknames window, select the item in the Create Nicknames window and click the Change push button to open the Change Nickname window.

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 select Custom and type a new schema.
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 select Custom and type a new nickname value.
3. In the Fold box, specify the fold options that you want to use as default values.
4. Click OK to refresh and populate the Create Nicknames window with your selected options.

   Note:

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

[Return to main task]