
What's New in this Release
The following table highlights the new or c hanged functionalit y in this release, and sho ws you where each feature is documen ted.
New Features in ALLBASE/SQL Release G.0
Feature (Category) | Description | Documented in . . . |
|
|
|
Stored procedures | Provides additional stored | ALLBASE/SQL Reference Manual , \SQL |
(Usability) | procedure functionality for | Statements" and \Using Procedures" in |
| application programs. Allo ws | \Constraints, Procedures and Rules;" |
| declaration of a procedure cursor | ALLBASE/SQL Advanced Application |
| and fetching of multiple rows | Programming Guide , \Using Procedures in |
| within a procedure to applications. | Application Programs." |
| New statement: ADVANCE. |
|
| Changed syntax: CLOSE, |
|
| CREATE PROCEDURE, |
|
| DECLARE CURSOR, |
|
| DESCRIBE, EXECUTE, |
|
| EXECUTE PROCEDURE, |
|
| FETCH, OPEN. |
|
|
|
|
Case insensitivit y | Adds an optional attribute to the | ALLBASE/SQL Reference Manual , |
(Usability) | character and varchar type column | \Comparison Predicate" in \Searc h |
| attributes of tables. Allows search | Conditions," CREATE TABLE in \SQL |
| and compare of these columns in a | Statements." |
| case insensitive manner. Four new |
|
| SQLCore data types are added. |
|
| Changed syntax: ALTER TABLE, |
|
| CREATE TABLE. |
|
|
|
|
Support for 1023 | Increases the maxim um number of |
columns | columns per table or view to 1023. |
(Usability) | Increases maximum sort columns |
| and parameters in a procedure to |
| 1023. |
|
|
ALLBASE/SQL Reference Manual ,
CREATE TABLE and CREATE VIEW in
\SQL Statements;" ALLBASE/SQL
Database Administration Guide ,
\ALLBASE/SQL Limits" appendix.
ISQL HELP | Gives help for entire command | ISQL Reference Manual for ALLBASE/SQL |
improvements | instead of only the verb. | and IMAGE/SQL, HELP in \ISQL |
(Usability) |
| Commands." |
|
|
|
EXTRACT | Extracts modules from the | ISQL Reference Manual for ALLBASE/SQL |
command | database and stores them in a | and IMAGE/SQL, \Using Modules" in |
(Usability) | module le. Allows for creation of | \Using ISQL for Database T asks," |
| a module le at any time based on | EXTRACT, INSTALL in \ISQL |
| the current DBEnvironment | Commands." |
| without preprocessing. New |
|
| command: EXTRACT. Changed |
|
| syntax: INSTALL. |
|
|
|
|
vi