Skip to Content
Former Member
Feb 05, 2014 at 01:50 PM

ODBC and temporary tables no rows returned


Issue with global temporary tables and ODBC.

I created global temporary table and inserted couple records.

select * from table does not return any results.

I tried couple commercial products whic use ODBC and they do not return results either.

Sybase IQ Interactive SQL does return inserted rows.

What has to be set for ODBC in order for this to work?