User Guide : 8. Using Queries
Share this page                  
Using Queries
About Using Queries
Object Naming Rules
Create a New Query
Query Options Dialog
Query Status Bar Fields
Open an Existing Query
Find or Replace Text in a Query
Save a Query
Close a Query
Specify Default Output Format and Location for Query Results
Specify Output Format for Query Results
Specify Fonts Used in Queries and Results
Execute a Query
Cancel a Running Query
Copy Query Results
Save Query Results
DBMS Trace Message Display
Recording 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