CA-Easytrieve Reporting and File Manipulation

Case Training
Bristol, Edinburgh, Leeds, London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

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.

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.

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
...''

Phone:01275 859666

School Address:

+ 44 (0) 1275 859666

Jobs & Resumes: Bristol, Edinburgh, Leeds, London
Houses & Roommates: Bristol, Edinburgh, Leeds, London

Advanced JavaScript
Batch Programming with CA-TELON
Building DB2 Stored Procedures
Programming with C
C# Programming Workshop
CA-Easytrieve Basic Reporting
CA-Easytrieve Consolidation
CA-TELON Advanced Programming
CICS Introduction for Programmers
CICS for Applications Programmers (using VSAM)
COBOL
DB2 Advanced Programming
DB2 Application Data Recovery
DB2 Application Performance and Tuning
DB2 Development for Applications Programmers

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!