Hi Denys,

Good stuff !!

There are a few really useful things in there for example:
UPDSTAT   : Update statistics for tables in DBE belongingto the TIDB.

One thing I am regularly asked about is how to drop the views generated by
IMAGESQL, I now have an easier way than the scripts which are lying around
our system and that is to use the MKVIEW and then
D E"DROP" in QUAD :-)

______________________________________________
Ken Vickers
LINKWAY Development and Support
______________________________________________

-----Original Message-----
From: Denys Beauchemin <[log in to unmask]>
<snip>
>A good point, but the issue is easily solved.  About 6 years ago, I wrote a
>program called DBTune/SQL which allows you to do just that.  It is freeware
>and available for download at www.hicomp.com/toc.htm.
>
>It has several other features to help you manage an attached database.
>
<snip>
>-----Original Message-----
>From: Ken Vickers [SMTP:[log in to unmask]]
>Sent: Wednesday, 17 June, 1998 10:00 AM
>To: [log in to unmask]; [log in to unmask]; [log in to unmask]
>Subject: Re:      Re: SQLGEN Allbase_only enhancement
>
>I agree with Denys whole-heartedly BUT what would be REALLY useful, would
>be
>to have SQLGEN to create an IMAGESQL execute file for the attachments for
>those who did not think to save the ATCLOG when they attached them in the
>first place!
<snip>
>Subject: Re: SQLGEN Allbase_only enhancement
>
>
>>X-no-Archive:yes
>>That is welcome news indeed.  I would even propose that the flag be turned
>>on by default.  It never made sense to me that SQLGEN would create all the
>>SQL calls to create the IMAGE tables which would then not be able to be
>>created by IMAGESQL's ATTACH command.  Attaching an IMAGE database
>>effectively rendered SQLGEN useless.
>>
>>Good stuff!
>>
>>Kind regards,
>>
>>Denys. . .
>>
<snip>
>>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
>>
>><Excellent proposal snipped>
>>
>
>