Truncate table not allowed in SP

Can someone help me to understand why "truncate table" would cause a compilation error if it is used in a store procedure? It seems to me that certain SQL commands are not allowed in SP. I could work around it with the "delete from" but I really want to use the "truncate table" statement instead. Please advice how I might be able to do that.

Thanks in advance,
Kenny

--

• Kenny Yuen Email : kenny_yuen_at_hp.com -
• Hewlett-Packard Company US Mail: 5301 Stevens Creek Blvd. -
• Network Server Division MS 53U/FD -
• Information Technology Santa Clara, CA 95051 -
• Telnet: 553-3368 Phone : (408) 553-3368 -

  ---