Previous Topic: Selection ParametersNext Topic: Deleting Delta Rowsets


Reporting Delta Rowsets

You can produce reports about specific Delta rowsets with the AUTOCOLL OPTION=DELTARPT function. The report provides information about each of the rowsets and the number of rows in each DELTA table that is part of that rowset.

The rowset report is used to determine what deltas are available to be processed into other deltas or selected for extraction into output formats for loading into performance spreadsheets. The report does not list the various rows and their contents.

To see delta row contents, use one of the various query tools provided in CA Datacom (CA Dataquery, DBSQLPR, DB Reporter option, and so on.). While user programs can also be written using the standard RAAT, SAAT and SQL APIs, we recommend that they are not used to manipulate the delta rows’ data content as this can create problems for the rest of the AutoCollect functions.

The expected return code is 0 when executing the DELTARPT function. For details about the AUTOCOLL OPTION=DELTARPT syntax, parameters, and sample output report see the CA Datacom/DB DBUTLTY Reference Guide.