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 VLDBServer. You can run these sample queries against VLDBServer 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 VLDBServer 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 VLDBServer, be sure to
precede each query with a commit statement.
