Topics:

• Creating Master and Access Files
• Master Files
• Access Files
• The OCCURS Segment

In order to access a table or view using FOCUS, you must first describe it in two files, a Master File, and an associated Access File.

Note: The term table in this manual refers to both RDBMS base tables and views.

The Master File describes the columns of the RDBMS table using keyword-value pairs in comma-delimited format (see Master Files). The Access File includes additional attributes that complete the FOCUS definition of the RDBMS table (see Access Files). The adapters require both descriptions to generate SQL queries.