User's Guide

Part II. Tutorials

Chapter 6. Using Character-Mode ISQL

ISQL initially is not connected to any database. To connect, type the command

     connect

and press the Execute key.

ISQL prompts you for a number of connection parameters. These include a user identification (user ID), password and database file Type the user ID DBA, then press the Tab key to move to the next field.

Type in the password SQL. The password does not appear when you type it. This prevents someone else from seeing your password.

Press the Tab key again to move to the database file field and enter SADEMO.DB. This is the sample database that you will use in the tutorial.

Now press the Enter key (or click the OK button using a mouse) to connect to the database. If you have made typing mistakes or the sample database is not found, an error message will appear. You can use the tab key to move to the field in error and correct the problem using the cursor keys and the backspace key.

If you have typed everything correctly, the problem could be that the database SADEMO.DB is not in your current directory. You should return to the beginning of this chapter, making sure that the software has been installed correctly and that you have followed the instructions in "Tutorial files".

If you successfully connect to the database, the statistics window displays the message

Connected to database