I am new to Sybase Anywhere, I have a problem implementing a process in ASA database.

I tried running this T-SQL Command in ASA database Version 9 and 8

Select * Into DBA.tblDeviceToRep From DBA.tblDevice

it worked fine. But the same code gives me an error when I try to run it in sybase Anywhere version 7.0.4

Select * Into DBA.tblDeviceToRep From DBA.tblDevice

It says invalid syntax near '.'

I don't know what will the work around to solve the issue. All I need his creating a permenant table with same structure as tblDevice with all the data in the same DBSpace.

Please help

Thanks