may I have sample Ingres SQL to be run via JDBC which involve temp table?

hi

I want to write SQL which can be run on Ingres database. In the SQL, I would like to create temp table to store first SQL result to be used in second sql, to trim SQL performance and tempdb usage.

I know how to write on sybase but not ingres, can somebody please help?

i.e. in sybase, such thing can be done...
select * into #temptable1 from table_A
select * from #temptable1
sleepinglukeAsked:
Who is Participating?
 
QlemoConnect With a Mentor Batchelor, Developer and EE Topic AdvisorCommented:
IIRC Ingres uses create table temptable1 as select * from table_A to create a table copy.
There is also a construct to have a real temporary table called declare global temporary table - see http://docs.huihoo.com/ingres/ingres2006r2-guides/SQL%20Reference%20Guide/1107.htm for a description.
0
 
sleepinglukeAuthor Commented:
thank you so much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.