ALLBASE/SQL Reference Manual (36216-90216)

38
G1 RENAME Columnor
Table (Usability)
Adds capability of defining a new
name for an existing table or
column in a DBEnvironment.
You cannot rename a table or
column that has check
constraints or an IMAGE/SQL
table. New commands: RENAME
COLUMN, RENAME TABLE.
ALLBASE/SQL Reference
Manual, RENAME COLUMN and
RENAME TABLE in “SQL
Statements.”
G1 CAST function
added to
Expression syntax
(Usability)
Adds the CAST function to allow
explicitly converting from one
data type to another. It allows
conversion between compatible
data types and between
normally incompatible data
types such as CHAR and
INTEGER. New Expression
function: CastFunction.
ALLBASE/SQL Reference
Manual, “Cast” in
“Expressions.”
G1 Syntax added to
VALIDATE
(Usability,
Performance)
Automates execution of COMMIT
WORK after each module or
procedures is validated when
WITH AUTOCOMMIT is used. All
sections are revalidated whether
valid or invalid when FORCE is
used. This can reduce log space
and shared memory
requirements for the VALIDATE
statement. New syntax for
VALIDATE: FORCE, WITH
AUTOCOMMIT.
ALLBASE/SQL Reference
Manual, VALIDATE in “SQL
Statements.”
G1 Syntax added to
DELETE (Usability,
Performance)
Automates execution of COMMIT
WORK at the beginning of the
DELETE and after each batch of
rows is deleted when WITH
AUTOCOMMIT is used. Reduces
log-space and shared-memory
requirements. WITH
AUTOCOMMIT cannot be used in
some cases (see the DELETE
statement). New syntax for
DELETE: WITH AUTOCOMMIT.
ALLBASE/SQL Reference
Manual, DELETE in “SQL
Statements.”
G1 Decimal
operations
(Usability)
Increases maximum precision
from 18 to 27.
ALLBASE/SQL Reference
Manual, “Decimal Operations”
in “Data Types.”
Ver. Feature (Category) Description Documented in...