From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Wednesday, July 25, 2012 5:50 AM
To: 'U2 Users List'
Subject: Re: [U2] UV Triggers / SQL
George
Yes, you've been able to do that for some time. It simply adds a SICA blo
t: 24 July 2012 20:31
To: U2 Users List
Subject: Re: [U2] UV Triggers / SQL
First I dropped the schema I setup on that account Then I tried to add a
trigger to that fileand it didn't give me any errors.
So...I can add triggers to UV files that reside in accounts that are not
defined in
users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Wasylenko
Sent: Tuesday, July 24, 2012 3:04 PM
To: U2 Users List
Subject: Re: [U2] UV Triggers / SQL
LOGTO the account - it'll work there.
... david ...
David L. Wasylenko
Presi
fessionals, Inc
w) 314 558 1482
d...@pickpro.com
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Tuesday, July 24, 2012 2:17 PM
To: U2 Users List
Subject: Re: [U2] UV Triggers / SQL
Can I have t
David L. Wasylenko
Sent: Tuesday, July 24, 2012 3:04 PM
To: U2 Users List
Subject: Re: [U2] UV Triggers / SQL
LOGTO the account - it'll work there.
... david ...
David L. Wasylenko
President, Pick Professionals, Inc
w) 314 558 1482
d...@pickpro.com
-Original Message-
From: u2-
LOGTO the account - it'll work there.
... david ...
David L. Wasylenko
President, Pick Professionals, Inc
w) 314 558 1482
d...@pickpro.com
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Tuesda
es me nuts trying to figure
out
if I need to type in /varname or \varnameGaaa!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jerry Banker
Sent: Friday, April 21, 2006 14:56
To: U2Users
Subject: RE: [U2] [UV] Triggers
Real programmers don't use debu
figure out
if I need to type in /varname or \varnameGaaa!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jerry Banker
Sent: Friday, April 21, 2006 14:56
To: U2Users
Subject: RE: [U2] [UV] Triggers
Real programmers don't use debuggers :-)
-Origin
Real programmers don't use debuggers :-)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul Trebbien
Sent: Friday, April 21, 2006 3:40 PM
To: Allen E. Elwood; U2Users
Subject: RE: [U2] [UV] Triggers
I mostly use a CRT statement to list data f
le who care."
V 858.678.0030 F 858.300.2600 W koretech.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood
Sent: Thursday, April 20, 2006 2:36 PM
To: U2Users
Subject: RE: [U2] [UV] Triggers
I'm mostly a U2/Pick kind a guy, but ca
: U2Users
Subject: RE: [U2] [UV] Triggers
Allan, you could do that. But UV has a debugger, which while not
perfect, especially when you have multi includes (but that is another
matter)..., should be able to be used. Having to use print statements is
a bit backwards, especially when other development
:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood
Sent: Friday, 21 April 2006 10:15 a.m.
To: U2Users
Subject: RE: [U2] [UV] Triggers
I'm mostly a U2/Pick kind a guy, but can't you just put in PRINT
statements and input statements to pause execution once you get to a
certain point? I still do t
TS, 1, PL.INDEX, 0,
ACT.LOTS<1,ACTI>)
END
*PRINT 'SORTED.QTYS ':SORTED.QTYS
*PRINT 'SORTED.PARTS ':SORTED.PARTS
*PRINT 'SORTED.LOTS ':SORTED.LOTS
*INPUT BUG;IF BUG THEN DEBUG
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behal
will find out in the coming months
Cheers,
Phil.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Rajkowski
Sent: Friday, 21 April 2006 4:15 a.m.
To: U2Users
Subject: RE: [U2] [UV] Triggers
Actually, you do have an update and a delete Trigger in
TECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
> Sent: Thursday, April 20, 2006 7:55 AM
> To: 'U2Users'
> Subject: RE: [U2] [UV] Triggers
>
> Phil:
>
> Fortunately, this is not the case in UniData. However,
> triggers (plural) is
> rea
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Thursday, April 20, 2006 8:55 AM
To: 'U2Users'
Subject: RE: [U2] [UV] Triggers
Phil:
Fortunately, this is not the case in UniData. However, triggers
(plural) is
really a misnomer as you can on
Phil:
Fortunately, this is not the case in UniData. However, triggers (plural) is
really a misnomer as you can only put one trigger (singular) on a UniData
file.
Bill Haskett
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of phil walker
> Sent: W
Mike,
have a look at this MSMQ example from MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/msmq/msmq_using_transactions_1gz2.asp
I don't know if GCI presents any special problems under windows but this
looks like it might work to send a "single message transaction"
gua
Mike,
In this particular instance, 'hard real-time' isn't an issue, a delay of
a few seconds would be quite OK.
I wasn't commenting on hard real-time. MQ Series and MSMQ guarantee
delivery not delivery time (I could be wrong about MSMQ).
Rather I was thinking about how guaranteed you need t
Craig
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett
> Sent: Thursday, 8 September 2005 18:27
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] [UV] Triggers, transaction state and
> interaction wi
Sequential file I/O is permitted while a transaction is active, so your trigger
subroutine could write to a file that some server process (not in a
transaction) was waiting on. Sequential file I/O statements can also work with
named pipes, though these are more difficult in a Windows environmen
Mike,
I think your best solution would the IBM MQSeries interface (be aware
that IBM have not provided access to the transaction/rollback aspects of
MQ in their UV interface, this has led us to not switch to the new UV-MQ
interface).
If you can't use the MQSeries interface (and fair enough t
MICHAEL.HENDERSON wrote:
> The mechanism chosen by our architecture team is
> Microsoft BizTalk Server
> Please can anyone offer any experienced-based advice
> here, or suggest an alternative "d" which is easier,
> better, and/or quicker than my ideas.
> And yes, I'd at least consider a "buy my
Hi Mike
A couple of suggestions.
1. Biztalk has an interface to IBM MQ message service. You could use IBM MQ
to talk from U2 to Biztalk. (I do not know if there are issues with
transaction state and MQ)
2. You could set up a type 1 file and write the transaction to that file.
In Biztalk, you
Mike,
I am not sure if this is officially supported but I have done it in a
couple of sites.
You can change a couple of the settings in the VOC record for the
command you want to run. DOS or create an separate entry to the
executable itself.
Change attribute 4 of the voc entry to include one of
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
D) Have trigger spawn a phantom which instantly does the job and kills
itself???
hth,
Allen
www.tortillafc.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of HENDERSON MIKE,
MR
Sent: Wednesday, September 07, 2005 18:27
To: u2-users@listserver.u2ug.org
Cc:
.
Cheers,
Phil
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
Sent: Saturday, 11 June 2005 10:01 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Triggers, RAID and SQL 2005
No, you can't get past the write statement if you are ru
Hi,
I will be out of the office from June 13th through June 15th. I will
return on June 16. I will not have access to e-mail or voice mail. If
a you need an immediate response to your e-mail please e-mail
[EMAIL PROTECTED] or you can call Frank at extension 467.
Thanks and have a great day!
UV 10.1.
BobW
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of phil walker
> Sent: Friday, June 10, 2005 2:50 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] [UV] Triggers, RAID and SQL 2005
>
> I know that are good
Just to add fuel to the fire - UniData triggers have no such
constraints. In fact, using the debugger was how I discovered that our
(old) development team thought it would be a good idea to install
triggers on a large client site at the end of the day. The next morning
wasn't a good day in support
not ideal...
Phil
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, 10 June 2005 8:16 p.m.
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Triggers, RAID and SQL 2005
We use them. they're good, though slower t
We use them. they're good, though slower than i-type pseudo triggers, they
give more flexibility.
Triggers begin a transaction, which you aren't supposed to be able to step
through using a debugger.
Regards,
--
Stuart Boydell
[EMAIL PROTECTED] wrote on 10-06-2005 13.57.58:
> I have found what I
reate a schema before you may create SQL
tables.
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Martin Canty
Sent: Thursday, April 07, 2005 3:57 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV Tri
Kevin,
What version of UV are you using? Before 10.x, in order to have triggers
files did have to be SQL-ized; however from 10.0 on you can put a trigger on
an ordinary file of types 2-18 and 30.
Your syntax difficulty is most likely a missing semi-colon (";") at the end
of the statement - bites
The correct syntax should be:
CREATE.TRIGGER trigger_name [BEFORE | AFTER] UPDATE ON file_name FOR EACH ROW
CALLING 'subroutine';
Note the semi-colon. All SQL commands end with one. Failure to include it will result
in the "SQL+" prompt that you got.
The file does not have to be an SQL table, b
Canty
Sent: Thursday, April 07, 2005 3:57 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV Triggers
Hi Kevin,
Here are some sample commands; part of the trick is in the way you
catalog the trigger subroutine
>BASIC BP TRIG001
>ICATALOG BP *TRIG001 FORCE
>CREATE TRIGGER TRG1
S
Hi Kevin,
Here are some sample commands; part of the trick is in the way you
catalog the trigger subroutine
>BASIC BP TRIG001
>ICATALOG BP *TRIG001 FORCE
>CREATE TRIGGER TRG1
SQL+ AFTER INSERT ON PARTS FOR EACH ROW CALLING "*TRIG001";
Martin
-Original Message-
From: [EMAIL PROTECTED
We put the functionality into the programs instead.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rex Gozar
Sent: 15 October 2004 19:13
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UV] Triggers
Adrian,
You say you used to use triggers for updating audit
Adrian,
You say you used to use triggers for updating audit files and referential
integrity checks, so how are you implementing this functionality now
(without triggers?) What is the performance difference between using
triggers and the new way?
REX
---
u2-users mailing list
[EMAIL PROTECTED
verse replication we can't run triggers at all as
they are not supported on replicated files.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rex Gozar
Sent: 15 October 2004 14:15
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UV] Triggers
Some thoughts in
Some thoughts in regards to Dennis' observation that triggers are slow.
I would kinda expect them to be slow. After all, they are (essentially)
little programs that get run each time a record is changed. Even if the
trigger did nothing, some overhead is expected for processing each record.
I'm
Hi Mel
UniVerse 10.1.2
AIX 5.2
We've found triggers to be immensely slow. At first we thought it might be the
files to which we were writing, but then, on the suggestion of another list
member, we tested with a trigger that was only 2 lines long (ie the SUBROUTINE
statement and a RETURN), ie that
> Has anyone experience with triggers at both version levels?
We have both file-triggers (sql & non-sql) and index-triggers on our system.
We have used index triggers from version 9.4 through to 10.0.7. and
file-triggers with v10.
Performance-wise, there doesn't seem to be too much difference.
Ma
I recently used the index-trigger method to track and record all changes
to a file. It seems to work well; it's not a really active file, so the
performance hit has been negligible. If anyone is interested I will post
the code. The only gotcha was figuring out how many times the TRIGGER
subroutine
45 matches
Mail list logo
