Database - SQL Tab


In BBj 13.0 and higher, the Enterprise Manager Java app has been superseded by a new browser Enterprise Manager and Eclipse plug-in. See Enterprise Manager - Database: SQL.

SQL Tab

The SQL tab provides a way to execute an SQL statement against the selected database. When a statement is executed, the status of the process shows in an informational text area below the SQL text. This area also shows the elapsed time when the statement is complete.

 

Database

Select the database to use to execute the SQL statement.

Prefetch Size

The number of records that the driver will "prefetch" from the server and store in memory when executing a statement.  This setting is particularly useful for tuning ODBC and JDBC driver performance when the connection is made over a high latency connection.

SQL Statement

The SQL statement to execute.  SELECT statements populate a GUI table with the results of the SELECT statement.  Stored procedures (CALL statements) return a status result, or a result set.  When they return a result set, the table below displays the results in the same was as a SELECT statement.  UPDATE, DELETE, INSERT, DROP, ALTER, etc are all supported statement types as well. When using statements that do not return a result set, the number of records affected (if applicable) will show up in the informational area when the statement is complete.

Execute

Executes the statement in the SQL Statement area.

Execute in Window

Executes the statement in a new window so that the results of multiple statements are available for comparison at the same time.

Load SQL (12.0+)

Opens a file chooser on the client side to select a plain text file to open in the SQL Statement area.

Save SQL (12.0+)

Opens a file chooser on the client side to specify a file where the contents of the SQL Statement area will be saved.

Copy

Copies the contents of the SQL Statement area to the system clipboard.

Cancel

Cancels fetching of results for a running SQL statement.


See Also

Configuration

Information Tab

Tables Tab

Views Tab

Procedures Tab

Type Definitions Tab

Sequences Tab

Permissions & Roles Tabs

Query Analysis Tab



______________________________________________________________________________________

Copyright BASIS International Ltd. BBj®, Visual PRO/5®, PRO/5®, and BBx® are registered trademarks.