× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.