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


  1.  Home
  2. RPG400-L
  3. December 2005

Re: How to find who is updating particular PF ?

Asuming you want to add the user, time, date and program that did the last update, the trigger will be your best option. For user and date-time it is direct, create a D line with a variable alpha 10 inz(*user) and write it to your file. For date use either %date(), %time() or %timestamp(). 
In order to write wich program was used you need to call an API.
To find out the some of the programs doing currently the update you can journal the file. 

Raul.

Mahesh Pawar wrote:


can you let me knwo how.?

FrankKany@xxxxxxxxxxx wrote:  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 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/02/2005 05:55 AM
Please respond to
RPG programming on the AS400 / iSeries 

To
RPG programming on the AS400 / iSeries 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

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.