| 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. |
