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

174 Chapter 10

Technical Articles

New Features in ALLBASE/SQL Version G3

by Doug Myers

Database Lab, Commercial System Division

Overview

This article includes information on the following features of

ALLBASE/SQL included with this version G3 on MPE/iX 6.0 release

(C.60.00):

• ALLBASE/SQL manual set is on Instant Information CD-ROM

• String functions are a new feature for ALLBASE/SQL G3

• Security features introduced with ALLBASE/SQL G2

• Year 2000 compatibility introduced with ALLBASE/SQL G2

• Manuals updated

• CAST Function introduced with G1.15

Instant Information CD-ROM

The entire manual set for ALLBASE/SQL is now available on the new

CD-ROM documentation system, "Instant Information." You can now

look up information quickly in the on-line documentation.

String Functions

With the G3 release of ALLBASE/SQL and IMAGE/SQL, the supported

SQL syntax has been enhanced to include the following string

manipulation functions: UPPER, LOWER, POSITION, INSTR, TRIM,

LTRIM and RTRIM. These string functions allow you to manipulate or

examine the CHAR and VARCHAR values within the SQL syntax,

allowing for more sophisticated queries and data manipulation

commands to be formed. These string functions were designed to be

compatible with functions speciﬁed in the ANSI SQL '92 standard and

functions used in ORACLE. In cases where the ANSI SQL '92 standard

and the ORACLE functions were not compatible (such as the LTRIM

and RTRIM in ORACLE versus TRIM in the ANSI standard), both

versions where implemented. The speciﬁcations for each of these

functions follows.

Function Speciﬁcation

Lower

Converts all the characters in stringexpr to lower case