Re: [U2] Triggers in Universe
"/...but I've created systems with master triggers that read a list of subordinate triggers from a control file and call them in order./" This appears to be the "best practices" of managing triggers in UD. Once explained, it seems the most logical method of managing triggers and allowing individual dbms accounts to use local versions of trigger subroutines. Bill - Original Message - *From:* br...@brianleach.co.uk *To:* 'U2 Users List' *Date:* 1/29/2013 1:08 AM *Subject:* Re: [U2] Triggers in Universe Peter Yes, they are still cached but you can derive the name - it's an overhead but I've created systems with master triggers that read a list of subordinate triggers from a control file and call them in order. Then these can have a version stamp appended when catalogued. IN practice I found the overhead of reading the list was minimal compared with the overheads on calling the trigger in the first place, and because it's happening all the time on a busy system that control file is constantly cached in memory anyway. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: 28 January 2013 23:26 To: U2 Users List Subject: Re: [U2] Triggers in Universe Could use the trigger program to call one or more external subroutines based on the trigger action required? I understand that the external subroutines are not cached and can be updated without needing to stop/start the master trigger. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Saturday, 26 January 2013 20:19 To: U2 Users List Subject: Re: [U2] Triggers in Universe Remember also that triggers, as subroutines, are cached in memory so if you recompile a trigger the changes won't be picked up by any processes that have not logged off or returned to TCL. Brian Sent from my iPad On 25 Jan 2013, at 22:18, Bobby Worley wrote: [snipped] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
On 28/01/13 23:26, Peter Cheney wrote: > Could use the trigger program to call one or more external subroutines based > on the trigger action required? > I understand that the external subroutines are not cached and can be updated > without needing to stop/start the master trigger. > Never tried this, but you should be able to break the cache if you so wish ... MYSUB = "subroutine name" CALL @MYSUB See my other post about the catalog and caching :-) but this will cache the object code in the variable MYSUB. If you reload the variable with the subroutine name EVERY CALL, it should load the object code afresh every time. Never tried it, can't guarantee it, but if you use this sort of code in your trigger program it should work fine without caching. When it's all tested and working, you can change it to "CALL *MYSUB" or whatever. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
Peter Yes, they are still cached but you can derive the name - it's an overhead but I've created systems with master triggers that read a list of subordinate triggers from a control file and call them in order. Then these can have a version stamp appended when catalogued. IN practice I found the overhead of reading the list was minimal compared with the overheads on calling the trigger in the first place, and because it's happening all the time on a busy system that control file is constantly cached in memory anyway. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: 28 January 2013 23:26 To: U2 Users List Subject: Re: [U2] Triggers in Universe Could use the trigger program to call one or more external subroutines based on the trigger action required? I understand that the external subroutines are not cached and can be updated without needing to stop/start the master trigger. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Saturday, 26 January 2013 20:19 To: U2 Users List Subject: Re: [U2] Triggers in Universe Remember also that triggers, as subroutines, are cached in memory so if you recompile a trigger the changes won't be picked up by any processes that have not logged off or returned to TCL. Brian Sent from my iPad On 25 Jan 2013, at 22:18, Bobby Worley wrote: > That's what I did, Perry! GMTA ;) > > > > On Fri, Jan 25, 2013 at 4:07 PM, Perry Taylor wrote: > >> You can globally catalog in a Pick-flavored account. Copy the >> CATALOG VOC record from the UV account to your Pick-flavored account >> VOC renaming it something like ICATALOG. We do it all the time for our >> file-based triggers. >> >> Perry >> >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org [mailto: >> u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley >> Sent: Friday, January 25, 2013 3:03 PM >> To: U2 Users List >> Subject: Re: [U2] Triggers in Universe >> >> The problem was the locally cataloged program.I was in an account that >> is PICK flavor and wouldn't allow global cataloging. When I catalog >> the program globally from the UV account the CREATE TRIGGER now works. >> Thanks! >> >> >> >> >> >> On Fri, Jan 25, 2013 at 3:56 PM, Woodward, Bob >> >> wrote: >> >>> In Unidata the problem would be that the trigger has to be cataloged >>> globally, not locally. I'm not sure how to do that in Universe, though. >>> >>> -Original Message- >>> From: u2-users-boun...@listserver.u2ug.org [mailto: >>> u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley >>> Sent: Friday, January 25, 2013 1:33 PM >>> To: U2 Users List >>> Subject: [U2] Triggers in Universe >>> >>> I'm up against a wall here - trying to use triggers for the first >>> time, >> on >>> Universe. Can't seem to get my test to work - >>> >>> Universe on AIX: >>> >>> RELLEVEL >>> 001 X >>> 002 11.1.9 >>> 003 PICK >>> 004 PICK.FORMAT >>> 005 11.1.9 >>> >>>> BASIC BDW TRIGTEST >>> Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' >>> * >>> >>> Compilation Complete. >>> >>>> CATALOG BDW TRIGTEST >>> "TRIGTEST" cataloged. >>> >>>> .L TRIGTEST >>> >>> TRIGTEST >>> 001 V >>> 002 BDW.O/TRIGTEST >>> 003 B >>> 004 BNP >>> 005 >>> 006 PICK.FORMAT >>> 007 S N P I A E H >>> 008 NO.WARN NOPAGE LPTR KEEP.COMMON TRAP HDR-SUPP >>> 009 BDW.O >>> >>> >>>> CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL >>>> FOR >>> EACH ROW CALLING 'TRIGTEST'; >>> Unable to locate trigger program "BDW.O/TRIGTEST". >>> >>> >>> -- >>> >>> >>> >>> *Bobby D. Worley* >>> >>> IT Applications Developer >>> >>> Coburn Supply Company >>> >>> o: 903.753.8613 | m: 214.676.9825 >>> >>> bwor...@coburns.com >>> >>> ** ** >>> ___ >>> U2-Users mailing list >>> U2-Users@listse
Re: [U2] Triggers in Universe
Could use the trigger program to call one or more external subroutines based on the trigger action required? I understand that the external subroutines are not cached and can be updated without needing to stop/start the master trigger. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Saturday, 26 January 2013 20:19 To: U2 Users List Subject: Re: [U2] Triggers in Universe Remember also that triggers, as subroutines, are cached in memory so if you recompile a trigger the changes won't be picked up by any processes that have not logged off or returned to TCL. Brian Sent from my iPad On 25 Jan 2013, at 22:18, Bobby Worley wrote: > That's what I did, Perry! GMTA ;) > > > > On Fri, Jan 25, 2013 at 4:07 PM, Perry Taylor wrote: > >> You can globally catalog in a Pick-flavored account. Copy the >> CATALOG VOC record from the UV account to your Pick-flavored account >> VOC renaming it something like ICATALOG. We do it all the time for our >> file-based triggers. >> >> Perry >> >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org [mailto: >> u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley >> Sent: Friday, January 25, 2013 3:03 PM >> To: U2 Users List >> Subject: Re: [U2] Triggers in Universe >> >> The problem was the locally cataloged program.I was in an account that >> is PICK flavor and wouldn't allow global cataloging. When I catalog >> the program globally from the UV account the CREATE TRIGGER now works. >> Thanks! >> >> >> >> >> >> On Fri, Jan 25, 2013 at 3:56 PM, Woodward, Bob >> >> wrote: >> >>> In Unidata the problem would be that the trigger has to be cataloged >>> globally, not locally. I'm not sure how to do that in Universe, though. >>> >>> -Original Message- >>> From: u2-users-boun...@listserver.u2ug.org [mailto: >>> u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley >>> Sent: Friday, January 25, 2013 1:33 PM >>> To: U2 Users List >>> Subject: [U2] Triggers in Universe >>> >>> I'm up against a wall here - trying to use triggers for the first >>> time, >> on >>> Universe. Can't seem to get my test to work - >>> >>> Universe on AIX: >>> >>> RELLEVEL >>> 001 X >>> 002 11.1.9 >>> 003 PICK >>> 004 PICK.FORMAT >>> 005 11.1.9 >>> >>>> BASIC BDW TRIGTEST >>> Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' >>> * >>> >>> Compilation Complete. >>> >>>> CATALOG BDW TRIGTEST >>> "TRIGTEST" cataloged. >>> >>>> .L TRIGTEST >>> >>> TRIGTEST >>> 001 V >>> 002 BDW.O/TRIGTEST >>> 003 B >>> 004 BNP >>> 005 >>> 006 PICK.FORMAT >>> 007 S²N²P²I²A²E²H >>> 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP >>> 009 BDW.O >>> >>> >>>> CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL >>>> FOR >>> EACH ROW CALLING 'TRIGTEST'; >>> Unable to locate trigger program "BDW.O/TRIGTEST". >>> >>> >>> -- >>> >>> >>> >>> *Bobby D. Worley* >>> >>> IT Applications Developer >>> >>> Coburn Supply Company >>> >>> o: 903.753.8613 | m: 214.676.9825 >>> >>> bwor...@coburns.com >>> >>> ** ** >>> ___ >>> U2-Users mailing list >>> U2-Users@listserver.u2ug.org >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >>> ___ >>> U2-Users mailing list >>> U2-Users@listserver.u2ug.org >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> >> >> -- >> >> >> >> *Bobby D. Worley* >> >> IT Applications Developer >> >> Coburn Supply Company >> >> o: 903.753.8613 | m: 214.676.9825 >> >> bwor...@coburns.com >> >> ** ** >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org
Re: [U2] Triggers in Universe
Remember also that triggers, as subroutines, are cached in memory so if you recompile a trigger the changes won't be picked up by any processes that have not logged off or returned to TCL. Brian Sent from my iPad On 25 Jan 2013, at 22:18, Bobby Worley wrote: > That's what I did, Perry! GMTA ;) > > > > On Fri, Jan 25, 2013 at 4:07 PM, Perry Taylor wrote: > >> You can globally catalog in a Pick-flavored account. Copy the CATALOG VOC >> record from the UV account to your Pick-flavored account VOC renaming it >> something like ICATALOG. We do it all the time for our file-based triggers. >> >> Perry >> >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org [mailto: >> u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley >> Sent: Friday, January 25, 2013 3:03 PM >> To: U2 Users List >> Subject: Re: [U2] Triggers in Universe >> >> The problem was the locally cataloged program.I was in an account that >> is PICK flavor and wouldn't allow global cataloging. When I catalog the >> program globally from the UV account the CREATE TRIGGER now works. >> Thanks! >> >> >> >> >> >> On Fri, Jan 25, 2013 at 3:56 PM, Woodward, Bob >> wrote: >> >>> In Unidata the problem would be that the trigger has to be cataloged >>> globally, not locally. I'm not sure how to do that in Universe, though. >>> >>> -Original Message- >>> From: u2-users-boun...@listserver.u2ug.org [mailto: >>> u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley >>> Sent: Friday, January 25, 2013 1:33 PM >>> To: U2 Users List >>> Subject: [U2] Triggers in Universe >>> >>> I'm up against a wall here - trying to use triggers for the first time, >> on >>> Universe. Can't seem to get my test to work - >>> >>> Universe on AIX: >>> >>> RELLEVEL >>> 001 X >>> 002 11.1.9 >>> 003 PICK >>> 004 PICK.FORMAT >>> 005 11.1.9 >>> >>>> BASIC BDW TRIGTEST >>> Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' >>> * >>> >>> Compilation Complete. >>> >>>> CATALOG BDW TRIGTEST >>> "TRIGTEST" cataloged. >>> >>>> .L TRIGTEST >>> >>> TRIGTEST >>> 001 V >>> 002 BDW.O/TRIGTEST >>> 003 B >>> 004 BNP >>> 005 >>> 006 PICK.FORMAT >>> 007 S²N²P²I²A²E²H >>> 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP >>> 009 BDW.O >>> >>> >>>> CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR >>> EACH ROW CALLING 'TRIGTEST'; >>> Unable to locate trigger program "BDW.O/TRIGTEST". >>> >>> >>> -- >>> >>> >>> >>> *Bobby D. Worley* >>> >>> IT Applications Developer >>> >>> Coburn Supply Company >>> >>> o: 903.753.8613 | m: 214.676.9825 >>> >>> bwor...@coburns.com >>> >>> ** ** >>> ___ >>> U2-Users mailing list >>> U2-Users@listserver.u2ug.org >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >>> ___ >>> U2-Users mailing list >>> U2-Users@listserver.u2ug.org >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> >> >> -- >> >> >> >> *Bobby D. Worley* >> >> IT Applications Developer >> >> Coburn Supply Company >> >> o: 903.753.8613 | m: 214.676.9825 >> >> bwor...@coburns.com >> >> ** ** >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> CONFIDENTIALITY NOTICE: This e-mail message, including any >> attachments, is for the sole use of the intended recipient(s) >> and may contain confidential and privileged information. Any >> unauthorized review, use, disclosure or distribution is >> prohibited. ZirMed, Inc. has strict policies regarding the >> content of e-mail communications, specifically Protected Health >> Information, any communications containing such material will >> be returned to the originating party with such advisement >> noted. If you are not the intended recipient, please contact >> the sender by reply e-mail and destroy all copies of the >> original message. >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > -- > > > > *Bobby D. Worley* > > IT Applications Developer > > Coburn Supply Company > > o: 903.753.8613 | m: 214.676.9825 > > bwor...@coburns.com > > ** ** > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
That's what I did, Perry! GMTA ;) On Fri, Jan 25, 2013 at 4:07 PM, Perry Taylor wrote: > You can globally catalog in a Pick-flavored account. Copy the CATALOG VOC > record from the UV account to your Pick-flavored account VOC renaming it > something like ICATALOG. We do it all the time for our file-based triggers. > > Perry > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley > Sent: Friday, January 25, 2013 3:03 PM > To: U2 Users List > Subject: Re: [U2] Triggers in Universe > > The problem was the locally cataloged program.I was in an account that > is PICK flavor and wouldn't allow global cataloging. When I catalog the > program globally from the UV account the CREATE TRIGGER now works. > Thanks! > > > > > > On Fri, Jan 25, 2013 at 3:56 PM, Woodward, Bob >wrote: > > > In Unidata the problem would be that the trigger has to be cataloged > > globally, not locally. I'm not sure how to do that in Universe, though. > > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org [mailto: > > u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley > > Sent: Friday, January 25, 2013 1:33 PM > > To: U2 Users List > > Subject: [U2] Triggers in Universe > > > > I'm up against a wall here - trying to use triggers for the first time, > on > > Universe. Can't seem to get my test to work - > > > > Universe on AIX: > > > > RELLEVEL > > 001 X > > 002 11.1.9 > > 003 PICK > > 004 PICK.FORMAT > > 005 11.1.9 > > > > >BASIC BDW TRIGTEST > > Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' > > * > > > > Compilation Complete. > > > > >CATALOG BDW TRIGTEST > > "TRIGTEST" cataloged. > > > > >.L TRIGTEST > > > > TRIGTEST > > 001 V > > 002 BDW.O/TRIGTEST > > 003 B > > 004 BNP > > 005 > > 006 PICK.FORMAT > > 007 S²N²P²I²A²E²H > > 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP > > 009 BDW.O > > > > > > >CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR > > EACH ROW CALLING 'TRIGTEST'; > > Unable to locate trigger program "BDW.O/TRIGTEST". > > > > > > > > > -- > > > > > > > > *Bobby D. Worley* > > > > IT Applications Developer > > > > Coburn Supply Company > > > > o: 903.753.8613 | m: 214.676.9825 > > > > bwor...@coburns.com > > > > ** ** > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > > > > *Bobby D. Worley* > > IT Applications Developer > > Coburn Supply Company > > o: 903.753.8613 | m: 214.676.9825 > > bwor...@coburns.com > > ** ** > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > CONFIDENTIALITY NOTICE: This e-mail message, including any > attachments, is for the sole use of the intended recipient(s) > and may contain confidential and privileged information. Any > unauthorized review, use, disclosure or distribution is > prohibited. ZirMed, Inc. has strict policies regarding the > content of e-mail communications, specifically Protected Health > Information, any communications containing such material will > be returned to the originating party with such advisement > noted. If you are not the intended recipient, please contact > the sender by reply e-mail and destroy all copies of the > original message. > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
You can globally catalog in a Pick-flavored account. Copy the CATALOG VOC record from the UV account to your Pick-flavored account VOC renaming it something like ICATALOG. We do it all the time for our file-based triggers. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, January 25, 2013 3:03 PM To: U2 Users List Subject: Re: [U2] Triggers in Universe The problem was the locally cataloged program.I was in an account that is PICK flavor and wouldn't allow global cataloging. When I catalog the program globally from the UV account the CREATE TRIGGER now works. Thanks! On Fri, Jan 25, 2013 at 3:56 PM, Woodward, Bob wrote: > In Unidata the problem would be that the trigger has to be cataloged > globally, not locally. I'm not sure how to do that in Universe, though. > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley > Sent: Friday, January 25, 2013 1:33 PM > To: U2 Users List > Subject: [U2] Triggers in Universe > > I'm up against a wall here - trying to use triggers for the first time, on > Universe. Can't seem to get my test to work - > > Universe on AIX: > > RELLEVEL > 001 X > 002 11.1.9 > 003 PICK > 004 PICK.FORMAT > 005 11.1.9 > > >BASIC BDW TRIGTEST > Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' > * > > Compilation Complete. > > >CATALOG BDW TRIGTEST > "TRIGTEST" cataloged. > > >.L TRIGTEST > > TRIGTEST > 001 V > 002 BDW.O/TRIGTEST > 003 B > 004 BNP > 005 > 006 PICK.FORMAT > 007 S²N²P²I²A²E²H > 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP > 009 BDW.O > > > >CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR > EACH ROW CALLING 'TRIGTEST'; > Unable to locate trigger program "BDW.O/TRIGTEST". > > > > > -- > > > > *Bobby D. Worley* > > IT Applications Developer > > Coburn Supply Company > > o: 903.753.8613 | m: 214.676.9825 > > bwor...@coburns.com > > ** ** > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
The problem was the locally cataloged program.I was in an account that is PICK flavor and wouldn't allow global cataloging. When I catalog the program globally from the UV account the CREATE TRIGGER now works. Thanks! On Fri, Jan 25, 2013 at 3:56 PM, Woodward, Bob wrote: > In Unidata the problem would be that the trigger has to be cataloged > globally, not locally. I'm not sure how to do that in Universe, though. > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley > Sent: Friday, January 25, 2013 1:33 PM > To: U2 Users List > Subject: [U2] Triggers in Universe > > I'm up against a wall here - trying to use triggers for the first time, on > Universe. Can't seem to get my test to work - > > Universe on AIX: > > RELLEVEL > 001 X > 002 11.1.9 > 003 PICK > 004 PICK.FORMAT > 005 11.1.9 > > >BASIC BDW TRIGTEST > Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' > * > > Compilation Complete. > > >CATALOG BDW TRIGTEST > "TRIGTEST" cataloged. > > >.L TRIGTEST > > TRIGTEST > 001 V > 002 BDW.O/TRIGTEST > 003 B > 004 BNP > 005 > 006 PICK.FORMAT > 007 S²N²P²I²A²E²H > 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP > 009 BDW.O > > > >CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR > EACH ROW CALLING 'TRIGTEST'; > Unable to locate trigger program "BDW.O/TRIGTEST". > > > > > -- > > > > *Bobby D. Worley* > > IT Applications Developer > > Coburn Supply Company > > o: 903.753.8613 | m: 214.676.9825 > > bwor...@coburns.com > > ** ** > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
In Unidata the problem would be that the trigger has to be cataloged globally, not locally. I'm not sure how to do that in Universe, though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, January 25, 2013 1:33 PM To: U2 Users List Subject: [U2] Triggers in Universe I'm up against a wall here - trying to use triggers for the first time, on Universe. Can't seem to get my test to work - Universe on AIX: RELLEVEL 001 X 002 11.1.9 003 PICK 004 PICK.FORMAT 005 11.1.9 >BASIC BDW TRIGTEST Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' * Compilation Complete. >CATALOG BDW TRIGTEST "TRIGTEST" cataloged. >.L TRIGTEST TRIGTEST 001 V 002 BDW.O/TRIGTEST 003 B 004 BNP 005 006 PICK.FORMAT 007 S²N²P²I²A²E²H 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP 009 BDW.O >CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR EACH ROW CALLING 'TRIGTEST'; Unable to locate trigger program "BDW.O/TRIGTEST". > -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
Has to be globally cataloged. And there's a prescribed list of args. There are some 'best practices' i can pass on to you when im at a fullsize keyboard if you'd like. (Allen - Sent from my paperweight) On Jan 25, 2013, at 4:33 PM, Bobby Worley wrote: > I'm up against a wall here - trying to use triggers for the first time, on > Universe. Can't seem to get my test to work - > > Universe on AIX: > > RELLEVEL > 001 X > 002 11.1.9 > 003 PICK > 004 PICK.FORMAT > 005 11.1.9 > >> BASIC BDW TRIGTEST > Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' > * > > Compilation Complete. > >> CATALOG BDW TRIGTEST > "TRIGTEST" cataloged. > >> .L TRIGTEST > > TRIGTEST > 001 V > 002 BDW.O/TRIGTEST > 003 B > 004 BNP > 005 > 006 PICK.FORMAT > 007 S²N²P²I²A²E²H > 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP > 009 BDW.O > > >> CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR > EACH ROW CALLING 'TRIGTEST'; > Unable to locate trigger program "BDW.O/TRIGTEST". > > > -- > > > > *Bobby D. Worley* > > IT Applications Developer > > Coburn Supply Company > > o: 903.753.8613 | m: 214.676.9825 > > bwor...@coburns.com > > ** ** > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers AND Q Pointers....[solved]
never mind...it turned out the trigger called a subroutine, which opened a file, which wasn't defined in the other account Once I created a Q pointer for that file, the trigger ran fine. George > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of George Gallen > Sent: Thursday, August 20, 2009 3:48 PM > To: U2 Users List > Subject: [U2] Triggers AND Q Pointers > > ok. not sure what is happeneing, except the trigger fails. > It has been working great when changes are made from the same account, > But if I attempt to make a change from another account that uses a q > ponter >to that file, the trigger fails. > > I'm guessing, that it's because you need a filename and location, so I > gave the > complete filename in the VOC entry in the other account for N&ABTP and > NABTP > F > /unix/location/N&ABTP > /unix/location/D_N&ABTP > > I can view the data, but If I change the data (activating the trigger) > I get: > : FI > Program "ED": pc = 726C, Trigger program "*TRIGGER_EMAIL" did not > complete. > Program "ED": pc = 726C, Error performing trigger for "/data2/CBS- > BLUE/N&ABTP". > Failed to file "000247" in file "NABTP". STATUS = -1 > > This is on UV 10 / unix > > George Gallen > Senior Programmer/Analyst > Accounting/Data Division, EDI Administrator > ggal...@wyanokegroup.com > ph:856.848.9005 Ext 220 > The Wyanoke Group > http://www.wyanokegroup.com > > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers and Account Copy
Sorry I forgot to mention - you should only need to edit the header when the files need to be fnuxi'd (in our case, the source db is AIX and target is Linux). The "end" changes and you can't fnuxi a file with triggers on them. Otherwise, if you don't have to fnuxi between source & target, it should just be a simple copy and restore without dropping the triggers. Stuart Boydell From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Tuesday, 2 June 2009 13:09 To: U2 Users List Subject: Re: [U2] Triggers and Account Copy ...if it's a 24/7 file (ie you can't drop the trigger as it would compromise data integrity) you can edit the file header once it has been restored. It's fiddly but possible. We do it this way when using a snap copy of the production database. Stuart Boydell From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Jenkins Sent: Tuesday, 2 June 2009 07:23 To: 'U2 Users List' Subject: Re: [U2] Triggers and Account Copy If you are using uvbackup / uvrestore drop the triggers first. Regards JayJay From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: 01 June 2009 20:19 To: U2 Users List Subject: [U2] Triggers and Account Copy Uv 10.2 RH I need to copy a "live" account to a "test" account (i.e. cp -r live test), but the live account has Triggers setup on several files. Should I drop these triggers before copying? Or can they be left alone and work in the new account just fine? I know indexes require some cleanup after the copy, just never had to deal with triggers before. TIA, Mark ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers and Account Copy
Thanks Shaun. Yes, the triggers are simple "audits". I'll go ahead and do the cp, and then review everything is working. Mark -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of shaun.fergu...@ferguson.com Sent: Tuesday, June 02, 2009 6:49 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Triggers and Account Copy Triggers on files usually call subroutines that do something, update an audit file or check for consistency or add an item to a queue, for example. As long as the trigger subroutines are accessing local files in the test environment and the main trigger subroutines are cataloged globally, you should be fine. You can substitute any other called subroutines within the main subroutine locally and make them 'stub' programs if necessary. There is no reason to remove the triggers on the files with a plain 'cp' command. Just make sure that the subroutines are not updating production data anywhere and that all file opens are to local files in your test environment. Shaun Ferguson Master Data Systems Analyst/Global Business Applications Wolseley plc - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers and Account Copy
Triggers on files usually call subroutines that do something, update an audit file or check for consistency or add an item to a queue, for example. As long as the trigger subroutines are accessing local files in the test environment and the main trigger subroutines are cataloged globally, you should be fine. You can substitute any other called subroutines within the main subroutine locally and make them 'stub' programs if necessary. There is no reason to remove the triggers on the files with a plain 'cp' command. Just make sure that the subroutines are not updating production data anywhere and that all file opens are to local files in your test environment. Shaun Ferguson Master Data Systems Analyst/Global Business Applications Wolseley plc - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers and Account Copy
Mark Eastwood wrote: Exactly, dropping the triggers is something I’d like to avoid. I’d much rather copy and then “fix” in the new account. I was hoping there were commands to facilitate (similar to SET.INDEX for Indexes). Remember that the logic you put in the DELETE or UPDATE trigger is arbitrary, so it would be difficult to have a general "Rebuild" ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers and Account Copy
Exactly, dropping the triggers is something I'd like to avoid. I'd much rather copy and then "fix" in the new account. I was hoping there were commands to facilitate (similar to SET.INDEX for Indexes). Thanks, Mark From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Monday, June 01, 2009 8:09 PM To: U2 Users List Subject: Re: [U2] Triggers and Account Copy ...if it's a 24/7 file (ie you can't drop the trigger as it would compromise data integrity) you can edit the file header once it has been restored. It's fiddly but possible. We do it this way when using a snap copy of the production database. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers and Account Copy
...if it's a 24/7 file (ie you can't drop the trigger as it would compromise data integrity) you can edit the file header once it has been restored. It's fiddly but possible. We do it this way when using a snap copy of the production database. Stuart Boydell From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Jenkins Sent: Tuesday, 2 June 2009 07:23 To: 'U2 Users List' Subject: Re: [U2] Triggers and Account Copy If you are using uvbackup / uvrestore drop the triggers first. Regards JayJay From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: 01 June 2009 20:19 To: U2 Users List Subject: [U2] Triggers and Account Copy Uv 10.2 RH I need to copy a "live" account to a "test" account (i.e. cp -r live test), but the live account has Triggers setup on several files. Should I drop these triggers before copying? Or can they be left alone and work in the new account just fine? I know indexes require some cleanup after the copy, just never had to deal with triggers before. TIA, Mark ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers and Account Copy
Mark, UV stores the location of the index(es) in the file header, so your "test" files would still point back to the original indexes, and potentially corrupt them as you changed the test data. The SET.INDEX verb allows you to view/update the index location path. I think you should be able to use it on your test data after the cp. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 On Mon, Jun 1, 2009 at 12:18 PM, Mark Eastwood wrote: > Uv 10.2 RH > > I need to copy a “live” account to a “test” account (i.e. cp –r live test), > but the live account has Triggers setup on several files. Should I drop > these triggers before copying? Or can they be left alone and work in the > new account just fine? > > I know indexes require some cleanup after the copy, just never had to deal > with triggers before. > > > > TIA, > > Mark > > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers and Account Copy
If you are using uvbackup / uvrestore drop the triggers first. Regards JayJay From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: 01 June 2009 20:19 To: U2 Users List Subject: [U2] Triggers and Account Copy Uv 10.2 RH I need to copy a "live" account to a "test" account (i.e. cp -r live test), but the live account has Triggers setup on several files. Should I drop these triggers before copying? Or can they be left alone and work in the new account just fine? I know indexes require some cleanup after the copy, just never had to deal with triggers before. TIA, Mark ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] Triggers on PICK flavor of UV
We use triggers UV w/Pick flavor and they work fine. Just some issues when you need to drop the trigger after moving the file. Horacio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Thursday, November 20, 2008 8:21 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Triggers on PICK flavor of UV Which version of UV? Triggers have only recently worked on UV files. They used to only work on SQL-ized files. If you're not using SQL and haven't upgraded recently you may be on a version that's too old to support them. (And is HTTEST a type 1/19? No triggers on them ...) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Dallaire Sent: 20 November 2008 15:59 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers on PICK flavor of UV Tom, Yes they are, we use them in our Pick UniVerse system. Mike Michael Dallaire Senior Applications Developer IBM Certified Solutions Expert Mortgage Builder Software, Inc. [EMAIL PROTECTED] Main: 800.850.8060 ext. 103 Fax:248.304.0601 www.mortgagebuilder.com Help Desk198 Confidentiality Notice This transmission may contain confidential information which is intended for the exclusive use of the intended recipient. Any disclosure, copying, distribution or use of the contents by anyone other than the intended recipient is strictly prohibited. If received in error, please reply to the sender immediately -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Thursday, November 20, 2008 10:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers on PICK flavor of UV Does anyone know if Triggers are supported under the PICK flavor of UniVerse. >CREATE TRIGGER UPCASE BEFORE INSERT OR UPDATE ON HTTEST CALLING UPCASE.IT; Statement triggers are not supported. If they are not, does anyone know a cleaver way around it other than writing your own? Thanks in advance Tom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers on PICK flavor of UV
Which version of UV? Triggers have only recently worked on UV files. They used to only work on SQL-ized files. If you're not using SQL and haven't upgraded recently you may be on a version that's too old to support them. (And is HTTEST a type 1/19? No triggers on them ...) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Dallaire Sent: 20 November 2008 15:59 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers on PICK flavor of UV Tom, Yes they are, we use them in our Pick UniVerse system. Mike Michael Dallaire Senior Applications Developer IBM Certified Solutions Expert Mortgage Builder Software, Inc. [EMAIL PROTECTED] Main: 800.850.8060 ext. 103 Fax:248.304.0601 www.mortgagebuilder.com Help Desk198 Confidentiality Notice This transmission may contain confidential information which is intended for the exclusive use of the intended recipient. Any disclosure, copying, distribution or use of the contents by anyone other than the intended recipient is strictly prohibited. If received in error, please reply to the sender immediately -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Thursday, November 20, 2008 10:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers on PICK flavor of UV Does anyone know if Triggers are supported under the PICK flavor of UniVerse. >CREATE TRIGGER UPCASE BEFORE INSERT OR UPDATE ON HTTEST CALLING UPCASE.IT; Statement triggers are not supported. If they are not, does anyone know a cleaver way around it other than writing your own? Thanks in advance Tom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers on PICK flavor of UV
John, thanks it was the ON EACH ROW that I was missing. It works now, thanks again Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of john reid Sent: Thursday, November 20, 2008 10:11 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Triggers on PICK flavor of UV i get the same error, unless i use 'FOR EACH ROW CALLING' rather than 'CALLING'. Also, the 'called' trigger needs to be globally cataloged, ie '*UPCASE.IT' j On Thu, Nov 20, 2008 at 10:31 AM, Tom Dodds <[EMAIL PROTECTED]> wrote: > Does anyone know if Triggers are supported under the PICK flavor of > UniVerse. > > > >>CREATE TRIGGER UPCASE BEFORE INSERT OR UPDATE ON HTTEST CALLING UPCASE.IT; > > Statement triggers are not supported. > > > > If they are not, does anyone know a cleaver way around it other than > writing your own? > > > > Thanks in advance > > > > Tom > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3627 (20081120) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers on PICK flavor of UV
Thanks, now I have to go look further. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Dallaire Sent: Thursday, November 20, 2008 9:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers on PICK flavor of UV Tom, Yes they are, we use them in our Pick UniVerse system. Mike Michael Dallaire Senior Applications Developer IBM Certified Solutions Expert Mortgage Builder Software, Inc. [EMAIL PROTECTED] Main: 800.850.8060 ext. 103 Fax:248.304.0601 www.mortgagebuilder.com Help Desk198 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers on PICK flavor of UV
Hi, Yes, it run under PICK flavor, A trigger is not linked to the flavor of the current VOC, it is a definition into the header of the file. A subroutine is always executed into his compilation's flavor (from VOC wehre BASICed or $OPTIONS in source) Under PICK Flavor you must create a CATALOG verb to global catalog your Trigger subroutines. CATALOG 001 V 002 CATALOG 003 I 004 BDGZ 005 catalog 006 PICK.FORMAT CATALOGI 001 V 002 CATALOG 003 I 004 BDGZ 005 catalog 006 INFORMATION.FORMAT Then, compile your routine BASIC BP mytrigger Then, global catalog your routine CATALOGI BP *mytrigger mytrigger Then you can fix it to a file CREATE TRIGGER MYTRIGGER BEFORE INSERT OR UPDATE ON file FOR EACH ROW CALLING "*mytrigger"; My two pence. Manu > -Message d'origine- > De : [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] De la part de Tom Dodds > Envoyi : jeudi 20 novembre 2008 16:31 > @ : u2-users@listserver.u2ug.org > Objet : [U2] Triggers on PICK flavor of UV > > Does anyone know if Triggers are supported under the PICK flavor of > UniVerse. > > > > >CREATE TRIGGER UPCASE BEFORE INSERT OR UPDATE ON HTTEST CALLING > UPCASE.IT; > > Statement triggers are not supported. > > > > If they are not, does anyone know a cleaver way around it other than > writing your own? > > > > Thanks in advance > > > > Tom > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers on PICK flavor of UV
Yes, at least on 10.1 they are. Which UV Release are you running? Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Thursday, November 20, 2008 8:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers on PICK flavor of UV Does anyone know if Triggers are supported under the PICK flavor of UniVerse. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers on PICK flavor of UV
i get the same error, unless i use 'FOR EACH ROW CALLING' rather than 'CALLING'. Also, the 'called' trigger needs to be globally cataloged, ie '*UPCASE.IT' j On Thu, Nov 20, 2008 at 10:31 AM, Tom Dodds <[EMAIL PROTECTED]> wrote: > Does anyone know if Triggers are supported under the PICK flavor of > UniVerse. > > > >>CREATE TRIGGER UPCASE BEFORE INSERT OR UPDATE ON HTTEST CALLING UPCASE.IT; > > Statement triggers are not supported. > > > > If they are not, does anyone know a cleaver way around it other than > writing your own? > > > > Thanks in advance > > > > Tom > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers on PICK flavor of UV
Tom, Yes they are, we use them in our Pick UniVerse system. Mike Michael Dallaire Senior Applications Developer IBM Certified Solutions Expert Mortgage Builder Software, Inc. [EMAIL PROTECTED] Main: 800.850.8060 ext. 103 Fax:248.304.0601 www.mortgagebuilder.com Help Desk198 Confidentiality Notice This transmission may contain confidential information which is intended for the exclusive use of the intended recipient. Any disclosure, copying, distribution or use of the contents by anyone other than the intended recipient is strictly prohibited. If received in error, please reply to the sender immediately -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Thursday, November 20, 2008 10:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers on PICK flavor of UV Does anyone know if Triggers are supported under the PICK flavor of UniVerse. >CREATE TRIGGER UPCASE BEFORE INSERT OR UPDATE ON HTTEST CALLING UPCASE.IT; Statement triggers are not supported. If they are not, does anyone know a cleaver way around it other than writing your own? Thanks in advance Tom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers on a NFS file?
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Martin Phillips > Sent: Friday, October 24, 2008 1:18 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Triggers on a NFS file? > > Hi George, > > > If I have a NFS mounted directory (on a third non-UV system) > > which houses a UV format file. > > > > I have (2) linux system that have that directory mounted, which > > each have UV that have a VOC pointer to that file. <1>F , > > <2> /mnt/directory/filename , > > <3> /mnt/directory/D_filename > > > > Both UV systems can read/write to this file, but only one system > > will be writing to the file, the other will only be > reading.I realize > > locking is not respected from one system to another. > > Be careful! I have seen (and repaired) files that have been > damaged in > broadly similar situation. > > As you say, the locking system will not work as the file is > being accessed > by two completely independent UV systems. The problem that > you may have is > not with record locking but with group locking that protects > the internal > structure of the file. Even with only one system writing, it > is possible > (likely?) that there will be times when the system doing the > reading will > access a group at the same moment that the other system is > modifying an > overflow chain. We run into similar timing issues with trading partners when exchanging data via ftp, although this doesn't involve UV hashed files. The issue is similar, though, in that one side needs to know for sure that the other has finished writing before it begins reading to avoid data loss. One way we handle this is by having the writing machine write a file with the same name and a ".done" extension appended to the end when it is done updating. The writing machine will not attempt to do any further writing to that file as long as the ".done" file exists. The reading machine will wait until it sees the ".done" file before it begins reading, and will delete the ".done" file when it's finished. I think that might also work in this scenario. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers on a NFS file?
The NFS mount is actually set to ro (read only), so I wouldn't think (not to be read as it couldn't happen) the files would get corrupted. Stranger UV things have happened. The file itself is not on a UV system. What I did was a CREATE-FILE then copied the file to the shared directory. Then I did a DELETE-FILE so it was no longer in the original UV's systems linkages. Now the only reference is via a VOC remote pointer. I will have to play around with this (Warnings taken, not lightly). Thanks for the info. George > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Martin Phillips > Sent: Friday, October 24, 2008 5:05 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] RE: Triggers on a NFS file? > > > UV introduced the ALLOWNFS configuration option long ago with > a default > setting of 0 (no). When I deliver UV training, I take great care to > emphasise that setting this to 1 (yes) also means "it's all > my fault if the > file gets corrupted". > > > Martin Phillips --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers on a NFS file?
Hi George, If I have a NFS mounted directory (on a third non-UV system) which houses a UV format file. I have (2) linux system that have that directory mounted, which each have UV that have a VOC pointer to that file. <1>F , <2> /mnt/directory/filename , <3> /mnt/directory/D_filename Both UV systems can read/write to this file, but only one system will be writing to the file, the other will only be reading.I realize locking is not respected from one system to another. Be careful! I have seen (and repaired) files that have been damaged in broadly similar situation. As you say, the locking system will not work as the file is being accessed by two completely independent UV systems. The problem that you may have is not with record locking but with group locking that protects the internal structure of the file. Even with only one system writing, it is possible (likely?) that there will be times when the system doing the reading will access a group at the same moment that the other system is modifying an overflow chain. If I defined a trigger on this file on the system that will only be doing the reading, will it detect any changes to the file when the other UV makes changes? No. Triggers are fired somewhere deep in the UV file system. There is no way in which one system can know about changes applied by the other system. Even with uv/net to avoid the locking problems, the triggers are not going to get run on both systems for an update. Basically System1 will be making changes to that file. And System2 will need to update on it's system based on those changes. Sounds like you need to investigate data replication, changing the network structure if necessary. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers on a NFS file?
We run on Unidata 7.x on both Windows, HP/UX and AIX We use FX pointers and NFA to read and write to files on two physically separate systems. Nicholas M Gettino | Director of Development | EnRoute Emergency Systems, an Infor company | office: 813-207-6998 | fax: 678-393-5389 [EMAIL PROTECTED] | www.enroute911.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, October 23, 2008 5:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers on a NFS file? If I have a NFS mounted directory (on a third non-UV system) which houses a UV format file. I have (2) linux system that have that directory mounted, which each have UV that have a VOC pointer to that file. <1>F , <2> /mnt/directory/filename , <3> /mnt/directory/D_filename Both UV systems can read/write to this file, but only one system will be writing to the file, the other will only be reading.I realize locking is not respected from one system to another. If I defined a trigger on this file on the system that will only be doing the reading, will it detect any changes to the file when the other UV makes changes? Basically System1 will be making changes to that file. And System2 will need to update on it's system based on those changes. The reason I'm using NFS is that the two UV systems can't interact easily because they are on different networks, but both have access to the system which is exporting the UV formatted file. George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.9005 Ext 220 > The Wyanoke Group http://www.wyanokegroup.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Thank you everybody for your suggestions. My testing has been successful. My stumbling block came with global cataloging. Our ERP is set up in Pick flavor (or flavour depending on where you are from), which doesn't really support global cataloging. What I did was to create a synonym CATALOG command called CATALOG.INFO to be used for cataloging the subroutine using the Information catalog format (suggested by Terry at Strategy 7). Now the problem is adequate tools to test with the ERP database. Our test system is UV 10.0.14 which apparently does not support Triggers (Production is on 10.2.4) With 2000+ users, I am a little apprehensive to implement it cold over night (although my test scenarios on independent files worked fine). What's the worst, I try it, it doesn't work and I look for a new job Also, very nice article Brian. Thanks again. Vance Alspach John Deere Landscapes (248) 588-2100 ext 360 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, August 28, 2008 9:25 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Triggers Another resource is Brian Leach's article on UniVerse triggers on page 12 of the Nov/Dec 2007 issue of International Spectrum magazine. The issue can be downloaded from: http://www.intl-spectrum.com/mag/NOVDEC.2007/default.aspx Regards, Clif CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
Another resource is Brian Leach's article on UniVerse triggers on page 12 of the Nov/Dec 2007 issue of International Spectrum magazine. The issue can be downloaded from: http://www.intl-spectrum.com/mag/NOVDEC.2007/default.aspx Regards, Clif On Aug 28, 2008, at 5:24 PM, Anthony Caufield wrote: Clif, You are very correct I use a few of them on several files for auditing of my universe files. It was tough for me as well to find but then I found it they are the same commands whether its SQL tables or universe files. Make sure nobody has the file open when you create them thou. Tony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, August 28, 2008 4:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Triggers Chapter 5 of the 10.2 SQL Reference manual is correct. The file does not have to be SQLized, but you still have to use valid SQL syntax for the TCL commands used to CREATE and DROP them, ie., ' for literals (not ") and you must end the command with a semi-colon (;). Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com The information in the System Description manual is inaccurate. On Aug 27, 2008, at 8:32 AM, Tom Dodds wrote: Universe SQL Reference if I remember correctly. HTH Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alspach, Vance Sent: Wednesday, August 27, 2008 8:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers What manual contains information on creating Universe triggers for non-SQLized files? I cannot seem to find it in any manual UV 10.2.4 Pick format IBM RS6000 Vance Alspach CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3392 (20080827) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Clif, You are very correct I use a few of them on several files for auditing of my universe files. It was tough for me as well to find but then I found it they are the same commands whether its SQL tables or universe files. Make sure nobody has the file open when you create them thou. Tony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, August 28, 2008 4:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Triggers Chapter 5 of the 10.2 SQL Reference manual is correct. The file does not have to be SQLized, but you still have to use valid SQL syntax for the TCL commands used to CREATE and DROP them, ie., ' for literals (not ") and you must end the command with a semi-colon (;). Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com The information in the System Description manual is inaccurate. On Aug 27, 2008, at 8:32 AM, Tom Dodds wrote: > Universe SQL Reference if I remember correctly. > > HTH > > Tom Dodds > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Alspach, > Vance > Sent: Wednesday, August 27, 2008 8:54 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] Triggers > > What manual contains information on creating Universe triggers for > non-SQLized > files? I cannot seem to find it in any manual > > UV 10.2.4 Pick format > IBM RS6000 > > Vance Alspach > > > > CONFIDENTIALITY. This electronic mail and any files transmitted > with it may > contain information proprietary to Deere & Company, or one of its > subsidiaries > or affiliates, and are intended solely for the use of the > individual or > entity > to whom they are addressed, shall be maintained in confidence and not > disclosed to third parties without the written consent of the > sender. If you > are not the intended recipient or the person responsible for > delivering the > electronic mail to the intended recipient, be advised that you have > received > this electronic mail in error and that any use, dissemination, > forwarding, > printing, or copying of this electronic mail is strictly > prohibited. If you > have received this electronic mail in error, please immediately > notify the > sender by return mail. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > > __ Information from ESET NOD32 Antivirus, version of virus > signature > database 3392 (20080827) __ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
Chapter 5 of the 10.2 SQL Reference manual is correct. The file does not have to be SQLized, but you still have to use valid SQL syntax for the TCL commands used to CREATE and DROP them, ie., ' for literals (not ") and you must end the command with a semi-colon (;). Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com The information in the System Description manual is inaccurate. On Aug 27, 2008, at 8:32 AM, Tom Dodds wrote: Universe SQL Reference if I remember correctly. HTH Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alspach, Vance Sent: Wednesday, August 27, 2008 8:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers What manual contains information on creating Universe triggers for non-SQLized files? I cannot seem to find it in any manual UV 10.2.4 Pick format IBM RS6000 Vance Alspach CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3392 (20080827) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
On my Uv/NT 10.2 file triggers are documented in the System Description Manual. Try the following link. http://www-01.ibm.com/software/data/u2/pubs/library/102univ/ Ron White -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alspach, Vance Sent: Wednesday, August 27, 2008 8:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers What manual contains information on creating Universe triggers for non-SQLized files? I cannot seem to find it in any manual UV 10.2.4 Pick format IBM RS6000 Vance Alspach CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Universe SQL Reference if I remember correctly. HTH Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alspach, Vance Sent: Wednesday, August 27, 2008 8:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers What manual contains information on creating Universe triggers for non-SQLized files? I cannot seem to find it in any manual UV 10.2.4 Pick format IBM RS6000 Vance Alspach CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3392 (20080827) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Hi Vance, None indeed. But triggers work on files too. Christian -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Alspach, Vance Envoyi : mercredi 27 ao{t 2008 15:54 @ : u2-users@listserver.u2ug.org Objet : [U2] Triggers What manual contains information on creating Universe triggers for non-SQLized files? I cannot seem to find it in any manual UV 10.2.4 Pick format IBM RS6000 Vance Alspach CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
The work-around that I use (I wonder if there is an easier way to do this?) for non-SQL'd files is: 1. Create your trigger code (update your audit file, verify authorized user, whatever) as an I-type. Have it return a null. 2. Create a NO.NULLS index on the I-type. This will cause the I-type to be called whenever a record is created/deleted/updated in your file. The code in your I-type will be executed, but because the index is NO.NULLS and you are returning null, no actual index updates take place. Below is an example of a trigger I use to track changes to a file. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 SUBROUTINE SAVE.CHANGES.ENVC(ANS,REC,ID) * track changes to the ENVC file * 08-12-04 asb * This subroutine is called from the 'TRIGGER' I-Type in dict ENVC. * A secondary index on ENVC is defined on 'TRIGGER' using the NO.NULLS option. * That forces this subroutine to be called twice when an ENVC record is updated: * the first time with REC = the original record, then again with REC = the new * record (however, if the ENVC record is new, this subroutine is called only once). INCLUDE INC EQU.CHANGES COMMON /SAVE.CHANGES.ENVC/ CHANGES,DICT.CHANGES,OLD.REC,ID2 ANS = "" IF ASSIGNED(CHANGES) ELSE OPEN "ENVC.CHANGES" TO CHANGES ELSE OPEN "MD" TO MD ELSE RETURN READ X FROM MD,"ENVC.CHANGES" THEN RETURN Q = "Q" Q<2> = "xxx" Q<3> = "ENVC.CHANGES" wRITE Q ON MD,"ENVC.CHANGES" OPEN "ENVC.CHANGES" TO CHANGES ELSE RETURN END OPEN "DICT ENVC.CHANGES" TO DICT.CHANGES ELSE RETURN OLD.REC = "" ID2 = "[EMAIL PROTECTED]&*" END * This indexed trigger sub is only called once when filing a new record, so we need * to handle the case of filing a new record, then immediately editing it: IF REC EQ OLD.REC THEN ID2 = ID RETURN END IF ID2 NE ID THEN * first time @record = old rec OLD.REC = REC ID2 = ID RETURN END ELSE * 2nd time @record = new rec NEW.REC = REC ID2 = "[EMAIL PROTECTED]&*" END IF OLD.REC EQ NEW.REC THEN RETURN * * Run MAKE.FIELDS.ARRAY on ENVC and merge in the * ENVC.FIELDS.ARRAY here, then comment out the fields * you don't want to track changes for. Do not $include the * item, or else your commented out fields may get stepped * on if MAKE.FIELDS.ARRAY is run again. * *** * MAKE.FIELDS.ARRAY for file ENVC as of 12-27-07 asb * MAXFIELDS = 168 DIM FIELDNAMES(168) ; DIM CONVS(168) MAT FIELDNAMES = "" ; MAT CONVS = "" FIELDNAMES(1) = "LINE.IDS" FIELDNAMES(2) = "PRV.TIN" FIELDNAMES(3) = "PRV.NAME" FIELDNAMES(4) = "PRV.SORTKEY" FIELDNAMES(5) = "PRV.ADDRESS" FIELDNAMES(6) = "PRV.CITY" FIELDNAMES(7) = "PRV.ST" FIELDNAMES(8) = "PRV.ZIP" FIELDNAMES(9) = "FAM.SSN" FIELDNAMES(10) = "FAM.NAME" FIELDNAMES(11) = "FAM.ADDRESS" FIELDNAMES(12) = "FAM.CITY" FIELDNAMES(13) = "FAM.ST" FIELDNAMES(14) = "FAM.ZIP" FIELDNAMES(15) = "FAM.DOB" ; CONVS(15) = "D4-" FIELDNAMES(16) = "PAT.NUM" FIELDNAMES(17) = "PAT.NAME" FIELDNAMES(18) = "PAT.DOB" ; CONVS(18) = "D4-" FIELDNAMES(19) = "PAT.ADDRESS" FIELDNAMES(20) = "PAT.REL" FIELDNAMES(21) = "PAT.NOTES" FIELDNAMES(22) = "PAT.CITY" FIELDNAMES(23) = "FAM.SEX" FIELDNAMES(24) = "PAT.SEX" FIELDNAMES(25) = "FUND" FIELDNAMES(26) = "CLAIM.NO" FIELDNAMES(27) = "ERRMSG" FIELDNAMES(28) = "PAT.SSN" **FIELDNAMES(29) = "DATE" ; CONVS(29) = "D4-" FIELDNAMES(30) = "USER" FIELDNAMES(31) = "DCN" FIELDNAMES(32) = "TYPE" FIELDNAMES(33) = "PRV.REFNUM" FIELDNAMES(34) = "NEWPAT" FIELDNAMES(35) = "HS.ID" FIELDNAMES(36) = "PRV.PHONE" FIELDNAMES(37) = "FAM.PHONE" FIELDNAMES(38) = "PAT.ST" FIELDNAMES(39) = "PAT.ZIP" FIELDNAMES(40) = "PAT.PHONE" FIELDNAMES(41) = "OI.NAME" FIELDNAMES(42) = "OI.ADDRESS" FIELDNAMES(43) = "OI.CITY" FIELDNAMES(44) = "OI.STATE" FIELDNAMES(45) = "OI.ZIP" FIELDNAMES(46) = "OI.PHONE" FIELDNAMES(47) = "OI.DOB" ; CONVS(47) = "D4-" FIELDNAMES(48) = "OI.SEX" FIELDNAMES(49) = "OI.PLAN" FIELDNAMES(50) = "OI.POLICY" FIELDNAMES(51) = "TOT.AMT" ; CONVS(51) = "MR2" FIELDNAMES(52) = "REF.NAME" FIELDNAMES(53) = "REF.PHONE" FIELDNAMES(54) = "REF.PID" FIELDNAMES(55) = "REN.NAME" FIELDNAMES(56) = "REN.ADDRESS" FIELDNAMES(57) = "REN.CITY" FIELDNAMES(58) = "REN.ST" FIELDNAMES(59) = "REN.ZIP" FIELDNAMES(60) = "REN.PID" FIELDNAMES(61) = "FAC.NAME" FIELDNAMES(62) = "FAC.ADDRESS" FIELDNAMES(63) = "FAC.CITY" FIELDNAMES(64) = "FAC.ST" FIELDNAMES(65) = "FAC.ZIP" FIELDNAMES(66) = "LAB.NAME" FIELDNAMES(67) = "ADJ" FIELDNAMES(68) = "PRV.SITE" FIELDNAMES(69) = "PLAN.NAME" FIELDNAMES(70) = "STATUS.CODE" **FIELDNAMES(71) = "STATUS.DATE" ; CONVS(71) = "D4-" **FIELDNAMES(72) = "PAID.AMT" ; CONVS(72) = "MR2," FIELDNAMES(73) = "NEWPRV" **FIELDNAMES(74) = "PAYEE" FIELDNAMES(75) = "PAT.SOF" FIELDNAMES(76) = "PAT.ROI" FIELDNAMES(77) = "PAT.AOB" FIELDNAMES(78) = "PAYER.NAME" FIELDNAMES(79) = "PRV.TS" FIELDNAMES(80) = "PRV.TYPE
Re: [U2] Triggers
Tried it... works. j On 12/1/06, Clifton Oliver <[EMAIL PROTECTED]> wrote: I've not tried it, but triggers should work on a dictionary. I am assuming that is what you meant, not work on a directory level that has a type 18 dictionary. Gordon J Glorfield wrote: > But would triggers work on a dictionary that was created as a type 18 > file? All of our files are created with type 18 dictionaries. > > > Gordon J. Glorfield > Sr. Applications Developer > UnitedHealthcare's Mid-Atlantic Health Plans > 301-360-8839 > > [EMAIL PROTECTED] wrote on 11/28/2006 04:10:13 PM: > > >> That is correct. The trigger information is stored in the file header in >> what is called a SICA block. Since type 1 & 19 "files" are really >> directories, they do not have a file header, thus, no place to store the >> trigger information. >> > > >> BTW, the same goes for transaction logging and directories. >> > > >> -- >> > > >> Regards, >> > > >> Clif >> > [SNIP] > > > This e-mail, including attachments, may include confidential and/or > proprietary information, and may be used only by the person or entity to > which it is addressed. If the reader of this e-mail is not the intended > recipient or his or her authorized agent, the reader is hereby notified > that any dissemination, distribution or copying of this e-mail is > prohibited. If you have received this e-mail in error, please notify the > sender by replying to this message and delete this e-mail immediately. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
I've not tried it, but triggers should work on a dictionary. I am assuming that is what you meant, not work on a directory level that has a type 18 dictionary. Gordon J Glorfield wrote: > But would triggers work on a dictionary that was created as a type 18 > file? All of our files are created with type 18 dictionaries. > > > Gordon J. Glorfield > Sr. Applications Developer > UnitedHealthcare's Mid-Atlantic Health Plans > 301-360-8839 > > [EMAIL PROTECTED] wrote on 11/28/2006 04:10:13 PM: > > >> That is correct. The trigger information is stored in the file header in >> what is called a SICA block. Since type 1 & 19 "files" are really >> directories, they do not have a file header, thus, no place to store the >> trigger information. >> > > >> BTW, the same goes for transaction logging and directories. >> > > >> -- >> > > >> Regards, >> > > >> Clif >> > [SNIP] > > > This e-mail, including attachments, may include confidential and/or > proprietary information, and may be used only by the person or entity to > which it is addressed. If the reader of this e-mail is not the intended > recipient or his or her authorized agent, the reader is hereby notified > that any dissemination, distribution or copying of this e-mail is > prohibited. If you have received this e-mail in error, please notify the > sender by replying to this message and delete this e-mail immediately. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
But would triggers work on a dictionary that was created as a type 18 file? All of our files are created with type 18 dictionaries. Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 [EMAIL PROTECTED] wrote on 11/28/2006 04:10:13 PM: > That is correct. The trigger information is stored in the file header in > what is called a SICA block. Since type 1 & 19 "files" are really > directories, they do not have a file header, thus, no place to store the > trigger information. > BTW, the same goes for transaction logging and directories. > > -- > Regards, > Clif [SNIP] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
Do triggers work on directories of other databases? - Original Message - From: "phil walker" <[EMAIL PROTECTED]> To: Sent: Tuesday, November 28, 2006 2:52 PM Subject: RE: [U2] Triggers Yeah, that has always bugged me...there is no real reasons for it as far as I can tell. The reasons often put up are: 1. Not able to control operating system level access...so what, we cannot control people usin cp, rm, or mv either, or for that matter a binary editor of some sort. 2. There is no place to put the sica...yes there is, the .Type1 file, or add in a .Type19 file. The beauty with UV is it is flexible to do things, there are lots of things in UV which you shouldn't do, but if you are aware of the constraints and make an informed decision then you can do some really neat things, one of these would be a trigger on a directory Just my 2c... Cheers, Phil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Wednesday, 29 November 2006 9:16 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers But they don't work on directoriesat least that's what I've heard (I'm a Unidata programmer) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward Sent: Tuesday, November 28, 2006 11:34 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers Yes. A number of us are using triggers in UV. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 9:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Yes Triggers work well. You can find the docs in Chapter 5 of the SQL reference manual within UV Docs "SQLREF.PDF" I have a set of pretty simple set trigger programs that I would share. They are too big to send outside of an attachment. So I will send them to you direct. HTH Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 11:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! Pulse para ir al sitio web JesC:s Barbero RodrC-guez Departamento de AnC!lisis y ProgramaciC3n - Desarrollo tecnolC3gico Zoco Gran Santander, 1B* Planta b 39011 PeC1acastillo b Santander b ESPACA Tel.: +34 902 233 323 b Fax: +34 902 234 280 AVISO LEGAL: Este mensaje contiene informaciC3n destinada exclusivamente al usuario de destino, pudiendo contener informaciC3n confidencial o protegida legalmente. Si, por un error de envC-o o transmisiC3n, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningC:n medio . Cualquier opiniC3n en C)l contenida, es exclusiva de su autor y no representa necesariamente la opiniC3n de Quiter Servicios InformC!ticos, S.L. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the authorE=s own and do not necessarily reflect those of Quiter Servicios InformC!ticos, S.L. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
Hm. That seems like a pretty straightforward solution. Did I hear something at the IBM IOD conference in the Futures presentation about adding triggers and/or transaction logging to directories? Or am I mis-remembering things again? :-) Anyone else who attended IOD an may have notes? -- Regards, Clif phil walker wrote: 2. There is no place to put the sica...yes there is, the .Type1 file, or add in a .Type19 file. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
That is correct. The trigger information is stored in the file header in what is called a SICA block. Since type 1 & 19 "files" are really directories, they do not have a file header, thus, no place to store the trigger information. BTW, the same goes for transaction logging and directories. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ Allen E. Elwood wrote: But they don't work on directoriesat least that's what I've heard (I'm a Unidata programmer) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward Sent: Tuesday, November 28, 2006 11:34 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers Yes. A number of us are using triggers in UV. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 9:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Yeah, that has always bugged me...there is no real reasons for it as far as I can tell. The reasons often put up are: 1. Not able to control operating system level access...so what, we cannot control people usin cp, rm, or mv either, or for that matter a binary editor of some sort. 2. There is no place to put the sica...yes there is, the .Type1 file, or add in a .Type19 file. The beauty with UV is it is flexible to do things, there are lots of things in UV which you shouldn't do, but if you are aware of the constraints and make an informed decision then you can do some really neat things, one of these would be a trigger on a directory Just my 2c... Cheers, Phil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Wednesday, 29 November 2006 9:16 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers But they don't work on directoriesat least that's what I've heard (I'm a Unidata programmer) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward Sent: Tuesday, November 28, 2006 11:34 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers Yes. A number of us are using triggers in UV. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 9:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
Alive and well at 10.?. On 11/28/06, chuchi <[EMAIL PROTECTED]> wrote: Hi all!! Someone know if exists triggers in Universe?? Thanks all!! Pulse para ir al sitio web JesC:s Barbero RodrC-guez Departamento de AnC!lisis y ProgramaciC3n - Desarrollo tecnolC3gico Zoco Gran Santander, 1B* Planta b 39011 PeC1acastillo b Santander b ESPACA Tel.: +34 902 233 323 b Fax: +34 902 234 280 AVISO LEGAL: Este mensaje contiene informaciC3n destinada exclusivamente al usuario de destino, pudiendo contener informaciC3n confidencial o protegida legalmente. Si, por un error de envC-o o transmisiC3n, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningC:n medio . Cualquier opiniC3n en C)l contenida, es exclusiva de su autor y no representa necesariamente la opiniC3n de Quiter Servicios InformC!ticos, S.L. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the authorE=s own and do not necessarily reflect those of Quiter Servicios InformC!ticos, S.L. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
But they don't work on directoriesat least that's what I've heard (I'm a Unidata programmer) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward Sent: Tuesday, November 28, 2006 11:34 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers Yes. A number of us are using triggers in UV. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 9:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Yes. A number of us are using triggers in UV. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 9:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Not sure if this is a question? But yes, Triggers have existed in UV for quite some time. Initially against UV SQL tables, but at release 10.x against UV Files too. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Wednesday, 29 November 2006 7:31 a.m. To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! Pulse para ir al sitio web JesC:s Barbero RodrC-guez Departamento de AnC!lisis y ProgramaciC3n - Desarrollo tecnolC3gico Zoco Gran Santander, 1B* Planta b 39011 PeC1acastillo b Santander b ESPACA Tel.: +34 902 233 323 b Fax: +34 902 234 280 AVISO LEGAL: Este mensaje contiene informaciC3n destinada exclusivamente al usuario de destino, pudiendo contener informaciC3n confidencial o protegida legalmente. Si, por un error de envC-o o transmisiC3n, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningC:n medio . Cualquier opiniC3n en C)l contenida, es exclusiva de su autor y no representa necesariamente la opiniC3n de Quiter Servicios InformC!ticos, S.L. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the authorE=s own and do not necessarily reflect those of Quiter Servicios InformC!ticos, S.L. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Yes you can create triggers. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 9:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! Pulse para ir al sitio web JesC:s Barbero RodrC-guez Departamento de AnC!lisis y ProgramaciC3n - Desarrollo tecnolC3gico Zoco Gran Santander, 1B* Planta b 39011 PeC1acastillo b Santander b ESPACA Tel.: +34 902 233 323 b Fax: +34 902 234 280 AVISO LEGAL: Este mensaje contiene informaciC3n destinada exclusivamente al usuario de destino, pudiendo contener informaciC3n confidencial o protegida legalmente. Si, por un error de envC-o o transmisiC3n, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningC:n medio . Cualquier opiniC3n en C)l contenida, es exclusiva de su autor y no representa necesariamente la opiniC3n de Quiter Servicios InformC!ticos, S.L. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the authorE=s own and do not necessarily reflect those of Quiter Servicios InformC!ticos, S.L. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Unfortunately this is the best documentation that I have seen. I received it from David Scoggins via U2_Digest group who got if from Bryan Thorell. I have written several more routines using this as a basis that I could email to you if you like. The list won't accept attachments. Let me know and I will send them to you TRIGGER * The routine called by the trigger process. SUBROUTINE TRIGGER(TRIGGER.NAME, TRIGGER.SCHEMA, TRIGGER.FILE, TRIGGER.EVENT , TRIGGER.TIME, TRIGGER.NEWID, TRIGGER.NEWREC, TRIGGER.OLDID, TRIGGER.OLDREC, T RIGGER.ASSOC, TRIGGER.AEVENT, TRIGGER.COUNT, TRIGGER.CHAIN, TRIGGER.CASCADE) ** WARNING** * This routine must be cataloged globally not locally. * This is accomplished by using the I.CATALOG verb. This verb is present * in both the AAON accounts and in the ON.TEST accounts or it may be * created by coping the CATALOG verb from the voc of the UV account into * the voc of any account changing is's name to I.CATALOG. * Do NOT overwrite the CATALOG verb in the to acount or BAD things will happen * It's syntax is * I.CATALOG -PGM-MODS * .TRIGGER .TRIGGER * It is the * .TRIGGER that makes is globally cataloed. A globally * cataloged program does not need an entry in the VOC file. *** * Generic trigger to log updates to files * 08/23/04 gds - created, from an example by Bryan Thorell * 08/14/04 ttd - received from David Scoggins via U2_Digest group * * Usage notes: * Triggers must be globally cataloged. * Use ICATALOG verb - ICATALOG SRC.BP CDB.T in the RIS account * * To activate the trigger on a file: * CREATE TRIGGER triggername AFTER INSERT OR UPDATE OR DELETE ON filename * FOR EACH ROW CALLING 'CDB.T' * * To deactivate the trigger on a file: * DROP TRIGGER filename triggername * DROP TRIGGER filename ALL - drops all triggers on filename * * Parameter list: * TRIGGER.NAME:name of the trigger * TRIGGER.SCHEMA: name of schema (account) trigger is called from * TRIGGER.FILE:name of file trigger is called on * TRIGGER.EVENT: INSERT, UPDATE or DELETE * TRIGGER.TIME:BEFORE or AFTER * TRIGGER.NEWID: new record ID if event is INSERT or UPDATE * TRIGGER.NEWREC: new record if event is INSERT or UPDATE * TRIGGER.OLDID: old record ID if event is UPDATE or DELETE * TRIGGER.OLDREC: old record if event is UPDATE or DELETE * TRIGGER.ASSOC: name of dynamically normalized association * TRIGGER.AEVENT: event (INSERT, UPDATE or DELETE) on association * TRIGGER.COUNT: number of triggers currently firing * TRIGGER.CHAIN: number of active triggers since last cascade * TRIGGER.CASCADE: cascaded event (UPDATE or DELETE) firing the trigger * EQU DELIM TO '_' * * CRT 'EVENT ':TRIGGER.EVENT * * Create the Log Record R.TRANS = '' ; K.TRANS = '' R.TRANS<1,1> = DATE() R.TRANS<1,2> = TIME() R.TRANS<1,3> = TRIGGER.EVENT R.TRANS<1,4> = @LOGNAME R.TRANS<1,5> = @USER.NO R.TRANS<1,6> = @PATH * * Write the Log Record BEGIN CASE CASE TRIGGER.EVENT EQ 'UPDATE' K.TRANS = TRIGGER.FILE:DELIM:TRIGGER.OLDID:DELIM:R.TRANS K.TRANS<2> = TRIGGER.NEWREC:'~' CASE TRIGGER.EVENT EQ 'INSERT' K.TRANS = TRIGGER.FILE:DELIM:TRIGGER.OLDID:DELIM:R.TRANS K.TRANS<2> = TRIGGER.NEWREC:'~' CASE TRIGGER.EVENT EQ 'DELETE' K.TRANS = TRIGGER.FILE:DELIM:TRIGGER.OLDID:DELIM:R.TRANS:'~' END CASE * CRT 'READY TO WRITE ':R.TRANS * CALL *XML.PARSE(K.TRANS,ERR.REC,FLAG) IF FLAG THEN CRT 'An error was received from the XML.PARSE routine ' CRT ERR.REC END * FINALLY: * RETURN END * Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pamela J Robbins Sent: Tuesday, October 03, 2006 9:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers Does anyone know where I might find good documentation on triggers? I haven't worked with them before and the UniVerse manuals don't have much documentation. -- Pamela J Robbins University of Pennsylvania Sr Programmer/Analyst School of Veterinary Medicine mailto: [EMAIL PROTECTED] New Bolton Center 610-444-5800 610-925-6438 Computer help, ext HELP (4357) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
Hi Look at Universe SQL reference ! CREATE/DROP TRIGGER ... (use the complete syntax even if you don't use SQL Schema or even your file is not a SQL table) LIST.SICA (to look the trigger defn linked to a file) Your file must be fully closed when you create/drop a trigger. Your Subroutine must be global catalogued Don't move at binary level a file with trigger definition. > universe core dump There is a little bug : when you DROP the trigger, the SICA info are not completely clean and you get problems to uvbackup/uvrestore the file. (solver recently 10.1.16) sample subroutine for update log on a file .X 01 CT BP SUBR.TRIGGER.UPDATE SUBROUTINE SUBR.TRIGGER.UPDATE(trigger.name, schema, table, event, time, new.recordID, new.record, old.recordID, old.record, association, association.event, count, chain.cascade, cascade) OPEN "FTRIGGER.UPDATE" TO FILE ON ERROR RETURN ELSE RETURN KEY.TRIGGER = trigger.name KEY.TRIGGER := "_":DATE():"_":TIME() 1 READU REC.TRIGGER FROM FILE,KEY.TRIGGER ON ERROR RETURN LOCKED GOTO 1 THEN REC.TRIGGER<1> = @LOGNAME REC.TRIGGER<2> = @WHO REC.TRIGGER<3> = @SENTENCE REC.TRIGGER<4> = @PARASENTENCE REC.TRIGGER<5> = '' REC.TRIGGER<6> = @TTY:" ":@USERNO REC.TRIGGER<7> = TIMEDATE() REC.TRIGGER<8> = @COMMAND REC.TRIGGER<9> = table REC.TRIGGER<10> = new.recordID REC.TRIGGER<11> = new.record WRITE REC.TRIGGER TO FILE,KEY.TRIGGER ON ERROR RETURN ELSE RETURN RETURN END I hope this help. Manu - Original Message - From: "Pamela J Robbins" <[EMAIL PROTECTED]> To: Sent: Tuesday, October 03, 2006 4:30 PM Subject: [U2] Triggers Does anyone know where I might find good documentation on triggers? I haven't worked with them before and the UniVerse manuals don't have much documentation. -- Pamela J Robbins University of Pennsylvania Sr Programmer/Analyst School of Veterinary Medicine mailto: [EMAIL PROTECTED] New Bolton Center 610-444-5800 610-925-6438 Computer help, ext HELP (4357) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
Maybe/and also on the wiki Ross Ferris Stamina Software Visage an Evolution in Software Development >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald >Sent: Monday, 14 March 2005 7:36 AM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] Triggers docs? > >Ah. I'd forgotten about the filtering. So, Martin, if you get a chance, a >direct email? Thanks. > >...although in this particular instance, I think I've seen enough. >Fortunately, all sanctioned updates occur via a standard update subroutine, >so we'll just go with that. A manager had come across the word "triggers", >so I had to do some due diligence. > >Didn't there used to be a place to contribute and read docs? I poked around >a bit, and didn't find one. > > > > > >"Our greatest duty in this life is to help others. And please, if you can't >help them, could you at least not hurt them?" - H.H. the Dalai Lama >"When buying & selling are controlled by legislation, the first thing to be >bought & sold are the legislators" - P.J. O'Rourke >Dan Fitzgerald > > > > >>From: Moderator <[EMAIL PROTECTED]> >>Reply-To: u2-users@listserver.u2ug.org >>To: u2-users@listserver.u2ug.org >>Subject: Re: [U2] Triggers docs? >>Date: Sun, 13 Mar 2005 14:58:53 -0500 >> >>Dan, >>You won't see an attachment. Our list filters out attachments to >>minimize the risk of virii and trojans. >> >>- Charles Barouch, Moderator >> >>Dan Fitzgerald wrote: >> >>>Martin - I appreciate it, but I didn't see an attachment... >>--- >>u2-users mailing list >>u2-users@listserver.u2ug.org >>To unsubscribe please visit http://listserver.u2ug.org/ >--- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ > > >-- >No virus found in this incoming message. >Checked by AVG Anti-Virus. >Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 > -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers docs?
Ah. I'd forgotten about the filtering. So, Martin, if you get a chance, a direct email? Thanks. ...although in this particular instance, I think I've seen enough. Fortunately, all sanctioned updates occur via a standard update subroutine, so we'll just go with that. A manager had come across the word "triggers", so I had to do some due diligence. Didn't there used to be a place to contribute and read docs? I poked around a bit, and didn't find one. "Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them?" - H.H. the Dalai Lama "When buying & selling are controlled by legislation, the first thing to be bought & sold are the legislators" - P.J. O'Rourke Dan Fitzgerald From: Moderator <[EMAIL PROTECTED]> Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: Re: [U2] Triggers docs? Date: Sun, 13 Mar 2005 14:58:53 -0500 Dan, You won't see an attachment. Our list filters out attachments to minimize the risk of virii and trojans. - Charles Barouch, Moderator Dan Fitzgerald wrote: Martin - I appreciate it, but I didn't see an attachment... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers docs?
Dan, You won't see an attachment. Our list filters out attachments to minimize the risk of virii and trojans. - Charles Barouch, Moderator Dan Fitzgerald wrote: Martin - I appreciate it, but I didn't see an attachment... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
Martin - I appreciate it, but I didn't see an attachment... "Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them?" - H.H. the Dalai Lama "When buying & selling are controlled by legislation, the first thing to be bought & sold are the legislators" - P.J. O'Rourke Dan Fitzgerald From: "Martin Canty" <[EMAIL PROTECTED]> Reply-To: u2-users@listserver.u2ug.org To: Subject: RE: [U2] Triggers docs? Date: Fri, 11 Mar 2005 22:47:35 -0800 Hi Dan, Attached is a document I wrote (for our monthly newsletter) to use triggers. The example is to trap record corruption, there is coding for both UniData & UniVerse. We found the culprit within 10 minutes of implementing the trigger! There is a cost to using triggers though I measured it on UniData 5 & found that an update with a trigger took something like 10 times longer than an index based trigger (though the real trigger is so much more functionally rich!) Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/msword which had a name of U2 Triggers.doc] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
Scott Ballinger wrote: > The trigger is normally called twice: the first time you get the > original @RECORD, the second time the new @RECORD. If an item > is new or > being deleted, then the trigger is called only once. I use > named common > to track of where I am and to save old @RECORD, so that I can test: if > this is not a new item, and old @RECORD is null, then this must be a > delete. Scott said in an earlier post that he was talking about a pseudo-trigger implemented by creating a secondary index on a SUBR I-type. It may well be that such index routines are called twice, but real TRIGGERs aren't. Certainly on UniData they're not. Cheers, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
Hi Dan, Attached is a document I wrote (for our monthly newsletter) to use triggers. The example is to trap record corruption, there is coding for both UniData & UniVerse. We found the culprit within 10 minutes of implementing the trigger! There is a cost to using triggers though I measured it on UniData 5 & found that an update with a trigger took something like 10 times longer than an index based trigger (though the real trigger is so much more functionally rich!) Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/msword which had a name of U2 Triggers.doc] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
I think this must be something to do with why proper triggers impose such a load on a universe system. It has to check for deletes using some internal mechanism. Mind you the replication in Universe imposes very little load and that track deletes as well -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 22:55 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? I should think a little longer before pressing send... It's not that easy to catch a delete using this kind of trigger. You can test for a new record by trying to read it, if it's not there then this is a new update. But since the trigger is called only once for a delete, it gets pretty ugly to trap for this condition. The best answer I can come up with on a Friday afternoon is treat every first pass as a delete, then un-do whatever you did to track the delete on the second pass (if there is one). That is a particularly heinous solution, however. There must be a better way to do this. Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Friday, March 11, 2005 1:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? How do you track a record being deleted from the file though? The real trigger mechanism fires with INSERT, UPDATE or DELETE. If memory serves this type of pseudo-trigger can't differentiate between a delete and an insert/update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 20:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? Here is link that might be helpful: (works for both UV & UD) http://www.mindspring.com/~tpackert/unidata_tricks.htm I have used the index-trigger method to track and record all changes to a file. It seems to work well; 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 was called, and what my RECord variable contained each time. Here is the note at the top of the subroutine regarding this: SUBROUTINE SAVE.CHANGES.MYFILE(ANS,REC,ID) * This subroutine is called from the 'TRIGGER' I-Type in dict MYFILE. * A secondary index on MYFILE is defined on 'TRIGGER' using the NO.NULLS option. * That forces this subroutine to be called twice when a MYFILE record is updated: * the first time with REC = the original record, then again with REC = the new * record (however, if the MYFILE record is new, this subroutine is called only once). Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regula
RE: [U2] Triggers docs?
Must be a Unidata thing. It only gets called once on Universe. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 22:29 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? The trigger is normally called twice: the first time you get the original @RECORD, the second time the new @RECORD. If an item is new or being deleted, then the trigger is called only once. I use named common to track of where I am and to save old @RECORD, so that I can test: if this is not a new item, and old @RECORD is null, then this must be a delete. Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Friday, March 11, 2005 1:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? How do you track a record being deleted from the file though? The real trigger mechanism fires with INSERT, UPDATE or DELETE. If memory serves this type of pseudo-trigger can't differentiate between a delete and an insert/update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 20:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? Here is link that might be helpful: (works for both UV & UD) http://www.mindspring.com/~tpackert/unidata_tricks.htm I have used the index-trigger method to track and record all changes to a file. It seems to work well; 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 was called, and what my RECord variable contained each time. Here is the note at the top of the subroutine regarding this: SUBROUTINE SAVE.CHANGES.MYFILE(ANS,REC,ID) * This subroutine is called from the 'TRIGGER' I-Type in dict MYFILE. * A secondary index on MYFILE is defined on 'TRIGGER' using the NO.NULLS option. * That forces this subroutine to be called twice when a MYFILE record is updated: * the first time with REC = the original record, then again with REC = the new * record (however, if the MYFILE record is new, this subroutine is called only once). Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
I should think a little longer before pressing send... It's not that easy to catch a delete using this kind of trigger. You can test for a new record by trying to read it, if it's not there then this is a new update. But since the trigger is called only once for a delete, it gets pretty ugly to trap for this condition. The best answer I can come up with on a Friday afternoon is treat every first pass as a delete, then un-do whatever you did to track the delete on the second pass (if there is one). That is a particularly heinous solution, however. There must be a better way to do this. Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Friday, March 11, 2005 1:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? How do you track a record being deleted from the file though? The real trigger mechanism fires with INSERT, UPDATE or DELETE. If memory serves this type of pseudo-trigger can't differentiate between a delete and an insert/update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 20:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? Here is link that might be helpful: (works for both UV & UD) http://www.mindspring.com/~tpackert/unidata_tricks.htm I have used the index-trigger method to track and record all changes to a file. It seems to work well; 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 was called, and what my RECord variable contained each time. Here is the note at the top of the subroutine regarding this: SUBROUTINE SAVE.CHANGES.MYFILE(ANS,REC,ID) * This subroutine is called from the 'TRIGGER' I-Type in dict MYFILE. * A secondary index on MYFILE is defined on 'TRIGGER' using the NO.NULLS option. * That forces this subroutine to be called twice when a MYFILE record is updated: * the first time with REC = the original record, then again with REC = the new * record (however, if the MYFILE record is new, this subroutine is called only once). Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
I used the pseudo-trigger method in UV 9.6. Although you cannot tell a DELETE during the trigger firing I did determine the DELETE status during log file processing by doing a read of the file. If no record was found I new it was a deleted record. Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Friday, March 11, 2005 3:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? How do you track a record being deleted from the file though? The real trigger mechanism fires with INSERT, UPDATE or DELETE. If memory serves this type of pseudo-trigger can't differentiate between a delete and an insert/update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 20:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? Here is link that might be helpful: (works for both UV & UD) http://www.mindspring.com/~tpackert/unidata_tricks.htm I have used the index-trigger method to track and record all changes to a file. It seems to work well; 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 was called, and what my RECord variable contained each time. Here is the note at the top of the subroutine regarding this: SUBROUTINE SAVE.CHANGES.MYFILE(ANS,REC,ID) * This subroutine is called from the 'TRIGGER' I-Type in dict MYFILE. * A secondary index on MYFILE is defined on 'TRIGGER' using the NO.NULLS option. * That forces this subroutine to be called twice when a MYFILE record is updated: * the first time with REC = the original record, then again with REC = the new * record (however, if the MYFILE record is new, this subroutine is called only once). Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
The trigger is normally called twice: the first time you get the original @RECORD, the second time the new @RECORD. If an item is new or being deleted, then the trigger is called only once. I use named common to track of where I am and to save old @RECORD, so that I can test: if this is not a new item, and old @RECORD is null, then this must be a delete. Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Friday, March 11, 2005 1:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? How do you track a record being deleted from the file though? The real trigger mechanism fires with INSERT, UPDATE or DELETE. If memory serves this type of pseudo-trigger can't differentiate between a delete and an insert/update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 20:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? Here is link that might be helpful: (works for both UV & UD) http://www.mindspring.com/~tpackert/unidata_tricks.htm I have used the index-trigger method to track and record all changes to a file. It seems to work well; 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 was called, and what my RECord variable contained each time. Here is the note at the top of the subroutine regarding this: SUBROUTINE SAVE.CHANGES.MYFILE(ANS,REC,ID) * This subroutine is called from the 'TRIGGER' I-Type in dict MYFILE. * A secondary index on MYFILE is defined on 'TRIGGER' using the NO.NULLS option. * That forces this subroutine to be called twice when a MYFILE record is updated: * the first time with REC = the original record, then again with REC = the new * record (however, if the MYFILE record is new, this subroutine is called only once). Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
How do you track a record being deleted from the file though? The real trigger mechanism fires with INSERT, UPDATE or DELETE. If memory serves this type of pseudo-trigger can't differentiate between a delete and an insert/update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 20:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? Here is link that might be helpful: (works for both UV & UD) http://www.mindspring.com/~tpackert/unidata_tricks.htm I have used the index-trigger method to track and record all changes to a file. It seems to work well; 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 was called, and what my RECord variable contained each time. Here is the note at the top of the subroutine regarding this: SUBROUTINE SAVE.CHANGES.MYFILE(ANS,REC,ID) * This subroutine is called from the 'TRIGGER' I-Type in dict MYFILE. * A secondary index on MYFILE is defined on 'TRIGGER' using the NO.NULLS option. * That forces this subroutine to be called twice when a MYFILE record is updated: * the first time with REC = the original record, then again with REC = the new * record (however, if the MYFILE record is new, this subroutine is called only once). Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
Here is link that might be helpful: (works for both UV & UD) http://www.mindspring.com/~tpackert/unidata_tricks.htm I have used the index-trigger method to track and record all changes to a file. It seems to work well; 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 was called, and what my RECord variable contained each time. Here is the note at the top of the subroutine regarding this: SUBROUTINE SAVE.CHANGES.MYFILE(ANS,REC,ID) * This subroutine is called from the 'TRIGGER' I-Type in dict MYFILE. * A secondary index on MYFILE is defined on 'TRIGGER' using the NO.NULLS option. * That forces this subroutine to be called twice when a MYFILE record is updated: * the first time with REC = the original record, then again with REC = the new * record (however, if the MYFILE record is new, this subroutine is called only once). Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers docs?
> The manual is a bit skimpy on triggers. Any supplemetal docs around? > > We're trying to track updates to a file; individual items have gone missing > lately. No SQL involvement at all. Sorry, can't comment on Universe. For unidata, here's some brief docs I wrote after digging. I found info in 'Developing UniBasic Applications' A trigger is a piece of code (subroutine) that is executed when one of two things happens: a record is written (updated) or a record is deleted. These two event are separate, that is, the subroutine to execute in each case may be different. Some Unidata trigger commands: LIST.TRIGGER filename CREATE.TRIGGER filename subroutine_name UPDATE CREATE.TRIGGER filename subroutine_name DELETE DELETE.TRIGGER filename UPDATE DELETE.TRIGGER filename DELETE Some trigger notes: 1. Subroutines for triggers must be globally cataloged. That is: :CATALOG subroutine_name 2. Triggers may only be created/manipulated by the owner of the file at the operating system level or have root permissions on UniData. What you use a trigger subroutine to do is up to you. Here's a sample template: SUBROUTINE subroutine_name(X.EXECSTAT,X.DICT,X.FILE,X.ID,X.REC) * * This subroutine MUST BE GLOBALLY CATALOGed! * JVB Jeff Butera * H08 Hampshire College * * EXECSTAT=2 says to allow the record to be written (when we exit * this subroutine) but use the record as in X.REC (ie: we may manipulate * it in this subroutine and it'll use the edited copy, not the original) * X.EXECSTAT=2 After that, you're free to do whatever you like in native Unibasic. The variable X.REC contains the entire record to be written to the database file X.FILE with the ID X.ID. The EXECSTAT variable, when set to 2, allows you to possibly manipulate the record in this subroutine before the record is updated/deleted. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "There are 10 kinds of people in the world: those that understand binary and those that don't."Various --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
Dan, I haven't found any additional documentation but I have come across a serious gotcha. Once you add a trigger to a file it is a SQL file. There is no going back short of creating a new table. This makes it difficult to move data between INDIAN's (sp?). I have been unable, even using FORMAT.CONVERT to move data from an AIX box to Windows. If someone else has managed to get this to work, I'd appreciate the info. Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 12:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
I used this post by Bryan Thorell as a starting point when I set them up for the first time. BTW, Thanks Bryan! http://www.indexinfocus.com/dl/u2list/200210/40372.html > -Original Message- > From: Dan Fitzgerald [mailto:[EMAIL PROTECTED] > Sent: Friday, March 11, 2005 10:15 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] Triggers docs? > > > The manual is a bit skimpy on triggers. Any supplemetal docs around? > > We're trying to track updates to a file; individual items > have gone missing > lately. No SQL involvement at all. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers on UV
On a UV file, you need UV10.x for triggers. Prior to that, you would have to convert your file to a UV SQL table in a UV SQL schema (account) in order to use triggers. This is certainly possible, and I have done just that for clients. But it was rather messy considering the state of their dictionaries, SQL constraint issues, etc. I would recommend upgrading to UV10.1 if at all possible. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Jun 16, 2004, at 13:49, Chuck Mongiovi wrote: Are WRITE & DELETE triggers available on UV 9.5? (or do they start with UV10) -Chuck --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/