Preserving the Small TAQ Sample Data Set

If you load the larger sample data set into RAP, the TAQ data already in RAPStore and the STOCK_HISTORY table will be lost. To preserve the old sample data, you must perform additional steps.

To preserve the TAQ data already in RAPStore and the STOCK_HISTORY table:

  1. Open the file load_unix_IQ_TAQ_tables.tst for edit.
  2. Comment out the following commands: 
    truncate table DBA.STOCK_QUOTE;
commit;
truncate table DBA.STOCK_TRADE;
commit;
    load_unix_IQ_TAQ_tables.tst is called by load_unix_IQ_TAQ_tables.sh. This preserves the TAQ data already in RAPStore.
  3. Comment out the following commands: 
    truncate table DBA.STOCK_HISTORY;
commit;
    This preserves the TAQ data already in the STOCK_HISTORY table.
Parent topic: Loading Additional TAQ Sample Data

Created October 8, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com