ALLBASE/SQL Reference Manual (36216-90216)

37
New Features in G1, G2 and G3
The following table highlights the new or changed functionality added in G1, G2 and G3
releases, and shows you where each feature is documented.
Ver. Feature (Category) Description Documented in...
G3 String Functions
(Usability)
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
manipulation commands to be
formed.
In future version of the
ALLBASE/SQL Reference
Manual.
G2 Allow or disallow
SQLMON for users.
(Usability)
Grants or revokes the ability to
run SQLMON for specific users.
New attribute for GRANT and
REVOKE: MONITOR.
ALLBASE/SQL Reference
Manual, GRANT, REVOKE in
“SQL Statements.”
G2 Allow or disallow
authorityto create
modules.
(Usability)
Grants or revokes the ability to
create modules for specific users.
New attributes for GRANT and
REVOKE: INSTALL.
ALLBASE/SQL Reference
Manual, GRANT, REVOKE in
“SQL Statements.”
G2 PC ODBC 16-bit
and 32-bit support
(Connectivity,
Client/Server)
ODBCLINK/SE allows
connectivity to ALLBASE and
IMAGE/SQL servers from a PC
running MS Windows using
ODBC.
ODBCLINK/SE Reference
Manual
G2 Year 2000 solution
(Standards)
Provides the JCW
HPSQLSPLITCENTURY to use in
setting a value between 0 and
99. This value is used to change
the century part of the DATE and
DATETIME functions to override
the default of 19.
“Date/Time Functions” in the
“Expressions” chapter of the
ALLBASE/SQL Reference
Manual.
G1 New operand to
concatenate
strings
(Standards)
Adds an operand to concatenate
character or binary strings in an
expression. New operand: ||
ALLBASE/SQL Reference
Manual, “Expressions.”