Historical market data queries compare price histories for different instruments over time. Historical market data does not change frequently and updates typically occur at the end of the trading day.
Historical data queries are optimized for RAP, as they require the content of the market data repository. You can run these sample queries against the RAP repository with Interactive SQL (dbisql).
For more information on running queries with Interactive SQL, see Chapter 2, “Using Interactive SQL (dbisql)” in the Sybase IQ Utility Guide.
The Historical market data queries for the RAP repository
all begin with a commit statement. This commit statement
causes the data to refresh, so the query accesses the most recent
data. When you write your own queries for the RAP repository, be
sure to precede the query with a commit statement.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
