command for storing result from a query to a temporary table in db2

Question

question

ritu asked Aug 30, '13

command for storing result from a query to a temporary table in db2

select * into # tbl1 from( select * from tableA) above given query is used for storing result of single sql statement into a temporary table in SQL server .i want to know a same query but for DB2 Server

temporary-table db2

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Aug 30, 2013 at 11:26 AM

You may get an answer here, but you might be better served taking the question to a DB2 dedicated forum.

1 ·

Answer 1 · 2013-08-30T13:24:36Z

michaelchapman 7202 answered Aug 30, '13

declare global temporary table Temp1 (pub_name varchar(7), maxprice numeric(8,2)) on commit preserve rows not logged ; insert into SESSION.Temp1 (pub_name, maxprice ) select pub_name, max(c_price) from book group by pub_name;

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question