Classification: Public
Classification: Public
Richard
If by 'accumulator' you mean that the NUM_FILES column is actually showing the
sum of the current row and the previous row/rows then I don't think this is the
case. It looks to me like there is an implicit ORDER BY NUM_FILES on the select
Has anyone seen a case when a select from occupancy returns rows where the
NUMFILES columns is acting as an accumulator?
SP 7.1.7.100
The command.
select
NODE_NAME,TYPE,FILESPACE_NAME,STGPOOL_NAME,NUM_FILES,PHYSICAL_MB,LOGICAL_MB,REPORTING_MB,FILESPACE_ID
from occupancy
Here is a sample