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
