Moving the sample data to the server

All sample data for the RAP repository is located in the %Sybase%\Data\IQ\RAP_Input directory. Although Sybase distributes sample data as comma separated value (.csv) files, some data has been compressed (.zip) to conserve disk space.

Preparing the reference sample data

The reference table sample data is loaded into all tables except the STOCK_TRADE and STOCK_QUOTE tables. You must unzip one file, then use FTP to transfer all of the .csv data files to the machine on which the IQ server resides.

1. Unzip the STOCK_HISTORY.zip file located in the %Sybase%\Data\IQ\RAP_Input directory.

2. Use FTP to transfer all of the .csv files in the %Sybase%\Data\IQ\RAP_Input folder from Windows to the UNIX machine on which the IQ server resides. The .csv files, which contain the sample data, must be transferred in ASCII format. The sample data in these files is loaded into the reference tables in the ASE database.

   Note The .csv files must be in the same location (folder or directory) as the Sybase IQ database files and the directory from which the Sybase IQ server is started.

Preparing the TAQ sample data

The TAQ sample data, which is loaded into the STOCK_TRADE and STOCK_QUOTE tables, must be unzipped and transferred using FTP.

1. Unzip the STOCK_QUOTE.zip and STOCK_TRADE.zip files located in the %Sybase%\Data\IQ\RAP_Input directory.

2. Use FTP to transfer in ASCII mode the data files STOCK_QUOTE.csv and STOCK_TRADE.csv from Windows to the UNIX machine on which the IQ server resides.

   The .csv files, which contain the sample data, must be transferred in ASCII format.

Refer to the section “Loading additional TAQ sample data” in Chapter 4, “Loading TAQ Data” for information on loading this sample data into the STOCK_TRADE and STOCK_QUOTE tables in the RAP repository.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF