Communicator e3000 MPE/iX Release 6.0 Express 1 (C.60.01) (30216-90286)

32 Chapter3

Technical Articles

IMAGE/SQL Enhancement: P and Z Data Types

UP[DATE] TYPE

Updates data type mapping information for a speciﬁed TurboIMAGE/iX data type or a

speciﬁed Mapped Column.

SYNTAX

U[PDATE] TYPE {SourceType IN { * }}

{ { MappedTable}}

{IN MappedTable.MappedColumn }

[TO NewMappedType [SIGNED ]]

[UNSIGNED]

EXAMPLES

(i) UPDATE TYPE I4 IN COMPOSER

(ii) UPDATE TYPE IN COMPOSER.BIRTHDATE TO CHAR(18)

(iii) UPDATE TYPE IN TABLE1.UNSIGNEDZ4 TO DECIMAL(4,0) UNSIGNED