Database Guide

Using high-level qualifiers

Some database managers use high-level qualifiers to qualify table names. For example, DB2 qualifies a table with the user ID of the person who owns the table. If you are working with tables that are not all owned by the user ID you are logged on as, you will want to use high-level qualifiers in your SQL statements.

To use high-level qualifiers, open the settings of the multi-row query and turn to page 2 of the Query Spec tab. Select Use high level qualifiers from the Options menu.

Every time you create a new SQL statement, the SQL Editor will either use high-level qualifiers or not based on this option. Every time you close and come back to the Multi-row Query Settings window, your option is saved as the default.

Selecting high-level qualifiers does not change existing SQL statements.

Tips
You can list the high-level qualifiers you want to use in the database options of the VisualAge Preferences notebook. To open this notebook, select Preferences from the Options menu in the VisualAge Organizer. You can list multiple qualifiers separated by spaces or commas, and use wild card characters to specify more than one qualifier.

When you set high-level qualifiers in the preferences notebook, the table list in the SQL editor will show only those tables with qualifiers that appear in the preferences notebook.

Note:If you are accessing AS/400 databases, you should always use high-level qualifiers. The qualifier that VisualAge uses is the alias in your workstation's catalog, which must be the collection name on your AS/400 system.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]