Repository Training
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Repository Training as PDF for free.
More details
- Words: 361
- Pages: 22
EZSource Repository Training
Redefining software delivery
Repository
Basic Terms Main Tables Query Sample Excel Samples
Repository
Basic Terms • Resources: Tables, Files, Maps, JCLs, Copybooks, Programs, Sections, Paragraphs, Statements, Variables • References: Program to Resource, Resource to Source, Statement to Source
Repository
Basic Terms Paragraphs
Programs
Resource Occurrences Statement Reference Add. Data
Resource
Source Static Tables Static Tables Static Tables
Repository
Basic Terms Main Tables Query Sample Excel Samples
Repository
Main Tables – Tables and Files • Tables - Fields types and size - Index and keys •Files - Physical and Logical names - Record information - Keys
Repository
Main Tables – Maps and Copybooks
• BMS / MFS / OLM - Record reference - Map/Map set hierarchy • Copybooks - Record reference - Program reference
Repository
Main Tables – Programs and Sections • Programs - Resources reference - Nested programs • Sections - Program reference - Sections sequence
Repository
Main Tables – Paragraphs • Paragraphs - Program and Section reference - # of Statements, # of Lines, # of Remarks - Paragraphs reference - Paragraph type: Unreachable, Fall Through, Exist
Repository
Main Tables - Statements
• Statements - Used resource - Statement type - Source reference
Repository
Main Tables - Variables • Variables / Records • Definition: Picture, Size, Usage • Hierarchy: Ancestors, Siblings, Position in Record • Copy / Program reference • Redefines, Redefined
Repository
Main Tables - JCLS
• Job Steps • DD cards • PGMS • Physical Data Sets • Procs
Repository
Basic Terms Main Tables Query Sample Excel Samples
Repository
Query Sample – Variables usage
SELECT VarName, ProgramName, StartRow FROM Variables AS v, Programs AS p, Occurrences AS o WHERE (v.VarName LIKE "*TOTAL*") and (v.PIC LIKE "ZZZ99") and (v.OccurID = o.OccurID) and (o.ProgID = p.ProgramID) ORDER BY ProgramName;
Repository
Query Sample - Variables usage
Repository
Basic Terms Main Tables Query Sample Excel Samples
Repository
Excel Samples
Following examples show: • Statements usages across programs • Graphical view of Statements usage • Files usage across programs • Files usage within a single program (detailed by paragraphs) • Graphical view of Files usage
Repository
Excel Sample
Repository
Excel Sample
Repository
Excel Sample
Repository
Excel Sample
Repository
Excel Sample
Redefining software delivery
Repository
Basic Terms Main Tables Query Sample Excel Samples
Repository
Basic Terms • Resources: Tables, Files, Maps, JCLs, Copybooks, Programs, Sections, Paragraphs, Statements, Variables • References: Program to Resource, Resource to Source, Statement to Source
Repository
Basic Terms Paragraphs
Programs
Resource Occurrences Statement Reference Add. Data
Resource
Source Static Tables Static Tables Static Tables
Repository
Basic Terms Main Tables Query Sample Excel Samples
Repository
Main Tables – Tables and Files • Tables - Fields types and size - Index and keys •Files - Physical and Logical names - Record information - Keys
Repository
Main Tables – Maps and Copybooks
• BMS / MFS / OLM - Record reference - Map/Map set hierarchy • Copybooks - Record reference - Program reference
Repository
Main Tables – Programs and Sections • Programs - Resources reference - Nested programs • Sections - Program reference - Sections sequence
Repository
Main Tables – Paragraphs • Paragraphs - Program and Section reference - # of Statements, # of Lines, # of Remarks - Paragraphs reference - Paragraph type: Unreachable, Fall Through, Exist
Repository
Main Tables - Statements
• Statements - Used resource - Statement type - Source reference
Repository
Main Tables - Variables • Variables / Records • Definition: Picture, Size, Usage • Hierarchy: Ancestors, Siblings, Position in Record • Copy / Program reference • Redefines, Redefined
Repository
Main Tables - JCLS
• Job Steps • DD cards • PGMS • Physical Data Sets • Procs
Repository
Basic Terms Main Tables Query Sample Excel Samples
Repository
Query Sample – Variables usage
SELECT VarName, ProgramName, StartRow FROM Variables AS v, Programs AS p, Occurrences AS o WHERE (v.VarName LIKE "*TOTAL*") and (v.PIC LIKE "ZZZ99") and (v.OccurID = o.OccurID) and (o.ProgID = p.ProgramID) ORDER BY ProgramName;
Repository
Query Sample - Variables usage
Repository
Basic Terms Main Tables Query Sample Excel Samples
Repository
Excel Samples
Following examples show: • Statements usages across programs • Graphical view of Statements usage • Files usage across programs • Files usage within a single program (detailed by paragraphs) • Graphical view of Files usage
Repository
Excel Sample
Repository
Excel Sample
Repository
Excel Sample
Repository
Excel Sample
Repository
Excel Sample
Related Documents
Repository Training
October 2019 13
Repository Description
December 2019 16
Repository Wiki
May 2020 15
Repository Devika (1).docx
June 2020 9
Pc 811 Repository Guide
October 2019 23