Preserving the Small TAQ Sample Data Set in the Historical Database

Before loading the larger sample data set into the historical database, you may wish to perform additional steps to preserve the small TAQ and STOCK_HISTORY table sample data in Sybase IQ.

1. Run the configure.sh script, if you have not already run it.
   The script file will not be in this directory if you do not perform this step.
2. Use a text editor to open the file load_TAQ_tables.sql from <RAP Enablement Installation Directory>/databases/iq/scripts
3. Comment out these lines:

   truncate table RAP_USER.STOCK_QUOTE;
   commit;
   truncate table RAP_USER.STOCK_TRADE;
   commit;

   This preserves the TAQ data already in the historical database.