The TAQ data queries run on RAPCache and VLDBServer. The Interday and Historical market data queries are optimized to run on VLDBServer. You can run the TAQ query scripts against the cache database and the Interday and Historical market data query scripts against VLDBServer using Interactive SQL: isql for the RAPCache database and dbisql for VLDBServer.
Use Interactive SQL (isql) to run the TAQ data query scripts on your RAPCache database. isql sends Transact-SQL commands to Adaptive Server Enterprise, formatting the results and printing them to standard output. There is no maximum size for an isql statement. To use Transact-SQL directly from the operating system with the isql utility program, you must have an Adaptive Server Enterprise account or login.
For more information on running queries with Interactive SQL, see Chapter 2, “Using the isql Utility” in the Adaptive Server Enterprise Utility Guide.
Use Interactive SQL Java (dbisql) to run the Interday and Historical market data query scripts on your VLDBServer database.
Interactive SQL (dbisql) is an application that allows you to type a SQL statement and send it to a database. Because interactions with databases use SQL statements, you can carry out any database operation from dbisql.
Although both Interactive SQL Classic (dbisqlc) and Interactive SQL Java (dbisql) are included, Sybase recommends that you use Interactive SQL Java to run the queries on VLDBServer.
The Force_No_Scroll_Cursors option
can make a significant difference in reducing query execution time
and should be set ON. If you use Interactive SQL Classic, when you
scroll through the results you may get an error that says “When
Force_No_Scroll_Cursors=ON,
scrolling cursor operations are not supported by Sybase IQ.” You
can ignore this error.
For more information on running queries with Interactive SQL, see Chapter 2, “Using Interactive SQL (dbisql)” in the Sybase IQ Utility Guide.
