Maintaining the BMCXCOPY table

Periodically, you should review BMCXCOPY-table and delete old rows to control its expansion. To delete all rows from the BMCXCOPY table that are older than 30 days, use the following statement as an example:

Related topic

Maintaining-common-utility-tables


DELETE
FROM creatorName.CMN_BMCXCOPY
WHERE DAYS(CURRENT TIMESTAMP) - DAYS(TIMESTAMP) > 30;

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*