Viewing Details

Access the Archive Run Control Details page (select PeopleTools, and then Data Archive Manager, and then Archive Data to History and click View Details).

Field or Control Description

Field or Control	Description
View SQL	Select to view the archive selection SQL for the archive object. The View Details page appears, with a text box containing the SQL, for example: `%InsertSelect(CONF_OB2_PARENT, CONF_OB2_PAR_HS) FROM PS_CONF_OB2_PAR_HS WHERE PSARCH_ID = 'CONFDEMO' AND PSARCH_BATCHNUM = 1`
Count Rows	Select to view the number of rows of the archive object that the archiving process will affect in the related database. The View Details page appears, with a description of the number of rows that will be processed by Data Archive Manager.

View SQL

Select to view the archive selection SQL for the archive object. The View Details page appears, with a text box containing the SQL, for example:

%InsertSelect(CONF_OB2_PARENT, CONF_OB2_PAR_HS)
 FROM PS_CONF_OB2_PAR_HS WHERE
 PSARCH_ID = 'CONFDEMO' AND PSARCH_BATCHNUM = 1

Count Rows

Select to view the number of rows of the archive object that the archiving process will affect in the related database. The View Details page appears, with a description of the number of rows that will be processed by Data Archive Manager.