Re: Database editor -- MIDRANGE-L

Maybe, Marsha, but I bet it'd be a bad thing to do. Probably multiple related files have that same value in them, and you have to catch them all. If you don't know the file structure, you're dead.

Can you get a list of the bad numbers? And figure out the new ones? Can you execute the converter from a command line? Then you could create a small file with those 2 fields in it. There are various system tools for editing such a creature, including DFU and Operations Navigator.

Once that file is populated, create a CL program that loops through the file, inserting the old and new values in the appropriate parameters of the command or program call. Run in batch - you're done.

Such a program is very simple - do you have development forces there? If not, contact me offlist if you want.

BTW, welcome to our world - hope you like it so far.

Regards

Vern

At 04:19 PM 4/2/2003 -0500, you wrote:

I'm VERY new to the AS/400, sort of had the responsibility dropped in my lap last year. We're the misdemeanor probation dept. for our County and we use an AS/400 (a 9406-720) with a proprietary software package on which we perform our daily business. This software package/database uses a Master List Entry number that serves as the Primary Key for the database. Each client's Case Numbers reside under their ML#. Our software vendor recently did a massive conversion of our Case Numbers to a new format, but approx. 20,000 numbers were unable to be converted, due to data entry errors, etc. that kept those cases from fitting into the predefined format. This means that each of those remaining 20,000 numbers must be converted individually by hand. There is a Case Number correction/transfer module available in the software package, but you can only correct one Case Number at a time. I'm curious to know if there would be a way to convert these case numbers in batches, using some! type of editor, rather than having to convert them all manually, one at a time.

Suggestions welcome...
Marsha Barton
Criminal Justice Services
1040 S. Florida Ave.
Rockledge, FL 32955
(321) 633-2006 Ext. 52330
Please make note of new email address:
marsha.barton@xxxxxxxxxxxxxxxx

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.