CA Easytrieve Reporting and File Manipulation

Course 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

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 Environment

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.