Trying to find if there is something similar to TRUNCATE TABLE in these 2 database systems.
MODIFY mytable TO TRUNCATED
is the equivalent SQL for Ingres/Vector/ActianX