|
HiHo Cold again, I think the chickens are dead 1. Backup or copy file IIM (just in case) 2. From a command line: STRSQL 3. Here is the SQL Statement UPDATE BPCSXXXF/IIM set ILIST = (ILIST + (ILIST * .05)) The XXX = the name of your data library Hope this helps Marc Lacelle Royal Canadian Mint > ---------- > From: lorrel@gencor.com[SMTP:lorrel@gencor.com] > Reply To: SSA's BPCS ERP System > Sent: Friday, January 24, 2003 12:15 PM > To: bpcs-l@midrange.com > Subject: BPCS 405CD - IIM List Price Update for all records > > Can anyone please tell me how I can update the List Price field in the IIM > for all records. I would like to do an increase of 5% across the board. Is > there a way to take the ILIST field value, multiply it by 1.05, then put it > back into the table? I am not sure whether this can be done through an RPG > or CL program, query, SQL statement, or if the data needs to be downloaded > off the AS400, modified, and then uploaded again. I am not a programmer, so > the simplest method would be the best. Any feedback would be greatly > appreciated. > > Thanks, > > Larry Orrel > Gencor Industries > > > Larry Orrel > Director of Information Systems > Gencor Industries > Phone: (407)290-6000 > Fax: (407)298-1806 > mailto:lorrel@gencor.com > > > > _______________________________________________ > This is the SSA's BPCS ERP System (BPCS-L) mailing list > To post a message email: BPCS-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo.cgi/bpcs-l > or email: BPCS-L-request@midrange.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/bpcs-l. > >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.