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/
[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/
RE: [U2] Counting records
If you need to find out how many records are in a file quickly and on a regular basis, add a secondary index on the ID and see how fast a select is Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Rye Hill House T 01604 592289 M 07917 856195 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 19 November 2008 21:51 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Counting records COUNT is a "TCL2" Verb just like SELECT, LIST, SORT, LIST-LABEL, ETC. So this is already a valid statement in Universe and Unidata: COUNT CONTACT WITH @ID LIKE "2..." T > From: Dave Laansma > One advantage of using my subroutine is I can pass in just the file > name and get a count of all records, or I can specify the filename AND > some selection criteria and it will return the count of the records > that match that criteria. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/