Transcription of Advantage CA-Easytrieve Plus Report Generator …
1 Advantage CA-Easytrieve plus Report Generator Application Guide This documentation and related computer software program (hereinafter referred to as the Documentation ) is for the end user s informational purposes only and is subject to change or withdrawal by Computer Associates International, Inc. ( CA ) at any time. This documentation may not be copied, transferred, reproduced, disclosed or duplicated, in whole or in part, without the prior written consent of CA. This documentation is proprietary information of CA and protected by the copyright laws of the United States and international treaties. Notwithstanding the foregoing, licensed users may print a reasonable number of copies of this documentation for their own internal use, provided that all CA copyright notices and legends are affixed to each reproduced copy.
2 Only authorized employees, consultants, or agents of the user who are bound by the confidentiality provisions of the license for the software are permitted to have access to such copies. This right to print copies is limited to the period during which the license for the product remains in full force and effect. Should the license terminate for any reason, it shall be the user s responsibility to return to CA the reproduced copies or to certify to CA that same have been destroyed. To the extent permitted by applicable law, CA provides this documentation as is without warranty of any kind, including without limitation, any implied warranties of merchantability, fitness for a particular purpose or noninfringement. In no event will CA be liable to the end user or any third party for any loss or damage, direct or indirect, from the use of this documentation, including without limitation, lost profits, business interruption, goodwill, or lost data, even if CA is expressly advised of such loss or damage.
3 The use of any product referenced in this documentation and this documentation is governed by the end user s applicable license agreement. The manufacturer of this documentation is Computer Associates International, Inc. Provided with Restricted Rights as set forth in 48 Section , 48 Sections (c)(1) and (2) or DFARS Section (c)(1)(ii) or applicable successor provisions. 2003 Computer Associates International, Inc. All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies. Contents Chapter 1: Overview Related Program File Environment Definition Library Activity Definition Rules of Statement Environment PARM SYNTAX COMPILE Chapter 2: Library FILE File-name SYSxxx Parameter (VSE Only).
4 2-3 File-type Device-type Record Format Contents iii DEFINE Field-name Location Attributes MASK VALUE Chapter 3: Activity Definition JOB SORT JOB SORT SELECT Chapter 4: Data Manipulation Assignment Arithmetic Chapter 5: Decision and Branching Logic IF Statement DO Statement Conditional Field Relational Field Class Field Series File Presence File Presence Series Record Relational IF, ELSE, and END-IF DO and END-DO DO END-DO Nesting DO GOTO (or GO TO) Statement iv Application Guide Procedure PROC and END-PROC PERFORM STOP Chapter 6: Input/Output Specification Automatic Controlled Database DISPLAY Content and Spacing Rules for PRINT GET PUT PUT POINT Search Value READ WRITE Chapter 7: Report Processing Report Standard Label Report Mailing Label Labels Produced by Mailing Label SEQUENCE Contents v CONTROL TITLE HEADING LINE Report Coding Special-name Report BEFORE-LINE and Chapter 8.
5 File Processing File Control of Record System-Defined Error Data Availability Opening and Closing SAM VFM ISAM Sequential Skip-Sequential Random VSAM File Record Record Record Synchronized File Conditional File Presence File Presence Series vi Application Guide Record Relational Chapter 9: Table Processing Table Instream External SEARCH Chapter 10: IMS/DLI Processing FILE RECORD RETRIEVE Automatic Input with Sweep of a Tickler File Input Definition (Paths)..10-6 Chapter 11: OS/390 and z/OS JCL Sample Short Report Output Mailing Label Output Synchronized File Processing Compile and Link-Edit Load Previously Compiled and Link-Edited Chapter 12: VSE JCL Sample Short Report Output Mailing Label Output Synchronized File Processing Compile and Link-Edit Load Previously Compiled and Link-Edited Chapter 13: Applications Application Program Formatting Contents vii Program Output Inventory Sample Personnel Sample Chapter 14.
6 Basic Examples Employees in Region Proposed Salary Employee Mailing Tally Women's Phone Salary Tally File Average Regional Gross Central Region Inventory Report by Expanded Inventory Error Inventory Inventory File Table Reorder Notification Chapter 15: Advanced Techniques Selected Control Break Summary File Special Report Processing Sorting Input Synchronized File Facility: File Reformat Printed Output from VSAM File Defining and Loading VSAM Data Sets with Alternate Load Base Defining and Building Alternate Indexes and Define Updating a VSAM KSDS Sequentially Reading VSAM File through Non-unique Alternate Updating a VSAM ESDS Deleting and Adding Records of VSAM KSDS GETDATE viii Application Guide CONCAT Processing JCL Chapter 16: Bank System Online Initialize Customer BANKLIB Bank File Batch Detail Mass Summary Chapter 17: Project Management System Master File File File Update Report Project Appendix A: Table of Statements Statement Appendix B.
7 Cross-References Cross-Reference IndexContents ix Chapter 1 Overview CA-Easytrieve plus is an information retrieval and data management system designed to simplify typical programming tasks. Almost any business-oriented task can be accomplished. It is simple enough for a beginner to use without additional training, and sophisticated enough to enable a data processing expert to perform complex tasks. This Application Guide is will help you generate reports and process files without extensive data processing training and experience. This guide covers a subset of CA-Easytrieve plus statements. The statements are described briefly, along with the associated parameters. Examples of a variety of business applications are also presented.
8 These examples include the required coding and illustrations of the output reports. If you want more information about any individual CA-Easytrieve plus statement, function, or operation, refer to the Reference Guide. This guide is written for the business-oriented professional. Using this guide enables you to manipulate files, and to design and print reports, without having to wait for available time from data processing personnel. Topics This guide contains information related to the following: Program data and task statements Assignment statement Decision and branching logic Automatic, controlled, and database input/output specifications Program-produced reports File processing to read, modify, delete or add new records Table processing with typical examples IMS/DLI facilities for information retrieval from databases OS/390, z/OS.
9 And VSE JCL requirements Overview 1 1 Related Publications Sample jobs that perform typical data processing functions Online and batch processing illustrations to demonstrate a variety of coding techniques Project management systems List and description of statements covered in this guide Cross references of statements to specific examples Related Publications The following publication, not produced by Computer Associates, is either referenced in this publication or is recommended reading: IBM IMS/DLI Applications Programming Manual Program Capabilities Following is a list of some important CA-Easytrieve plus capabilities: File Processing Accepts any number of input files. Processes SAM, ISAM, VSAM, or IMS/DLI files.
10 Allows fixed, variable, undefined, or spanned record formats. Processes data in alphabetic, numeric, packed, packed-unsigned, or binary format. Searches files and performs logical data selection based on input or calculation. Edits and updates files. Matches an unlimited number of files. Creates subfiles containing selected records from a master file. 1 2 Application Guide Application Operations Performs extensive computations through user logic; including percentages, averages, and other calculations. Sorts on any number of keys. Calls your programs and subroutines written in other languages and integrates them into the job. Output Outputs any number of files or reports on one pass of the input file(s). Automatically formats output with all totals calculated internally.
