Forwarded by moderator on behalf of Doug Ritsema: ------------------------------------------------- If you are very daring you can change the field using SQL. Before I would do this I would try it in a test environment to make sure that your filtering is correct. It also bypasses the data base integrity that using the maintenance screen enforces. Doug Ritsema Holland American Wafer Co 3300 Roger B Chaffee Grand Rapids, MI 49548 firstname.lastname@example.org -----Original Message----- From: aldg [mailto:email@example.com] Sent: Wednesday, October 04, 2000 5:44 PM To: MAPICS Mailing List Cc: Gershen, Al; Gershen, Al Subject: Suggestions for Changing Many Records in a Mapics DB File Hi Group: My last letter (sent just a while ago) delt with the WHSLC field in both the ITEMBL and ITEMASA Mapics files. In a somewhat related matter, is there an easy way to change the WHSLC fields in "many" Items No records with a minimal amount of keystrokes? The methods I'm aware of (using "two" AS/400 sessions, and the Copy and Paste computer functions) are: 1. Use Inventory Management's File Maintenance, the changes can be made to one file and copied and pasted to the second file; one record at a time. 2. Similarly, using AS/400 utilities such as Data Base Utility (DBU) or Data File Utility (DFU), the the changes can be made to one file and copied and pasted to the second file; one record at a time. Is there a way to write a Query (using Query/400) that can make the WHSLC changes to a List of Item Numbers in each file? I don't believe this can be done but I'd like some input on this question. What about Report Program Generator (RPG)? I'm not trained in it so I'm not aware of its capabilities. This is probably the tool to use to make changes to a group of records in a large DB file. +--- | This is the MAPICS Mailing List! | To submit a new message, send your mail to MAPICS-L@midrange.com. | To subscribe to this list send email to MAPICS-L-SUB@midrange.com. | To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.