ADSM-L

Re: Select for file size

2000-02-29 13:25:19
Subject: Re: Select for file size
From: Richard Sims <rbs AT BU DOT EDU>
Date: Tue, 29 Feb 2000 13:25:19 -0500
>Does anyone know a Select statement I could use to get the file size of a
>client file?
>Q BA  at the client will give you the size.
>Select file_size from contents   gives a size, but not the right one.

Julie - That was the subject of one of my posted questions a few weeks ago.
        Unfortunately, the File_Size in the Contents table is the size of
the aggregate in which the file resides.

The great frustration is that the client interface can report actual file
sizes, but you can't report them from the server SQL queries (as documented,
at least).  That's a tremendous handicap for administration and centralized
reporting.
       Richard Sims, BU
<Prev in Thread] Current Thread [Next in Thread>