Load process directories  Setting the environment variables

Chapter 4: Loading TAQ Data

RAP load scripts

This section describes the scripts that instantiate the loading process.

Shell scripts

Use FTP to transfer the shell (.sh) scripts from the %Sybase%\Scripts\RAP_Load_Scriptsfolder on Windows to the $RAP_HOME directory on the server. These shell scripts control the loading process and load the RAP cache tables.

Script name

Description

rap_link.sh

Links new data source files in the $RAP_IN directory to the $RAP_DATA, $IQ_DIR, and $RAP_ARCH directories.

rap_start_pl.sh

Launches the loading process.

rap_stop_pl.sh

Creates a tickler file in the $RAP_STAT directory. The loading process stops, when the tickler file exists.

rap_tbl_bcp_pl.sh

Runs the bcp utility with arguments, determines completion status, then issues error messages, if errors occurred, and logs trail files. Called by rap_tbl_mon_pl.sh.

rap_tbl_dbisql_pl.sh

Runs the dbisql utility with arguments and determines completion status, then issues error messages, if errors occurred, and logs trail files. Called by rap_tbl_mon_pl.sh.

rap_tbl_mon_pl.sh

Looks for new data source files. This is a middle level process called by rap_start_pl.sh.

set_rap_env_pl.sh

Sets the environment variables.

rap_truncate.sh

Truncates the tables.

SQL scripts

Use FTP to transfer the .sql scripts from the %Sybase%\Scripts\RAP_Load_Scripts\IQ_Load_Scripts folder on Windows to the $LOAD_IQ_SCRIPT_DIR directory on the server. These scripts load the RAP repository tables.

Script name

Description

load_iq_stock_quote.sql

Loads the STOCK_QUOTE table.

load_iq_stock_trade.sql

Loads the STOCK_TRADE table.





Copyright © 2005. Sybase Inc. All rights reserved. Setting the environment variables

View this book as PDF