CA Easytrieve

CA Easytrieve

Audience

This course is for all staff associated with applications development in the IBM zSeries Enterprise Server (z/OS) environment.

Prerequisites

Before attending this course, the delegate should have an understanding of the development cycle in the IBM mainframe environment.

Familiarity with ISPF, SDSF and JCL would be an advantage, together with experience of a programming language, such as COBOL or PL/1.

Duration

3 days. Hands on.

Course Objectives

This course provides theoretical and practical knowledge of the Advantage CA-Easytrieve Plus programming language for the IBM mainframe environment. Once the training course is complete, the programmer will immediately be able to develop and maintain CA-Easytrieve Plus programs in a live environment.

The course will include lectures given by the instructor, discussions within the class, and practical sessions where each delegate will write and test programs. The delegate’s workbook includes all the lecture notes, practical exercise questions and spare notepaper.

By the end of this course, the delegate will be able to:

  • Understand the structure of a program.
  • Access data held in a variety of file and database formats.
  • Create simple and complex reports using automatic and controlled formatting.
  • Create extract files of various types.
  • Control the flow of processing in a structured way.
  • Create and use macro code.
  • Use the match/merge algorithm within the language.
  • Write, run and debug several programs.

Course Content

Getting Started
Which name
Easytrieve Capabilities
Running programs
Sample JCL
Syntax Conventions
Program Structure
Environment Section
Library Section
Activity Section
Sample Program
Sample Output

Run-time Environment
PARM Statement
PARM Parameters

Defining Data
File Definitions
Field Definitions
Working Storage
Field Definition
Examples
Headings
Masks
Use of Masks
Results of Masks
Mask Examples
Default Masks
Copy
Relative Start Location
Redefines
Value
Reset

Basic Processing
JOB Activity
Automatic Input
Processing Cycle
Condition Checking
If/Else/End-If
Else-If
And/Or
Special IF
Case
Go To
Assign
Move
Move Like
Display
Print

Reports
Report Parameters
Report Parameter Defaults
Report Layout
Testing Parameters
Labels
Report Definition Statements
Sequence
Control
Sum
Title
Heading
Line

Customizing Reports
Tally
Additional Report Parameters
Report Parameter Defaults
Sumspace
Dtlctl
Sumctl
Summary Reports
Printer

Structured Logic & Arrays
User Procedures
START/FINISH Procedures
DO WHILE Statement
DO UNTIL Statement
Arrays
Subscripts
Indexes

Report Procedures
S Type Working Storage
Report Procedures
Report Input
Before Break
After BreakBefore Line
After Line
Endpage
Termination

Macros
Macros
Instream MacrosSubstitution Parameters
Substitution Parameters – Examples
Field Name Prefixes
Single Quote Substitution

File Access
File Access
Get
Put
VSAM Files
VSAM Parameter defaults
Point
Read
Write
File Status
VSAM File loading
Virtual Files
Card
Comma Delimited
Summary Files
Summary ‘Ranking’ Reports
Tables
SORT Activity
SORT Procedure

Synchronised File Processing
Synchronised File Processing
Special If Tests
Matched Records
Duplicate Records
File Presence Tests
Sample Matching Programs

Odds & Ends
Reserved Words
Stop
Call
Bit Testing

DB2 Access
DB2 Access
SQL Rules
SQL Communications Area
Defining Host Variables
INCLUDE Statement
Static SQL
Programming Methods
Specifying Automatic Input
Automatic Input – Select Statement
Automatic Input – SQL keyword
Automatic Input – SQL File
Automatic Input – Both
Automatic Input – Using START PROC
Automatic Input – Multiple Tables
SQL Controlled by Programmer
SQL Controlled Updates
Update via cursor61
UPDATE
INSERT
DELETE
Dynamic SQL – Execution JCL
Static SQL – Compile and Bind Procedure
Static SQL – Execution JCL

Exercises
8 Essential exercises
6 Optional exercises

Virtual Courses

ALL of our courses can be delivered virtually. And our Bath public schedule of courses are now available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at: www.zoom.us/test

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...