GT10 - CA-Easytrieve Reporting and File Manipulation - 3 Days


Course Description

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.

View Dates

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.


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

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.

On-site course enquiry (from £165 pp per day)

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.


Availability

Course Enquiry