Supported Informix datatypes

The Informix database interfaces support the Informix datatypes listed in the following table in DataWindow objects and embedded SQL.

Blob

LVarChar

Boolean

Money

Byte (a maximum of 2^31 bytes)

NChar

Char

NVarChar

Clob

Real

Date

Serial

DateTime

Serial8

Decimal

SmallInt (2 bytes)

Float

Text (a maximum of 2^31 bytes)

Int8

Time

Integer (4 bytes)

VarChar (1 to 255 bytes)

Interval

 


Datatype conversion

When you retrieve or update columns, PowerBuilder converts data appropriately between the Informix datatype and the PowerScript datatype. Keep in mind, however, that similarly or identically named Informix and PowerScript datatypes do not necessarily have the same definitions.

For information about the definitions of PowerScript datatypes, see Datatypes in PowerScript Reference.

Informix DateTime datatype

The DateTime datatype is a contiguous sequence of boxes. Each box represents a component of time that you want to record. The syntax is:

DATETIME largest_qualifier TO smallest_qualifier

PowerBuilder defaults to Year TO Fraction(5).

For a list of qualifiers, see your Informix documentation.

To create your own variation of the DateTime datatype:

  1. In the Database painter, create a table with a DateTime column.

    For instructions on creating a table, see the section called “Working with tables” in Users Guide.

  2. In the Columns view, select Pending Syntax from the Objects or pop-up menu.

    The Columns view displays the pending changes to the table definition. These changes execute only when you click the Save button to save the table definition.

  3. Select Copy from the Edit or pop-up menu or click the Copy button.

    The SQL syntax (or the portion you selected) is copied to the clipboard.

  4. In the ISQL view, modify the DateTime syntax and execute the CREATE TABLE statement.

    For instructions on using the ISQL view, see Users Guide.

Informix Time datatype

The Informix database interfaces also support a time datatype. The time datatype is a subset of the DateTime datatype. The time datatype uses only the time qualifier boxes.

Informix Interval datatype

The interval datatype is one value or a sequence of values that represent a component of time. The syntax is:

INTERVAL largest_qualifier TO smallest_qualifier

PowerBuilder defaults to Day(3) TO Day. For more about interval datatypes, see your Informix documentation.