Using Queries
About Using Queries
The query facility of Director lets you use SQL statements to do the following:
Manipulate database objects
Create, modify, and destroy a variety of database objects, such as tables, views, indexes, and database procedures
Manipulate data
Select, insert, update, and delete data in database tables
Manage groups of statements as transactions
Process a group of database statements as a single transaction. Transaction management includes the ability to undo (roll back) a transaction, either in whole or in part.
Perform other database management functions
Set runtime options, copy data between tables and files, modify the characteristics of a database table, and perform many other database management functions.
SQL statements are categorized according to the task performed:
Data Definition Language (DDL)
Creates or deletes objects such as tables, indexes, and database procedures
Data Manipulation Language (DML)
Allows data manipulation in tables
You open existing queries or create new queries using options on the Home menu tab. You execute queries and configure output options on the
Query menu tab (see
Query Tab).
For more information about SQL, see the Ingres
SQL Reference Guide at
http://docs.actian.com/.