Restriction: This topic applies to Windows environments only.
- From the main menu, click
Run > Tools > Data Tools > SQL Option for DB2 > Client > SQL Wizard.
The Connect Dialog Box
The
Connect dialog box is used to specify the XDB Server you want to use with SQLWizard and to enter a password if one is required.
The Connect dialog box may or may not be displayed when you start SQLWizard, depending on certain settings you make in the
Options Utility. Likewise, certain items may or may not be selectable, depending on the settings in Options.
To use the Connect dialog box:
- Type the name of the XDB Server you want to access, or click the down arrow button next to the
Server field to select an XDB Server from the drop-down list.
To connect to an XDB Server that you never used before, run the Options utility before starting SQLWizard. Use the
Connect
tab in Options to set up the communication protocol, client node name, and default location.
If the server name is displayed as a label rather than in a text-entry field, you cannot select or type a different server
name.
- In the
Location field, type the name of the location you want to access, or click the
Browse button to select a location from the
Browse Dialog box. The
Browse Dialog box shows all locations known to the selected XDB Server.
Note:
Each time you access the
Browse Dialog box, the selected XDB Server is checked for the list of all known locations available and you are logged in to the specified
XDB Server with the current AuthID and password. If security is on, you must have SELECT privileges on the XDB Server's system
location for this feature to operate correctly. (For more information, refer to the description of the WSQL043 message in
online help.)
If you do not click the location drop-down list, the XDB Server is not accessed until you connect.
- Type your AuthID in the Username field. If you need to access a multi-user XDB Server on the LAN, ask your XDB Server Administrator
what AuthID to use.
- If security is turned on, type your password. Asterisks (*) are displayed for each character you type to prevent others from
seeing your password.
Note: Passwords are case-sensitive; be sure to use the correct combination of upper and lower case letters.
If security is off, the
Password field will not be displayed on the Connect dialog box.
- After making your selections, click
OK to start SQLWizard and connect to the specified XDB Server and location.
Note: If the Catalog Browser is set up to load on SQLWizard startup and the location you are trying to connect is an XDB Link location,
a transaction dialog box appears. This dialog box asks you to complete the transaction to free up locks and close queries.
Of the three options the dialog box presents you with, Commit and Rollback free the locks, while Proceed keeps them in place.
Keeping the locks interferes with other DB2 users who are attempting to perform Data Definition Language (DDL) SQL statements.
If you enter your AuthID or password incorrectly, an error message is displayed. You have three chances to enter the correct
AuthID and password.