After completing FOCUS: Accessing External Files, the user should be able to:

	Create a Master File Description for general categories of external files
	Describe the structure of simple sequential files and multiple record type files
	Distinguish between the MFDs for ISAM and VSAM interfaces
	Code FOCUS MFD for the DB2 and SQL/DS interfaces
	Code Access File Description to access SQL tables from FOCUS

Defining External Files

	Categories
	The ACTUAL attribute

Fixed Format Files

	Simple sequential files
	Multiple record type files

Variable Segment Files

Segments

Other DBMS Files

ISAM and VSAM

Optional Interfaces

DB2 and SQL/DS

This course has the following features:

	A glossary
	A Skill Assessment

	FOCUS: Getting Started (FOCS01)
	FOCUS: Working with FOCUS (FOCS02)
	FOCUS: Basic Report Preparation (FOCS03)
	FOCUS: Creating Simple Reports (FOCS04)
	FOCUS: Creating Complex Reports (FOCS05)
	FOCUS: Additional Reporting Techniques (FOCS06)
	FOCUS: Fundamentals of Graphs (FOCS07)
	FOCUS: Advanced Graph Topics (FOCS08)
	FOCUS: Data Manipulation for Reporting (FOCS09)
	FOCUS: Advanced Screening Techniques (FOCS10)
	FOCUS: Creating File Definitions (FOCS11)
	FOCUS: Adjusting File Definitions (FOCS12)

	FOCUS: Basic MODIFY Requests (FOCS14)
	FOCUS: Segment Modification (FOCS15)
	FOCUS: Complex MODIFY Requests (FOCS16)
	FOCUS: Additional File Maintenance (FOCS17)
	FOCUS: Dialogue Manager and FIDEL (FOCS18)
	FOCUS: More Features of FIDEL (FOCS19)
	FOCUS: MAINTAIN Facility (FOCS20)
	FOCUS: Completing a MAINTAIN Application (FOCS21)