Maintaining the BMCXCOPY table
Periodically, you should review BMCXCOPY and delete old rows to control its expansion.
To control expansion of the BMCXCOPY table
To delete all rows from the BMCXCOPY table that are older than 30 days, run an SQL DELETE statement, using the following statement as an example:
DELETE
FROM <creatorName.CMN_BMCXCOPY
WHERE DAYS(CURRENT TIMESTAMP) - DAYS(TIMESTAMP) > 30;
Related topics
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.