Previous Topic: Rowset ConceptNext Topic: DBSQLPR Delimiter Separated Values Output


Accessing AutoCollect Data Using DBSQLPR

Products such as the CA Datacom Server can use SQL to directly access the Delta tables, apply various functions, and build result sets. With CA Datacom Server, these results can be loaded directly into a Microsoft Excel spreadsheet.

AutoCollect provides the ability to build Summary and Baseline rowsets so that later processing can be easier. The AutoCollect system also delivers a non-SQL batch option, OPTION=DSVOUT, to select data from the Delta tables that can be used to generate Microsoft Excel spreadsheets. However, in some cases, you may find it difficult to use the Delta table data being generated without some further summarization or editing.

The Delta tables are defined as a standard CA Datacom/DB database that can be accessed by any of the programming APIs (RAAT, SAAT, or SQL) and by the standard CA Datacom query tools, such as:

Users with any of these tools and an understanding of the Delta table layouts can easily extend their view of the AutoCollect data.