Chapter 3: Sample Queries

Running the sample queries

The TAQ data queries run on both the RAP in-memory cache database and the RAP repository. The Interday and Historical market data queries are optimized to run on the RAP repository. You can run the TAQ query scripts against the cache database and the Interday and Historical market data query scripts against your RAP repository database using Interactive SQL: isql for the cache database and dbisql for the repository.

RAP cache

Use Interactive SQL (isql) to run the TAQ data query scripts on your RAP cache 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 account, or login, on Adaptive Server Enterprise.

For more information on running queries with Interactive SQL, see Chapter 2, “Using the isql Utility” in the Adaptive Server Enterprise Utility Guide.

RAP repository

Use Interactive SQL Java (dbisql) to run the Interday and Historical market data query scripts on your RAP repository 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.

Which version of Interactive SQL should I use?

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 the RAP repository.

If you use Interactive SQL Classic, you may get an error that says “When Force_No_Scroll_Cursors=ON, scrolling cursor operations are not supported by Sybase IQ.” when you scroll through the results. The Force_No_Scroll_Cursors option can make a significant difference in reducing query execution time and should be set ON. The error can be ignored.

For more information on running queries with Interactive SQL, see Chapter 2, “Using Interactive SQL (dbisql)” in the Sybase IQ Utility Guide.

View this book as PDF