RE: problem loading data
Aside from Raw, standard and temp, in XPS we have operational, static and
scratch. Finer gradations than the simplistic standard/raw dichotomy.
Scratch is a non logging temp table.
Static is a non-updated table (hence no locks, no logging etc.)
Operational is between standard and raw, you can have indexes, but it isn't
a logged table.
Of course I'm doing that from memory - TFM may phrase it slightly
differently. My memory is subject to lost pages - today I found myself, for
the first time that I remember, telling a joke that I didn't remember part
of. I immediately started an oncheck -cD. Sigh, age is a wonderful thing.
cheers
j.
> -----Original Message-----
> From: Virginia Panlasigui [mailto:virginia@informix.com]
> Sent: Friday, December 08, 2000 12:28 PM
> To: Obnoxio The Clown; brett@brabys.co.za; doc@informix.com
> Cc: dl@novertec.com.ie.informix.com; informix-list@iiug.org
> Subject: Re: problem loading data
>
>
> IDS support for RAW tables came in 7.31 and is documented in the
> SQLSDOC_7.3 documentation notes in the directory
> $INFORMIXDIR/release/en_us/0333
> You can also find these 7.31 doc notes on the URL:
> http://www.informix.com/informix/resource/ids0731.htm
>
> Also, RAW tables are in the 9.21 version and documented in
> SQLSDOC_9.21.
> The PERFDOC_9.21 doc notes also have a load procedure with raw tables.
> You can find these docnotes at
> http://www.informix.com/informix/resource/ids2000.htm
>
> IDS support of RAW tables has been included in the next
> versions of the
> SQL Syntax Guide and Performance Guide.
>
>
> Hope this helps,
> Virginia Panlasigui
> Principal Tech Writer
>
> At 05:54 AM 12/8/00 , Obnoxio The Clown wrote:
> >From: Brett Geer <brett@brabys.co.za>
> >>
> >>Read the manual?
> >
> >I did. It says that RAW tables are an XPS-only extension.
> (Current Informix
> >Guide to SQL: Syntax, page 2-230)
> >
> >> > How'd you create a raw table in 7.31?
> >>
> >>create raw table bob
> >>(
> >> an integer
> >>);> >>
> >>alter table bob type (standard);> >>
> >>voila.
> >>
> >>Some history for a friday giggle, we were comparing our engine's
> >>performance on ugly queries vs m$sql... I wont mention the timings
> >>but we didn't get a chance to laugh at m$ before it finished.
> >>
> >>The raw table eliminated the loggin on the load of a few hund K
> >>records from a phat file. Ok, a temp table would have done
> it aswell,
> >>but I was playing.
> >
> >Crap. I used to look like a fool for not reading the manual,
> now I look like
> >a fool for reading the manual. :-(
> >
> >_____________________________________________________________
> ______________
> __________
> >Get more from the Web. FREE MSN Explorer download :
http://explorer.msn.com
>