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 authority to 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." |
G1 | RENAME Column or 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." |
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 what is rolled back 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 authority to 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 migration to a new 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. |
SQLINSTL file; 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." |
G1 | POSIX support (Tools) |
Starting with G1, the ALLBASE/SQL preprocessor (PSQLCOB) supports
preprocessing and generation of Microfocus COBOL source code under POSIX
(Portable Operating system Interface). |
Communicator 3000 MPE/iX Release 5.5 (Non-Platform Software Release
(C.55.00), "ALLBASE/SQL Enhancements." |
G1 | Terminate a user's connections (Connectivity) |
Terminates one or more connections for a user. New syntax for
TERMINATE USER: CID ConnectionID. |
ALLBASE/SQL Reference Manual, TERMINATE USER in
"SQL Statements." |
| Run Queue Control for ALLBASE/NET (Connectivity) |
Allows running HPDADVR in D queue for an MPE/iX session or HP-UX
connection or C queue for an MPE/iX job connection. New environment
variable: HPSQLJOBTYPE. |
Communicator 3000 MPE/iX Release 5.5 (Non-Platform Software Release
C.55.00), "ALLBASE/SQL Enhancements." |
| 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 |
| 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. |