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

Chapter 6 165
Announcing a Post 6.5 Release Patch
IMAGE/SQL Date Mapping Enhancement
SP(LIT)
Divides a large mapped column into two or more smaller columns.
Syntax
SP[LIT] MappedTable.MappedColumn INTO
NewMappedColumn:SourceType
[FORMAT=FormatType[,lowvalue[,highvalue]]]
[:MappedType [SIGNED ]
[UNSIGNED]] [,...]
If MappedType is 'DATE', then FORMAT must be specified.
Example
(i) SPLIT TABLE1.COLUMN5 INTO NEWCOLUMN1:I4:CHAR(8),&
NEWCOLUMN2:X20,&
NEWCOLUMN3:K3:DECIMAL(15,0)
(ii) SPLIT TABLE2.COLUMN3 INTO NEWCOL1:I4:CHAR(8),&
NEWCOL2:X20,&
NEWCOL3:Z4:DECIMAL(4,0) UNSIGNED
(iii) SPLIT TABLE2.MYDATE INTO &
MYDATE1:X6 FORMAT=DT35,'000000','999999':DATE, &
MYDATE2:X6 FORMAT=DT36,'******','&&&&&&':DATE
(iv) SPLIT TABLE2.DDATE INTO &
DDATE1:X6 FORMAT=DT26,' 0',' 99':DATE,&
DDATE2:X6 FORMAT=DT25,' ','------':DATE
(vi) SPLIT TABLE2.MYDATE2 INTO &
MYDATE2_1:I2 FORMAT=DT2,0,-1:DATE, &
MYDATE2_2:I2 FORMAT=DT2,0,-1:DATE
(vii) SPLIT TABLE1.COLUMN5 INTO NEWCOLUMN1:I4:CHAR(8),&
NEWCOUMNL2:X20,&
NEWCOLUMN3:K4:FORMAT=BB2:FLOAT
(viii) SPLIT TABLE2.MYBBDECS INTO &
MYBBDEC_1:K2 FORMAT=BB1:FLOAT, &
MYBBDEC_1:K4 FORMAT=BB2:FLOAT