RE: Character varlength question

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Jeff

IBM recommends a compromise between space and speed - set the 
allocate to the length that is long enough for 80 or 90% of the rows. 
ALLOCATE = 0 is the most efficient as to space - ALLOCATE = full 
length is the best performing, but that's because it is the same as a 
fixed length - all data is stored in one placed - with shorter 
allocations, data longer than the allocation is stored in an auxiliary space.

I forget where this is cited - maybe the Data Management manual.

HTH
Vern

At 10:41 AM 11/9/2007, you wrote:

> Alright, one more question.
> Would it really be detrimental to the system if I was to allocate 1 
> Alpha and set a high max length for each of the varchar fields?  Not 
> every record will have data in all of the fields, and it would cut 
> down on wasted DASD.
>
> >>> "Jeff Day" <Jeff.Day@xxxxxxxx> 11/09/07 11:26 AM >>>
>
> <squint>lol</squint> will try.  I haven't done sql in inav yet... i 
> normally use squirrel or strsql, depending on what platform i'm using.
>
> Anyways, wanted to say thanks for all your replies.  It sounds like 
> it really is just allocating 256 then... I was concerned there may 
> be a bug in strsql, or...
>
> Thanks
>
> >>> <rob@xxxxxxxxx> 11/09/07 11:18 AM >>>
>
> You know, if you really don't like this stop using STRSQL and use iNav's
> Run SQL Scripts to run it in.  It kinda shrinks the display to fill the
> screen, with the usual gui methods to expand or contract the columns
> further.
>
> I can easily get two 8000 varchar fields to fit into about 2.5" of screen
> space without having to squint.
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
> --
> 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/mailman/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 message has been scanned for viruses by MailControl - www.mailcontrol.com
>
> Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==  to 
> report this email as spam
>
>
>
>
>
> If the reader of this email is not the intended recipient(s), please 
> be advised that any dissemination, distribution or copying of this 
> information is strictly prohibited. Johnson Matthey PLC has its main 
> place of business at 40-42 Hatton Garden, London (020 7269 8400).
>
> Johnson Matthey Public Limited Company
> Registered Office: 40-42 Hatton Garden, London EC1N 8EE
> Registered in England No 33774
>
> Whilst Johnson Matthey aims to keep its network free from viruses 
> you should note that we are unable to scan certain emails, 
> particularly if any part is encrypted or password-protected, and 
> accordingly you are strongly advised to check this email and any 
> attachments for viruses. The company shall NOT ACCEPT any liability 
> with regard to computer viruses transferred by way of email.
>
> Please note that your communication may be monitored in accordance 
> with Johnson Matthey internal policy documentation.
>
> This message has been scanned for viruses by MailControl - www.mailcontrol.com
> --
> 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/mailman/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/mailman/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.