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 >