Communicator 3000 MPE/iX Release 6.0 (Platform Software Release C.60.00) (30216-90269)

Chapter 10 179
Technical Articles
New Features in ALLBASE/SQL Version G3
CAST Syntax
{CAST ({Expression NULL}{AS,}DataType[,FormatSpec])}
Parameters
Expression Column, USER function, host variable, local variable,
AddMonths function, aggregate function, date/time
conversion function, dynamic parameter, or procedure
parameter, constant, current function, long column
function, string function, or any combination of these in
an arithmetic or concatenation expression.
DataType ALLBASE/SQL data type: CHAR(n), VARCHAR(n),
DECIMAL(p[,s]), FLOAT, REAL, INTEGER,
SMALLINT, DATE, TIME, DATETIME, INTERVAL,
BINARY(n), VARBINARY(n).
The LONG BINARY(n) and LONG VARBINARY(n)
cannot be used in the CAST operations.
FormatSpec Format specification used for DATE, TIME,
DATETIME, INTERVAL conversions. FormatSpec is the
same as that used in the date/time conversion
functions. See the ALLBASE/SQL Reference Manual
for more details.
Pseudo-Mapped Files Removed from
ALLBASE/SQL
by Poongodi R and Doug Myers
Commercial Systems Division
Introduction
This article provides information regarding the handling of
pseudo-mapped files when installing ALLBASE/SQL. Pseudo-mapped
files in MPE XL are disk files that are accessed without the usual file
mapping by the operating system.
Pseudo-mapped files are no longer supported by ALLBASE/SQL. If the
pseudo-mapped files already exist in the system, they will not be
supported on the G.0 (or later) versions. Serious system problems may
occur because of the use of pseudo-mapped files.
NOTE The conversion from pseudo-mapped to mapped MUST be done on an
F.0 version before updating to G.x. You cannot do the conversion after
the system has been updated.