Re: [U2] Exporting to File regularly

David

Assuming records are not deleted the count function can give the number of records
COUNT FILE
32000 records counted.

On Allen's suggestion our system uses *NEW.NUMBER in the Dictionary file.
You can see all items by LIST DICT FILE



Jon Card
VP Special Projects
Combined Transport, Inc.
541-618-6565
Fax 541-826-9787

www.combinedtransport.com
Division of Combined Transport Logistics Group, Inc


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of George Gallen
Sent: Wednesday, December 11, 2013 6:46 AM
To: [email protected]; U2 Users List
Subject: Re: [U2] Exporting to File regularly

Going along this train of thought. What if you setup a new printer and make the Device's filename to be a script filename. Then when you setup the SP.ASSIGN and Then do your LIST ... it will send the output directly to your script.

Granted, you will need to setup a new "printer" device on the UV system account But that shouldn't be too difficult.

But - Personally, I'd opt for Trigger method and have the subroutine also track Deletes and Changes as well as Adds. However the Trigger method has filename naming constraints As well as permissions issues to allow the setting of the Trigger, however, a search Of this list will yield some trigger setup tips from about 6 months ago I believe.

George

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Allen Egerton
Sent: Wednesday, December 11, 2013 6:33 AM
To: 'U2 Users List'
Subject: Re: [U2] Exporting to File regularly

Good morning David.

While the answers you've gotten regarding triggers are valid, they're perhaps an overly complicated solution to your problem.

Your statement that LIST FILE.NAME LPTR gives you the info you need seems to
imply to me that the record key is numeric and generated sequentially.   If
so, then there's a control record in the existing system that you should be
able to retrieve.   And it may be as simple as finding the &NEXT.AVAILABLE&
record in the dictionary of the file that you're looking at.   If not, it's
going to be stored in a parameter file somewhere.   Unfortunately that
"somewhere" is a nasty word given that you are new to universe...



-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of David Campbell
Sent: Wednesday, December 11, 2013 12:39 AM
To: [email protected]
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-regularly
-tp42264.html
Sent from the U2 - Users mailing list archive at Nabble.com.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users