Re: Changed Object

Thanks Rob. The command PRTSQLINF gave me the answer.

Thanks & Regards,
Isaac Ayeh Antwi  | Business Systems Manager | Knowledge & Information Technology | Anglogold Ashanti, Ghana
Tel: +233-(0)3225-40494 ext. 1591  |  Fax: +233-(0)3225-41008  |  Cell: +233-(0)24-4335562
Email: iantwi@xxxxxxxxxxxxxxxxxxxxxxx
 Think before you print.


-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On Behalf Of antwi, isaac a.
Sent: 17 October 2012 08:40
To: BPCS ERP System
Subject: Re: [BPCS-L] Changed Object

Thanks Rob. I have to check. It is a BPCS program and I do not have the source codes.

Thanks & Regards,
Isaac Ayeh Antwi  | Business Systems Manager | Knowledge & Information Technology | Anglogold Ashanti, Ghana
Tel: +233-(0)3225-40494 ext. 1591  |  Fax: +233-(0)3225-41008  |  Cell: +233-(0)24-4335562
Email: iantwi@xxxxxxxxxxxxxxxxxxxxxxx
P Think before you print.

-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: 16 October 2012 18:08
To: BPCS ERP System
Subject: Re: [BPCS-L] Changed Object

Does your program have imbedded SQL? If so, try this command against the
object: PRTSQLINF. That data gets updated in the program. It tries to remember the best performing way to run it.
Other possible choices:
- periodic batch routines to remove observability

A good change management product can often tell and won't send you false flags.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "antwi, isaac a." <iantwi@xxxxxxxxxxxxxxxxxxxx>
To: <bpcs-l@xxxxxxxxxxxx>,
Date: 10/16/2012 02:04 PM
Subject: [BPCS-L] Changed Object
Sent by: bpcs-l-bounces@xxxxxxxxxxxx



Hi All,

A quick Question. Why is it that AS/400 displays a recent change date
for program objects whilst there hasn't been any recompilation of the
programs. I often see this when I use the DSPOBJD command.



Thanks & Regards,

Isaac Ayeh Antwi | Business Systems Manager | Knowledge & Information
Technology | Anglogold Ashanti, Ghana

Tel: +233-(0)3225-40494 ext. 1591 | Fax: +233-(0)3225-41008 | Cell:
+233-(0)24-4335562

Email: iantwi@xxxxxxxxxxxxxxxxxxxxxxx
<mailto:iantwi@xxxxxxxxxxxxxxxxxxxxxxx>

P Think before you print.




This email, and its attachments, is subject to important warnings and
disclaimers which are legally incorporated into this email in terms of
Section 11(3) of the South African Electronic Communications and
Transactions Act, 25 of 2002. The full text of the warnings and
disclaimers, together with the company?s details and directors is
available by clicking on
http://www.anglogoldashanti.co.za/additional/generalinfo/emaildisclaimer.htm