Running SQL statements

Important: IBM Cloud Pak® for Data Version 4.7 will reach end of support (EOS) on 31 July, 2025. For more information, see the Discontinuance of service announcement for IBM Cloud Pak for Data Version 4.X.

Upgrade to IBM Software Hub Version 5.1 before IBM Cloud Pak for Data Version 4.7 reaches end of support. For more information, see Upgrading IBM Software Hub in the IBM Software Hub Version 5.1 documentation.

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.