Viewing the data

The data from Historical Server is in the same format as defined when the view from the view table was created on the Adaptive Server. To store the data, Historical Server creates two system tables:

The table structures are similar to the structure of the output data files, where:

This structure, for the date and timestamp, and the data items, is identical to the structure defined in the DDL scripts Historical Server provides when a bulk copy is executed on Historical Server data files into another Adaptive Server.