SQL/DDL 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.

For DDL implementation, the index is generated with the same name as source member name.

Auxiliaries are not applicable for DDL type file as Views are not created for DDL type file and only Index with the same name as the source member name is created.