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



Server, Database and Table's functions of the Object menu can also be accessed by right clicking any object in the object browser and selecting any function from the drop-down menu. This process and functions are described on the Main window page. Please note, that commands are only shown in the menu if they are relevant to the object. Below is the description for all the functions.

Functions specific to Server type:

• Show Disk Usage - shows disk usage information grid (SPU ID, Total MB, Used MB, Disk Usage, etc.)
• Server monitor - allows server monitoring (GP States, Process, Disk Free Space, etc.)
• Open SSH terminal - opens a new window to connect to SSH terminal.
• Refresh - refreshes status of all servers in the object browser.

Functions specific to Database type:

• Refresh DB list - refreshes the list of all databases in object browser.
• Comment on Database - adds a comment for the selected database.
• 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.
• Show User Sessions - brings up a Session List window with a grid showing all users connected to the server.
• Show Query History - shows all executed queries history. This option also allows different setup parameters to be added to the displayed result.
• Show Tables Size - brings up a new window with detailed description (i.e. Data and Processing Skew) of currently selected database tables.
• View - changes databases view mode.
• Analyze DB Schema - performs various data checks including: uniqueness of data, referential integrity and bad table distribution.
• Analyze DB Data - performs analysis of the data table content in order to suggest improvements to the: nullability of fields that allow nulls, minimizing the row size by using minimum precision for columns and minimizing the size character columns.
• Groom Database - choose this option if you want to permanently delete the previously deleted records from the server.

Functions specific to Table:

• Refresh Table List - refreshes the list of tables for currently selected database.
• Script - generates basic select, insert, update and DDL commands to either be pasted to the query window or to your clipboard.
• Data Review - executes a select script requesting the top 100 records, or duplicate records.
• Advanced - shows advanced options for selected table (Reclaim, Groom, Change Distribution, etc.).
• Charts - shows frequency distribution chart.
• Edit Comment - makes notes of changes and modifications. Comments are also available for table columns. They are editable via the Workbench and SQL queries.
• Refresh Columns - refreshes columns in the selected table.
• Show Distribution - visualizes how your data is distributed over the SPUs in your system.Data in blue is live data, red is data that has been deleted but is yet to be reclaimed.
• Show Storage - shows information on table's storage details by Table and Data Slice. 
• Import/Export Data - imports and exports table from/to external text files. It allows you to customize the operation around the way your data is formatted, including date, null, and binary formatting.

Functions specific to View:

• Refresh View List - refreshes view list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• Data Review - executes a select script requesting the top 100 records.
• Charts - shows frequency distribution chart. The program will ask you to select a table column for frequency distribution plot.
• Create View - inserts 'Create or Replace View...' SQL command preset to new SQL editor window for fast and easy view creation.
• Edit View - inserts 'Create or Replace View...' SQL command to new SQL editor window with all the data from currently selected view.
• Edit Comment - allows to add/edit description of the selected view.
• Refresh columns - refreshes columns of the selected view.
• Export Data - opens 'Export Data' window, prompting the user to specify different parameters to export the view.

Functions specific to Sequence:

• Refresh Sequence List - refreshes sequence list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• Edit Comment - allows to add/edit description of the selected sequence.

Functions specific to Stored Procedures:

• Refresh Stored Procedures List - refreshes external table list in the selected database.
• Script - generates select, insert statement or DDL commands to either be pasted to the query window or to your clipboard.
• Create Procedure - the Stored Procedure Properties window pops up. You can specify the new procedure’s name, language and arguments here.
• Edit Procedure  - allows you to edit any stored procedure.
• Edit Comment - allows to add/edit description of the selected procedure.

Functions specific to External Table:

• Refresh External Table List - refreshes external table list in the selected database.
• Script - generates select, insert statement or DDL commands to either be pasted to the query window or to your clipboard.
• Refresh Column  - refreshes columns of the selected external table.

Functions specific to Materialized View:

• Refresh Materialized View List - refreshes view list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• Data Review - executes a select script requesting the top 100 records, also can find duplicate records.

Functions specific to User Defined Functions:

• Refresh UDF list - refreshes user defined function list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• New - allows you to create a user-defined function. Fill in the 'Function Properties' form, click OK. 
• Edit UDF - allows you to edit a the selected user-defined function.
• Edit Comment - allows to add/edit description of the selected user defined function.

Functions specific to User Defined Aggregates:

• Refresh UDA list - refreshes user defined aggregates list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• New - allows you to create a user-defined function. Fill in the 'Function Properties' form, click OK. 
• Edit UDA - allows you to edit the selected user-defined aggregates.
• Edit Comment - allows to add/edit description of the selected user defined aggregates.

Functions specific to Synonyms :

• Refresh synonym list - refreshes user defined aggregates list in the selected database
• Edit Comment - allows to edit comments for the selected synonym.
  

Go up  |  Go To WorkBench Help page