SQL Editor

Use the SQL Editor to send ad hoc queries to the database. This is only supported by databases that include a Data Manipulation Language (DML).

To open this tool, choose Main Menu ( ≡ ) > Edit SQL

You can connect to databases that support SQL, and to some others to a limited extent. For more information on the extent of support, see the DBMS connector documentation for your DBMS.

SQL Workbench

SQL Workbench

Fields

  • Data Path—DBMS or network path used to access the data. If you enter an incorrect path assignment on this form, an implicit and immediate apexit is generated; that is, you exit the application immediately.
  • SQL Command—SQL command to execute. Do not use a semicolon when entering the command. SQL statements that exceed 2 kilobytes are truncated.
  • DBMS Output—query results.

Related Topics