Re: Re: online 7.10.UD2
>Rastislav JANAC (rasto@softec.sk) writes: > Jim Tibbets wrote: > : According to informix this was a change from the uc to the ud > : verions that temp tables are created fragmented with the round robin > : option. > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > Is this really true ? > And how it could works when whole temptable is in tempdbs ? > Is it fragmented into different tblspaces inside one dbspace ? > And what about rowids then ? > > We have actually a kind of similar problem. We are migrating from > online v5 ultrix to online v7 DEC alphaserver now and oldest > programs written using Forms Fourgen stopping at "select * from > realtab, temptab where realtab.rowid = temptab.row_id" with an > internal error -874. > Does OL have any problem using rowids ? There was a huge discussion here about rowids a few weeks ago. You may be able to search one of the archives for something like that topic. Basically, rowid refers to the physical location of the row on disk. Since, in a fragmented table, the row may move from one fragment to another, the rowid is no longer a valid identifier. You may make up your own rowid column and work around this change. There is a brief note in the Informix book: "Upgrading to Informix- OnLine Dynamic Server Training Manual", version 01-95, part number 502-5-227-1-999999-3 on page 16-386. There is no index reference in that book, or in the Migration Guide or Feature Enhancements manuals either. (I'll write the doc people about that one.) > Configuration: OL v7.10.UD1, 4GL RDS v6.01.UC1, OSF/1 3.2C > [...sig deleted...] Good luck, __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|