BT09 - Programming with VSAM Files - 2 Days

DateLocationDurationCostEnrolEnquiry
2022-06-15Virtual2 Days £1000.00 (plus VAT)
Enquire
2022-08-18Virtual2 Days £1000.00 (plus VAT)
Enquire
2022-10-20Virtual2 Days £1000.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
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
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
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

COBOL SELECT / ASSIGN STATEMENT
VSAM Select / Assign Statement

COBOL FILE DEFINITION
VSAM File Definition

COBOL OPEN STATEMENT
Opening VSAM Files

COBOL READING AND RID FIELDS
Specifying Key Fields for a VSAM Dataset
VSAM File Direct Access
VSAM File Sequential Access
VSAM File Alternate Index Data Access

COBOL START STATEMENT
Positioning the File Pointer within a VSAM File

COBOL WRITE STATEMENT
Inserting Records into a VSAM File
Placement of Records

COBOL REWRITE STATEMENT
Updating Records on a VSAM File
Updating Restrictions

COBOL DELETE STATEMENT
Deleting Records from a VSAM File

CLOSE STATEMENT
Closing a VSAM File

FILE STATUS CHECKING
Checking the VSAM File Status


Course Enquiry