Scratch Table Vs Temp Table
This is a discussion on Scratch Table Vs Temp Table within the Informix forums, part of the Database Server Software category; --> Hi, >From the Informix documentation, I found that both scratch table and temp table looks almost similar. But if ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 05:29 PM
| ||||
| ||||
 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.      |
|
04-20-2008, 05:29 PM
| ||||
| ||||
| Re: Scratch Table Vs Temp Table 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 F948AC71AA5283828EDDFD0F7F22146CBEFB099A7DA0571EDB BD1591DC5228F3 |
Linear Mode
