I ran the following query in Sybase IQ 15.4
create table #temp1 (id varchar(1))
select * from #temp1
But I got this error:
SQL Anywhere Error - 1000011: Transaction 13377xxx attempted to access '#temp1' created by transaction 0.
but my coworker run the same query in his machine using same credential and his query ran fine.
asked 07 Aug '14, 12:43
it was an aqua studio setting. I unchecked Auto Complete and Auto Commit option which caused this issue. Once I checked the option, everything works.
answered 07 Aug '14, 15:42