Need a bit of help with temporary tables

[James Foreman]

Running UDB 8.2.0 on Suse linux 8.1, as database administrator I do:

declare global temporary table session.animal_noises
(animal varchar(10), noises varchar(10));

insert into session.animal_noises
values ('Duck', 'QUACK');

select *
from session.animal_noises;

returns

ANIMAL NOISES
---------- ----------

0 record(s) selected.

What am I doing wrong?

[Serge Rielau]

James Foreman wrote:

Running UDB 8.2.0 on Suse linux 8.1, as database administrator I do:

declare global temporary table session.animal_noises
(animal varchar(10), noises varchar(10));

insert into session.animal_noises
values ('Duck', 'QUACK');

select *
from session.animal_noises;

returns

ANIMAL NOISES
---------- ----------

0 record(s) selected.

What am I doing wrong?

global temps are by default ON COMMIT DELETE ROWS. Presumably your
client (CLP ?) is in auto-commit mode.
add a clause: ON COMMIT PRESERVE ROWS and you shoudl be in business.

Cheers
Serge

[James Foreman]

Thanks for that