CA Easytrieve

Duration: 
3 days
Codes: 
CA
Versions: 
NULL

Overview

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.

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.

Course Outline

  • 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
  • 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 Input
  • Before Break
  • After BreakBefore Line
  • After Line
  • Endpage
  • Termination
  • Macros
  • Instream MacrosSubstitution Parameters
  • Substitution Parameters – Examples
  • Field Name Prefixes
  • Single Quote Substitution
  • 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
  • Special If Tests
  • Matched Records
  • Duplicate Records
  • File Presence Tests
  • Sample Matching Programs
  • Odds & Ends
  • Reserved Words
  • Stop
  • Call
  • Bit Testing
  • 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

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Glasgow
Glasgow3 3750 £3750 2019-09-18
Midlands
Birmingham3 2500 £2500 2019-09-18
Manchester
Manchester3 3750 £3750 2019-09-18