Select Object Definitions to Extract

If you select Option 3 on the EXTRACT Process menu, you can choose one or more types of object definitions from the Specify Object Definitions to EXTRACT panel. (Primary keys, relationships, and indexes are selected by default, as shown by the SELECT status in Figure 1.)

To extract the definitions needed to create a Materialized Query Table, extract the base tables for the MQT and select the Materialized Query Tables object type.

You can choose the object definitions to be extracted by selecting and deselecting object types. Any selected object definition types are extracted for each table that participates in the Extract Process. Your selections are profiled and displayed automatically the next time you use Option 3 on the EXTRACT Process menu.

------------------- Specify Object Definitions to EXTRACT ---------------------
Command ===>                                                  SCROLL ===> PAGE 

Use S Line Command to Select ALL Associated Objects of Specified Type 
Use U Line Command to Unselect Associated Objects of Specified Type   

Cmd   Status             Object Type            
---  --------  -------------------------------- 
 _   SELECT    Primary Keys and Relationships   
 _   SELECT    Indexes                          
 _   UNSELECT  Views
 _   UNSELECT  Materialized Query Tables        
 _   UNSELECT  Aliases                          
 _   UNSELECT  Synonyms                         
 _   UNSELECT  Column Field Procedure Names     
 _   UNSELECT  Triggers                         
 _   UNSELECT  User Defined Types and Functions 
 _   UNSELECT  Stored Procedures                

Note: Catalog Queries to Extract Object Definitions are Expensive 
      Selected Objects Extracted for Tables ONLY                  
      Will Always Extract Index Required by DB2 Primary Key       

Panel

This panel includes:

Cmd

Line command area. The available line commands are:

S

Select object definition.

U

Unselect object definition.

Status

Indicate whether an object definition is to be extracted. Displayed as:

SELECT

Object definition is to be extracted.

UNSELECT

Object definition is not to be extracted.

Object Type

List of object definition types that can be extracted. The default selections, for Primary Keys and Relationships and Indexes, are shown with the SELECT status in Figure 1.

The index for the primary key is always extracted when Primary Keys and Relationships are selected, whether or not Indexes is selected. If Column Field Procedure Names is selected, the names of the edit and validation exit routines for the table are also extracted.

Only for Tables

The selected object types are extracted only for table objects listed on the Select Tables/Views for AD panel. These selected object definitions are not extracted for an object on the Table List that is not a table. Thus, an alias, synonym, view, or Legacy Table listed on the Select Tables/Views for AD panel is extracted but related object definitions are not. A table made up of the columns included in an alias, synonym, or view is created at the destination for the extracted object.

The DDL for Temporary Tables is extracted and can be used to create Temporary Tables at the destination. However, no keys, relationships, etc., are associated with Temporary Tables and no data is stored in them.

You should consider what is to be created at the destination. If you do not need the related objects (primary keys, relationships, and indexes, etc.) for object definitions other than tables, you need only include the alias, synonym, or view on the Table List. However, if you need the related objects, you can list the base table on the Select Tables/Views for AD panel and select the object type on the Specify Object Definitions to Extract panel, thus extracting the desired object and related objects.

Generic primary keys and relationships are extracted as generic objects and are created as generic unless you modify the Creator ID on the CREATE Object List panel or modify the SQL statements generated to create the objects.

Joined views are extracted only if all tables that make up the view are listed on the Select Tables/Views for AD panel. For Primary Keys and Relationships, the pertinent object definitions for all listed tables, including reference tables, are extracted. For more information about creating object definitions, see Create Process.

Materialized Query Tables

To obtain the definitions for a Materialized Query Table, you must extract the base tables for it and select the Materialized Query Table object type on the Specify Object Definitions to Extract panel. Use this extract file to create the MQT and the base tables at the destination. For more information, see Insert Process and Create Process.

Available Commands

Use END to return to the EXTRACT Process menu or CANCEL to abandon your changes and return to the EXTRACT Process menu.