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

168 Chapter6
Announcing a Post 6.5 Release Patch
IMAGE/SQL Date Mapping Enhancement
invalid value will be displayed as '9901-12-31'
There will be no default values for lowvalue and highvalue. If lowvalue
and/or highvalue are not provided, then the code checking for
lowvalue/highvalue will not be exercised.
3. For integer DT types (DT1 - DT18), the lowvalue and the highvalue must be set to
integer values.
4. For ASCII DT types (DT25 - DT38), the lowvalue and the highvalue must be set to ascii
values (single quoted), 0 (for COBOL LOWVALUES), or -1 (for COBOL
HIGHVALUES). Single quote character cannot be included in the lowvalue or
highvalue ascii string. No padding will be done for the user. The user must provide ascii
values with the correct length. For example, for DT25, the lowvalue and highvalue
provided must be 6 characters long.
5. If the TURBO data type is P8, Z6 or Z8, and it is being mapped to DATE, then
[UNSIGNED/SIGNED] keyword can be used to indicate whether positive data should be
SIGNED or UNSIGNED when inserting data via IMAGE/SQL. The default is SIGNED.
Examples
1. Use IMAGESQL:
UPDATE TYPE IN mytable.mydate FORMAT=DT26,'******','$$$$$$' TO DATE
2. Use ISQL
INSERT INTO mytable VALUES ('9900-01-01');
This statement will PUT '******' into the TURBO field mydate.
INSERT INTO mytable VALUES ('9999-12-31');
This statement will PUT '$$$$$$' into the TURBO field mydate.
INSERT INTO date2.d2 VALUES ('9901-12-31','9901-12-31','bad date');
Invalid DATE for TurboIMAGE: set 1, item 0, column 2, record 0.
(DBERR 13512)
Number of rows processed is 0
SELECT mydate FROM mytable where mydate is null;
returns "Number of rows selected is 0"
i.e. nothing qualifies.
SELECT mydate FROM mytable WHERE mydate = '9900-01-01';
returns all records with TURBO value = '******'
(if index exist on the item, mydate, then CHAIN READ is used)
SELECT mydate FROM mytable WHERE mydate = '9999-12-31';
returns all records with TURBO value = '$$$$$$'
(if index exist on the item, mydate, then CHAIN READ is used)
SELECT mydate FROM mytable WHERE mydate = '9901-12-31';
returns all records with TURBO value is not a valid date.
(SERIAL READ is always used in this case)
3. How do you migrate your ATCINFO file?
NOTE Before migrating your ATCINFO file of your DBE, make sure you backup your
existing ATCINFO file and the matching DBE.