File-AID MVS

Duration:   3 days

Participants:   Programmers and operations personnel and others responsible for maintenance of data files, and analysis of global data changes.

Objectives:   Upon successful completion of this course you will be able to: -  Use the powerful File-AID comparison, viewing, updating and printing tools and contrast File-AID with traditional ISPF. -  Edit and Browse data using a variety of formatted viewing and selection techniques. -  Create test beds of data. -  Analyze programs for global modifications. -  Run online and batch File-AID requests. -  Create, manipulate, and alter VSAM clusters and data. (Optional) -  Describe the latest enhancements to File-AID MVS.

Overview:   -  File-AID is an interactive product that enhances programmer productivity in file handling and record maintenance. This course presents the many features and functions of File-AID that will enhance programmer and user productivity. The File-AID analysis facilities are explored and extended to general analysis of any global maintenance change in program and data. -  This course focuses on File-AID running under TSO and batch File-AID MVS. For File-AID for DB2 or File-AID for IMS, please ask about our one-day follow-up courses..

Prerequisites:   A strong knowledge of TSO/ISPF and MVS data storage is recommended, as well as a working knowledge of basic JCL.

Format:   Lecture and discussion with extensive hands-on exercises.

Topic Outline:   -  File-AID Overview         File-AID vs. ISPF         Online vs. Batch File-AID         File-AID family of products for flat files, VSAM, DB2, and IMS -  Getting Started         Starting File-AID in TSO         Customizing File-AID -  Browse         Member selection         Layout: Mapping to a copybook or other data structure         Vertical and horizontal formats         Record selection         Primary and line commands         Comparison with ISPF Browse -  Creating New Datasets         SMS support         PDSE support         GDG support         Maintenance support -  Selection (search) Criteria         Syntax and capabilities         Searching for records with specific characteristics         Limiting number of records selected         Creating control statements for batch         Maintaining a library of selection criteria         Data types for comparison         Formatted and unformatted searches         Relational operators         Techniques to locate invalid and very large packed numbers -  Providing Default Parameters         System Parms, especially Jump         Selection Parms         Print Parms         Process Parms         Audit Parms -  Edit         Similarities to File-AID Browse         Updating data         Audit trail         Primary and line commands         Comparison with ISPF Edit -  Copy         Copying selected records (selection criteria)         Copying selected members         Scanning for specific search criteria         Renaming with wild card characters         Creating test beds of data -  Search/Update Utility (=3.6)         Member, Browse, Update         Member list              Sort, Reset, Find, Change, Sort         Selection criteria         Search and replace              Relational operators for changing data (E, EA, R, RA)              Confirming changes -  Catalog Utility (3.4)         Catalog panel         Catalog line commands              Comparison with ISPF 3.4 -  VSAM Support  (Optional - If used at client site.)         Utility option 3.5              Allocating clusters, AIXs, BLDX, PATH              Viewing existing component definitions              Modifying, renaming VSAM components         Edit and Browse              New primary and line commands for Edit and Browse              Protect and Unprotect line commands (P and U)              Specifying start and limit of records browsed or edited              Edit error messages and fixing them         Copy capabilities (similar to REPRO)         Catalog (3.4) information         Generate JCL and IDCAMS statements         Tips for efficient VSAM definition and use -  Boolean  (Optional - Generally not presented.)         Data types         Relational Operators         Searching for and changing bit settings -  XREF         Multiple layouts for a data set         Capturing layouts from within programs -  Batch File-AID         Interactive Utility to test batch commands (3.8)         Generating batch JCL (in most screens: copy, compare, 3.6, etc.)         Advantages and disadvantages of using old style batch              JCL              New syntax: Old syntax still works         Viewing on-line syntax and capturing for batch         Changing generated JCL for ongoing use         Writing your own JCL and control statements              Batch Action Functions              Batch Processing Parameters              Batch control card layout              Function Modifiers              Parameter Elements              Typical Job streams -  Compare         Simple         Key compare              Types of key compares         Batch vs. online compare              Customizing compare -  Reformat         A "fancy" copy         Setting up copybooks         Creating the "reformat specification" dataset         Source and target dataset requirements         Setup - specifying what gets copied, and how data is to be changed         Execute the reformat         Browse the new dataset -  Additional Topics         VTOC         Printing         View: Viewing Layouts         Recursive commands         On-line Help -  Load Module Management         Library Utility         CSECT mapping         Module browsing and manipulation -  Recent Features         New Technology:              HFS File Support for OS/390 UNIX                 Browse, Edit, Copy, Delete, Rename, XMLGEN, Print (Data file)                 Compare HFS files on the UNIX environment of OS/390              XML Document Creation from existing files              Support of COBOL II 31-digit packed decimal         Browse/Edit Enhancements:               HIDE and HOLD Fields              COPY and PASTE records              FLIP Excluded/Non-excluded records              COLS command              GO command              Automatic Creation of Frequently Used File List         Improved Compare              Compare Load Modules and Parse CSECT Information              Enhanced and streamlined reporting              Report only changed fields.              Ability to set Tolerance Percentage for "close" numeric matches               Compare CA-Panvalet/Librarian Files              Integration with File-AID/Data Solutions, another product    -  Earlier Features         Compare              New interface, new features, new output formatting              Different layouts for new and old files              Save and modify compare criteria              Compare entire PDS/PDSE datasets              Direct compared records to different output files              Set compare tolerances              Read-ahead for non-sequenced files              Control fields in output         Browse/Edit              TSO SUBMIT command supported              VFMT - LOCATE field command         Edit              Formatting without a record layout              Wrapping         Batch              New batch parameters: ELSE, READNEXT, and DFLT WRITE              Option 3.1 includes batch choice         Selection Criteria              Supports 18 packed digits in formatted mode and 31 packed digits in unformatted mode         HSM              Migrated Datasets deleted without being recalled         Compare - printed output options              Print or suppress printing of changed, inserted, deleted, matched              Condensed report format              User-specified record key or sync field underscore option              Print only changed lines              New ruler bar choices              Save print profile         Windowed Browse              Handle inordinately large sequential files         Windowed Edit              Edit any size KSDS and IAM keyed files         VPRINT              Vertical print         System Supported blocksize - install option         Multi-volumne support         XREF - faster support         Expanded PDSE support         Documentation on CDs - three ways         Improved Panvalet and Librarian support         New option for dataset lists         Online install reduces install complexity         Browse support for RLS (Record Level Sharing)         Dynamic allocation/creation of datasets in Copy         Panel format changes         Tape support in 3.3, 3.6, Print, and Compare         Support for extended VSAM datasets

Tools List       TSO List       VSAM List       Site Map       Home