Re: BPCS-L Digest, Vol 1, Issue 523

Hi Friend,

It is simple Just do a sql statement ,

STRSQL from your Command line

Beware , before doing this take a copy of your IIM in another PF.

Update XXXlib/IIM set ILIST = (ILIST +( ILIST * 0.5%)).

Hope this answers your query.

Regards,
Gopal

From: bpcs-l-request@midrange.com
Reply-To: bpcs-l@midrange.com
To: bpcs-l@midrange.com
Subject: BPCS-L Digest, Vol 1, Issue 523
Date: Fri, 24 Jan 2003 12:00:08 -0600

Send BPCS-L mailing list submissions to
bpcs-l@midrange.com

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo.cgi/bpcs-l
or, via email, send a message with subject or body 'help' to
bpcs-l-request@midrange.com

You can reach the person managing the list at
bpcs-l-owner@midrange.com

When replying, please edit your Subject line so it is more specific
than "Re: Contents of BPCS-L digest..."


Today's Topics:

1. BPCS 405CD - IIM List Price Update for all records
2. RE: BPCS 405CD - IIM List Price Update for all records
3. RE: BPCS 405CD - IIM List Price Update for all records
4. Re: BPCS 405CD - IIM List Price Update for all records
5. Re: BPCS 405CD - IIM List Price Update for all records
6. Re: BPCS 405CD - IIM List Price Update for all records


----------------------------------------------------------------------


Message: 1
Date: Fri, 24 Jan 2003 12:15:53 -0500
From: lorrel@gencor.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





------------------------------


Message: 2
Date: Fri, 24 Jan 2003 12:38:49 -0500
From: "Lacelle, Marc" <LACELLE@rcmint.ca>
Subject: 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.
>
>



------------------------------


Message: 3
Date: Fri, 24 Jan 2003 12:39:29 -0500
From: "Yan Shargorodsky" <yshargorodsky@yysinc.com>
Subject: RE: BPCS 405CD - IIM List Price Update for all records


Use the following SQL statement (Please first test it)

UPDATE IIM SET ILIST = (ILIST x 1.05)

Please be careful as it will update the whole file. If there is any
selection use it. and Test first.

Regards,

Yan Shargorodsky
Y&Y Solutions, Inc
Phone:(215)741-7138
Cell: (267)934-8327
e-mail: yshargorodsky@yysinc.com


-----Original Message-----
From: bpcs-l-bounces@midrange.com [mailto:bpcs-l-bounces@midrange.com]On
Behalf Of lorrel@gencor.com
Sent: Friday, January 24, 2003 12:16 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.







------------------------------


Message: 4
Date: Fri, 24 Jan 2003 12:38:34 -0500
From: Lisa.Abney@sensient-tech.com
Subject: Re: BPCS 405CD - IIM List Price Update for all records


Actually, any of those choices would work (well, except query!). Do you
have a programmer available? Any programmer with SQL experience could do
it in about 30 seconds, if it's that easy of a change, or an RPG program
would be very easy as well, especially if you want an audit log showing the
before and after price, or anything like that. We normally do ours using
the download-to-a-spreadsheet method, but we do lots of analysis and
negotiating with sales folks ... if they would say 5% across the board, I'd
be delighted! I can't think of any downsides to just changing the IIM
price field. (Keep in mind that the new price will only affect new orders
... orders already in house will keep their original price.)




lorrel@gencor.com
Sent by: To: <bpcs-l@midrange.com>
bpcs-l-bounces@mi cc:
drange.com Subject: BPCS 405CD - IIM List Price
Update for all records

01/24/2003 12:15
PM
Please respond to
"SSA's BPCS ERP
System"






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.







------------------------------


Message: 5
Date: Fri, 24 Jan 2003 09:49:35 -0800
From: "Chick Doe" <Cdoe@barton-instruments.com>
Subject: Re: BPCS 405CD - IIM List Price Update for all records

all of the techniques you mention would work! if you do not know how to do it, who is going to do it? get with that person and make sure they understand what you want done. the technique that they use is probably immaterial.

if i were doing it i'd use as/400 SQL. but using PC software such as access and ODBC is probably just about as easy. the key is to get with the person who is going to do this and make sure they understand.

one final comment, do you use special prices in the ESP file? depending upon what you are doing, you may or may not want to review these also.



>>> lorrel@gencor.com 01/24/03 09:15AM >>>
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.





------------------------------


Message: 6
Date: Fri, 24 Jan 2003 11:51:51 -0600
From: JJackson@fiestagasgrills.com
Subject: Re: BPCS 405CD - IIM List Price Update for all records

Wouldn't you use PRO510 and select pricing method E?

Johnnie Jackson
Fiesta Gas Grills, LLC






lorrel@gencor.com
Sent by: bpcs-l-bounces@midrange.com
01/24/2003 11:15 AM
Please respond to "SSA's BPCS ERP System"


To: <bpcs-l@midrange.com>
cc:
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.





------------------------------

_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) digest 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.



End of BPCS-L Digest, Vol 1, Issue 523
**************************************