Triggers have more overhead associated with them:
- you have install the trigger in all your hashed files/tables
IIRC, you can't have triggers on non-hashed file types.
Regards,
David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Ray Wurlod
Sent: Tuesday,
Have you thought of using trigger subroutines to keep the audit trail?
Much easier, and the before- and after-records and keys are available for you right
there in the arguments. :D
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
Why not write a little paragraph that does the select, then ED, which you execute ?
Ross Ferris
Stamina Software
Visage – an Evolution in Software Development
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
>Behalf Of John Hester
>Sent: Tuesday, 27 April 2004 9:
You're not wrong. Triggers on files came in at rev 10.
--
Regards,
Clif
On Apr 26, 2004, at 18:21, John Hester wrote:
Correct me if I'm wrong, but on UV 9.6 I think I'd have to convert
every UV file to a SQL table to be able to use a trigger.
--
u2-users mailing list
[EMAIL PROTECTED]
http://
You might try this. I am not on a system right now, so I can't test
this until later.
--
Regards,
Clif
~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~
saveList
Other things to consider:
1. What happens if someone uses XEQ within ED to edit another record.
2. What about people using UPDATE.RECORD
3. And what about REVISE (ENTRO/MODIFY)
There are many different ways to get around audit trails if people want to.
AdrianW
-Original Message-
From: J
We don't have this type of problem using PI/Open flavour - something to do
with EXECUTE being run in a different process space under other flavours.
Have a look at the PASSLIST keyword that can be used with EXECUTE.
Something like:
READLIST ID.LIST
ELSE STOP
EXECUTE "ED filename " PASSLIST ID
Lembit,
I just remembered one more thing.
We have set up PAM to make use of pam_smb so users are validated against the windows
domain controller (works well).
It looks like Unirpcd doesn't do this however so users logging in must have a local
password entry. There are a couple of work arounds
Lembit,
> Has anybody installed udt 6.0.5 on RH AS. Any experiences with that, especially with
> UOJ ?
We have installed udt6.0.5 on RHEL 2.1 ES. The install crashed on the part that tests
the shared memory parameters but Wally Terhune had a patch waiting for me in my inbox
the next morning
Humm...got me there...don't know when they added the ability to create
Triggers on Non-SQL tables?
> Correct me if I'm wrong, but on UV 9.6 I think I'd have to
> convert every
> UV file to a SQL table to be able to use a trigger.
>
__
This
Mark Eastwood wrote:
Have you looked at "Triggers" ?
I wrote a wrapper for the ED command last week to keep an
audit trail of
any changes made to files outside our applications. I'm just
writing a
before and after version of an edited record to a temp file and
comparing afterwards.
Corr
[EMAIL PROTECTED] wrote:
John what is wrong with this approach
loop
readnext id else done = true
until done do
list<-1> = id
repeat
select list to mylist
loop
readnext id else done = true
until done do
execute "ed ":file:" ":id
repeat
then before, after, between the two loops you can d
Steven,
here is a simple VB test application.
Set up qmilk or whatever in uci.config
Private Sub cmdConnect_Click()
On Error GoTo ErrorTrap
Dim strConnect As String
Dim sDSN As String, sAccount As String
Dim sUser As String, sPword As String
Dim time1 As Single, time2 As Single
Set UADODB =
In a message dated 4/26/2004 5:22:07 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> I wrote a wrapper for the ED command last week to keep an audit trail of
> any changes made to files outside our applications. I'm just writing a
> before and after version of an edited record to a temp
Have you looked at "Triggers" ?
>
> I wrote a wrapper for the ED command last week to keep an
> audit trail of
> any changes made to files outside our applications. I'm just
> writing a
> before and after version of an edited record to a temp file and
> comparing afterwards.
>
_
Hello
We're struggling through the IBM documentation to figure out how to call a
subroutine on UniData via OLEDB. (The OLDB.pdf) I'm hoping some one can
point us in the direction of some additional documentation or code examples.
I've begun searching in the archives, but only limited success s
I wrote a wrapper for the ED command last week to keep an audit trail of
any changes made to files outside our applications. I'm just writing a
before and after version of an edited record to a temp file and
comparing afterwards. All seemed fine until one of my coworkers
informed me he could
Can anyone tell me if Universe runs on Solaris for Intel?
Thanks,
Marc
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
In a message dated 4/26/2004 1:07:32 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> >Well I think that's going to depend on the application.
> >In an application where some users need read-only access to a few
> databases,
> >AND where they are not doing mass updates then it could be
> f
Will,
I'd suggest at third criteria: It needs to not break what we already have in Post
Nuke.
-- Original Message -
From: [EMAIL PROTECTED]
>The main objection was to not have information spread around in different areas that
>required different ways to view it. And sec
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Monday, April 26, 2004 9:49 AM
>Well I think that's going to depend on the application.
>In an application where some users need read-only access to a few
databases,
>AND where they are not doing mass updates th
In a message dated 4/26/2004 7:58:09 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
> The HP superdome systems I've seen running Universe apps were single large
> multiprocessor systems. One notable example was for a wholesale
> distribution company running 400+ branches and around 7500 us
In a message dated 4/26/2004 2:16:07 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
> A couple of other posts recommend I look at the feasibility of the m2f
> stuff, however obviously it is really up to the u2ug Board who will be
> taking over the list, what technology they want to use etc.
About the discussion regarding France Telecom : Their 30,000 UniVerse
licences is their installed park : These licences are geographically
dispatched onto 5 pairs of IBM servers connected via UV/Net. Each system
have its backup system.
Daily average number of "Telnet" connected users is 2,500 o
Thanks everyone. I appreciate the pointers.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
The HP superdome systems I've seen running Universe apps were single large
multiprocessor systems. One notable example was for a wholesale
distribution company running 400+ branches and around 7500 users on a single
24 processor machine attached to a large EMC Clariion disk array. One big
database
What does the hardware look like for a system with this many users ?
Are they all running the same apps going after the same data ?
Is UV/NET involved ?
I curious on how you would scale up to a large number of users running the
same application. Would you beef up the machine or would it be better
Yes. If this were a live environment, then it wouldn't be prudent at all to
just pull the plug. As a matter of fact it would be plain stupid. The
exception to that scenario is when you have people in remote offices that do
not remember to log off before they go home. We have sale people who wa
Well, Charlie,
If you had fired up The DPMonitor, even in Evaluation 10 day free trail
mode,
and had an Agent running before & after you did the raid 5 to raid 1+0
switch,
you would have been able to precisely measure and graphical compare
I/O improvements, as well as all the other improvements
As promised, here is the summary of responses
that I received from my query about computerized
maintenance management packages. The original
query follows the summary. (I received a couple of
replies regarding IT-related work order systems...
what we are looking for is a package for our
physical
Thanx Les, Brian.
I was just thinking out loud.
Schalk.
On Mon, 26 Apr 2004 11:06:14 +0100, Les Hewkin
<[EMAIL PROTECTED]> wrote:
BUT if you really want to see the primary Index..
Create a secondary index on the ID of the file.
Les (I'm sure it was Brian that tolds me to do that) Hewkin
--
Ross,
Actually, we just had a reason to care. We just changed from raid 5 to raid
1+0, and wanted to determine how and where we achieved performance increase. We
weren't interested in knowing how we compared to a museum machine, but in how
we compared to the weekend before. We did see quite a p
BUT if you really want to see the primary Index..
Create a secondary index on the ID of the file.
Les (I'm sure it was Brian that tolds me to do that) Hewkin
-Original Message-
From: Brian Leach [mailto:[EMAIL PROTECTED]
Sent: 26 April 2004 10:43
To: 'U2 Users Discussion List'
Subjec
uniVerse has no primary index.
All items are stored using a hashing algorithm applied to the primary key so
there is no need to index it.
The only way to access these is to SELECT the file.
Brian
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Schalk van
I can access a file containing the Secondary indecis, but is it possible
to access the Primary index file?
Schalk van Zyl
-
GWK BEPERK/LIMITED (REG: 1997/022252/06)
POSBUS 47 PO BOX 8730
DOUGLAS
Direkteure/Directors: NB Jacobs, FJ Lawrence,
Kevin (u2ug Board Member) posted this on the u2ug web site:
"When I do read u2-users it is though gmane.org
(http://news.gmane.org/gmane.comp.db.u2.general/), so I know that there are
a number of different ways to skin each cat. The reason I use Gmane is that
I don't have time each day to wade thr
If you are worried about UV PE on your XP box (keeping resources etc), here
is another solution...
I run UV (or UniData or jBASE) on my laptop using virtual PCs.
This way they are always available when I need them, and I can close down
the VPC when they are not. I can save its state and continu
37 matches
Mail list logo