File menu consists of common options like shown below. This menu will help you gain access to most basic functions.



Here is the list of all the functions you can access via File menu.

   1.  Connect - allows you to connect to another database and/or server.

   2.  New Query Window - creates new connection instance to the same database/server.

   3.  Open Query Set - opens a set of queries from specified path and adds them to query analyzer window. Each time you open a query set the program will ask you to establish new connection and will open the query in new window.

   4.  Recent Query Sets - shows 10 most recently opened query sets. You can also open any query by selecting it from the drop-down list box. To setup different amount of recently opened query sets to be shown navigate to Tools >> Options >> General settings.

   5.  Save Query Set - saves all tabs currently opened in query analyzer into one query file. If you add new tab and hit select Save Query Set again - it will add this tab to the current query set file.

   6.  Save Query Set As - allows a query set saving with different name/extension.

   7.  Open SQL File - opens a SQL file and adds it to the new  tab in the query analyzer.

   8.  Recent SQL Files - shows 10 most recently opened SQL files by default. To setup different amount of recently opened sql files to be shown navigate to Tools >> Options >> General settings.

   9.  Save Query - saves a query to a local drive.

 10.  Save Query As - allows a query saving with different name/extension.

 11.  Open DDL File - opens a DDL (Data Definition Language) file from local drive. Brings up a new window. You can compare this DDL file with other DDL file and/or database, save DDL file As and Generate a SQL from opened DDL file.

 12.  Recent DDL Files - shows 10 most recently opened DDL files. To setup different amount of recently opened DDL files to be shown navigate to Tools >> Options >> General settings.

 13.  New UDX - allows you to create a new user-defined function (Aggregate, Function or Table Function) using C++ language.

 14.  Open UDX file - allows you to open a previously created UDX file.

 15.  Recent UDXs  - shows 10 most recently opened UDX files. To setup different amount of recently opened UDX files to be shown navigate to Tools >> Options >> General settings.

 16.  Open Query Plan file - allows you to open a query plan file. When opened, a new window will show a query execution plan. It will also show step-by-step actions a server would do to find and process the required data.

 17.  Recent Query Plans - shows 10 most recently opened query plans files. To setup different amount of recently opened query plans files to be shown navigate to Tools >> Options >> General settings.

 18.  Print - prints selected text in the SQL editor.

 19.  Send - select this option if you want to send current query via e-mail.

 20.  Open SPU Utilization Info file - allows you to open an SPU utilization info files. To create the file, select Execute with SPU Utilization monitor from Query menu. Note: the application will ask you for credentials to connect to NPS Linux OS.

 21.  Recent SPU Utilization Infos - shows 10 most recently opened SPU utilization files. To setup different amount of recently opened SPU utilization files to be shown navigate to Tools >> Options >> General settings.

 22.  Exit - exit Aginity Workbench for Netezza.







Go up  |  Go To WorkBench Help page