I actually think this is a really good solution and was my first thought. Assuming you are allowed to update the dictionary in the source file, you could add an ATB to do a TRANSLATE and make the select of those records that are in the source and not in the dest easier. Do what you need to do with that list. Then use SREFORMAT (does uv have that command?) to just copy the ID's of the list to the target to mark them done.
HELP SREFORMAT is: Help Information For: "UNIQUERY SREFORMAT" Page: 1/3 SREFORMAT Syntax SREFORMAT filename attributes [selection_criteria] Description The UniQuery SREFORMAT command sorts specified records by their record IDs and copies the record attributes from one file to another file. SREFORMAT uses the first attribute named in the UniQuery statement as the record ID in the destination file. The remaining attributes in the UniQuery statement become record attributes in the destination file. UniQuery prompts for the name of the destination file after you enter the SREFORMAT command. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Wednesday, December 11, 2013 10:38 AM To: U2 Users List Subject: Re: [U2] Exporting to File regularly Hi David, Though this is not a great option, you could create a new file and either just copy the current contents of the file you want to watch into it or just a "fingerprint" record if all you need is a "record exists" type of monitoring. Then a simple SELECT of the first file followed by an NSELECT of the fingerprint file would give you a resulting active select list, if any, of the new records which you could use to update your fingerprint file. These would be done inside a new., small program that you could then send an email message from. Run it from the OS's task scheduler and it's fully automated. Like I said, this is probably NOT the best solution but it gives you another approach to consider, depending on your needs. It also is completely separate from the current system you have with no interference of the vendors application. I'd be happy to give you more specifics if you want to try this. BobW -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Campbell Sent: Tuesday, December 10, 2013 9:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] Exporting to File regularly Hi Everyone, I'm new to universe (a complete noob) and I couldn't quite find what I was looking for on google and I've been smashing my face against this for a while until I stumbled upon this mailing list so I was wondering if anyone could help me out here. I'm writing a script that will hopefully alert me via email whenever a new record is added to a particular universe file, if there is a better way to do this I would be all ears. I'm working around another proprietary system which operates on universe and I dont know enough about universe to really say for sure what is proprietary and what is universe standard code and the proprietary stuff is covered in NDA's and no touchy hand slappy orders so I cannot really modify the way it works, I just need to know when a new entry appears, preferably via an smtp email. My Current plan works like this I'm looking to regularly (every 5 minutes) output data into a text or csv file, doesn't matter really, so long as it is not full of characters that batch scripts hate and it can happen in an automated fashion. The closest thing I can get to what I want right now is SP.ASSIGN HS LIST FILE.NAME LPTR this lists all the records and dumps them in a spool file under /var/spool/uv/ and then a script I have written in the past retrieves that spool file for me, I have trained that spool file to look for specific markers in the first line of the file and apply a particular script to it This spooled print job gives me a list of the records that I can then sort numerically, pick the highest number, check that number against what the number was last time and alert me via email if its different. Ultimately I would love for a regularly running script to just output the highest record (maybe sort numerically and give me the highest number and dump just that number into a file on the unix box for me to retrieve and the work with. Any help would be greatly appreciated! -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Exporting-to-File-regul arly-tp42264.html Sent from the U2 - Users mailing list archive at Nabble.com. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ----------------------------------------- IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
