Hi,
Can anyone please suggest me how to wite and use temporary table in DB2.

I have written follwoing query:


DECLARE GLOBAL TEMPORARY TABLE session.fred
(dept SMALLINT NOT NULL
,avg_salary DEC(7,2) NOT NULL
,num_emps SMALLINT NOT NULL);

select * from session.fred;

insert into session.fred values (1,1200,45);
insert into session.fred values (2,4560,56);
insert into session.fred values (1,8500,96);
insert into session.fred values (3,2699,36);
insert into session.fred values (2,4566,25);
select count(*) from session.fred;

select * from session.fred;
drop table session.fred;

It is not shwoing me the data in final output

Even it is shwin 0 as count(*) query.

how are you running all of this? command line? program? spufi? script?
Dave

Turn off autocommit.

Rows of temporary table was deleted on commit (autocommit):

Lenny

Thanks!!! It works.