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. Any ideas?? |
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. |