Editing the script files

All script files are located %Sybase%\Data\ASE\RAP_Load directory. These files contain placeholders that you must change to values that correspond to the RAP cache database.

Shell scripts

Use an editor to change the placeholders in the load_unix_ase_rap_tables.sh and load_unix_ASE_TAQ_tables.sh scripts to match the server, database, and path names:

SQL scripts

Change this...	To your value for this...
<ASE Server>	Server name
<ASE Database>	Database name
<path>	Full path to the .csv files
<Database Name>	Database name

Use an editor to change the <Database Name> placeholder in the truncate_tables_ase.sql script to match the RAP cache database name.

Notes

The parameters <ASE Database> and <Database Name> are equal to rapt and rapq for the ASE sample databases. You must edit these files and run the load process for each database.
Globally change <path> to the full path of the %SYBASE%\Risk Analytics Platform 2.0\Data\ASE\RAP_Load directory or to the location of the reference table .csv data files. The path must reflect the location of .csv files as the server sees them and the files must be accessible to the server.
Because rapq and rapt are temporary databases, all data is truncated in these databases every time the server restarts. These databases are created by the RAP_DB_Devices.sql script. To preserve data in the reference tables, load the data permanently in the model database. This ensures that the temporary databases rapq and rapt contain the reference data every time the server starts.

Use an editor to change the <TRADE DataBase> and <QUOTE DataBase> placeholders in the truncate_ASE_TAQ_tables_ase.sql script to match the cache database names. This script truncates both the STOCK_TRADE table in one cache database and the STOCK_QUOTE table in the other cache database. For the ASE sample databases, <TRADE DataBase> is rapt and <QUOTE DataBase> is rapq.