To query or update data in a DB2® for z/OS® source, you must create a relational table that maps to that data source. You open a connection to a DB2 for z/OS subsystem and import the table or view into a physical data model. Then, you can generate and run the DDL.
Before you begin
In your data design project, you must have at least one physical model.
About this task
You can import DB2 tables, views, materialized query tables, and aliases. All of these objects become tables in a schema in a physical data model.
Dropping a DB2 object into a schema adds the object to that schema. Dropping a DB2 object into a data design project that has no schema causes Classic Data Architect to create a schema and add the DB2 object to it. Dropping an entire DB2 schema into a data design project adds that schema to the project and imports all of the DB2 objects that are in the DB2 schema.
When objects are created, they are created with DB2 column and, if applicable, indexes.
Columns that are not supported in Classic federation are not added.
Procedure