Hi,
I am new to IBM DB2, I was using Sybase T-SQL.
In sybase we can copy data from one table to another table by doing "Select * into"
e.g.
SELECT emp_no, dept_no, sal
INTO sample_table
FROM emp
WHERE ......

Here "sample_table" is dynamically created, no need to explicitely create it.

Can you please explain how can I do this in DB2?


Also In sybase, we can also create session specific dynamic table
e.g.
SELECT emp_no, dept_no, sal
INTO #tempo_table
FROM emp
WHERE .....

Here #tempo_table is session specific dyna,ic table.
Is it possible in DB2?

You could do that with a CREATE TABLE statement:

CREATE TABLE ... AS SELECT ...

This creates a materialized query table; check the manual for available options.




Check the DECLARE GLOBAL TEMPORARY TABLE statement.