IBM DB2 for z/OS (formerly OS/390)
To create a PDM with support for features specific to the IBM DB2 for z/OS DBMS family, select the appropriate version in the DBMS field of the New Model dialog. To view these extensions to the PowerDesigner metamodel in the Resource Editor, select 
Database 
Edit Current DBMS 
and expand the Profile node.
The following table lists DB2 objects and their equivalents in PowerDesigner:
|
DB2 |
PowerDesigner |
|---|---|
|
Bufferpool |
Storage |
|
Database Partition Group |
Extended Object <<DatabasePartitionGroup>> |
|
Distinct Type |
Domain |
|
Function |
Procedure of "Function" type |
|
Index Extension |
Extended Object <<IndexExtension>> |
|
Method |
Abstract Data Type Procedure |
|
Type |
Abstract Data Type |
|
SuperView |
SubView of a View |
The following sections list the extensions provided for DB2 for z/OS.
The following extensions are available on the DB2 tab:
|
Name |
Description |
|---|---|
|
Field procedure name |
Defines the procedure that will be used as generator/cryptor of values. Scripting name: ExtFieldProcName |
|
Character subtype |
[v6.x and higher] Specifies a subtype for a character string column. Scripting name: ExtSubtypeData [up to v6.x] Specifies a subtype for a character string column (column with a CHAR,VARCHAR,or LONG VARCHAR data type). The subtype can proceed from the list defined in extended attribute type T_ForData. Scripting name: ExtData |
|
Generated value |
[v7.x and higher] Indicates that DB2 generates values for the column using the computed column function. If you select Always, the server will send an error message if you try to type a value in the column. If you select By Default, the server uses the computed column value or the value typed for the column. Scripting name: ExtGeneratedAs |
|
Implicitly hidden |
[v9.x and higher] Specifies that the column is not visible in the result for SQL statements unless you explicitly refer to the column by name. Scripting name: ImplicitlyHidden |
As security label |
[v8 and higher] Specifies that the column will contain security label values. This also indicates that the table is defined with multi-level security with row level granularity. Scripting name: SecurityLabel |
The following extensions are available on the DB2 tab:
|
Name |
Description |
|---|---|
|
Character Subtype |
[v6.x and higher] Specifies a subtype for a character string column. Scripting name: ExtSubtypeData |
The following extensions are available on the DB2 tab:
|
Name |
Description |
|---|---|
|
Enforced |
[v8 and higher] Indicates whether or not the referential constraint is enforced by the database manager during normal operations, such as insert, update, or delete. Scripting name: Enforced |
The following extensions are available on the DB2 tab:
Name |
Description |
|---|---|
Datatype |
Specifies a computed value for "As" option. Allows to select a data type in a list. Scripting name: AsDatatype |
Length |
Specifies the length of the data type Scripting name: AsDatatypeLength |
Start with |
Specifies the first value for the sequence. Scripting name: InitialStartWith |
Increment by |
Specifies the interval between consecutive values of the sequence. Scripting name: InitialIncrementBy |
Cache |
Specifies the numerical value of the cache option. Scripting name: CacheValue |
No Cache |
Specifies a computed boolean value for order option. Scripting name: NoCacheBool |
Cycle |
Specifies a computed boolean value for cycle opion. Scripting name: CycleBool |
Order |
Specifies a computed boolean value for order option. Scripting name: OrderBool |
Minimum value |
Specifies the numerical value of the minvalue option. Scripting name: LimitsMinvalueValue |
Maximum value |
Specifies the numerical value of the maxvalue option. Scripting name: LimitsMaxvalueValue |
No minimum |
Specifies a computed boolean value for no minvalue option. Scripting name: NoMinLimit |
No maximum |
Specifies a computed boolean value for no maxvalue option. Scripting name: NoMaxLimit |