Re: [U2] UV Triggers / SQL
I also found that the tablename has to be a type "F" in the VOC, and not a Q pointer At least when setting up the trigger. I'm guessing that if I replaced the Q pointer, with an F and the DICT/FILE names with Absolute file names /directory/tree/D_ and /directory/tree/ I most likely Could set the trigger from whatever account that new F pointer were defined in, even If the file were in another account But it's easier to keep the Q pointer, and define the trigger from the account where The file actually lives! George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, July 25, 2012 5:50 AM To: 'U2 Users List' Subject: Re: [U2] UV Triggers / SQL George Yes, you've been able to do that for some time. It simply adds a SICA block to the file and logs the trigger information in there. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 24 July 2012 20:31 To: U2 Users List Subject: Re: [U2] UV Triggers / SQL First I dropped the schema I setup on that account Then I tried to add a trigger to that fileand it didn't give me any errors. So...I can add triggers to UV files that reside in accounts that are not defined in UV_SCHEMA file? Interesting. George ___ 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] UV Triggers / SQL
George Yes, you've been able to do that for some time. It simply adds a SICA block to the file and logs the trigger information in there. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 24 July 2012 20:31 To: U2 Users List Subject: Re: [U2] UV Triggers / SQL First I dropped the schema I setup on that account Then I tried to add a trigger to that fileand it didn't give me any errors. So...I can add triggers to UV files that reside in accounts that are not defined in UV_SCHEMA file? Interesting. George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Triggers / SQL
First I dropped the schema I setup on that account Then I tried to add a trigger to that fileand it didn't give me any errors. So...I can add triggers to UV files that reside in accounts that are not defined in UV_SCHEMA file? Interesting. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Wasylenko Sent: Tuesday, July 24, 2012 3:04 PM To: U2 Users List Subject: Re: [U2] UV Triggers / SQL LOGTO the account - it'll work there. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, July 24, 2012 2:06 PM To: U2 Users Subject: [U2] UV Triggers / SQL I'm trying to setup a trigger on a UV File. I created the cataloged subroutine, I'm running as user uvsql I type in CREATE TRIGGER name AFTER INSERT ON table FOR EACH ROW CALLING '*subroutine'; And it says it can't find TABLE table I have this account setup in UV_SCHEMA already (for another trigger), And the TABLE table is a Q pointer to another filename, which does not exist in THIS account. Do I need to setup the other account in UV_SCHEMA, and then create the trigger From that account on the file from within the account it resides? ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Triggers / SQL
You don't need a schema... Triggers are allowed w/o schema. It's a pain here too, separate account for DATA / programs... Create a control record of files/triggers/programs etc. Then write a program to perform bulk maintenance. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, July 24, 2012 2:17 PM To: U2 Users List Subject: Re: [U2] UV Triggers / SQL Can I have tables from multiple UV accounts in the same SQL Schema? Or will Have to Maintain multiple Schemas and use the schema.table notation when referring to it? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Wasylenko Sent: Tuesday, July 24, 2012 3:04 PM To: U2 Users List Subject: Re: [U2] UV Triggers / SQL LOGTO the account - it'll work there. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, July 24, 2012 2:06 PM To: U2 Users Subject: [U2] UV Triggers / SQL I'm trying to setup a trigger on a UV File. I created the cataloged subroutine, I'm running as user uvsql I type in CREATE TRIGGER name AFTER INSERT ON table FOR EACH ROW CALLING '*subroutine'; And it says it can't find TABLE table I have this account setup in UV_SCHEMA already (for another trigger), And the TABLE table is a Q pointer to another filename, which does not exist in THIS account. Do I need to setup the other account in UV_SCHEMA, and then create the trigger From that account on the file from within the account it resides? ___ 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 ___ 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] UV Triggers / SQL
Can I have tables from multiple UV accounts in the same SQL Schema? Or will Have to Maintain multiple Schemas and use the schema.table notation when referring to it? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Wasylenko Sent: Tuesday, July 24, 2012 3:04 PM To: U2 Users List Subject: Re: [U2] UV Triggers / SQL LOGTO the account - it'll work there. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, July 24, 2012 2:06 PM To: U2 Users Subject: [U2] UV Triggers / SQL I'm trying to setup a trigger on a UV File. I created the cataloged subroutine, I'm running as user uvsql I type in CREATE TRIGGER name AFTER INSERT ON table FOR EACH ROW CALLING '*subroutine'; And it says it can't find TABLE table I have this account setup in UV_SCHEMA already (for another trigger), And the TABLE table is a Q pointer to another filename, which does not exist in THIS account. Do I need to setup the other account in UV_SCHEMA, and then create the trigger From that account on the file from within the account it resides? ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Triggers / SQL
LOGTO the account - it'll work there. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, July 24, 2012 2:06 PM To: U2 Users Subject: [U2] UV Triggers / SQL I'm trying to setup a trigger on a UV File. I created the cataloged subroutine, I'm running as user uvsql I type in CREATE TRIGGER name AFTER INSERT ON table FOR EACH ROW CALLING '*subroutine'; And it says it can't find TABLE table I have this account setup in UV_SCHEMA already (for another trigger), And the TABLE table is a Q pointer to another filename, which does not exist in THIS account. Do I need to setup the other account in UV_SCHEMA, and then create the trigger From that account on the file from within the account it resides? ___ 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
