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. |
![]() |