To analyze tables in the Personnel object list for queries logged over the last 7 days, and then recommend actions to move them into MyNewMap:
CALL TDMaps.AnalyzeSP( 'MyNewMapList', 'Personnel',NULL, CAST(CURRENT_TIMESTAMP – INTERVAL '7' day AS TIMESTAMP), CURRENT_TIMESTAMP, 'DBC', 'MyNewMapActions', :NumAlters, :NumExcludes, :NumLogEntries); Procedure has been executed. *** Total elapsed time was 19 minutes and 47 seconds. NumAlters NumExcludes NumLogEntries ---------------- ---------------- ------------- 85 0 98020