RE: QADBIFLD

OOPS! That should be whfldb, NOT whfldd

An alternative on earlier releases is

select sum(whallc) from vern/ffd where whvarl='Y' union
select sum(whfldb) from vern/ffd where whvarl<>'Y'

Not sure if there's a way to combine the sums in one statement

At 09:53 AM 3/22/02 -0600, you wrote:
>Got it. So you're left with DSPFFD to an outfile and query it. This gives
>total allocated length (non vriable + variable)
>
>select sum(case when whvarl = 'Y' then whallc else whfldd end) from
>vern/ffd
>
>At 08:47 AM 3/22/02 -0500, you wrote:
>> >From: Vernon Hamberg [mailto:vhamberg@attbi.com]
>> >DSPFD has total (possible) record length at the bottom
>>
>>I know. It's the allocated length that I was referring to. There appears to
>>be no total allocated length in either display. If you don't have VARCHAR
>>and the like then total possible = total allocated, but if you do (like
>>QADBIFLD) it would be nice to have such a count.
>>
>>-Walden
>>
>>
>>------------
>>Walden H Leverich III
>>President
>>Tech Software
>>(516) 627-3800 x11
>>(208) 692-3308 eFax
>>WaldenL@TechSoftInc.com
>>http://www.TechSoftInc.com
>>
>>_______________________________________________
>>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>>To post a message email: MIDRANGE-L@midrange.com
>>To subscribe, unsubscribe, or change list options,
>>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>>or email: MIDRANGE-L-request@midrange.com
>>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@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.