Synametrics Technologies

We frequently use temp tables and then use the temp table to query from. select * from zprc19990731 where symbol = "GTC" into temp dsx; select * from dsx; I then receive this error... Error: The specified table (dsx) is not in the database. Is there a work around for this? Thanks in advance.

Hi, You must separate these queries with a query terminator. For example, select * from zprc19990731 where symbol = "GTC into temp dsx GO select * from dsx Notice the word 'GO' between the two queries. Informix does not support multiple queries in the same statements. Therefore, you must the statement into two distinct queries. By default, 'GO' is considered to be a query terminator. Thanks, IndusSoft support >We frequently use temp tables and then use the temp table to query from. > >select * from zprc19990731 where symbol = "GTC" into temp dsx; >select * from dsx; > >I then receive this error... >Error: The specified table (dsx) is not in the database. > >Is there a work around for this? Thanks in advance.

Good morning,

I configured RDBMS but I don't have the synLog table that I displayed in the old version.

I use Syncrify - Version: 5.4 - build 1122

 

thanks

Simone Rota