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 <bob_woodw...@k2sports.com>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
