OI Attach_Table/Detach_Table utility (OpenInsight 16-Bit)
At 25 MAR 2002 07:22:33PM Donald Merkey wrote:
Is there a way of defining what is considered a system table?
We have run into an issue with the behavior of OI Detach_Table SP. It does not Detach certain System tables one of which is ImportExport. I thought it was only a system table in AREV not OI.
We have a customer with a volume attached that contains ImportExport and are trying to create a Utility to Detach and Attach between a production and test data environment. When the volume is detached the remaining ImportExport prevents the new volume from attaching.
Thanks,
At 25 MAR 2002 08:05PM Mike Ruane wrote:
Don:
System Tables, for the purposes of the detach_table command, are:
SYSDICT
SYSENV
SYSLISTS
SYSOBJ
SYSPROCS
SYSPTRS
SYSTABLES
SYSVIEWS
SYSVOLUMES
SYSTYPES
SYSTYPEMAPS
SYSPROCINDEX
SYSCOLUMNS
ACCESSIBLE_COLUMNS
SYSLHGROUP
SYSLHVERIFY
IMPORTEXPORT
WINDOWS
LOG
SYSREPOS
SYSREPOS_TEMP
SYSREPOSTYPES
SYSAPPS
SYSREPOSLOCKS
SYSREPOSLOG
SYSREPOSWINS
SYSREPOSWINEXES
SYSREPOSEVENTS
SYSREPOSEVENTEXES
SYSREPOSCLASSES
SYSREPOSPOPUPS
SYSREPOSMESSAGES
SYSREPOSAPPNOTES
SYSREPOSREPORTS
SYSREPOSRELEASES
SYSREPOSVIEWS
SYSREPOSSTORAGE
SYSREPOSTYPEFAMILIES
SYSREPOSDATASOURCES
SYSREPOSDBCOMPONENTS
SYSREPOSDBCOMPONENTEXES
Mike
At 25 MAR 2002 08:31PM Donald Merkey wrote:
Thanks Mike,
Is this list "hard coded"? What does OI use ImportExport for anyway?
Don
At 25 MAR 2002 09:10PM Mike Ruane wrote:
Hardcoded, built into the Initialize process.
At 25 MAR 2002 11:27PM Oystein Reigem wrote:
Don,
IMPORTEXPORT is used by Database Manager's Ascii Import.
- Oystein -