How to make a temp table public?

Hi Everybody, How can i make a temp table public? I have an Application which creates a temporary table and then calls another Application to work with these data too. But the other Application doesn't find the temp table. I don't need these data after them, so i won't write them into a normal Table. Thanks for helping Ernst Nuber Ernst.Nuber@alcatel.de

Ernst Nuber wrote: > > Hi Everybody, > > How can i make a temp table public? Hi also ! first: a temp table is a personal table. That means only the user that creates the table (... INTO TEMP temptab1 .. CREATE TEMP TABLE ...) can access the table. What you need is a normal table (CREATE TABLE ....) and a script (or trigger, or something else) that drops these table in the evening or night: dbaccess - <<EOF DATABASE blabla; DROP TABLE temptab1;EOF Regards Markus > > I have an Application which creates a temporary table and then calls > another > Application to work with these data too. > But the other Application doesn't find the temp table. > I don't need these data after them, so i won't write them into a normal > Table. > > Thanks for helping > > Ernst Nuber > Ernst.Nuber@alcatel.de