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 Database > Edit Current DBMS 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

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

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