Create a simple query to display specific rows in a table
by using Query By Example.
You can perform a query on a table, and then review, update,
or delete the rows that are displayed as a result.
To perform
a query:
- On the menu of the HCL OpenAdmin Tool (OAT) for Informix®,
expand SQL Toolbox, and then click Query
By Example.
- To find a table, type any part of the
table name in the Find field, and click Search.
You can also expand a database to display the tables.
Note: The list displays only the tables that you can work with
in Query By Example (QBE). The tables that you cannot work with in
QBE are not displayed, including tables that are system tables or
tables in a system database (other than the sysadmin database)
and tables that contain data types that are not supported by QBE:
BLOB, BYTE, CLOB, DISTINCT TYPES, LIST, MULTISET, NCHAR, NVARCHAR,
ROW, SET, TEXT, and UDTs.
The columns in the selected table
are displayed on the Query page.
- To enter the query criteria, click the button by a column
to open the Enter query criteria page.
- Select an operator from the list of operators, enter a
value, and click Add.
The query
criterion is displayed in the table. When you add another criterion,
first select AND or OR.
- Click OK.
The page
closes and the query criteria are displayed for the column.
- To perform the query, click Submit.
The page displays the rows that result from your query one
row at a time. If you perform the query without entering any query
criteria, all the rows in the table are displayed.
To scroll
through the rows, use the arrow buttons.