online 7.10.UD2
Hello all,
I am having a strange problem with Online-7.10.UD2.
this statement:
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).
Thanks
James Tibbets
jtibb@rankin.com
--
) \\ / (
/|\\ )\\_/( /|\\
* / | \\ (/\\|/\\) / | \\ *
|\\ / | \\ \\`|'/ / | \\ /|
| .________________/___|___o__ __\\|/__ __o___|___\\________________. |
| James Tibbets |^` V ^|` Suite 1286 |
| Application Engineer Phoenix, Arizona 85029 |
| Rankin Technology Group Phone:(602) 997-6996 |
| 2432 West Peoria Avenue Fax: (602) 997-4256 |
| ._______________________________________________________________. |
|/ | /\\ / \\\\ \\ /\\ | \\ |
* | / V )) V \\ | *
|/ // \\|
V