ALLBASE/SQL Reference Manual (36216-90216)

39
G1 Terminate a query
(Usability,
Performance)
Allows termination of a query for
a connection or transaction. New
statement: TERMINATE QUERY.
New syntax for SET SESSION,
SET TRANSACTION.
ALLBASE/SQL Reference
Manual,TERMINATE QUERY,
SET SESSION, SET
TRANSACTION in “SQL
Statements.”
G1 Terminate a
transaction
(Usability,
Performance)
Allows stopping of a given
transaction. New statement:
TERMINATE TRANSACTION.New
syntax for SET SESSION, SET
TRANSACTION.
ALLBASE/SQL Reference
Manual, TERMINATE
TRANSACTION, SET
SESSION, SET TRANSACTION
in “SQL Statements.”
G1 Timeout enhanced
to allow specifying
whatisrolledback
or terminated
(Usability,
Performance)
Allows specifying the action
when a timeout expires. New
attributes for SET SESSION and
SET TRANSACTION:
TERMINATION AT LEVEL,
USER TIMEOUT, ON TIMEOUT
ROLLBACK.
ALLBASE/SQL Reference
Manual, in “SQL Statements.”
G1 New SQLUtil
command
CHKPTHLP reduces
time for flushing
data
(Performance)
Flushes the data in parallel to
the CHECKPOINT command in
ISQL. New SQLUtil command:
CHKPTHLP.
ALLBASE/SQL Database
Administration Guide,
CHKPTHLP in “SQLUtil”
G1 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.”
G1 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.”
G1 Script for
migrationtoanew
release (Usability,
Tools)
Provides SQLLINSTL script for
migration to a new release of
ALLBASE/SQL. Read the
SQLINSTL file on your system
for more information.
SQLINSTLfile;Communicator
3000 MPE/iX Release 5.5
(Non-Platform Software
Release C.55.00),
“ALLBASE/SQL
Enhancements”;
ALLBASE/SQL Database
Administration Guide in
‘SQLINSTL” section of the
“DBA Tasks and Tools”
chapter.
G1 GENPLAN on a
section (Usability)
Obtains an access plan of a
stored static query by specifying
the module and section number.
Changed syntax: GENPLAN.
ALLBASE/SQL Reference
Manual, GENPLAN in “SQL
Statements.”
Ver. Feature (Category) Description Documented in...