CA Easytrieve Consolidation

Course

In Edinburgh

£ 800 + VAT

Description

  • Type

    Course

  • Location

    Edinburgh (Scotland)

  • Class hours

    2h

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. Suitable for: 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.

Facilities

Location

Start date

Edinburgh (Midlothian/Edinburghshire)
16 St. Mary'S Street, EH1 1SU

Start date

On request

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

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


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 Environment

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.

CA Easytrieve Consolidation

£ 800 + VAT