BT08 - VSAM File Management - 1 Day

DateLocationDurationCostEnrolEnquiry
2022-06-14Virtual1 Day £600.00 (plus VAT)
Enquire
2022-08-17Virtual1 Day £600.00 (plus VAT)
Enquire
2022-10-19Virtual1 Day £600.00 (plus VAT)
Enquire

Course Description


Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.


Course Details

GETTING STARTED
VSAM Datasets
VSAM File Characteristics
VSAM Advantages
VSAM File Types
Ways to Identify Logical Records
VSAM Components
VSAM Cluster
Control Interval
Control Area
Spanned Records
Considerations
VSAM Access Types
Summary Of VSAM Facilities

VSAM DEFINITION
Defining a Cluster
Cluster Definition Parameters
Deleting a Cluster
Cluster Deletion Parameters
Parameter Abbreviations
Using ISPF to Define and Delete VSAM Clusters
VSAM File - Define
Allocating A New VSAM File Using File-AID

ENTRY-SEQUENCED DATASETS
Entry-Sequenced Datasets
ESDS Main Features
Alternate Index
ESDS Data Access

KEY-SEQUENCED DATASETS
Key-Sequenced Datasets
KSDS Freespace Considerations
KSDS Main Features
The Index Component
Index Structure
Control Interval Splits and Control Area Splits
Data Access
Direct Access
Sequential Access
Skip-Sequential Access

RELATIVE RECORD DATASETS
Relative Record Datasets
Data Access
RRDS Main Features
RRDS Structure

LINEAR DATASETS
Linear Datasets
Linear Main Features

VSAM COMMANDS
Overview
The Alter Command
The Repro Command
Using Repro to Reorganize a Dataset
Repro Parameters
The Listcat Command
The Examine Command
The Verify Command
The Print Command

USING AN ALTERNATE INDEX
What Is An Alternate Index?
How Does An Alternate Index Work
Defining An Alternate Index

BROWSING USING FILE-AID
Overview
Datasets Supported
Accessing Browse
The Browse Panel
Character Mode
Vertical Mode
Formatted Mode
Browse Primary Commands
COBOL File Layout / Copybook Example

VSAM AND CICS
Initial Setup
File Control Table (FCT)
Reading
Writing
Deleting
Updating
Unlocking
Browsing Multiple Records
Batch And On-Line File Access

VSAM AND COBOL OVERVIEW
File Definition – Select Statement
Opening VSAM Files
Indexed Read
Sequential Read
Write Records
Rewriting Records
Deleting Records
Positioning Within A File - Start

VSAM AND SAS OVERVIEW
Using SAS System Options
VSAM Option for the FILENAME Statement
Reading a VSAM File
Writing to an Empty VSAM File
Updating a VSAM Data Set
Reading Records from a KSDS
KSDS Reading – Key Option
KSDS Reading – KEYGE Option
KSDS Reading – GENKEY Option
KSDS Reading – Direct RBA Access
Reading a KSDS with Skip Sequential Access
Adding Records to a KSDS
Updating Records in a KSDS
Erasing Records from a KSDS

VSAM AND REXX OVERVIEW
Rexx / Vsam - File Processing
Rexx / Vsam - File Definition / Deletion
Rexx / Vsam - File Repro
Rexx / Vsam – Data Manipulation

FILE ACCESS STATUS CODES
File Access Status Codes


Course Enquiry