Scratch Table Vs Temp Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ehchn1 - 26 Oct 2007 02:55 GMT

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.

Reply to this Message

Jonathan Leffler - 26 Oct 2007 06:55 GMT

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

Signature

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

Reply to this Message