Changing Your Current Location and SQLID

Restriction: This topic applies to Windows environments only.

SQLWizard allows you to connect to a different location than the one you are currently using without exiting the program. If you have an alternate AuthID, you can change that also. These changes are made by clicking on the Set Location command from the Location menu or by clicking the Set button on the Catalog Browser dialog box.

In some cases, it may not be necessary to change to another location. For example, to query data that resides in another location of the XDB Server to which you are connected, simply enter a three-part name for the table being queried. It is also possible to set up alias names for tables in other locations.

Note: To change to a location on another XDB Server on your LAN, you must exit SQLWizard and restart it, choosing the desired server and location when the Connect dialog box appears. To change your default XDB Server and Location, use the Connect tab in the Options utility. If your organization uses the server-to-server connectivity features, you can access locations on multiple XDB Servers without having to log on to each individually.

To set the current location and SQLID:

  1. From the Location menu, choose the Set Location command.
    Note:


    Catalog Browser button
    From the Catalog Browser dialog box, click the Location tab; then click the Set button.

    SQLWizard displays the Set Location/SQLID dialog box.

  2. Enter a location name in the Current Location field or select a location from the drop-down list. For more about setting locations, see the description for the Set Location command in the .
  3. Enter a new SQLID if you wish to work using a different name. (Note that you are still logged in as the AuthID you used at the Connect dialog box, even though you changed your SQLID to a different name.) For more about CURRENT SQLID, see the description for the Set Current SQLID command.
  4. Click OK to accept the changes. The current location and SQLID are displayed in the status bar at the bottom of the SQLWizard window.