Running SQL statements

About this task

You can use the SQL editor feature to execute SQL statements and scripts against the database.

Procedure

To run SQL statements:

  1. Access the console.
  2. From the navigation menu, select Admin > SQL editor.
  3. From Databases drop-down, select the database on which you want to execute the query.
  4. Write your SQL statement (By default, SQL Editor contains SELECT statement with table name selected in Tables dropdown).
  5. Click on Run button to execute the SQL statement.
    Running SQL statements
  6. For more information on SQL, see the SQL reference in the Informix documentation.
    Note:
    1. Currently data from SQL statement is fetched 20 records at a time. Click on Load more button to load next 20 records and so on.
    2. Load more button will be only visible if SQL statement returns more than 20 records.