User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 12-35
•
To disable the option for all tables, click on
SetRecompileOptionToNo. The Recompile changes to N in all
tables.
2. Enable or disable the All Columns option:
• To enable or disable the option for one table, click on the All
Columns field for the table. The value of the All Columns field
changes to Y if it was N and vice versa.
• To enable the option for all tables, click on
SetAllColumnsOptionToYes. The All Columns field changes to Y in
all tables.
• To disable the option for all tables, click on
SetAllColumnsOptionToNo. The All Column changes to N in all
tables.
Perform the Update
To perform a statistics update, click on one of the following:
• Execute. Executes the command immediately.
• Show. Displays the SQL commands created by dba/m Database
Manager without executing them.
• Queue. Queues the command to be submitted in a batch later.
Invoking a Table
The invoke table function allows you to create the DDL of a table for the
following languages: SQL, TAL, COBOL, or C.
To display the Invoke Table window, click on Tables in the Main window,
then click on Invoke. The Invoke Table window is displayed, as shown in
Figure 12-25.