Skip to Content
0
Former Member
Dec 01, 2008 at 05:40 PM

How to truncate the values from the table

4349 Views

Hi All,

I am working on an issue..where we are first deleting all the records from the table and then based on few conditions we are putting the records back in that table...when we tried to run this program along with few others those who are doing almost the same stuff we are having issues...we tried to schedule few jobs related to these programs only...but after a ceratin amount of time couple of jobs got canceled...I was talking to my basis guy and he said the problem is ratehr then truncating the records from the table we are deleting the records and it's taking lots and lots of space to execute...so we need to truncate the records from the table insted of deleting it...we are using the following the statement right now:

DELETE FROM ZTUS_PG.

COMMIT WORK.

So can you please tell me how can we truncate the values from this table instead of just deleting them and what would be effect of this.

Thanks,

Rajeev Gupta