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.
You can list the high-level qualifiers you want to use in the database options of the VA Smalltalk Preferences notebook. To open this notebook, select Preferences from the Options menu in the Organizer. You can list multiple qualifiers separated by spaces or commas, and use wild card characters to specify more than one qualifier.
Last modified date: 05/20/2020