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

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.

{{kb0168_1.png}}