Re: Truncating Within Procedures

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Fri, 9 Oct 1998 14:47:16 +0100
Message-ID: <6vl445$h94$1@schbbs.mot.com>

Given that TRUNCATE does not use the rollback segments I wonder how the transaction control is handled in this application.

Does the TRUNCATE statement issue an implied COMMIT on other data or is the scope entirely seperate so that you can commit or rollback your transaction with the trunctae having occurred anyway?

--
Alan D. Mills

esiyuri_at_my-dejanews.com wrote in message <6vl17a$5eu$1_at_nnrp1.dejanews.com>...
>In article <6vk7n7$49i$1_at_nnrp1.dejanews.com>,
> jflipse_at_spacestar.com wrote:
>> I am able to truncate tables within a stored procedure by passing the
>> table name (mytable) to a procedure which performs the truncate
>> :
>> :
>> I have no problems when the table name is explicitly called out, but
>> run into problems when the table name is a synonym. I've tried to
>> bind the synonym to a variable and pass this to the procedure...
>
>John,
Received on Fri Oct 09 1998 - 08:47:16 CDT