online 7.10.UD2 problem figured

Hello all, Just wanted to let you all know I found out what was going on with my previous problem of: >select * from (any EMPTY table) where rowid = 0 >into temp my_tmp with no log> >and then... > >select rowid from my_tmp> >produces: >857: Rowids do not exist in table.> >Yet if I run the select statement without the 'with no log' >option the statement executes fine OR if there are >rows in the select * from (table). >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. But I still dont understand that if this is true why does >the statement work if there are rowid in the select * from (table). The DBSPACETEMP in the onconfig file is set to: DBSPACETEMP=tmp1,tmp2 so the temp table is indeed being created fragmented. If DBSPACETEMP is set to just tmp1 the above statement will simply return a notfound like would be expected. This still seems like a bug to me. I would think that regardless of if the table was created fragmented or not a select rowid from the temp table should return a notfound if there aren't any rows in the temp table and not a -857: Rowids do not exist in table. If anyone else is having this problem the case # is 378620. thanks James Tibbets jtibb@rankin.com