Database Object Browser
This window allows you to fully browse any database you create in Netezza as well as to access database and table-specific functions.
By right-clicking a database or table you can access functions specific to each object.
Functions specific to each object type:
Database Functionality
Edit Comments
Comments allow you to make notes of changes and modifications. They are editable via the Workbench and SQL queries.
Script Database
This option allows you to publish a sql command file with all of the necessary commands to completely rebuild your database structure.
You can also customize which objects need should be included in the script.
Table Functionality
Data Review → Show Top 100
Executes a select script requesting the top 100 records.
Data Review → Find Duplicates
Generate a script to find the first 100 duplicates in the table. Finding duplicates by primary key is particularly useful since Netezza does not strictly enforce primary key integrity. If the table contains a primary key, only the primary key is used. Otherwise the script will group by each field in the table.
Note: The scripts are not run automatically; you need to execute it yourself.
Script → Select, Insert, and DDL
Generate basic select, insert, and DDL commands to either be pasted to the query window or to your clipboard. The DDL command provides all of the necessary queries to rebuild or copy this table’s structure.
Note: The scripts are not run automatically; you need to execute it yourself.
Edit Comments
Make notes of changes and modifications. Comments are also available for table columns. They are editable via the Workbench and SQL queries.
Advanced → Show Distribution
Visualize how your data is distributed over the SPUs in your Netezza system. Data in blue is live data, red is data that has been deleted but is yet to be reclaimed.
Advanced → Reclaim
Generate a script to irrevocably delete records from the database.
Note: The scripts are not run automatically; you need to execute it yourself.
Import/Export Data
Export and import table from/to external text files. The import/export menu allows you to customize the operation around the way your data is formatted, including date, null, and binary formatting.
Stored Procedures
You can also create and run stored procedures in the Aginity Netezza Workbench.