Data Warehouseing from within a Basic+ Program (None Specified)
At 14 OCT 1999 10:29:29AM Debbie Cornett wrote:
Has anyone had experience with invoking the warehouseing process from within a program instead of the client/server workspace?
At 14 OCT 1999 11:18AM Stephen S. Revelation wrote:
Debbie,
Once you create a Warehouse Procedure, the code for the procedure is stored as a stored procedure 'WP_'. You can view the source of the procedure from System Editor and run this procedure, modify it, with desired arguments (specified within the procedure) from the Exec line.
-Stephen
At 14 OCT 1999 05:19PM Debbie Cornett wrote:
Probably a dumb question, what do I user for the handle parameter? I took the pieces of the stored procedure and stuffed them into my program. Have it all down except the file handle.
Thanks!
At 15 OCT 1999 02:39PM Stephen S. Revelation wrote:
Debbie,
The handle is returned from use of the XOInstance function. Because of this, it may be best to include WP_ within another function which gets the handle and passes IT to the WP_ and run this from the Exec. line.
Even better might be to write a stored procedure not using a WP created from Warehouse Manager. Simply use these procedures generated as a guideline.
-Stephen