The CA OPS/MVS product uses SQL to create a database containing relational tables that store automation data. Each table contains one or more rows consisting of one or more columns. The relationship among the tables, rows, and columns of a relational table resembles the relationship among z/OS data set components, as shown in the following table:
z/OS Data Set Component |
Relational Data Framework Equivalent |
Data set |
Relational table |
Record |
Row |
Record field |
Column |
In most languages, you map the fields in a record yourself, so you know how the data is stored and which offset contains a certain field. SQL, however, controls where data goes in a table. Therefore, with SQL you do not need to know the arrangement of the data, only the names of the table and the columns where the data is located.
Copyright © 2014 CA.
All rights reserved.
|
|