Re: problem loading data
Thanks Virginia.
From: Virginia Panlasigui <virginia@informix.com>
>
>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
> >
>
_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com