Related Extract
lets users create a test relational database from a larger production database by extracting, loading, and transforming related data at the client or server level. Extracting and loading data can be performed on the same database, or data can extracted from one database and loaded into a different database. is the client/server partner for . Used together, they are the easiest way to create a small, relationally valid database from a large DB2 UDB database.
Related Extract extracts the appropriate data from the source selected. The data is extracted based on relationships defined in the database, which is called referential integrity (RI) or based on relationship, defined within the Application Relationship Editor, which is called application relationships (AR).
extract enables programmers and database administrators to easily extract a complete subset of related data from DB2 objects and/or MVS files. Data related by referential integrity or application-defined relationships can be extracted within their respective DB2 or MVS environments, with full support for all relationship constraints.
Users can tailor the extract to their needs by doing the following:
- Selecting the driving object from which to start the extraction process. All relationships for this extract are derived from this object.
- Deciding whether to use referential integrity to discover the related object starting with the driving object
Viewing the list of objects and list of parent/dependent relationships. On these views, users can further prune the extract content by doing the following:
- Changing the extract scope by modifying the Direct (D), Parent (P), Sibling (S), and Indirect (I) settings
Including and excluding specific tables/views or relationships