Maintaining the BMCHIST table
When a utility completes successfully, it inserts a row into the BMCHIST table. Periodically, review BMCHIST and delete old rows to control its expansion.
To delete selected rows from the BMCHIST table based on the date that the utility was completed, use the following sample SQL statement:
DELETE
FROM creatorName.CMN_BMCHIST
WHERE DATE < 'yyyy-mm-dd';
FROM creatorName.CMN_BMCHIST
WHERE DATE < 'yyyy-mm-dd';
Related topics
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*