To create a table, you first create the table within a physical
data model, then you promote the table to the metadata catalog of your data
server.
When you create a table in a physical data model, you open the file
that contains the data structures that you want to base the table on. Each
record, field, or element that you select (depending on your data source)
becomes a column in the table.
When you promote the table to a metadata
catalog, you generate SQL data definition language (DDL) statements (the CREATE
statement to create the table and any related statements, such as statements
for creating indexes, grants, keys, and so on). You then run the DDL on the
data server.
Learning objectives
After you complete the
lessons in this module, you will understand the concepts and know how to do
the following tasks:
- Map VSAM records from a COBOL copybook to columns in a relational table
- Promote the table to a data server
- Run a test query on the table
This module should take approximately 20 minutes to complete.