CA-Easytrieve

AUDIENCE: This course is for all staff associated with applications development in the IBM zSeries Enterprise Server (z/OS) environment.
PREREQUISITES: An understanding of applications development for IBM Enterprise Servers is required. This should have been gained in the workplace or through comprehensive training. Attending our courses z/OS for Beginners, TSO/ISPF Workshop, z/OS JCL and either COBOL, PL/1 or Assembler is highly recommended.
DURATION: 3 days. Hands on.
OBJECTIVES: On successful completion of this course each student will be able to:
Describe the structure and flow of operation of an Easytrieve job.
Code FILE statements for QSAM and other files used.
Use macros in data definitions.
Distinguish between compiled and interpreted Easytrieve programs.
Given a record description, code the FILE definitions needed by Easytrieve.
Code a REPORT definition for sequenced data.
Code TITLE, HEADING, and LINE definitions.
Use processing statements to control the flow of execution.
Match/merge two sequential input files to produce a single output file.
Produce extract files.
Code processing statements which assign values to data fields.
Code statements which process records from VSAM and QSAM files.
Define and process in-stream tables.
Define and process indexed tables.
Code SEARCH statements to process tables.
Define and use report procedures.
List the JCL statements needed to run Easytrieve programs.
COURSE CONTENT:
Getting Started
Introduction
Structure of an Easytrieve program
FILE, JOB, REPORT
Simple examples
JCL requirements
Compilation process and options
LIST
PARM statement
Syntax rules
Continuation rules
Comments
Processing cycle.

Defining Data
The FILE statement
System-defined fields
Creating files
Use of asterisk in fieldnames
Categories A, N, P, U, B
Edit masks
Working Storage fields
Categories W and S
System-defined fields.

Producing Reports
REPORT statement
Standard, label, and sequenced reports
CONTROL reports
TITLE, HEADING, LINE; SUM
SORT statement and its use
Alternate column headings
Printer files and corresponding JCL

Basic Processing Statements
JOB and SORT activities
Assigning values
Arithmetic
MOVE
Testing conditions
IF, DO WHILE, GOTO, PERFORM, CASE, STOP, DISPLAY, PRINT
Defining PROCs.

Handling files
QSAM and VSAM files
READ, WRITE, GET, PUT, DISPLAY, POINT, PRINT
Testing for end-of-file
File status
Reformatting records
Extract files
Sort,
Match/merge
Virtual files.

Table Handling
In-stream tables
External tables
Indexed tables
OCCURS, INDEX, SEARCHing tables
Working with variable length records and segmented data.

Advanced processing
PERFORM, START, FINISH
Controlled input
Bit manipulation
Creating and using macros
Calls
Producing percentages
Report procedures
Performance considerations.