|
Your question is pretty broad but here goes. It seems that this is going to require some programming. Firstly, you'd have to determine why each of the records failed the conversion, then code to that situation. A contract programmer, (I'm assuming that you don't have one on staff), performing this task would probably be cheaper than hiring temps to convert and enter the data. You must understand that without seeing the data layouts and the data itself, there is no way to address specifics on this forum. Thanks, Mark Mark Walter Sr. Programmer/Analyst Hanover Wire Cloth a div of CCX, Inc. mwalter@xxxxxxxxxxxxxxx http://www.hanoverwire.com 717.637.3795 Ext.3040 /"\ \ / X / \ |--------+--------------------------------> | | <marsha.barton@xxxxxxx| | | county.us> (Marsha | | | Barton) | | | Sent by: | | | midrange-l-bounces@xxx| | | range.com | | | | | | | | | 04/02/2003 04:19 PM | | | Please respond to | | | Midrange Systems | | | Technical Discussion | | | | |--------+--------------------------------> >-----------------------------------------------------------------------------------------------------------| | | | To: <midrange-l@xxxxxxxxxxxx> | | cc: | | Subject: Database editor | >-----------------------------------------------------------------------------------------------------------| 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 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 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.