× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




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.
>


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.