Re: [U2] Finding Triggers on files
Oops. :-( I've create a documentation issue to get this resolved in the 7.3.0 manual set. Thanks for pointing this out. Regards, Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Monday, October 10, 2011 3:10 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Finding Triggers on files >From BASR.pdf, UD 7.2: 27 Is the file encrypted? ALL 0 - File is not encrypted 1 - File is encrypted 28 Type of file encryption ALL Returns a dynamic array containing the following information: ? For a file encrypted with the WHOLERECORD option: -1@SM@SM ? For a file encrypted at the field level: @SM@SM@SM ? Returns an empty string if the file is not encrypted. Dean Armbruster System Analyst 757-989-2839 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Finding Triggers on files
Thanks Dean. Haven't used encryption, yet, so I'll just add this to my system notes for now. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Monday, October 10, 2011 2:10 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Finding Triggers on files >From BASR.pdf, UD 7.2: 27 Is the file encrypted? ALL 0 - File is not encrypted 1 - File is encrypted 28 Type of file encryption ALL Returns a dynamic array containing the following information: ? For a file encrypted with the WHOLERECORD option: -1@SM@SM ? For a file encrypted at the field level: @SM@SM@SM ? Returns an empty string if the file is not encrypted. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Monday, October 10, 2011 4:50 PM To: U2 Users List Subject: Re: [U2] Finding Triggers on files I can't find any of them documented. What's 27 and 28 listed as? And thanks for 25 & 26. I've been looking for something like those, which works great! (UD 6.1) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Monday, October 10, 2011 1:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Finding Triggers on files I also find it interesting that it isn't in the UniBasic Commands Reference manual, even though 27 & 28 are there. We saw 25 & 26 in a README for a previous release and have been using it ever since. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, October 10, 2011 4:38 PM To: U2 Users List Subject: Re: [U2] Finding Triggers on files Dean: This is interesting to know! 2 Dev (0)-> BPTEST OPEN '', 'ARTMASTER' TO ARTMASTER ELSE STOP 201, 'ARTMASTER' ; CRT FILEINFO(ARTMASTER, 25) ; CRT FILEINFO(ARTMASTER, 26) ; END Compiling Unibasic: SAVEDLISTS\BpTest_487376561 in mode 'p'. compilation finished U2.MASTER.TRIGGER.U U2.MASTER.TRIGGER.D This isn't in my most recent UD BASIC Reference manual (although 27 & 28 are). Thanks, Bill - Original Message - *From:* FILEINFO > > 25 - Returns update trigger > 26 - Returns delete trigger > > > Dean Armbruster > Information Technology, System Analyst > Ferguson Enterprises, Inc. > 12500 Jefferson Avenue * Newport News * VA * 23602-4314 > T: +1 (757) 989 2839 * F: +1 (757) 989 2801 > www.ferguson.com > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey > Butera > Sent: Monday, October 10, 2011 11:40 AM > To: U2 Users List > Subject: [U2] Finding Triggers on files > > >Unidata 7.2.9 on RedHat > > Is there a programmatic way to determine if a file has a trigger on it? > > I've looked at FILEINFO and it doesn't indicate that any parameter would > > return trigger information. I know I can do something like: > > EXECUTE "LIST.TRIGGER MY_FILE" CAPTURING X.RESULT > > and parse X.RESULT, but was curious if there's a better way. > > I've occasionally been bitten by converting a file from static to > dynamic hashing, losing an update trigger in the process so I want to > write some code to check these and let me know if something's awry. > ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Finding Triggers on files
>From BASR.pdf, UD 7.2: 27 Is the file encrypted? ALL 0 - File is not encrypted 1 - File is encrypted 28 Type of file encryption ALL Returns a dynamic array containing the following information: ? For a file encrypted with the WHOLERECORD option: -1@SM@SM ? For a file encrypted at the field level: @SM@SM@SM ? Returns an empty string if the file is not encrypted. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Monday, October 10, 2011 4:50 PM To: U2 Users List Subject: Re: [U2] Finding Triggers on files I can't find any of them documented. What's 27 and 28 listed as? And thanks for 25 & 26. I've been looking for something like those, which works great! (UD 6.1) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Monday, October 10, 2011 1:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Finding Triggers on files I also find it interesting that it isn't in the UniBasic Commands Reference manual, even though 27 & 28 are there. We saw 25 & 26 in a README for a previous release and have been using it ever since. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, October 10, 2011 4:38 PM To: U2 Users List Subject: Re: [U2] Finding Triggers on files Dean: This is interesting to know! 2 Dev (0)-> BPTEST OPEN '', 'ARTMASTER' TO ARTMASTER ELSE STOP 201, 'ARTMASTER' ; CRT FILEINFO(ARTMASTER, 25) ; CRT FILEINFO(ARTMASTER, 26) ; END Compiling Unibasic: SAVEDLISTS\BpTest_487376561 in mode 'p'. compilation finished U2.MASTER.TRIGGER.U U2.MASTER.TRIGGER.D This isn't in my most recent UD BASIC Reference manual (although 27 & 28 are). Thanks, Bill - Original Message - *From:* FILEINFO > > 25 - Returns update trigger > 26 - Returns delete trigger > > > Dean Armbruster > Information Technology, System Analyst > Ferguson Enterprises, Inc. > 12500 Jefferson Avenue * Newport News * VA * 23602-4314 > T: +1 (757) 989 2839 * F: +1 (757) 989 2801 > www.ferguson.com > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey > Butera > Sent: Monday, October 10, 2011 11:40 AM > To: U2 Users List > Subject: [U2] Finding Triggers on files > > >Unidata 7.2.9 on RedHat > > Is there a programmatic way to determine if a file has a trigger on it? > > I've looked at FILEINFO and it doesn't indicate that any parameter would > > return trigger information. I know I can do something like: > > EXECUTE "LIST.TRIGGER MY_FILE" CAPTURING X.RESULT > > and parse X.RESULT, but was curious if there's a better way. > > I've occasionally been bitten by converting a file from static to > dynamic hashing, losing an update trigger in the process so I want to > write some code to check these and let me know if something's awry. > ___ 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] Finding Triggers on files
I can't find any of them documented. What's 27 and 28 listed as? And thanks for 25 & 26. I've been looking for something like those, which works great! (UD 6.1) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Monday, October 10, 2011 1:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Finding Triggers on files I also find it interesting that it isn't in the UniBasic Commands Reference manual, even though 27 & 28 are there. We saw 25 & 26 in a README for a previous release and have been using it ever since. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, October 10, 2011 4:38 PM To: U2 Users List Subject: Re: [U2] Finding Triggers on files Dean: This is interesting to know! 2 Dev (0)-> BPTEST OPEN '', 'ARTMASTER' TO ARTMASTER ELSE STOP 201, 'ARTMASTER' ; CRT FILEINFO(ARTMASTER, 25) ; CRT FILEINFO(ARTMASTER, 26) ; END Compiling Unibasic: SAVEDLISTS\BpTest_487376561 in mode 'p'. compilation finished U2.MASTER.TRIGGER.U U2.MASTER.TRIGGER.D This isn't in my most recent UD BASIC Reference manual (although 27 & 28 are). Thanks, Bill - Original Message - *From:* FILEINFO > > 25 - Returns update trigger > 26 - Returns delete trigger > > > Dean Armbruster > Information Technology, System Analyst > Ferguson Enterprises, Inc. > 12500 Jefferson Avenue * Newport News * VA * 23602-4314 > T: +1 (757) 989 2839 * F: +1 (757) 989 2801 > www.ferguson.com > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey > Butera > Sent: Monday, October 10, 2011 11:40 AM > To: U2 Users List > Subject: [U2] Finding Triggers on files > > >Unidata 7.2.9 on RedHat > > Is there a programmatic way to determine if a file has a trigger on it? > > I've looked at FILEINFO and it doesn't indicate that any parameter would > > return trigger information. I know I can do something like: > > EXECUTE "LIST.TRIGGER MY_FILE" CAPTURING X.RESULT > > and parse X.RESULT, but was curious if there's a better way. > > I've occasionally been bitten by converting a file from static to > dynamic hashing, losing an update trigger in the process so I want to > write some code to check these and let me know if something's awry. > ___ 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] Finding Triggers on files
I also find it interesting that it isn't in the UniBasic Commands Reference manual, even though 27 & 28 are there. We saw 25 & 26 in a README for a previous release and have been using it ever since. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, October 10, 2011 4:38 PM To: U2 Users List Subject: Re: [U2] Finding Triggers on files Dean: This is interesting to know! 2 Dev (0)-> BPTEST OPEN '', 'ARTMASTER' TO ARTMASTER ELSE STOP 201, 'ARTMASTER' ; CRT FILEINFO(ARTMASTER, 25) ; CRT FILEINFO(ARTMASTER, 26) ; END Compiling Unibasic: SAVEDLISTS\BpTest_487376561 in mode 'p'. compilation finished U2.MASTER.TRIGGER.U U2.MASTER.TRIGGER.D This isn't in my most recent UD BASIC Reference manual (although 27 & 28 are). Thanks, Bill - Original Message - *From:* FILEINFO > > 25 - Returns update trigger > 26 - Returns delete trigger > > > Dean Armbruster > Information Technology, System Analyst > Ferguson Enterprises, Inc. > 12500 Jefferson Avenue * Newport News * VA * 23602-4314 > T: +1 (757) 989 2839 * F: +1 (757) 989 2801 > www.ferguson.com > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey > Butera > Sent: Monday, October 10, 2011 11:40 AM > To: U2 Users List > Subject: [U2] Finding Triggers on files > > >Unidata 7.2.9 on RedHat > > Is there a programmatic way to determine if a file has a trigger on it? > > I've looked at FILEINFO and it doesn't indicate that any parameter would > > return trigger information. I know I can do something like: > > EXECUTE "LIST.TRIGGER MY_FILE" CAPTURING X.RESULT > > and parse X.RESULT, but was curious if there's a better way. > > I've occasionally been bitten by converting a file from static to > dynamic hashing, losing an update trigger in the process so I want to > write some code to check these and let me know if something's awry. > ___ 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] Finding Triggers on files
Dean: This is interesting to know! 2 Dev (0)-> BPTEST OPEN '', 'ARTMASTER' TO ARTMASTER ELSE STOP 201, 'ARTMASTER' ; CRT FILEINFO(ARTMASTER, 25) ; CRT FILEINFO(ARTMASTER, 26) ; END Compiling Unibasic: SAVEDLISTS\BpTest_487376561 in mode 'p'. compilation finished U2.MASTER.TRIGGER.U U2.MASTER.TRIGGER.D This isn't in my most recent UD BASIC Reference manual (although 27 & 28 are). Thanks, Bill - Original Message - *From:* FILEINFO 25 - Returns update trigger 26 - Returns delete trigger Dean Armbruster Information Technology, System Analyst Ferguson Enterprises, Inc. 12500 Jefferson Avenue * Newport News * VA * 23602-4314 T: +1 (757) 989 2839 * F: +1 (757) 989 2801 www.ferguson.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, October 10, 2011 11:40 AM To: U2 Users List Subject: [U2] Finding Triggers on files Unidata 7.2.9 on RedHat Is there a programmatic way to determine if a file has a trigger on it? I've looked at FILEINFO and it doesn't indicate that any parameter would return trigger information. I know I can do something like: EXECUTE "LIST.TRIGGER MY_FILE" CAPTURING X.RESULT and parse X.RESULT, but was curious if there's a better way. I've occasionally been bitten by converting a file from static to dynamic hashing, losing an update trigger in the process so I want to write some code to check these and let me know if something's awry. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Finding Triggers on files
FILEINFO 25 - Returns update trigger 26 - Returns delete trigger Dean Armbruster Information Technology, System Analyst Ferguson Enterprises, Inc. 12500 Jefferson Avenue * Newport News * VA * 23602-4314 T: +1 (757) 989 2839 * F: +1 (757) 989 2801 www.ferguson.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, October 10, 2011 11:40 AM To: U2 Users List Subject: [U2] Finding Triggers on files Unidata 7.2.9 on RedHat Is there a programmatic way to determine if a file has a trigger on it? I've looked at FILEINFO and it doesn't indicate that any parameter would return trigger information. I know I can do something like: EXECUTE "LIST.TRIGGER MY_FILE" CAPTURING X.RESULT and parse X.RESULT, but was curious if there's a better way. I've occasionally been bitten by converting a file from static to dynamic hashing, losing an update trigger in the process so I want to write some code to check these and let me know if something's awry. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 "...we must choose between what is right and what is easy..." Dumbledore ___ 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] Finding Triggers on files
That's the only way we've figured out to do it. Brad. > From: Jeffrey Butera > To: U2 Users List > Date: 10/10/2011 10:39 AM > Subject: [U2] Finding Triggers on files > Sent by: u2-users-boun...@listserver.u2ug.org > > Unidata 7.2.9 on RedHat > > Is there a programmatic way to determine if a file has a trigger on it? > I've looked at FILEINFO and it doesn't indicate that any parameter would > return trigger information. I know I can do something like: > > EXECUTE "LIST.TRIGGER MY_FILE" CAPTURING X.RESULT > > and parse X.RESULT, but was curious if there's a better way. > > I've occasionally been bitten by converting a file from static to > dynamic hashing, losing an update trigger in the process so I want to > write some code to check these and let me know if something's awry. > > -- > Jeff Butera, Ph.D. > Manager of ERP Systems > Hampshire College > jbut...@hampshire.edu > 413-559-5556 > > "...we must choose between what is right and what is easy..." >Dumbledore > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
