A data file contains the data for a single view recorded during a session. The file name is dsessionid_viewnumber_viewname where:
sessionid is the unique identifier for the session.
viewnumber is a number greater than or equal to one that reflects the order in which views were defined for the session.
viewname is the user-supplied name for the view, truncated if necessary to conform to the file-naming conventions of the current platform. On the Windows NT platform, the file name is limited to eight characters.
One record in the file exists for each unique combination of data item key field values that occurred in each sample taken.
Each such record holds:
Date and time of the sample
This timestamp is based on the local time in effect at the Adaptive Server that was monitored
Values of all of the data items sampled
If no data is returned for this view during a given sample interval, a placeholder record is written to the historical data file. This record contains the timestamp of the sample, followed by a comma-separated list of empty values. That is, the timestamp field is followed by as many commas as are needed to separate the remaining data items of the view, but no values are stored for those data items. This format is acceptable to the Bulk Copy utility, provided that the columns into which the data items are being copied will accept nulls.
