Netezza

To create a PDM with support for features specific to the Netezza 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 Start of the navigation path Database Next navigation step Edit Current DBMS End of the navigation path and expand the Profile node.

The following sections list the extensions provided for Netezza.

Columns (v5.0 and higher)

The following extensions are available on the Standard Checks tab:

Name	Description
Default constraint name	Specifies the constraint name for default constraint Scripting name: `DefaultConstName`
Not null constraint name	Specifies the constraint name for not null constraint. Scripting name: `NotNullConstName`

Name

Description

Default constraint name

Specifies the constraint name for default constraint

Scripting name: DefaultConstName

Not null constraint name

Specifies the constraint name for not null constraint.

Scripting name: NotNullConstName

Tables

The following extensions are available on the Options tab:

Name	Description
Distribution type	Specifies the type of row distribution. You can choose between None, hash, and random (on General tab for v4.5). Scripting name: `Distribution`
Columns	[hash or random distribution] Specifies the hash distribution columns (on General tab for v4.5). Scripting name: `DistributeOnExplicitColumnList`
Organize on	Specifies whether or not the table is organized. Scripting name: `Organized`
Columns	[organized table] Specifies the list of columns. Scripting name: `OrganizedColumnList`
Options	Displays the options defined for the table. Scripting name: `TableOption`

Databases (v5.0 and higher)

The following extensions are available on the General tab:

Name	Description
Character set	Specifies the default character set and collation. The default and only supported value is Latin9. Scripting name: `Charset`
Collation	The collation is binary. You cannot specify other values. Scripting name: `Collation`

Name

Description

Character set

Specifies the default character set and collation. The default and only supported value is Latin9.

Scripting name: Charset

Collation

The collation is binary. You cannot specify other values.

Scripting name: Collation

Users/Groups (v5.0 and higher)

The following extensions are available on the Options tab:

Name	Description
SysId	Specifies the SYSID clause to choose the group ID of the new user/group. Scripting name: `SysId`
Owner	The user that created this user/group. Scripting name: `Owner`
Rowset limit	Specifies the maximum number of rows any query run by this user (or group) can return. Scripting name: `RowsetLimit`
Query timeout	Specifies the amount of time a query can run before the system sends the administrator a message. Scripting name: `QueryTimeout`
Session idle timeout	Specifies the amount of time a session can be idle before the system terminates it. Scripting name: `SessionTimeout`
Session priority	[group only] Specifies the default priority for the group. Scripting name: `DefPriority`
Default priority	[user only] Specifies the default priority for the user. Scripting name: `DefPriority`
Maximum priority	Specifies the maximum priority for the user/group. Scripting name: `MaxPriority`
Minimum resource	[group only] Specifies the minimum percentage of the system that a resource group will use when it has jobs. Scripting name: `ResourceMinimum`
Maximum resource	[group only] Specifies the maximum percentage of the system that a resource group can use. Scripting name: `ResourceMaximum`
Job maximum	[group only] Specifies the maximum number of concurrent jobs that a single resource group can run. Scripting name: `JobMaximum`
Password	[user only] Specifies the password used for database connection. Scripting name: `PasswordDisplay`
Valid until	[user only] Specifies the password validity. Scripting name: `ValidUntil`
Expire	[user only] Specify is the password expires on next connection. Scripting name: `ExpirePassword`
Authentication	[user only] Overrides the authentication for the user to LOCAL if specified. DEFAULT is the connection setting or whatever authentication is set. Scripting name: `Authentication`

Sequences (v5.0 and higher)

The following extensions are available on the Options tab:

Name	Description
Datatype	Specifies the data type. The value can be any exact integer type such as byteint, smallint, integer, or bigint. Scripting name: `As`
Start with	Specifies the starting value. Scripting name: `StartWith`
Increment	Specifies the increment value. The integer value can be any positive or negative integer, but it cannot be zero. Scripting name: `IncrementBy`
Minimum	Specifies the minimum value of the sequence. Scripting name: `Minvalue`
No min value	Results in a value of 1. Scripting name: `NoMinvalue`
Maximum	Specifies the maximum value of the sequence. Scripting name: `Maxvalue`
No max value	Results in the largest value for the specified datatype. Scripting name: `NoMaxvalue`
Cycle	Specifies whether the sequence continues to generate values after reaching either its maximum value (in an ascending sequence) or its minimum value (in a descending sequence). Scripting name: `Cycle`