RE: Database editor

Booth:

After seeing that the supplied "solution" only handled one-at-a-time, I jumped 
to the conclusion that it was an interactive process and a modified CA macro 
seemed an obvious possibility to me too.

Create a file of numbers to convert and download to the PC. Create an initial 
macro that records the sequence of correcting one number. Save the macro as a 
VB script.

>From there, it should be possible to modify the VB macro to use the downloaded 
>file as input.

If it can be done by a batch process on the AS/400, the same logic should be 
used in the macro.

Tom Liotta

midrange-l-request@xxxxxxxxxxxx wrote:

>   3. Re: Database editor (Booth Martin)
>
>I wonder if the easiest/quickest way under the circumstances would be to
>create a macro if you are using Client Access.  (It can be done with a
>terminal, to, but a bit differently).
> 
>Start your program.  Key in the old number then start recording.  Finish the
>cycle and end the recording, save as a name, and map a convenient keypair to
>the macro.  You may need two macros. (perhaps Ctrl-down arrow and alt-down
>arrow?)
> 
>-------Original Message-------
> 
>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.

-- 
-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertechgroup.com


__________________________________________________________________
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455