Duration
5 hours
Overview
The CA OPS/MVS® Event Management and Automation – Automating Events Using the Relational Data Framework course discusses the use of relational database tables and SQL to build event automation.
Audience
Suitable for Systems Programmers and Operations support personnel requiring knowledge of CA OPS/MVS RDF.
Prerequisites
General knowledge of the concepts of CA OPS/MVS and OPS/REXX facilities and how to use them.
Objectives
After completing this course, the student will be able to:
- Relational Tables for event automation
- RDF tables by using OPSVIEW
- RDF tables by using SQL statements
Course Content
The Relational Data Framework
RDF Table Structure
Defining and Maintaining RDF Tables Using OPSVIEW
Building SQL STATEMENTS – The Structure of SQL
SQL Statements and Structure
Using SQL in Event Automation Procedures with RDF Tables
Creating RDF Tables
Maintaining and Adding Data to RDF Tables
Deleting RDF Tables
Retrieving Data from RDF Tables in Event Automation Procedures
Retrieving Data from RDF Tables Using SQL
Cursor Operations Using SQL