You are in Home > Information Technology > Programming > Programming Techniques >

File-AID for DB2 - 1 Day

This course provides the applications programmer with an in-depth knowledge of File AID for DB2. It is aimed at programmers who need to code or support DB2 application programs written in COBOL, PL1 or C.

Pre-requisites

The delegate should be familiar with the OS/390 host environment, together with a working knowledge of DB2, SQL and using TSO / ISPF.

Course Objectives

The aim of this course is to provide the programmer, familiar with DB2, with the necessary skills required to define, access and manipulate DB2 data, using File-AID for DB2.

On completion of this course the student will be able to:

• define and set the user parameters for File-AID for DB2
• set up a DB2 test environment, using correctly defined tables, views, indexes, synonyms and aliases using File-AID for DB2
• define and maintain Referential Integrity using File-AID for DB2
• define and maintain Table Check Constraints using File-AID for DB2
• define and maintain DB2 security using File-AID for DB2
• selectively copy data from one table to another
• browse and edit the data on a table
• use the Object List to display and maintain DB2 objects
• use the Privileges Utility to display and maintain privileges against DB2 objects
• use the File-AID for DB2 SQL LOAD utility to populate tables
• use the IBM LOAD utility to populate tables
• use the Impact Analysis Report to determine the effect of a change in column size or type
• use the SQL Analysis and Development utility to improve SQL performance
• produce reports of either data or audit information
• maintain referential integrity and application integrity

Course Environment

Development will be performed using:

IBM Mainframe

Course Format

The course contains many practical exercises to ensure familiarity with the product. Initially students create Tables and Indexes, and then proceed to load and access the data held on the DB2 Tables. They then proceed to perform various utilities against the data and DB2 objects. On completion of this course students will have the necessary skills required to define, access and manipulate DB2 data and DB2 objects, using File-AID for DB2.

The comprehensive Student Guide supplied is fully indexed serving as a useful reference tool long after the course has finished. Delegates will also be able to access a free help-line with technical questions relating to topics covered on the course.

For further details and booking enquiries, telephone: 01275 859666 or visit:: www.casetraining.co.uk

Contact Case Training