× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I think that a trigger program might help.

Frank W. Kany IV
Senior Programmer/Analyst 
Unipres USA, Inc.
(615) 325-8428 - Office
(615) 517-1742 - Cell
http://www.unipres.com



Mahesh Pawar <pawarmahesh@xxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/02/2005 05:55 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
How to find who is updating particular PF ?






 Hi all,
 
 
 I need to add 2 new fields to a sales extract file and also populate 
them.The problem is I am not able to figure out how the file is getting 
updated.(which programs is updating this file)
 

  Whats known:
 
 The sales Extract file is journalled and the journal entries are created 
by a program which is a part of the datamirroring software. There is a 
constantly running batch job (also a part of Datamirror) which is most 
likely monitoring updates to the sales file.
 The object locks for this batch job has a *USRQ object which leads me to 
believe that the data from the sales file is written to the extract file 
using the *USRQ object.  Since the Datamirroring package is a 3rd party 
tool, I do not have access to the source code.
 
 I have verified that the Sales extract file is not DIRECTLY 
referenced/updated thru programs (scanned source members and also did a 
dsppgmref) / queries / Sqlpkg / dataareas / triggers).
 
 How do user queues work?? Is there anything else that I need to check. 
 
 Will appreciate if anyone could help. Thanks in advance. 

Thanks & Regards
  Mahesh Pawar

 
---------------------------------
 Yahoo! Personals
 Skip the bars and set-ups and start using Yahoo! Personals for free

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.