Overview  Historical data queries

Chapter 3: Sample Queries

SQL scripts

The SQL scripts for the Risk Analytics sample historical market and TAQ data queries are in the folder %Sybase%/Risk Analytics Platform 1.0\Scripts\RAP Queries. You can run these queries on your Sybase IQ sample database in Interactive SQL Java (dbisql).

If you use Interactive SQL Classic (dbisqlc) to run the queries, the error “When Force_No_Scroll_Cursors=ON, scrolling cursor operations are not supported by Sybase IQ.” may be returned when you are scrolling 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 in a Sybase IQ database using Interactive SQL, see Chapter 2, “Using Interactive SQL (dbisql)” in the Sybase IQ Utility Guide.





Copyright © 2005. Sybase Inc. All rights reserved. Historical data queries

View this book as PDF