FOCUS

Synopsis
FOCUS: Accessing External Files shows users how to describe external files to FOCUS.

Audience
This course is for anyone who is interested in learning how to provide an interface for files that are created and maintained through means other than FOCUS.

Time
2 hours

Product Code: FOCS13

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)

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.