Trading Networks 10.3 | Administering and Monitoring B2B Transactions | Trading Networks Built-In Services Reference | Archive Folder | Summary of Elements in this Folder | wm.tn.archive:archiveByStoredProc
 
wm.tn.archive:archiveByStoredProc
Archives documents and deletes documents from the Trading Networks database using the stored procedure based archive script.
Input Parameters
operation
String The operation to perform. The available options are archive or delete.
Value
Description
Archive
Moves the data from the production table to the archive table.
DeleteArchived
Deletes the data from the archive table.
DeleteProduction
Deletes the data from the production table.
afterDays
String The maximum number of days after which the stored documents are archived or deleted.
Specify any value for afterDays from 1 to 96665.
Note:
afterDays parameter supports only integers.
batchCount
String (optional) The maximum number of documents that can be archived or deleted in a batch.
The default is 1000 documents. Set the default value in the tn.archive.batchSize property defined in the properties.cnf file. For information about this property, see webMethods Trading Networks Administrator’s Guide.
Note:
batchCount parameter supports only integers.
Output Parameters
numberOfRowsImpacted
String The number of rows of data that the service successfully archives or deletes from the production table or deletes from the archive table.
errors
String List (optional) Retrieves all the errors resulted from the archive or delete operation.