File-Aid For DB2 OS 390 & z Os Course

Course Code: RT 452
Course Abstract:

This course teaches the use of File-AID and manipulating DB2 Tables and other DB2 Objects. The class attendees are guided through the File-Aid menu structures and capabilities.  Record selection, browsing, and editing DB2 tables are discussed in detail as well as using File-Aid to analyze SQL statements.
Audience:

This course is designed for programmers, operations personnel and system analysts who need hands-on guidance working with the File-Aid DB2 product.
Duration: 1 day
Learning Outcomes: Upon completion of this course, the participant will be able to:
> Edit and browse DB2 tables
> Discuss the features of File-Aid
> Change Default settings
> Use Record selection to retrieve only certain rows
> Display DB2 catalog information
> Analyze SQL
> Create, Drop, Alter DB2 Objects
> List DB2 Objects
> Run SPUFI from File-Aid
> Review DB2 Privileges
> Extract and Load Tables
Course Topics:

DB2 Tables
File-Aid Features
DB2 Catalog Information
DB2 Objects
SPUFI and File-Aid
DB2 Privileges
Table Extractions and Loading
Prerequisites: Familiarity with TSO/ISPF and DB2 is required.
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning

Testimonials

(Instructor) was great. Her knowledge of the subject and ability/desire to focus on our needs was phenomenal. We gained so much from those two days. I have already spoke with my boss (Director of IT) about some needed changes and access rights to allow us to be a much more productive group. Some of the things (instructor) showed us and helped us with will allow us to reduce the number of man hours required for one of our primary functions by 3 to 4 hours per event.