Querying a Database

You can use the SQL Editor to query a database using ad hoc SQL queries.

The SQL Editor can only be used with databases that include a Data Manipulation Language (DML). For more information on the extent of support, see the DBMS connector documentation for your DBMS.

  1. In the Uniface IDE, choose Main Menu ( ≡ ) > Edit SQL.
  2. In the Data Path field, specify the DBMS or network path with which you are accessing the data.
  3. Enter the SQL command.

    Do not use a semicolon when entering your command.

    Note:  SQL statements that exceed 2 KB are truncated.

  4. Click SQL (or Ctrl+D) to send your query to the database.

    The results of the query are displayed in the DBMS Output field. To view more data, resize the dialog box.

Related Topics