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?