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