Query By Example
Use this page to perform these standard SQL operations on a table: query, insert, update, and delete. Create a simple query to display specific rows in a table, and then update or delete rows, or insert new rows in a table.
The page displays a list of the databases in the database server.
Search
To find a table, type any part of the table name in the field, and click Search. You can also expand a database to display the tables.
Query
This page displays the columns in the selected table and the server to run the query on. You can run the query on the local server, a grid, or a region. You define grids and regions in the page. To run a query on a grid or a region requires Informix® 12.10.
To enter query criteria, click the button by a column to open the Enter query criteria page.
To perform the query, click Submit. If you perform the query without entering any query criteria, all the rows in the table are returned.
To edit the query criteria for a column, click the button by the column.
Enter query criteria
Use this page to enter query criteria for the selected column.
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.
When you click OK, the page closes and the query criteria are displayed for the column.