Inserting a table row

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:

  1. On the OAT menu, expand SQL Toolbox, and then click Query By Example.
  2. 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.

  3. Click the Insert tab.
  4. Type the values in the fields.
    Tip: Hover help for each field identifies the required data type, for example, CHAR, DECIMAL, or DATETIME.
  5. Click Add Row.

    The row is inserted in the table on the database server.

Copyright© 2018 HCL Technologies Limited