< Previous | Next >
WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


Module 2: Creating and modifying a table

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:
This module should take approximately 20 minutes to complete.

Lessons in this module



Feedback

Update icon Last updated: 2007-10-09


< Previous | Next >