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.