Download AGINITY WORKBENCH FOR NETEZZA FUNCTIONALITY OVERVIEW

Transcript
CONTENTS
1.
Overview ......................................................................................................................................... 4
2.
Database Connection Dialog Box...................................................................................................... 6
3.
Main Window of Aginity Workbench ............................................................................................. 10
3.1.
Object Browser ...................................................................................................................... 10
3.2.
SQL Editor .............................................................................................................................. 12
3.2.1.
Adding a New Tab in the SQL Editor ................................................................................ 12
3.2.2.
Accessing SQL Statement Management Functions .......................................................... 12
3.2.3.
Inserting a Object/Column Names into the SQL Editor .................................................... 13
3.3.
Result Set ............................................................................................................................... 13
3.3.1.
Managing Grid View ....................................................................................................... 14
3.3.2.
Exporting the Query Execution Result ............................................................................. 15
3.4.
Menu Bar and Toolbar............................................................................................................ 15
3.5.
Status Bar............................................................................................................................... 15
4.
File Menu ...................................................................................................................................... 16
5.
Edit Menu ...................................................................................................................................... 19
6.
Object Menu .................................................................................................................................. 24
7.
8.
6.1.
Functions Provided by the Object Menu ................................................................................. 24
6.2.
Viewing Database Space......................................................................................................... 30
Tools Menu.................................................................................................................................... 33
7.1.
Importing Data to the Database ............................................................................................. 44
7.2.
Using a 3-rd Party File Diff Tool in Workbench ........................................................................ 47
7.3.
Using Database Highlighting ................................................................................................... 49
Query Menu .................................................................................................................................. 51
8.1. Using Parameter Substitution ..................................................................................................... 56
CONFIDENTIAL AND PROPRIETARY, AGINITY LLC.
DISTRIBUTE WITHOUT PRIOR AUTHORIZATION.
DO NOT
2