RE: Database editor

SQL?  Or WRKDBF with the SQL function

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Marsha Barton
Sent: Wednesday, April 02, 2003 4: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.