Informix SQL

To create a PDM with support for features specific to the Informix SQL 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 Informix SQL.

Columns

The following extensions are available on the Informix tab:

Name

Description

Serial Start

Specifies the initial value of the column with a SERIAL datatype.

Scripting name: ExtSerialStart

Indexes

The following extensions are available on the Extended Attributes tab:

Name

Description

IndexSpec

Specifies an internal index definition (indexkeys column).

Scripting name: IndexSpec

Procedures

The following extensions are available on the Extended Attributes tab:

Name

Description

InternalID

Specifies an internal identifier in the server, which is used to retrieve the function of an index expression.

Scripting name: InternalID