Target Audience

This course has been designed for programmers who are required to write CA-Easytrieve programs that manipulate files and produce management reports. The language incorporates many built in features to enable reports and files to be formatted simply and quickly. Accessing DB2 Tables using CA-Easytrieve can also be taught on this course if required.

Pre-requisites

The delegate should preferably have some experience of a computing language and be familiar with ISPF. Previous exposure to JCL would be an advantage.

Course Objectives

The aim of this course is to provide the programmer with the necessary skills required to access various file types, manipulate data, produce reports and create files. The various 'automatic' features of the language will be covered in detail enabling the delegate to quickly develop maintainable programs. On completion of this course the student will be able to:

•     read sequential, VSAM, look-up table, card and database files
•     create virtual, sequential, summary and comma delimited files
•     update VSAM and database files
•     format detail and summary reports using automatic and programmer controlled options
•     use report procedures to further manipulate data on reports
•     produce name and address labels
•     use edit masks such as floating money symbols
•     specify conditional logic
•     test for special values such as low-values, high-values, zeros and spaces
•     perform powerful calculations
•     manipulate variables
•     use array processing
•     perform controlled logic loops
•     use a sort activity and temporary files
•     match and merge multiple files on any number of keys
•     create and use code held in macros
•     call programs written in other languages
•     use procedures to structure the program logic
•     write efficient, maintainable programs
•     manipulate the run-time environment of the program

Course Details

OVERVIEW

Introduction To CA-Easytrieve

Input of Source Code

CA-Easytrieve Capabilities

Program Structure

Environment Section

Library Section

Activity Section

Delimiters

ENVIRONMENT SECTION

Parm Statement

Parm Parameter Defaults

LIBRARY SECTION

File Definitions

Field Definitions

Field Types

Headings

Masks

Redefines

Value & Reset

ACTIVITY SECTION

JOB Activity

Condition Checking

IF/ELSE/END-IF Statement

ELSE-IF

AND/OR

Special IF Statement

CASE Statement

GOTO Statement

DO WHILE Statement

DO UNTIL Statement

User Procedures

START/FINISH Procedures

SORT Activity

SORT Procedure

MANIPULATING VARIABLES

Assign Statement

Arithmetic Functions

Move Statement

Move Like Statement

Array Processing

Subscripts

Indexes

Look-up Tables

REPORTS

Report Parameters

Report Layout

Name and Address Labels

Report Definition Statements

Sequence

Control

Sum

Title

Heading

Line

Tally

Additional Report Parameters

Sumspace

DTLCTL

SUMCTL

Summary Reports

Summary Files

Printer Parameter

S Type Working Storage

REPORT PROCEDURES

Report Input

Before Break

After Break

Before Line

After Line

Endpage

Termination

MACROS

Instream Macros

Substitution Parameters

Positional Parameters

Keyword Parameters

FILE ACCESS

Get

Put

VSAM Files

Point

Read

Write

File Status

Virtual Files

Card

Comma Delimited

DB2 ACCESS

SQL Communications Area

Defining Host Variables

INCLUDE Statement

Static SQL

SQL as Automatic Input

SQL as Automatic Input Using START PROC

SQL as Automatic Input With Multiple Tables

SQL Controlled by Programmer

SQL Controlled Updates

UPDATE

INSERT

DELETE

SYNCHRONISED FILE PROCESSING

Special If Tests

Matched Records

Duplicate Records

File Presence Tests

OTHER STATEMENTS

Reserved Words

Commands - Stop, Display, Call

Course Format

The course uses a combination of lectures, discussions and practical exercises to ensure familiarity with the product. The exercises are carried out throughout the course, using features introduced during the lecture and discussion sessions. The programs are run against a sample employee file, and students have ample opportunity to become familiar with the output from the syntax checker. On completion of this course students will be ready to start the development of application programs using CA-Easytrieve. As well as being familiar with CA-Easytrieve code, they will have become proficient at debugging programs. 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.