The following example shows how to reinstate the Personnel.Project table and prepare all statistics for the Personnel database, including those on the Personnel.Project table.
CALL TDSTATS.RemoveExcludedObject('PERSONNEL','PROJECT', NumRemoved);
*** Procedure has been executed.
*** Total elapsed time was 1 second.
NumRemoved
-----------
1
CALL TDSTATS.PrepCollect ('PERSONNEL', NULL, NULL, NULL, NumStmtsPrepped, NumStatsPrepped, CmdListID);
*** Procedure has been executed.
*** Total elapsed time was 3 seconds.