When an access path that is to be implemented in SQL/DDL has *IMMED index maintenance, you can press F7 from the Edit Access Path Details panel to access the Edit Access Path Auxiliaries panel. Previously this panel was available only for query (QRY) access paths.
Note: F7=Auxiliaries is not applicable for the DDL implementation.
EDIT ACCESS PATH DETAILS SYMDL File name . . . . . . . . : Customer Attribute . : REF Access path name. . . . . : Retrieval index Type. . . . : RTV Unique or duplicate order : U (U-Unique, F-FIFO, L-LIFO, C-FCFO, ‘ ‘-Undefined) Index maintenance option : I (I-IMMED, D-DLY, R-REBLD) Alternate Collating table : Allow select/omit . . . . : (S-Static, D-Dynamic, ‘ ‘-None) Generation mode . . . . . : S (M-MDLVAL, D-DDS, S-SQL, L-DDL) Source member name. . . . : UUADREL1 Source member text. . . . : Customer Retrieval index Data access method. . . . : (M-MDLVAL, G-DBFGEN, T-TABLE) Format GEN Format text Associated ? Seq name pfx (Based on file) Updated access path 1 FADREA0 AD Customer Update index SEL: Z-Entries, R-Relations, S-Select/omit, A-Assoc.acps, T-Trim, V-Virtualize F3=Exit F7=Auxiliaries F8=Change name F20=Narrative
|
Copyright © 2014 CA.
All rights reserved.
|
|