Re: Silly question time -- with answer (long)

In article <6hduq3$j1r$1@news.xmission.com>#1/3, jleffler@earthlink.net wrote: > > > This is a multi-part message in MIME format. > > --------------2F223D0C75A5 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > I hope you can read the attachment. If not, I'll resubmit this message. > > Yours, > Jonathan Leffler (jleffler@earthlink.net) #include <many-aliases.h> > > --------------2F223D0C75A5 > Content-Type: text/plain; charset=iso-8859-1; name="TABID.txt" > Content-Transfer-Encoding: 8bit > Content-Disposition: inline; filename="TABID.txt" > > Silly question time: how do you determine the value of TabID for a given table > in an Informix database? > The basic answer is as simple as the question: > SELECT TabID FROM SysTables WHERE TabName = 'tablename';> So, what's Leffler thinking about when he asks such a simple question with > such an obvious answer? And how on earth does he manage to write such a > long message when he's already given the answer? > There are several complicating factors: > ? Consider a MODE ANSI database. [ ... cutting here to make it short ... ... world, read! the original post, it is worth it ...] My $0.01: Everybody outside Europe tries to avoid ANSI databases, am I right ??? Here we can not: therefore standardisation (of user names, table names ....) counts and standardisation is a big percentage of every design here. I too have to live with all that nasty 'features' of mode ANSI databases and more to come like fill precentages in the Logical Log blocks written to disk where I jump when > 4 % .... No mode switching to non ANSI No easy way to delete records from a table with dbaccess without producing a LTX No easy way to do things like ALTER TABLE .... to reorganise extent contention - whenever it comes to a sort: see above - implicit sorts DO leave their traces in the Logical Log E.Suto's very good book and others in fact do mislead you when you run a mode ANSI database & look up chapters speaking about sizing of everything which has to do with after image logging. Good luck & please Jonathan, let me learn what I do not know already by keeping on posting such valuable details I was on V4.10/SCO long time, before that on 2.10K/XENIX (late '80ies) Now I am second level DBA with 135 machines / SNI SINIX V5.43 & INFORMIX V7.12 maybe moving to V7.2x in the next months. 135 mode ANSI databases are the reason why I post only rarely - sorry, no more time left & my poor English does the rest Best regards Dick Richard Kofler EDVg-debis Systemhaus Vienna, Austria e-mail: richard_kofler@edvg.co.at -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading