trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Liu, Yuan (Yuan)" <yuan....@esgyn.cn>
Subject purgedata can not be put in a transaction?
Date Fri, 12 Jan 2018 04:14:54 GMT
Hi Trafodioneers,

I found that purgedata can not be put in a transaction. If we put below rows after begin transaction,
error 20123 occurred.

>> begin;
>>purgedata test1;

*** ERROR[20123] A user-defined transaction has been started.

This DDL operation cannot be performed.

However, "drop" and "delete with no rollback form" can run normally. From my side, I think
both drop and purgedata are non-transactional, but why they behave different?
Is there any that we can workaournd this error?


Best regards,
Yuan


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message