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
|
|
|