SQL Implementation › Separate View and Index Creation › Edit Access Path Auxiliaries Panel

Edit Access Path Auxiliaries Panel

Because an SQL index is considered to be an access path auxiliary, this panel provides a method to suppress index generation. To suppress the generation of the SQL index, either enter *NONE in the name’ field or leave it blank. In both cases, the index will not be generated, regardless of the Maintenance Option’. As a result, you can create *IMMED DDS access paths and also suppress generation of an SQL index.

EDIT ACCESS PATH AUXILIARIES           SYMDL                                   
                                                                               
File name . . . . . . . . : Customer                                           
Access path name. . . . . : Retrieval index                                    
Source library. . . . . . : SYGEN                                              
                                                                               
                                                                               
SQL access path auxiliaries :                                                  
? Src member Type  Text                                                        
  UUADREL1   RTV   Customer                Retrieval index                     
                                                                               
                                                                               
  Index Name Type  Text                                                        
  UUADREL1I   IX1  Index SQL DDL LOCATED IN : UUADREL1                         
                                                                               
                                                                               
                                                                               
SEL: e-STRSEU.                                                                 
F3=Exit                                                                        

Note: The name’ is automatically set to *NONE when the Maintenance Option’ is either R or D. You cannot use this facility to create a REBLD or a DELAY DDS access path and also create an SQL index.