4. Creating a Database and Loading Data : Connect to or Disconnect from a Database
Share this page                  
Connect to or Disconnect from a Database
To connect to a database and enter SQL commands, you can use the line-based Terminal Monitor or Actian Director.
(Actian Director is a graphical interface that lets you interact with Vector installations and perform tasks like importing data, querying data, and administering databases. You can download it from http://esd.actian.com/.)
To connect to the local database using the Terminal Monitor
1. Issue the sql command:
sql dbname
where dbname is the name of the database.
The Terminal Monitor starts.
2. Type your SQL statements at the Terminal Monitor prompt.
3. Enter \g to execute the statements.
To disconnect from the database and exit the Terminal Monitor
Enter \q.
For more information about using the Terminal Monitor, see the SQL Language Guide.