Partitionning: support for Truncate Table WHERE

Hello,

Working in a DSS environment, we often need to truncate table partitions regarding a WHERE condition and have to:

- query the dictionnary to identify thoses partitions,

- build SQL statements,

- truncate all partitions covered by the WHERE condition

- eventually delete the rest ...

- perform additionnal maintenance tasks

Wouldn't it be possible to make it possible directly in SQL as a TRUNCATE TABLE WHERE syntax ?

I have done something similar using a procedure in Oracle:

- identifying partitions using oracle rowids by a SELECT using the same WHERE conditions

- for each partition check if data NOT in WHERE condition

- then DELETE WHERE or TRUNCATE PARTITION depending of data distribution.

Maybe there are some other constrainst like locking, FK disabling/enabling, indexes rebuild ...

Would be pleased to ear your feedback regarding this.

Regards

PAscal