Can we use truncate stmt within a procedure?
487726Feb 17 2006 — edited Feb 17 2006We have a procedure that loads the staging tables and some processing is performed on those tables. The same tables need to be loaded with some other data. Before we load we need to truncate the old data in the staging tables.
I tried to use truncate statements in the after begin keyword, it gave me an error.
How do I truncate the tables before loading different data into the staging tables.
I want to include few truncates in the beginning of the second load or at the end of the first load and processing.
Please give me some insight into this.
Thanks in advance,
Ac