Insert a row in a table on the database server by using
Query By Example in the HCL OpenAdmin Tool (OAT) for Informix®.
To insert a row in a table on the database server:
- On the OAT menu,
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:
BYTE, TEXT, BLOB, CLOB, NCHAR, NVARCHAR, SET, MULTISET, LIST, ROW,
DISTINCT TYPES, and UDTs.
The columns in the selected table
are displayed on the Query page.
- Click the Insert tab.
- Type the values in the fields.
Tip: Hover
help for each field identifies the required data type, for example,
CHAR, DECIMAL, or DATETIME.
- Click Add Row.
The
row is inserted in the table on the database server.