Re: [U2] UV Triggers / SQL

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 UV_SCHEMA

Re: [U2] UV Triggers / SQL

...@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 block to the file and logs the trigger

[U2] UV Triggers / SQL

I'm trying to setup a trigger on a UV File. I created the cataloged subroutine, I'm running as user uvsql I type in CREATE TRIGGER name AFTER INSERT ON table FOR EACH ROW CALLING '*subroutine'; And it says it can't find TABLE table I have this account setup in UV_SCHEMA already (for

Re: [U2] UV Triggers / SQL

: Tuesday, July 24, 2012 2:06 PM To: U2 Users Subject: [U2] UV Triggers / SQL I'm trying to setup a trigger on a UV File. I created the cataloged subroutine, I'm running as user uvsql I type in CREATE TRIGGER name AFTER INSERT ON table FOR EACH ROW CALLING '*subroutine'; And it says it can't find

Re: [U2] UV Triggers / SQL

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 President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users

Re: [U2] UV Triggers / SQL

, 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 tables from

Re: [U2] UV Triggers / SQL

-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 President, Pick

[U2] UV Triggers on DICT portion of a UV File?

Is there a way to have a trigger fire if a DICT item of a file is modified? George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

RE: [U2] [UV] Triggers

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 debuggers :-) -Original

RE: [U2] [UV] Triggers

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 :-) -Original Message- From

RE: [U2] [UV] Triggers

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 can't you just put in PRINT statements and input

RE: [U2] [UV] Triggers

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 from

[U2] [UV] Triggers

How many people in this group as using triggers in there applications? For those that do, how do they manage to use the debugger? As from what I have been able to ascertains it seems as soon as you try to debug a program which write/deletes to/from a file/table with a trigger on the program

RE: [U2] [UV] Triggers

: Wednesday, April 19, 2006 11:02 PM To: U2Users Subject: [U2] [UV] Triggers How many people in this group as using triggers in there applications? For those that do, how do they manage to use the debugger? As from what I have been able to ascertains it seems as soon as you try to debug

RE: [U2] [UV] Triggers

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 only put one

RE: [U2] [UV] Triggers

] [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 really a misnomer as you can only put one trigger (singular

RE: [U2] [UV] Triggers

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

RE: [U2] [UV] Triggers

PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of phil walker Sent: Thursday, April 20, 2006 12:58 To: U2Users Subject: RE: [U2] [UV] Triggers Mike, I may have mislead you slightly, in that in the scenario I have I do not actually want to debug the trigger code, although I cannot see why you should

RE: [U2] [UV] Triggers

:[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 this myself

RE: [U2] [UV] Triggers

To: 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

RE: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' [AD]

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

Re: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified}

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

Re: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified}

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

RE: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified}

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 with the 'outside world' {Unclassified

Re: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified}

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

Re: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified}

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

[U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified}

Listers, We provision our Microsoft Active Directory (and our SAP Logistics, and ..., and ...) from our UniVerse HR system [UV 10.0.x on Windows Server 2003 - we are pretty much a Windows shop]. Currently the data transfer is done by an overnight batch process, which we have used for several

RE: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified}

: SOO STEATHER, MR Subject: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified} Listers, We provision our Microsoft Active Directory (and our SAP Logistics, and ..., and ...) from our UniVerse HR system [UV 10.0.x on Windows Server 2003 - we are pretty

RE: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified}

--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified}

. To: u2-users@listserver.u2ug.org Cc: SOO STEATHER, MR Subject: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified} Listers, We provision our Microsoft Active Directory (and our SAP Logistics, and ..., and ...) from our UniVerse HR system [UV 10.0.x on Windows

RE: [U2] [UV] Triggers, transaction state and interaction with the 'outside world' {Unclassified}

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,

Re: [U2] [UV] Triggers, RAID and SQL 2005

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

RE: [U2] [UV] Triggers, RAID and SQL 2005

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 than i

RE: [U2] [UV] Triggers, RAID and SQL 2005

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

RE: [U2] [UV] Triggers, RAID and SQL 2005

-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 as they are very powerful. My point is I

RE: [U2] [UV] Triggers, RAID and SQL 2005

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!

RE: [U2] [UV] Triggers, RAID and SQL 2005

is there. 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 running

[U2] [UV] Triggers, RAID and SQL 2005

I have found what I believe to be a problem with implementing triggers in UniVerse. If I have a trigger on a file and a developer is trying to resolve a problem in a program which happens to update/delete that file an issue using 'RAID' the debugger ;-) When the developer steps over the write

[U2] UV Triggers

I am making my first foray into Universe triggers having knowledge only of how it works with Unidata and the Universe documentation, and am having a devil of a time. Is it a requirement that in Universe, the file must be created via SQL in order to put triggers on it? And then what of this

RE: [U2] UV Triggers

: 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 SQL+ AFTER INSERT ON PARTS

Re: [U2] UV Triggers

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,

RE: [U2] UV Triggers

me all the time. -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Sent: Thursday, April 07, 2005 2:38 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Triggers I am making my first foray into Universe triggers having knowledge only of how it works with Unidata

RE: [U2] [UV] Triggers

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 regards

RE: [U2] [UV] Triggers

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

RE: [U2] [UV] Triggers

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

[U2] [UV] Triggers

We have recently upgraded to v10.1 and are reconsidering the use of triggers after encountering significant issues with triggers with v9.4. After successfully testing them in our development environment, we encountered random write failures in production. Has anyone experience with triggers at

RE: [U2] [UV] Triggers

9.6.1.14 0003 PICK 0004 PICK.FORMAT 0005 9.6.1.14 Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Maresh, Mel Sent: Thursday, October 14, 2004 9:55 AM To: [EMAIL PROTECTED] Subject: [U2] [UV

RE: [U2] [UV] Triggers

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.