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



 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.