Skip to main content
COMPUTER  AND  SOFTWARE  EDUCATION   
HOME
VIEW FULL PUBLIC COURSE SCHEDULE
CONTACT US
COURSE
SEARCH
   Tel: 01275 859666
GT12 - CA-Easytrieve Consolidation
Duration1 or 2 Days (depending on modules chosen) (customisation)
Availability

Course Description

This course is for programmers who have some experience in writing CA-Easytrieve programs, but wish to consolidate certain areas of the language. The course is designed in a modular format and the options to be covered can be selected prior to the start of the course.

Pre-requisites

The delegate should have experience of writing CA-Easytrieve programs and should be familiar with ISPF and JCL.

Objectives

The aim of this course is to fill any gaps in the student’s level of knowledge of the CA-Easytrieve language.

The modules available are shown below. This course will be specifically tailored for use at a site and timings will therefore be dependant on which modules are selected, but as a guide 3 or 4 modules may be covered in a day depending on their complexity.

Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.

Course Details

LIBRARY SECTION REVIEW
Sequential File Definitions
Field Definitions
Working Storage Definitions
Field Types
Headings
Masks
Redefines
Value
Reset
ACTIVITY SECTION REVIEW
JOB Activity
Condition Checking
   IF/ELSE/END-IF Statement
   ELSE-IF
   AND/OR
   Special IF Statement
   CASE Statement
GOTO Statement
STOP
DISPLAY
CALL
User Procedures
START/FINISH Procedures
Assignment Statement
Arithmetic Functions
Move Statement
Move Like Statement
SORT Activity
SORT Procedure
BASIC REPORT REVIEW
Report Spacing Parameters
Report Layout
Name and Address Labels
Report Definition Statements
   Sequence
   Control
   Sum
   Title
   Heading
   Line
ADDITIONAL REPORT PARAMETERS
Tally
Sumspace
DTLCTL
SUMCTL
Summary Reports
Summary Files
Printer Parameter
ARRAY PROCESSING
DO WHILE Statement
DO UNTIL Statement
Array Processing
Subscripts
Indexes
REPORT PROCEDURES
S Type Working Storage
Report Input
Before Break
After Break
Before Line
After Line
Endpage
Termination
MACROS
Use of macros
Sample 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
Look-up Tables
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
DECLARE CURSOR
OPEN CURSOR
FETCH CURSOR
CLOSE CURSOR
SQL Controlled Updates
UPDATE
INSERT
DELETE
SYNCHRONISED FILE PROCESSING
Special If Tests
Matched Records
Duplicate Records
File Presence Tests

Course Format

The course uses a combination of lectures and practical exercises to ensure familiarity with the product. Each module will be followed by an exercise, using features introduced during the lecture session. Students will have the opportunity to discuss any particular queries they have concerning CA-Easytrieve will the instructor.

On completion of this course students will be more confident in their use of the language. 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.