Re: Making TEMP TABLES sticky
In <4mtt13$4jb@cssun.mathcs.emory.edu> elderbox@teleport.com writes:
>I have an associate who swears there is a way to make temp tables remain
>after a process has completed. He thinks this has to withe the WITH
> NO LOG keywords. I don't why he cares. It seems to me that if you want
> a table to remain you just create a file, but he cares. We have
> reviewed several Informix manuals and cannot find a reference to the temp
> tables remaining after process completion.
>Just to satisfy him, I have agreed to ask this august group. Does
>anyone know of a scenario where a temp table remains after a process
>completes? Thank you
>
Adding my tuppence-worth (everyone else, please forgive if this is hogging
the bandwith). It doesn't stick, but it comes back from the dead. :
{ send data to a file }
select x,y,z
from tablex
where ...
into temp xtemporaneous with no log ;
unload to ytemporaneous
select * from xtemporaneous;
{ later that day ... in a new session
or drop table xtemporaneous;
}
{ bring data back from the file }
select x,y,z
from tablex
where 1 = 0
into temp xtemporaneous;
load from ytemporaneous
insert into xtemporaneous;
Yours,
Nick
*********************************
Nick Nobbe, Library of Congress
NLS/BPH
mail: nnob@loc.gov
*********************************