Data Warehousing: Updates-Only Feature for Runtime Systems (Warehousing) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Data Warehousing: Updates-Only Feature for Runtime Systems (Warehousing) ======

======   ======

==== Created at 17 AUG 1998 04:08PM ====




In the Client/Server Workspace, when you select a table in the Configure Warehouse wizard to perform Updates-Only, an MFS is placed on that table. This MFS keeps a log of all the transactions processed on that table in the SYSLISTS table, stored in the format XQ*//tablename//.

 

Although an MFS can operate in either a development or runtime version of OpenInsight, the data warehousing functions are only available in development copies of OpenInsight. If you attempt to attach a runtime copy of a table into your development system for modification, the corresponding SYSLIST entries will be unavailable. To work around this, it is possible to use a table other than SYSLISTS to store the transaction list.

 

The attached XQSETTBL.TXT file contains code that will allow you to designate an alternate destination table for the transaction history. To use this file, create a new Stored Procedure and paste the contents of the text file into it. Compile the code.

 

The syntax for the new Stored Procedure is:

 

XQSETTABLE(//tablename//)

 

//tablename// is the name of the alternate destination table.

 

[[http://www.revelation.com/o4wtrs/KB_Articles/KB0168_files/xqsettbl.txt|{{kb0168_1.png}} ]]