The following table shows characteristics of CA 2E access paths:
|
Access Path Type |
Real Fields |
Key Fields |
Virtual Fields |
Virtual Keys |
|
PHY (Physical) |
Yes |
No |
No |
No |
|
UPD (Update) |
Yes |
Relation |
No |
No |
|
RTV (Retrieval) |
Yes |
Relation |
Yes |
No |
|
RSQ (Resequence) |
Yes |
User |
Yes |
No |
|
QRY (Query) |
Yes |
User |
Yes |
Yes |
|
SPN (Span) |
Yes |
User |
Yes |
No |
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |