Re: Database editor -- MIDRANGE-L

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.