Technical data

132 Chapter6
Technical Articles
Limits in TurboIMAGE/iX
Usage
Creating the database and using it continues to be the same. The new definitions of items,
sets, paths has to be in the schema after which a database is created using DBUTIL. The
number of paths from master to detail alone can be up to 64 but from detail to master
remains at 16 only. Sample schema processor output is shown below.
When a new database is created and the size of the buffer allocated in an application is not
enough for DBINFO, it may return erroneous results.
A new flag has been set in DBUTIL which is disabled by default. If this flag is enabled, and
if the buffer size passed to DBINFO is less than needed, an error message is returned
which hints to the user to increase the buffer and try again.
Storing and restoring databases with new limits: no changes to DBSTORE and
DBRESTORE utilities because of the increased limits.
IMAGE/SQL
IMAGE/SQL is now capable of attaching the database with increased limits to a dbe and
performing the same kinds of manipulation as before.
When a user is moving from B.G2.xx or B.G3.xx to B.G4.04 version of IMAGE/SQL, the
user needs to migrate. This can be done with the help of IMAGESQL.PUB.SYS MIGRATE
command. For example:
>>IMAGESQL.PUB.SYS
>>SET SQLDBE mydbe
>>MIGRATE
Sample schema processor output Sample schema processor summary information for
a database with 240 sets, 1200 items and 64 paths. In this example, tma001 - tma174 are
masters, tma025 is an Automatic master and the rest are manual masters, tma175 -
tma240 are detail datasets. item025 in dataset tma025 is linked to item025 in datasets
tma175 and tma176. item001 in dataset tma001 has 64 paths, i.e., from tma177 to tma240
NAME CNT CT LGTH REC CAPACITY FAC LGTH SPACE
TMA001 M 2 64 6 395 10 1 396 48
TMA002 M 229 0 505 510 10 1 511 48
TMA003 M 21 0 47 52 10 6 313 16
TMA004 M 22 0 50 55 10 6 331 16
TMA005 M 30 0 66 71 10 5 356 16
TMA006 M 37 0 84 89 10 4 357 16
TMA007 M 36 0 77 82 10 6 493 16
TMA008 M 50 0 111 116 10 4 465 16
TMA009 M 31 0 69 74 10 5 371 16
TMA010 M 41 0 92 97 10 5 486 16
.
.