New features in turboimage and allbase/sql

dataset size >80 gb

This enhancement in TurboIMAGE/iX removes the current 80 GB limit on the size of a dataset so as to allow users to have really large datasets. With this enhancement, the only limiting factor is the number of entries in a dataset, which can be up to 2**31 -1.

As the enhancement involves changes in the internal data structures of IMAGE, a new utility DBBIGSET provides an easy way for existing databases to migrate to the new structures. Once migrated, the structural details will be transparent to the users. User interface changes have been made to DBSCHEMA, DBUTIL and DBINFO.

Old and new format databases can co-exist in the same system.

turboimage limits

Number of items: 1200
Number of sets per database: 240
Number of paths for master : 64

All new databases created will have the benefit of increased limits. The new limits will not be applicable for old databases created under previous versions of TurboImage/iX. However, these databases will continue to function with the old limits and applications will be compatible.

ansi “AS” clause in allbase/sql

Until now, ALLBASE/SQL did not support column aliases in SELECT statement. Therefore, when there is an expression in the select list, the result is returned with a heading as "(EXPR)", when there is a constant, the heading is "(CONST)" and so on. This enhancement builds support for AS clause in SELECT statements to help the user to give a more meaningful name to the column headings. The alias name specified would be returned as the column heading in the result.