Subject RE: [ib-support] Dropping table from application
Author Helen Borrie
At 11:12 AM 23-11-02 -0500, you wrote:
> >>Cleanup is by deleting (or, preferably, disabling) that set of
> >>rows;
>
>Helen,
>
>What do you mean 'disabling'? I use the technique and delete the rows.
>Don't know how to disable.

It's just a technique you can use if you are storing rows that you want to
keep but want to make inaccessible to your applications. Include a single
byte column "IsActive". Set it to 'T' when you insert the row, set it to
'F' when you have performed whatever you want to do with it.

Have applications ignore the "disabled" rows by including

.. WHERE IsActive <> 'F'

At cleanup time, maybe as part of your end of day, use

WHERE IsActive = 'F' to select the disabled rows for deletion, archiving, etc.

heLen