NaturalONE Version 8.3.7
 —  External Objects in Predict  —

Incorporating DB2 Databases

This document covers the following topics:


Prerequisites

Incorporation of DB2 objects is subject to DB2 security mechanisms. See the section DB2 and SQL/DS in the Predict and Other Systems documentation.

Note:
See Concepts of Incorporation for basic information on how to use incorporation functions.

Top of page

Selecting DB2 Databases

Selection criteria

Common parameters which are not included in the table below are described under Common Parameters for All DB2 Types.

Parameters
DB2 database name DB2 database name. Asterisk notation is allowed.
Creator name Creator name. Asterisk notation is allowed.
Update DB attributes (connect option) Provided on a later page of the schema incorporation wizard (after the physical object has been selected from the drop-down list box). Y - Attributes of the Predict database object are to be updated.

Databases which meet the selection criteria and are not already connected to a Predict database object are then provided in the drop-down list box on the next page of the schema incorporation wizard.

Information in the drop-down list box
Creator Creator of the database.
Database name Name of the database
Predict database ID ID of Predict database object for a DB2 database with this DB2 name.
Remark Either the following type-specific remark or blank. For type-independent remarks see Remarks which apply to all Object Types.
SC missing Default storagegroup is not documented. Incorporation is not possible.

Top of page

Incorporation Functions for DB2 Databases

Valid functions:

Test

Compares the database and the Predict database object and reports differences between attributes and file lists.

Connect

Connects the DB2 database to the corresponding Predict database object and

Specify the following parameters in an additional page of the schema incorporation wizard.

Connect Options
Update DB attributes See the parameter table in Selecting DB2 Databases for a description of this parameter.

Incorporate

Scope of the Incorporation

Specify the following parameters in an additional page of the schema incorporation wizard. The parameter Database ID is mandatory, the other parameter is optional

Incorporation Options
Database ID ID of the new Predict database object. The creator and DB2 name of the database joined by a hyphen is displayed and can be accepted or overwritten.
List incorporated code
Y The values of all attributes incorporated for the database are to be listed.

Top of page

Keywords

The schema incorporation wizard uses the following keywords when showing the command that is to be processed:

Field Keyword
DB2 database name DB2NAME
Creator name CREATOR
Function SUB-FUNCTION
Database ID DATABASE-ID
List incorporated code LIST
Update DB attributes UPD-DB
SQL Server SQL-SERVER

Top of page