×
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.
Hi All,
I am making my first, of many, attempt to create a DDL Table to eventually replace a DDS file.
First question:
Is it a good standard practice to create the table with no keys and use the Create Index?
Second question:
The table I want to replace is a comment file that has the comments broken into 50 char chunks.
The user enters 50 char at a time, hits enter to add the record, tries to remember where they left off and continues to add.
What a mess. It was created in 1989.
I created a new pgm that splices all the 50 char records together, displays a single 2400 char field that they can add to and insert into the middle of. I then re-parse the field into 50 char chunks again.
There are about 25 million records with the 50 char comment.
In the new table it will have a 2400 varchar field. I would guess that 90%+ of the records will not ever be displayed again.
For the Allocate clause should I still use the average length of the real comment, say 150 or leave it at 0?
Thanks!!
Jerry Forss
Information Technology Team
WalzCraft
608-781-6355 EXT 2530
jforss@xxxxxxxxxxxxx
Subject to Change Notice:
WalzCraft reserves the right to improve designs, and to change specifications without notice.
Confidentiality Notice:
This message and any attachments may contain confidential and privileged information that is protected by law. The information contained herein is transmitted for the sole use of the intended recipient(s) and should "only" pertain to "WalzCraft" company matters. If you are not the intended recipient or designated agent of the recipient of such information, you are hereby notified that any use, dissemination, copying or retention of this email or the information contained herein is strictly prohibited and may subject you to penalties under federal and/or state law. If you received this email in error, please notify the sender immediately and permanently delete this email. Thank You;
WalzCraft PO Box 1748 La Crosse, WI. 54602-1748
www.walzcraft.com<
http://www.walzcraft.com/> Phone... 800-237-1326
midrange.com
