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 and expand the Profile node.
The following sections list the extensions provided for Netezza.
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 |
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 |
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 |
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 |
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 |