Start of change

DSNTIP72: SQL OBJECT DEFAULTS PANEL 3

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

Start of change
Figure 1. SQL OBJECT DEFAULTS PANEL 3: DSNTIP72
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 index-controlled table spaces and indexes:                   
  3  PREVENT ALTER LIMITKEY   ===> NO       Disable alter limit key for index-  
                                            controlled partitioned table spaces 
  4  EXCLUDE PART KEY COLUMNS ===> YES       When converting index-controlled    
                                            partitioned tables to table-        
                                            controlled partitioning (NO, YES)   
                                                                                
 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):                                                 
  5  RENAME TABLE             ===> DISALLOW_DEP_VIEW_SQLTUDF                    
                                                                                
                                                                                
                                                                                
                                                                                
 PRESS:  ENTER to continue   RETURN to exit   HELP for more information
End of change
End of change