Using Easytrieve Plus (3 days)

Designed for: Programmers and Operations support staff

Primary Objective: To use Easytrieve to create reports for VSAM, QSAM, and DB2 data

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.

Producing reports
REPORT statement; standard, label, sequenced reports; CONTROL reports; TITLE, HEADING, LINE; SUM; SORT statement and its use; alternate column headings; long form of date.

Basic processing statements
Assigning values, arithmetic, MOVE, testing conditions: IF, DO WHILE, GOTO, PERFORM, STOP; defining PROCs.

Handling files
 
QSAM and VSAM files; READ, WRITE, GET, PUT, DISPLAY, POINT, PRINT, testing for end-of-file, file status.

Table handling

In-stream tables; indexed tables: OCCURS, INDEX, SEARCHing tables.

Advanced processing
PERFORM, START, FINISH, sort considerations, bit manipulation, using macros, calls; report procedures; using S fields to produce percentages.  DB2 interface.

Easytrieve, SELCOPY

Home Page  |  About Oakwood  |  OS/390, JCL, DB2, CICS, VSAM, REXX  |  VSE/ESA, JCL, POWER  |  UNIX, Scripts, INGRES  |  COBOL, PL/1, Assembler  |  3rd Party Software  |  New Graduate Schemes

oakcomp@globalnet.co.uk