Previous Topic: YSQLWHR Model ValueNext Topic: YDBFACC Model Value


Direct Table Access

If an access path and the table over which it is based contain the same fields, it is generally more efficient to access data directly from the table rather than through a view. The Database Access Method (YDBFACC) model value and an option on the Edit Access Path Details panel let you specify which method is most appropriate for your environment.

Current implementation of DDL, allows database access method of *TABLE only.

Note: Direct table access is not supported for DRDA (Distributed Relational Database Architecture) Applications.