on 02-05-2014 1:50 PM
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?
when you ran the DDL to define the global temp, did you add the clause 'on commit preserve rows'?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.