Hi all, it’s been years since I’ve done QUERY, so could use some help?



I need a query that runs in a JCL to pull some archived data off the hp each day (as files are marked as removed).



No frills, runs every day, and just reports the files that were marked as removed the day before.





Thanks for any help you can provide!















[http://hosting.republictitle.com/signature/25thannivlogo.png]  Ray Shahan | Programmer

Republic Title of Texas, Inc. | Corporate

2701 W. Plano Parkway, Suite 100 | Plano, Texas 75075

Tel: 972-578-8611 | Direct: 214-556-0202

[log in to unmask]<mailto:[log in to unmask]> | www.republictitle.com

Proud to be ALTA Best Practices Certified











WIRE FRAUD ALERT: Effective immediately, Republic Title must send Wire Instructions via secured email. If you receive any communication that appears to be from our office containing revised wire instructions, consider it suspect and call your closing team immediately.  If you want us to wire funds to you, please bring your wiring instructions to closing.



　



CONFIDENTIALITY NOTICE:  This email transmission (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510 et seq., and any information contained in this message is legally privileged, confidential and intended only for the individual or entity named herein. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copy of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone and purge all copies of this message from your system. Thank you. This communication does not constitute an intention by the sender to conduct a transaction or make any agreement or contract by electronic means.







Although this e-mail and all attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus-free and Republic Title of Texas, Inc. bears no responsibility for any loss or damage arising in any way from its use.



* To join/leave the list, search archives, change list settings, *

* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *