RE: Database editor

["Kern, Mary T" <MKern4@xxxxxxxxxxxxxxxxx>]

Try Surveyor.  

        -----Original Message----- 
        From: Don [mailto:dr2@xxxxxxxxxxxx] 
        Sent: Wed 4/2/2003 8:53 PM 
        To: marsha.barton@xxxxxxxxxxxxxxxx 
        Cc: midrange-l@xxxxxxxxxxxx 
        Subject: Re: Database editor
        
        



        well, off hand you have DBU and WRKDBF
        
        www.wrkdbf.com   and www.prodata.com
        
        And I'm sure Al has a tool hidden somewhere up his (sleeve) he'll be
        telling us about in a few emails...:)
        
        :)
        
        
        
        On Wed, 2 Apr 2003 marsha.barton@xxxxxxxxxxxxxxxx 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 so!
        me!
        >  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.
        >
        
        _______________________________________________
        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.