logo资料库

CA_Easytrieve_Plus_App_Guide_6.3.pdf

第1页 / 共315页
第2页 / 共315页
第3页 / 共315页
第4页 / 共315页
第5页 / 共315页
第6页 / 共315页
第7页 / 共315页
第8页 / 共315页
资料共315页,剩余部分请下载后查看
CA-Easytrieve Plus Application Guide
Contents
Chapter 1: About This Guide
Purpose and Audience
Organization
Other CA-Easytrieve Plus Publications
Related Publications
Documentation Conventions
Variable Parameters
Chapter 2: Overview
Introduction
Capabilities
Application
Structure
Environment Definition Section
Library Section
Activity Definition Section
Rules of Syntax
Statement Structure
Words
Comments
Continuations
Environment Definition
PARM Statement
SYNTAX Parameter
COMPILE Parameter
Chapter 3: Library
Introduction
FILE Statement
File-type Parameters
Device-type Parameters
Record Format Parameters
DEFINE Statement
Field-name Parameter
Location Parameter
Attributes Parameter
MASK Parameter
VALUE Parameter
Chapter 4: Activity Definition
Introduction
JOB Statement
SORT Statement
SELECT Statement
Chapter 5: Data Manipulation
Assignment Statement
Equivalence
Arithmetic Expression
Chapter 6: Decision and Branching Logic
Introduction
Conditional Expressions
Field Relational Condition
Field Class Condition
Field Series Condition
File Presence Condition
File Presence Series Condition
Record Relational Condition
IF, ELSE, and END-IF Statements
IF Statement
ELSE Statement
END-IF Statement
Nesting IF Statements
DO and END-DO Statements
DO Statement
END-DO Statement
Nesting DO Loops
GOTO Statement
Statement Labels
Procedure Processing
PROC and END-PROC Statements
PERFORM Statement
STOP Statement
EXECUTE
Chapter 7: Input/Output Specification
Introduction
DISPLAY Statement
Content and Spacing Parameters
Rules for Use
Debugging
PRINT Statement
GET Statement
PUT Statement
Example
POINT Statement
READ Statement
WRITE Statement
Chapter 8: Report Processing
Introduction
Report Types
Standard Reports
Label Reports
REPORT Statement
SEQUENCE Statement
CONTROL Statement
TITLE Statement
HEADING Statement
LINE Statement
Report Procedures
Coding Techniques
Special-name Report Procedures
REPORT-INPUT
BEFORE-LINE and AFTER-LINE
BEFORE-BREAK
AFTER-BREAK
ENDPAGE
TERMINATION
Chapter 9: File Processing
Introduction
Control of Input/Output (I/O)
Record Formats
System-Defined Fields
Error Conditions
Data Availability Tests
Opening and Closing Files
SAM Files
Input
Output
VFM Files
ISAM Files
Sequential Processing
Skip-Sequential Processing
Random Processing
VSAM Files
File Loading
Input
Record Addition
Record Deletion
Record Update
Synchronized File Processing
Input
Conditional Expressions
File Presence Condition
File Presence Series Condition
Record Relational Condition
Chapter 10: Table Processing
Table Definition
Instream Tables
External Tables
SEARCH Statement
Chapter 11: IMS/DLI Processing
Introduction
FILE Statement
RECORD Statement
RETRIEVE Statement
Automatic Input with RETRIEVE
Sweep of a Database
Tickler File Control
Input Definition (Paths)
Chapter 12: OS/390 JCL
Introduction
Sample Short Report Output Program
Mailing Label Output Program
Synchronized File Processing Program
Compile and Link-Edit Load Module
Previously Compiled and Link-Edited Programs
Chapter 13: VSE JCL
Introduction
Sample Short Report Output Program
Mailing Label Output Program
Synchronized File Processing Program
Compile and Link-Edit Load Module
Previously Compiled and Link-Edited Programs
Chapter 14: Applications
Introduction
Application Overview
Program Formatting Standards
Program Output Standards
Inventory Sample File
Personnel Sample File
Chapter 15: Basic Examples
Introduction
Employees in Region 1
Proposed Salary Schedules
Employee Letters
Mailing Labels
Tally Reports
Women's Phone Numbers
Salary Tally Report
File Expansion
Average Regional Gross Salary
Central Region Employees
Inventory Report by City
Expanded Inventory Report
Error Correction
Inventory Reduction
Inventory File Update
Reorder Notification Report
Chapter 16: Advanced Techniques
Introduction
Selected Control Break Processing
Summary File Processing
Special Report Processing Exits
Sorting Input Files
Synchronized File Facility - File Update
Reformat Printed Output from IDCAMS
VSAM File Processing
Defining and Loading VSAM Data Sets with Alternate Indexes
Load Base Clusters Through CA-Easytrieve Plus
Defining and Building Alternate Indexes and Define Paths
Updating a VSAM KSDS Cluster
Sequentially Reading VSAM File through Nonunique Alternate Index
Updating a VSAM ESDS File
Deleting and Adding Records of VSAM KSDS File
GETDATE Macro
CONCAT Macro
Processing JCL Parameters
Chapter 17: Bank System
Introduction
Online Processing
Initialize Customer File
BANKLIB Macro
Bank File Program
Batch Processing
Detail Report
Mass Mailing
Summary Report
Chapter 18: Project Management System
Introduction
Master File Layout
Programs
File Maintenance
Project Status - EXAMPLE 18.1
Output Reports
File Update Reports
Project Status - EXAMPLE 18.2
Report Generation
Project Status - EXAMPLE 18.3
Project Summary
Project Summary - EXAMPLE 18.4
Project Completion - EXAMPLE 18.5
Appendix A: Table of Statements
Functions
Appendix B: Cross-References
Cross-Reference of Statement
Index
For OS/390, VM, VSE Application Guide 6.3 fi R0J7E863AGE
Release 6.3, February 2001 This documentation and related computer software program (hereinafter referred to as the Documentation) is for the end users 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. 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. THE USE OF ANY PRODUCT REFERENCED IN THIS DOCUMENTATION AND THIS DOCUMENTATION IS GOVERNED BY THE END USERS APPLICABLE LICENSE AGREEMENT. The manufacturer of this documentation is Computer Associates International, Inc. Provided with Restricted Rights as set forth in 48 C.F.R. Section 12.212, 48 C.F.R. Sections 52.227-19(c)(1) and (2) or DFARS Section 252.227.7013(c)(1)(ii) or applicable successor provisions.  1996-2001 Computer Associates International, Inc., One Computer Associates Plaza, Islandia, New York 11749. All rights reserved. All trademarks, trade names, service marks, or logos referenced herein belong to their respective companies.
Contents Chapter 1: About This Guide Purpose and Audience ........................................................................ 11 Organization ................................................................................. 11 Other CA-Easytrieve Plus Publications .......................................................... 13 Related Publications........................................................................... 13 Documentation Conventions ................................................................... 14 Variable Parameters ....................................................................... 14 Chapter 2: Overview Introduction .................................................................................. 21 Capabilities ............................................................................... 21 Application ............................................................................... 22 Structure ..................................................................................... 27 Environment Definition Section............................................................. 28 Library Section............................................................................ 28 Activity Definition Section ................................................................. 28 Rules of Syntax ..............................................................................210 Statement Structure ......................................................................210 Words...................................................................................211 Comments ...............................................................................212 Continuations............................................................................213 Environment Definition ...................................................................213 PARM Statement .........................................................................213 SYNTAX Parameter ......................................................................214 COMPILE Parameter .....................................................................214 Contents iii
Chapter 3: Library Introduction ................................................................................. 31 FILE Statement ............................................................................... 32 File-type Parameters ...................................................................... 34 Device-type Parameters ................................................................... 35 Record Format Parameters................................................................. 36 DEFINE Statement............................................................................ 38 Field-name Parameter ..................................................................... 39 Location Parameter ....................................................................... 39 Attributes Parameter ..................................................................... 310 MASK Parameter ........................................................................ 312 VALUE Parameter ....................................................................... 314 Chapter 4: Activity Definition Introduction ................................................................................. 41 JOB Statement................................................................................ 43 SORT Statement .............................................................................. 46 SELECT Statement ........................................................................ 47 Chapter 5: Data Manipulation Assignment Statement ........................................................................ 51 Equivalence .............................................................................. 51 Arithmetic Expression..................................................................... 52 Chapter 6: Decision and Branching Logic Introduction ................................................................................. 61 Conditional Expressions ................................................................... 63 Field Relational Condition ..................................................................... 65 Field Class Condition ......................................................................... 66 Field Series Condition......................................................................... 67 File Presence Condition ....................................................................... 68 File Presence Series Condition ................................................................. 68 Record Relational Condition ................................................................... 69 IF, ELSE, and END-IF Statements .............................................................. 69 IF Statement.............................................................................. 69 ELSE Statement.......................................................................... 610 END-IF Statement ....................................................................... 610 iv CA-Easytrieve Plus Application Guide
Nesting IF Statements.....................................................................610 DO and END-DO Statements..................................................................611 DO Statement ............................................................................611 END-DO Statement ......................................................................611 Nesting DO Loops........................................................................612 GOTO Statement.............................................................................612 Statement Labels .............................................................................613 Procedure Processing.........................................................................614 PROC and END-PROC Statements .........................................................614 PERFORM Statement .....................................................................615 STOP Statement .............................................................................615 EXECUTE ...............................................................................615 Chapter 7: Input/Output Specification Introduction .................................................................................. 71 DISPLAY Statement ........................................................................... 72 Content and Spacing Parameters............................................................ 73 Rules for Use ............................................................................. 74 Debugging ............................................................................... 74 PRINT Statement ............................................................................. 75 GET Statement................................................................................ 78 PUT Statement................................................................................ 78 Example.................................................................................. 78 POINT Statement ............................................................................. 79 READ Statement .............................................................................710 WRITE Statement ............................................................................711 Chapter 8: Report Processing Introduction .................................................................................. 81 Report Types ................................................................................. 83 Standard Reports.......................................................................... 83 Label Reports ............................................................................. 84 REPORT Statement............................................................................ 85 SEQUENCE Statement .......................................................................811 CONTROL Statement ........................................................................811 TITLE Statement .............................................................................812 HEADING Statement.........................................................................813 LINE Statement ..............................................................................814 Report Procedures ...........................................................................816 Contents v
Coding Techniques ...................................................................... 817 Special-name Report Procedures .......................................................... 818 REPORT-INPUT ......................................................................... 820 BEFORE-LINE and AFTER-LINE.......................................................... 820 BEFORE-BREAK ........................................................................ 821 AFTER-BREAK .......................................................................... 822 ENDPAGE .............................................................................. 822 TERMINATION ......................................................................... 822 Chapter 9: File Processing Introduction ................................................................................. 91 Control of Input/Output (I/O) ............................................................. 91 Record Formats........................................................................... 92 System-Defined Fields .................................................................... 93 Error Conditions.......................................................................... 93 Data Availability Tests .................................................................... 93 Opening and Closing Files ................................................................. 93 SAM Files.................................................................................... 94 Input .................................................................................... 94 Output .................................................................................. 95 VFM Files.................................................................................... 95 ISAM Files ................................................................................... 96 Sequential Processing ..................................................................... 96 Skip-Sequential Processing ................................................................ 96 Random Processing ....................................................................... 97 VSAM Files .................................................................................. 97 File Loading.............................................................................. 98 Input .................................................................................... 98 Record Addition ......................................................................... 910 Record Deletion ......................................................................... 910 Record Update .......................................................................... 911 Synchronized File Processing ................................................................. 911 Input ................................................................................... 914 Conditional Expressions .................................................................. 914 File Presence Condition .................................................................. 915 File Presence Series Condition............................................................. 915 Record Relational Condition .............................................................. 916 Chapter 10: Table Processing vi CA-Easytrieve Plus Application Guide
Table Definition..............................................................................101 Instream Tables ..........................................................................102 External Tables...........................................................................102 SEARCH Statement ..........................................................................103 Chapter 11: IMS/DLI Processing Introduction .................................................................................111 FILE Statement ..............................................................................112 RECORD Statement ..........................................................................113 RETRIEVE Statement.........................................................................114 Automatic Input with RETRIEVE ..............................................................116 Sweep of a Database ......................................................................116 Tickler File Control .......................................................................116 Input Definition (Paths) ...................................................................116 Chapter 12: OS/390 JCL Introduction .................................................................................121 Sample Short Report Output Program..........................................................122 Mailing Label Output Program ................................................................123 Synchronized File Processing Program .........................................................124 Compile and Link-Edit Load Module ..........................................................126 Previously Compiled and Link-Edited Programs ................................................126 Chapter 13: VSE JCL Introduction .................................................................................131 Sample Short Report Output Program..........................................................132 Mailing Label Output Program ................................................................133 Synchronized File Processing Program .........................................................135 Compile and Link-Edit Load Module ..........................................................137 Previously Compiled and Link-Edited Programs ................................................137 Contents vii
Chapter 14: Applications Introduction ................................................................................ 141 Application Overview.................................................................... 141 Program Formatting Standards............................................................ 142 Program Output Standards ............................................................... 142 Inventory Sample File .................................................................... 143 Personnel Sample File .................................................................... 144 Chapter 15: Basic Examples Introduction ................................................................................ 151 Employees in Region 1 ....................................................................... 152 Proposed Salary Schedules ................................................................... 153 Employee Letters ............................................................................ 155 Mailing Labels ............................................................................. 1511 Tally Reports............................................................................... 1513 Women’s Phone Numbers ................................................................... 1517 Salary Tally Report ......................................................................... 1518 File Expansion ............................................................................. 1519 Average Regional Gross Salary .............................................................. 1521 Central Region Employees................................................................... 1522 Inventory Report by City .................................................................... 1526 Expanded Inventory Report ................................................................. 1527 Error Correction ............................................................................ 1530 Inventory Reduction ........................................................................ 1531 Inventory File Update....................................................................... 1533 Reorder Notification Report ................................................................. 1535 Chapter 16: Advanced Techniques Introduction ................................................................................ 161 Selected Control Break Processing............................................................. 162 Summary File Processing ..................................................................... 163 Special Report Processing Exits ............................................................... 165 Sorting Input Files ........................................................................... 168 Synchronized File Facility - File Update....................................................... 1610 Reformat Printed Output from IDCAMS ...................................................... 1612 VSAM File Processing....................................................................... 1615 Defining and Loading VSAM Data Sets with Alternate Indexes.............................. 1616 Load Base Clusters Through CA-Easytrieve Plus........................................... 1617 viii CA-Easytrieve Plus Application Guide
分享到:
收藏