Re: problem loading data

From: William Rice <ricew@operamail.com> > >In article <90qqd9$luo$1@news.xmission.com>, > "Obnoxio The Clown" <obnoxio@hotmail.com> 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. :-( > > > > >Blame it on Informix for providing a GREAT feature, and then taking it >away. I seem to recall 9.3 is supposed to have raw tables. Taking it away? It's still there in 9.21. _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com