Scratch Table Vs Temp Table

#1

Hi,

Quote:

From the Informix documentation, I found that both scratch table and
temp table looks almost similar.

But if it's similar, there's no reason to have both.

So, can someone please enlighten me on the differences between scratch
and temp table.

Thanks in advance.

#2

ehchn1 wrote:

Quote:

From the Informix documentation, I found that both scratch table and
temp table looks almost similar.
But if it's similar, there's no reason to have both.

So, can someone please enlighten me on the differences between scratch
and temp table.

Scratch tables apply to XPS and not IDS.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2007.0914 -- http://dbi.perl.org/

publictimestamp.org/ptb/PTB-1629 ripemd256 2007-10-26 03:00:05
F948AC71AA5283828EDDFD0F7F22146CBEFB099A7DA0571EDB BD1591DC5228F3

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Scratch Table Vs Temp Table

comp.databases.informix comp.databases.informix

Scratch Table Vs Temp Table - 10-25-2007 , 09:55 PM

Re: Scratch Table Vs Temp Table - 10-26-2007 , 01:55 AM