RTVQMQRY Why does it change the last used date of the *qrydfn obj? Anyway to prevent this update?

540 pts.
Tags:
CMD
Documentation
QRY
RTVQMQRY    Why does it change the last used date of the *qrydfn obj?  Anyway to prevent  this update? 
ASKED: January 26, 2010  6:38 PM
UPDATED: January 27, 2010  2:13 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    To bypass "last used date" is not much different from telling the system to give misleading audit info. A RTVQMQRY seems to me to be a legitimate usage of the query. Someone might have a good answer, but it might need to be implemented with care in any regulated environment. Tom
    125,585 pointsBadges:
    report
  • Modiyooch
    Our documentation utility uses the command for analysis. Updating date last used is misleading. Other commands such as DSPOBJD doesn't update the object as being used. I use this command to identify files used in queries.
    540 pointsBadges:
    report
  • TomLiotta
    Other commands such as DSPOBJD doesn’t update the object as being used. True, but DSPOBJD doesn't quite access the object. It only accesses the description of the object (Display Object Description) which is a fairly minor part of a (compound) object. It's kind of like the difference between a prototype or a *CMD definition and the procedure or command-processing program behind them. RTVQMQRY goes inside of the object and provides output that technically needs to be tracked to verify whether or not it was executed. I use this command to identify files used in queries. Note that RTVQMQRY only identifies files that were used to create the queries. It doesn't identify which files are actually used by the query at run-time. The files that are used may be specified when the query runs. However, I understand what you mean. It is, of course, technically possible to set Last used date to be whatever you want. (Websense is effectively stopping me from finding useful links for you.) But every such procedure tends to bring even more difficult audit and control problems. Maybe I can link to one later. The Change Object Description (QLICOBJD) API might provide a combination that lets you think up a workable counter to the behavior of RTVQMQRY. I haven't figured one out for myself. You might retrieve Last used date before running RTVQMQRY, and use the API to store the date in the Source file date/time header field. Not very satisfying. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following