Menu Bar

The menu bar also allows you to access more functions essential to Netezza.

Query → Wordwrap

Click this to force your text to wrap within the query text editor.

Query → Current options

From here you can turn off/turn on syntax highlighting. You can also set the time limit for query timeouts, this is in seconds.

Object Menu

The object menu allows you to access all of the functions associated with the objects described above. Select the object and then click on the desired command from the Object menu.

Tools → Sql Dump Runner

The SQL Dump Runner allows you to run each query in a debug mode.

Tools → Reverse Engineer Database

This command is similar to the Script Database command except that you must provide the connection information that database you want to reverse engineer.

Tools → Compare Database Schema

Select any two databases and click Compare to get started. After the comparison has completed running you will see something similar to the following:

Objects highlighted in red are missing or different from the other schema. Clicking the Alter Script button for the respective window creates a sql scripts file which will reconcile any differences with the other database.

Please note this command will not create any insert statements to rectify changes in the data.

Tools → Options

Completely customize the Aginity Netezza Workbench via the Options menu. Some options of interest:

General

Set the default query time here. You can also adjust the number of files shown in Most Recently Used file menus.

Fonts and Colors

Here you can customize how your queries and syntax highlighting look.

Query Analyzer Defaults

From this menu, you can adjust object browser settings, the number of results returned from a query, and enable syntax highlighting. You can also change the format of the date fields that are returned in the results window.

Query Analyzer Data import/export

From this menu, you can adjust the default settings for importing and exporting data.