Re: IFS space usage, QRYIFSLIB

["Gary Kuznitz" <docfxit@xxxxxxxxxxxx>]

Hi,

Does anyone know how to reduce the output size these SQL fields 
of:
Count
ST_Size
ST_ALLOCSZ

Currently they are taking up on the screen
Count               20 pos
ST_Size           44 pos
ST_ALLOCSZ  41 pos

It would be much more readable on the screen if they occupied less 
positions.

Thank you,

Gary Kuznitz

On 29 Jul 2002 at 10:41, bdietz@xxxxxx (bdietz@xxxxxx 
<midrange-l@xxxxxxxxxxxx>) commented about Re: IFS space usage, QRYIFSLIB:

> I ran into the same issue trying to use the query the tool mentions.
> 
> I changed the query to substring the DIRNAME field, now it  looks like:
> 
> SELECT
>         COUNT(*) AS "Number of Objects",
>         SUM(CAST(st_size AS DEC(31))) AS "File Size",
>         SUM(CAST(st_allocsz AS DEC(31))) AS "Allocated Size",
>         SUBSTR(dirname,1,200) AS "Directory"
> FROM
>         qryifslib
> GROUP BY
>         SUBSTR(dirname,1,200)
> 
> 
> -------------------------
>  Bryan Dietz
> 3X Corporation
> 614-410-9205
> 
> 
> 
> 
> 
> 
> 
> "Urbanek, Marty" <Marty_Urbanek@xxxxxxxxxxxx>
> Sent by: midrange-l-admin@xxxxxxxxxxxx
> 07/29/2002 08:01 AM
> Please respond to midrange-l
> 
> 
>         To:     "'midrange-l@xxxxxxxxxxxx'" <midrange-l@xxxxxxxxxxxx>
>         cc:
>         Subject:        IFS space usage, QRYIFSLIB
> 
> 
> Update: I cut the DIRNAME field back to 1500 and recompiled the program
> and
> that eliminated the SQL error.
> 
> However, I still have my same basic problem of not being able account for
> all the space occupied by "user directories."
> 
> Thanks,
> -Marty
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To
> post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
> change list options, visit:
> http://lists.midrange.com/cgi-bin/listinfo/midrange-l or email:
> MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review
> the archives at http://archive.midrange.com/midrange-l.
>