ODBC and temporary tables no rows returned

[Former Member]

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?

[tom_kim]

when you ran the DDL to define the global temp, did you add the clause 'on commit preserve rows'?

[Former Member]

I did not, but it does work in Interactive SQL without preserve rows clause

[Former Member]

Ok. If I add preserve rows than it works. Still puzzled why it works in Interactive SQL when preserve rows not present, but does not work in my case.

[tom_kim]

it works because you probably did not issue a 'commit' in your session. if you issued a commit, you would get the same result (no data) as your ODBC connection. You probably have your ODBC configuration as 'autocommit'.

[Former Member]

You are correct. Defafult ODBC mode is autocommit on.

After changing to autocommit off everything works as expected.

Thank you very much for your help