Re: Edit IMHIST file

Joan,

A super tool to use on the AS/400 is a Data Base Utility (DBU) is available 
from ProData.  You can download a 30 day free trial from their website 
ProDatacomputer.com.  It is one of the easiest tools to view and fix problems 
in the database file.  We compared feature and functions against SQL400 and we 
liked it much better from a user perspective.

I am not associated with ProData, nor do I get anything for this 
recommendation.  This is solely my opinion and it would resolve your problem 
quickly.

Paola Groeber

>
> From: "McCready, Joan" <Joan.McCready@metaltekint.com>
> Date: 2002/09/26 Thu PM 01:09:56 EDT
> To: "MAPICS-List (mapics-l@midrange.com)" <mapics-l@midrange.com>
> Subject: Edit IMHIST file
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> To all -
>
> Whew! Quite a few topics flowing today on the ol' list. At the risk of
> overload, I need some help on a totally new topic.
>
> I need to edit some incorrect data in the IMHIST file - it does NOT involve
> a key field in the physical file. When I go into DFU, I get that lovely
> message "The retrieved record contains invalid data.", and of course I can't
> see or change the field I need to fix.
>
> I have neither the time nor the talent to write an edit program from
> scratch. Does anyone have one written that they'd be willing to "lend" to
> me. We're on Rel 6, but I don't think that the IMHIST file has changed much
> over the years... Does anyone have another solution to DFU besides some sort
> of RPG-written edit program? Maybe the SQL statements needed?
>
>           Thanks to all -- Joan
>
> Joan McCready, IS Manager      phone:  636-479-4499
> MetalTek International               fax:  636-479-3399
> The Carondelet Division             www.metaltekint.com
> <www.metaltekint.com>
> 8600 Commercial Blvd
> Pevely, MO  63070
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
>
>