Bulk Table copy.

Ian Pizey ( ifpizey@kenora.com )
Tue, 14 Jul 1998 14:20:09 -0500

Does any one know how to copy the calls table within the emerald
database to another
table that can be used for archive purposes. That in turn can be used for
user time look ups.

The table would have a different name and contain the same structure and
data as the current table. i asssume that once the table is created a
nightly trigger can update this table and therefore have near on line time
available for the users. I realize that the purpose of the consolidation
process is to reduce the amount of data in the calls table. However the
need for online time checking does save a needless administrative burden
and provides the customers with better service.

A response would be appreciated.

Ian Pizey
Technet of Kenora Inc.
924 5th Street South
Kenora, ON P9N 1L8
Ph 807-468-8900
Fx 807-468-7700