Scratch Table Vs Temp Table

Hi, >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.

ehchn1 wrote: > 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@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2007.0914 -- http://dbi.perl.org/ publictimestamp.org/ptb/PTB-1629 ripemd256 2007-10-26 03:00:05 F948AC71AA5283828EDDFD0F7F22146CBEFB099A7DA0571EDBBD1591DC5228F3