Hi David,
Depending on your file type and underlying OS you could
1) If the file type is not a type 1 or type 19 then write a uniVerse
subroutine as a SQL trigger.
See chapter 5 of the SQL reference guide, on how to do this.
2) If the file type is a type 1 or a type 19 then if your underlying O
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. I
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 s
Triggers are probably the way, but if you have a touchy vendor, they might
not appreciate your trigger as much as you do. If triggers aren't an
option, maybe this could work (at least on a smallerish file):
*Assume the filename is FOO and the id is @ID*
*At ECL/TCL:*
SSELECT FOO BY-DSND @ID
SELE
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.
54
Can I modify this suggestion to say that it *stores* each write, and only
emails you once a day :)
Put that snake back in the box!!!
-Original Message-
From: doug
To: U2 Users List
Sent: Tue, Dec 10, 2013 11:38 pm
Subject: Re: [U2] Exporting to File regularly
I suggest that you pu
Depends on the timeframe needed for a response. If this were for some form of
QA that if it were incorrect
Needed to be addresses quickly, then the every 5 minutes would be needed (or
maximum time frame).
If it's just for history - then once a day would be fine.
-Original Message-
From:
If you don't mind being notified of other data changes in addition to
record additions, my preference would be to simply check the last
modified time of the UV file at the OS level. I think this shell script
would work:
#!/bin/bash
if [ ! -f /var/tmp/uv_timestamp ]; then
touch /var/tmp/uv_time
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 NS
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
Wow, overwhelming response to this question, thank you VERY MUCH for all of
your idea's, I have a lot to process and decide what I can achieve... as a
bit of background that I probably should have included, I am running
UniVerse 11.1.9 on an IBM AIX 7.1.1.15 box.
So far Bruce Decker seems to have
When you say "fills with junk" what you may be seeing is just that the "end" of
the file is moving forward. So the rest of the file in your view, is really
just stuff that's not garbage-cleaned because Universe knows where the true end
really is, but Windows/Unix doesn't know. So it has no ne
Hi David,
If you can do some UV basic coding or have access to a resource who can then:
Have a look at installing a file trigger on the file(s) you need to monitor.
The "sysdesc" manual contains trigger information.
The reason I suggest this is that the trigger will fire on your designated
condit
Hi Everyone,
We’re looking at doing some remote file mangling and was wondering if there are
any gotchas when using UV/Net to do this?
In my scenario if I am on host A and want to read/write files on host B. Host B
only needs to read/write files on host B but not on host A. Do I need UV/Net on
Hi Peter,
It's been a while since I've used/played around with UV/Net, but this may
help...
1. Setup
You only need a ensure UniRPC is active and you license for UV/Net on the
server you wish to access. I don't recall you need to anything other than the
UniRPC Daemon listening for requests and
Thanks David,
There was some confusion about if both hosts need the license and if only one
then which? Based on what you've written re the setup below, and from what our
VAR has advised I think the remote host will require a UVnet licence which it
does not currently have.
I am now going to re
Hi David
If you upgrade to the latest UV version you have access to the built-in UV DB
audit logging facility. Then you can setup a logging event to log changes to
the file(s) in question. Hence, not violating the NDAs nor application flow
(which you would have too if modifying the file with ad
17 matches
Mail list logo