Application Utilities Menu
The Application Utilities submenu is available from the Applications Catalog and the Edit an Application frame menus. When you select this option, the Utilities submenu takes the place of the frame menu on the menu line.
Image
AppReport
Displays the Application Report frame, where you can generate a summary report on the application which you can save for later use
Ingres/Menu
Calls Ingres Menu, from which you can call any Ingres Tool (including an interactive query language) except ABF without leaving the current ABF session. Exit returns you to ABF. You cannot use Ingres Menu to switch to another database.
VMS: To use Ingres Menu, set your VMS subprocess quota to at least 3.
Shell
UNIX, Windows: Escapes to the operating system prompt.
UNIX: This is the setting of the environment variable $SHELL. If $SHELL is not set, escape to the Bourne shell (/bin/sh). Exit returns you to ABF.
Spawn
VMS: Escapes to spawn new DCL process. At exit, return to ABF.
LockStatus
Displays the Lock Administration frame to review or change an application's lock status
Cleanup
Reviews and clean up database system tables. Available to DBA only.
Destroying an application or frame does not remove all of the information about the destroyed object from the extended system catalogs. This unused data can affect performance, but otherwise causes no loss of functionality. You can create a new frame or application using the same name as a deleted one.
To remove this unused data, use the Cleanup operation or run the sysmod utility.
ConstantsFile
Displays the Specify a Global Constants File frame to select an alternate constants file to be used in the application. From this frame, you can also create a constants file based on the default constants or call the system editor to edit a constants file. See
Using Alternate Sets of Global Constant Values for more information.
Help, End
Perform standard operations
Call the Tables Utility
As part of the process of creating an application, you must decide on the elements of data you need and establish them in tables. If the database you are using already contains all the data you need, add more tables.
You can use the ABF Application Utilities menu to access the Ingres Tables Utility while you define frames or procedures for the application. You cannot create a new database at this time, however. See Character-based Querying and Reporting Tools User Guide for instructions on how to use the Tables Utility to create new tables or examine existing tables.
To call the Tables Utility
1. Choose Utilities from the Applications Catalog or the Edit an Application frame.
2. Choose Ingres/Menu.
3. Choose Tables.
The Tables Catalog frame appears, listing the tables in the database.
4. To leave the Tables Utility, select End on the Examine a Table frame, the Tables Catalog frame, and the Ingres Menu. You return to the Applications Catalog or the Edit an Application frame.
Note: Visual DBA provides an alternate way of creating and managing tables.
Last modified date: 08/28/2024