RE: Database editor

["Johnson, Duane" <djohnson@xxxxxxxxxxxxx>]

Marsha,
  If you can call this "Case Number correction/transfer module" from a
command line, or if it is interactive and you always respond the exact same
way except for the case number that you are dealing with, then the answer is
probably yes, otherwise, no, unless someone on this list has other thoughts.
Duane

> -----Original Message-----
> From: marsha.barton@xxxxxxxxxxxxxxxx [SMTP:marsha.barton@xxxxxxxxxxxxxxxx]
> Sent: Wednesday, April 02, 2003 3:19 PM
> To:   midrange-l@xxxxxxxxxxxx
> 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.