Communicator e3000 MPE/iX Release 6.5 (Non-Platform Software Release C.65.00 (30216-90291)

166 Chapter6

Announcing a Post 6.5 Release Patch

IMAGE/SQL Date Mapping Enhancement

U[PDATE] 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}

[FORMAT=FormatType[,lowvalue[,highvalue]]]}

{IN MappedTable.Col

[FORMAT=FormatType[,lowvalue[,highvalue]]]}

[TO NewMappedType [SIGNED ]

[UNSIGNED]]

If NewMappedType is 'DATE', then FORMAT must be speciﬁed.

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

(iv) UPDATE TYPE IN TABLE2.MYDATE FORMAT=DT35,'000000','999999' TO DATE

(v) UPDATE TYPE X6 IN TABLE2 FORMAT=DT26,' 0',' 99' TO DATE

(vi) UPDATE TYPE IN TABLE2.MYDATE2 FORMAT=DT2,0,-1 TO DATE

(vii) UPDATE TYPE IN TABLE2.MYP8 FORMAT=DT15,0,-1 TO DATE UNSIGNED

(viii) UPDATE TYPE IN TABLE3.MYZ6 FORMAT=DT26,'******','999999' &

TO DATE SIGNED

(ix) UPDATE TYPE IN TABLE4.MYZ8 FORMAT=DT38,'--------','########' & TO DATE

UNSIGNED

(x) UPDATE TYPE K2 IN TABLE2 FORMAT=BB1 TO FLOAT

(xi) UPDATE TYPE IN TABLE2.MYBBDEC FORMAT=BB2 TO FLOAT(53)