Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Really funny. Mine is IDS 7.30 on Solaris 2.6. I got the same result.
But I found that
'select * from syspools where nvl(po_address,0)>0 '
got the correct result.
Another funny thing is the result of
'select count(*) syspools where nvl(po_address,0)'
is 0.
syspools is the view of syspoollst. The result of these SQLs on
syspoollst is same.
In article <3A59B491.BF9E7554@hotmail.com>,
Brett Randall <brett_s_rREMOVECAPITALS@hotmail.com> wrote:
> Please excuse the alliteration.
>
> I was wondering if others on other platforms/versions/installations
get
> the same result as that listed below. There seems to be no (specific)
> defect recorded.
>
> onstat -V> Informix Dynamic Server 2000 Version 9.21.UC2
> uname -a
> Linux 2.2.14-5.0
>
> database sysmaster;>
> select *
> from syspools;>
> po_id po_address po_name po_class po_freeamt po_usedamt
>
> 1 268439584 resident 1 4472 573064
> 2 269017120 res-buff 1 4472 2051720
> 3 271200288 global 2 39304 4351608
> 4 271220768 mt 2 704120 1851784
> 5 271634464 smartblob 2 1304 2792
> 6 271638560 sbtlist 2 5600 6688
> 7 271650848 sb_delq 2 8424 20248
> 8 271753248 sb_delundoq 2 8424 20248
> 9 271855648 sb_lofd 2 8424 20248
> 10 271958048 sb_loheader 2 25944 236200
> 11 272293920 sb_arcspace 2 832 3264
> 12 272306208 rsam 2 2544 886288
> 13 272633888 aio 2 62208 425216
> 14 276787232 gls 2 5760 22912
> ... etc
>
> select *
> from syspools
> where po_address > 0;>
> No rows found.
>
> Filters for < and = produce the same.
>
> Brett Randall
>
Sent via Deja.com
http://www.deja.com/
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.