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