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