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.

Note: The DBMSs for Informix v8-9 are deprecated.

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

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

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

Name

Description

InternalID

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

Scripting name: InternalID