Hi,

We (in the lab) are currently working on the feasibility of implementing
an SQLGEN enhancement and are looking for any comments/suggestions that
the user community at large might have.

The enhancement has to do with IMAGE tables when using GENERATE ALL,
GENERATE TABLE & GENERATE INDEX. By default GENERATE ALL generates SQL
commands for all tables in the DBE (including IMAGE tables). By setting a
flag ALLBASE_ONLY (proposed new command) the user will now be able to
generate only Allbase tables. I will include a draft copy of the ES as it
stands now at the end of this mail.

Regards,

ashish
CSY-DB
[log in to unmask]

.............................................................................

        Sqlgen ALLBASE_ONLY Enhancement ES                    May 27, 1998
        ----------------------------------                    ------------

Ability to exclude Image/SQL tables in SQLGEN
*********************************************

Contents

1. Introduction
   Identification
   Motivation

2. External Specifications

3. Impacts

-----------------------------------
1. Introduction
===============
Identification
--------------

Project        Ability to exclude Image/SQL tables in SQLGEN
Description    This document describes the ES for users wanting to exclude
               Image/SQL tables in SQLGEN
Systems        HP 3000/900 (MPE/iX)
Product        ALLBASE
Release        G.2

Motivation
----------
SQLGEN generates commands for IMAGE/SQL attached tables.

SQLGEN 'generate all' is not sensitive to IMAGE/SQL attached tables and
creates SQL commands to rebuild the tables. This means that the user has to
edit out a great deal of needless SQL in order to have a backup of the DBE.


2. External Specifications:
===========================
New command:
------------
A new command setting "SET ALLBASE_ONLY {ON|OFF}" will be made available.

Setting this value to ON will indicate that only Allbase tables are to be used
in further SQLGEN statements. Therefore if SET ALLBASE_ONLY ON is used then
subsequent commands like GENERATE ALL will generate SQL scripts for only
Allbase tables defined in the DBE.

By default the value of this setting will be OFF ie., all tables will be
involved in the SQLGEN "generate" commands

The setting is valid until the end of the session or until another SET
ALLBASE_ONLY resets the value.

Usage of this setting will affect the following commands in SQLGEN:
- GENERATE ALL: This command will now generate statements that affect
        ALLBASE tables only for the current DBE
- GENERATE TABLES: This command will now generate statements to recreate
           only ALLBASE tables. The query to list table names will
           display only ALLBASE tables
- GENERATE INDEXES: This command will now generate statements to recreate
            indexes of ALLBASE tables only. The query to list table
            names will display only ALLBASE tables.

The commands GENERATE LOAD, GENERATE STATISTICS, GENERATE TABAUTH,
GENERATE VIEWS, GENERATE VIEWAUTH will NOT be affected by this setting. These
commands will generate SQL statements for all selected tables/views in the DBE
irrespective whether they be IMAGE or ALLBASE tables.

Duplicating an IMAGE DBE:
-------------------------
The following steps will need to be executed by a user wanting to duplicate a
DBE environment from source to destination.

1. Login to SQLGEN & set DBEnv to source
2. Set ALLBASE_ONLY ON
3. Generate all
4. Generate load

At the destination side:
1. Create the IMAGE DB
2. Attach this to an ALLBASE DBE
3. Use the SQLGEN schema on this DBE
4. Use the Generate load schema


3. Impacts:
===========

SQLGEN
------
The GENERATE ALL command will check to see if the SET ALLBASE_ONLY is set to
ON. In this case a filter will be built that will not display/generate any
IMAGE tables. The sub-commands that will actually be affected will be the
GENERATE TABLES & the GENERATE INDEXES.

..........................................................................