DSNTIP72: SQL OBJECT DEFAULTS PANEL 3

The entries on the DSNTIP72 panel provide options for accessing stopped objects, and options for renaming tables.

Figure 1. SQL OBJECT DEFAULTS PANEL 3: DSNTIP72
Start of change
DSNTIP72            INSTALL DB2 - SQL OBJECT DEFAULTS PANEL 3                 
===>                                                                          
                                                                              
Enter options for implicitly-created table spaces and indexes:                
  1  DEFINE DATA SETS         ===> YES    When creating a table space or index
  2  USE DATA COMPRESSION     ===> NO     When creating a table space         
                                                                              
Enter options for converting index-controlled table spaces and indexes:       
  3  PREVENT ALTER LIMITKEY   ===> NO     Disable alter limit key for index   
                                          controlled partitioned table spaces 
                                                                              
                                                                              
                                                                              
Enter whether to allow or disallow renaming of tables referenced in a view    
definition or the definition of an SQL table function (ALLOW_DEP_VIEW_SQLTUDF 
or DISALLOW_DEP_VIEW_SQLTUDF):                                                
  4  RENAME TABLE             ===> DISALLOW_DEP_VIEW_SQLTUDF                  
 


                                                                             
                                                                              
PRESS:  ENTER to continue   RETURN to exit   HELP for more information        
End of change