The next release of IMAGE/SQL, currently in beta, with the general release
for June, 1995, contains the following enhancements:
 
TurboIMAGE X.06.00
------------------
- Datasets can be greater than 4GB. A dataset can have multiple MPE files.
  By simply adding a control statement to the schema, any dataset will
  automatically become a "Jumbo Dataset."
 
- DBUTIL and DBSCHEMA have been converted to native mode. This will increase
  the speed of compiling the DBSCHEMA.
 
- Internal tables expanded to accomodate large log files when using DBRECOV.
  This enhancement results in easier logging cycle management.
 
- DBPUT and CIUPDATE check for integrity of neighboring entries before
  inserting into a chain.
 
- More detail added to the status register and error messages for
  Errors 18, -307, 1nn, Abort due to lost free space.
 
- DBUTIL allows detaching all DBEs from a given database.
 
IMAGE/SQL X.G1.00
-----------------
- Data is retrieved more efficiently when a mapped column represents a
  TurboIMAGE search item. Chained reads are used whenever possible for packed
  and zoned search items.
 
- Predicate level locking is used whenever possible. Only the rows containing
  data are locked. This promotes a high level of concurrency.
 
- The ALLBASE/SQL optimizer is used with TurboIMAGE search items, key items,
  and third party indexes (Bradmark's Superdex and DISC's Omnidex).
  The optimizer decides what indexes to use and the proper order of
  operations, resulting in use of the most efficient path to the desired data.
 
- String concatenation will be allowed by using two vertical bars between
  strings. (to be released in A.G1.05 or later)
 
ALLBASE/SQL A.G1.04
-------------------
- AUTOCOMMIT option for VALIDATE. This will help to avoid a log full condition
.
  (to be released in A.G1.05 or later)
 
- String concatenation will be allowed by using two vertical bars between
  strings. (to be released in A.G1.05 or later)
 
- Ability to use SQLUtil STOREONLINE with nonarchive logging option.
  This will enable the user to access the DBEnvironment when backup is in
  progress without having to worry about maintainance of the log files.
 
- SQLMON has capability to find the root cause of a locking problems.
  SQLMON will programmatically examine each session that is holding locks,
  Therefore it will be faster to resolve performance bottlenecks on the system
.
 
- Tables and columns can be renamed. You will no longer have to unload and
  reload date when you want to change naming conventions for your databases.
 
- Binary Large Objects (BLOBS) allowed with the GUPTA PC API; BLOBS
  allowed with ODBC PC API in A.G1.05.
 
- Multi-Row Stored Procedures allowed with GUPTA and ODBC PC API.  The user
  can execute multiple selects ina procedure.  Triggers and rules can be
  used to validate data entry.
 
- PC API allows you do turn on data compression for client server users.