NaturalONE	Version 8.3.7	SEARCH   CONTENTS   |   PDF BOOKS   |   HOME   UP   PREV   NEXT

This document covers the following topics:

• Common Parameters for All DB2 Types

• DB2 Database

• DB2 Procedure/Function

• DB2 Table/View

• DB2 Storagegroup

• DB2 Tablespace

Prerequisites

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

Common Parameters for All DB2 Types

The following parameters can be set in all DB2 object types.

DB2 Database

A DB2 database can be implemented with Dictionary View by generating the necessary SQL statements. The generated SQL statements can be saved in a generation protocol.

Note:
This function is only available if DB2 is installed in your server environment. The function is not applicable to SQL/DS.

The following topics are covered below:

• Parameters

• Keywords

• Sample Output

Parameters

Values for fields which have been locked by your data dictionary administrator cannot be overwritten. These fields are skipped when positioning the cursor with the TAB key. See Generation Defaults.

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

Keywords

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

If a parameter is not specified, the default value is taken.

Sample Output

Database-ID: EXAM-DATABASE

CREATE DATABASE EXAMDB
    STOGROUP EXAM001
    BUFFERPOOL BP1;

DB2 Procedure/Function

A DB2 procedure or function requires an object of type Program as input, from which then either a procedure or a function is generated.

Note:
This function is only available if DB2 is installed in your server environment. The function is not applicable to SQL/DS.

The following topics are covered below:

• Parameters

• Keywords

Parameters

Values for fields which have been locked by your data dictionary administrator cannot be overwritten. These fields are skipped when positioning the cursor with the TAB key. See Generation Defaults.

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

Note:
Links concerning the associations IN (Input FI) and RE (Returns FI) define the input and output parameters of the procedure or function.

Keywords

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

If a parameter is not specified, the default value is taken.

DB2 Table/View

The Generate DB2 Table / View function:

• Generates DB2 and SQL/DS Table/View/Indexes. If a table contains a LOB column, the function generates a SET CURRENT RULE='STD' statement which allows DB2 to create the necessary auxiliary tablespaces, tables and indexes for these objects.

• Generates distinct types.

• Generates check expressions. A check expression that differs from the documentation in Predict is dropped and recreated.

• Generates triggers. If a trigger is linked to a DB2 view, an INSTEAD OF trigger is generated. A trigger that differs from the documentation in Predict is dropped and recreated.

• Modifies existing DB2 and SQL/DS Table/Indexes, replaces DB2 and SQL/DS Views/Indexes or

• Purges indexes from DB2 or SQL/DS tables if no longer documented with a corresponding Predict file object of file type D (DB2 Table).

• Purges masks or permissions from DB2 tables if no longer documented with a corresponding Predict file object of file type D (DB2 Table).

Note:
If an XML column (Field format LO and Character Set X) is added for the first time to a DB2 table, you are recommended to run the function Compare DB2 table after the generation of the DB2 table. The function Compare DB2 table must be executed on the server with the update options Add fields and Field attributes set to Y.

The following topics are covered below:

• Parameters

• Keywords

• Sample Output

Parameters

Values for fields which have been locked by your data dictionary administrator cannot be overwritten. These fields are skipped when positioning the cursor with the TAB key. See Generation Defaults.

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

Special Considerations for Temporal Tables and Archive-Enabled Tables

When generating temporal tables, Predict only requires the name of the history or archive table to be used. This history or archive table is then automatically generated and connected to the base table. The history or archive table name can be provided when documenting a temporal table in Predict.

If you want to use a history or archive table with an index of its own then this history or archive table must be documented separately in Predict. Indexes can then be defined manually where required.

Such a separate history or archive table must then also be generated separately. The connection between the base table and the history or archive table, that is normally maintained automatically in Predict, will then be dropped. You will have to manually and individually apply changes made to the base table also in the history or archive table.

After the changes have been applied, you will have to generate both, the base table and the history or archive table, individually in order for the changes to take effect.

A third generation process is then required to reestablish the connection between the base table and the history or archive table.

Keywords

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

If a parameter is not specified, the default value is taken.

Sample Output

File-ID: EXAM-GEN_TABLE
CREATE TABLE EXAM.GEN_TABLE
   (EMPNO                    CHAR(6)          NOT NULL,
    FIRSTNME                 VARCHAR(12)      NOT NULL,
    MIDINIT                  CHAR(1)          NOT NULL,
    LASTNAME                 VARCHAR(15)      NOT NULL,
    WORKDEPT                 CHAR(3)          NOT NULL WITH DEFAULT,
    PHONENO                  CHAR(4)          NOT NULL WITH DEFAULT,
    HIREDATE                 DATE             NOT NULL WITH DEFAULT,
    JOB                      CHAR(8)          NOT NULL WITH DEFAULT,
    EDLEVEL                  SMALLINT         NOT NULL WITH DEFAULT,
    SEX                      CHAR(1)          NOT NULL WITH DEFAULT,
    BIRTHDATE                DATE             NOT NULL WITH DEFAULT,
    SALARY                   DECIMAL(9, 2)    NOT NULL WITH DEFAULT,
    BONUS                    DECIMAL(9, 2)    NOT NULL WITH DEFAULT,
    COMM                     DECIMAL(9, 2)    NOT NULL WITH DEFAULT,
    PRIMARY KEY (EMPNO))
   IN DATABASE EXAMDB
   EDITPROC PROGDB
   AUDIT NONE;
CREATE UNIQUE INDEX PRDDBA.EMPNO
   ON EXAM.GEN_TABLE
      (EMPNO                       ASC)
   SUBPAGES 4
   BUFFERPOOL BP0
   CLOSE YES;
CREATE INDEX DSN8210.XEMP2
   ON EXAM.GEN_TABLE
      (WORKDEPT                    ASC)
   SUBPAGES 4
   BUFFERPOOL BP0
   CLOSE YES;

DIC1880 SUMMARY:     14 FIELD(S) PROCESSED

DB2 Storagegroup

A DB2 storagegroup can be implemented with Dictionary View by generating the necessary SQL statements. The generated SQL statements can be saved in a generation protocol.

The following topics are covered below:

• Parameters

• Keywords

• Sample Output

Parameters

Values for fields which have been locked by your data dictionary administrator cannot be overwritten. These fields are skipped when positioning the cursor with the TAB key. See Generation Defaults.

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

Keywords

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

If a parameter is not specified, the default value is taken.

Sample Output

Storagespace-ID: EXAM-STORAGEGROUP

CREATE STOGROUP EXAM001
       VOLUMES (VOL05 )
       VCAT DB2;

DB2 Tablespace

A DB2 tablespace can be implemented with Dictionary View by generating the necessary SQL statements. The generated SQL statements can be saved in a generation protocol.

The following topics are covered below:

• Parameters

• Keywords

• Sample Output

Parameters

Values for fields which have been locked by your data dictionary administrator cannot be overwritten. These fields are skipped when positioning the cursor with the TAB key. See Generation Defaults.

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

Keywords

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

If a parameter is not specified, the default value is taken.

Sample Output

Dataspace-ID: EXAM-TABLESPACE

CREATE TABLESPACE EXAMTS IN EXAMDB
       NUMPARTS 4
       BUFFERPOOL BP0
       LOCKSIZE ANY
       CLOSE NO;

www.softwareag.com

Copyright © 2009-2016 Software AG, Darmstadt, Germany.

SEARCH   CONTENTS   |   PDF BOOKS   |   HOME   UP   PREV   NEXT