RE: BPCS 405CD - IIM List Price Update for all records

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.
> 
>