Hi,
I have simple utility written in DFC 5.3 SP5 where I am executing few update DQL statements within transaction. The transaction is started and committed using DQL statements "Begin Tran" and "Commit Tran". The update query statements work fine in DFC 5.3 SP5. I have to now upgrade the DFC to 6.5 SP2 and same utility fails with following error trying to execute the update DQL statement.
Exception: DfException:: THREAD: main; MSG: [DM_SESSION_W_CANT_BEGIN_TRANSACTION]warning: "Cannot begin a transaction since there is an active transaction for session 010170d780009188."; ERRORCODE: 100; NEXT: null
What is the difference in transaction management between 5.3 and 6.5? Is there a way to set DFQuery not to open transaction in 6.5? Any help is appreciated.
Thanks,
Mahmood