RE: [U2] [UV] Help with HELP
In universe I usually edit the help file to read it. Tis so much easier to page down/up line by line , print etc. SYS.HELP and BASIC.HELP are the two files I know of that contain the help documents. (alto I am sb+ as well but I would think the help is at the universe level, not sb+.) Thanks, Marilyn A. Hilb Value Part, Inc Direct: 847-918-6099 Fax: 847-367-1892 [EMAIL PROTECTED] www.valuepart.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 6:53 PM To: u2-users@listserver.u2ug.org Subject:RE: [U2] [UV] Help with HELP There's a bug in a UV help routine, CHOICE.BOX.B. So help doesn't render properly if the screen is greater than 80 columns. Stuart. -Original Message- From: Barry Brevik Running UV 9.6.1.3 on NT. Terminal emulation is VP60 using wIntegrate. Does anyone know what term type the HELP command expects to see? I can sorta Any ideas for me? ** 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 email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- 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] [UV] Help with HELP
Grab a copy of the pdf's and use them. That's more readable than the help files. I'm lucky in that we have a few high speed printers here that can do double sided pages. Once printed that way, I have the pdf's bound into crude books. On Fri, 11 Mar 2005 09:26:25 -0600, Marilyn Hilb [EMAIL PROTECTED] wrote: In universe I usually edit the help file to read it. Tis so much easier to page down/up line by line , print etc. SYS.HELP and BASIC.HELP are the two files I know of that contain the help documents. (alto I am sb+ as well but I would think the help is at the universe level, not sb+.) Thanks, Marilyn A. Hilb Value Part, Inc Direct: 847-918-6099 Fax: 847-367-1892 [EMAIL PROTECTED] www.valuepart.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 6:53 PM To: u2-users@listserver.u2ug.org Subject:RE: [U2] [UV] Help with HELP There's a bug in a UV help routine, CHOICE.BOX.B. So help doesn't render properly if the screen is greater than 80 columns. Stuart. -Original Message- From: Barry Brevik Running UV 9.6.1.3 on NT. Terminal emulation is VP60 using wIntegrate. Does anyone know what term type the HELP command expects to see? I can sorta Any ideas for me? ** 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 email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- 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] saving SAVEDLISTS files unintentionally
Many thanks to all repliers, this was enormously helpful greatly appreciated, I've found the relevant portions in the PICK manual now. Phil Walker wrote: STACKWRITE [OFF|ON] Place this in the LOGIN paragraph or even the UV.LOGIN paragraph in the UV account for a system wide setting. Cheers, Phil Walker +64 27 5336294 +64 3 3120352 [EMAIL PROTECTED] Gnosys Consulting Limited 25 Roscrea Place, Mandeville North, RD2 Kaiapoi, North Canterbury 8252, NEW ZEALAND DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Gnosys Consulting Limited is not responsible for any changes made to this message and / or any attachments after sending by Gnosys Consulting Limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Ivanick Sent: Friday, March 11, 2005 9:13 AM To: u2-users@listserver.u2ug.org Subject: [U2] saving SAVEDLISTS files unintentionally Hola - In preparation for our migration we're trying to clean up a lot of cruft on our old syustem that's no longer necessary, and so we're sorting through the SAVEDLISTS directories for temporary files that are no longer needed (some of them are, apparently, in constant use). Many of the files there, typically labelled as S.username.somethingelse are apparently triggered by some internal processes, as most of these users never have access to the TCL prompt. According to our PICK developer there's a switch/setting in UniVerse that determines whether these files get written out saved if not explicitly meant to be, but I'm not sure where to look in the docs for this (nothing on savedlists in admin uniadmin pdfs) - any pointers to what to look for in the docs and/or whether/how we can change this behavior so there's less housekeeping in the future would be greatly appreciated, as always. Thanks very much for any help. -- Peter Ivanick Sr. Programmer/Analyst School of Veterinary Medicine, University of Pennsylvania Email: [EMAIL PROTECTED] Phone: 215.573.2306Fax: 215.573.8777 http://www.vet.upenn.edu/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[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/
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 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/
[U2] Indexing issue
I have a file that has thousands of keys that start with an A. There is an index on the key. When I try and do a search for any items that start with say A12 and I type in A12... the search does not return what I expect and takes a long time because Unidata thinks it is doing a Alphanumeric search. Is there a way to get the results I expect? ** 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 email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- 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/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- 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] Indexing issue
From: Dan Knutson [EMAIL PROTECTED] Sent: Friday, March 11, 2005 2:23 PM Subject: [U2] Indexing issue I have a file that has thousands of keys that start with an A. There is an index on the key. When I try and do a search for any items that start with say A12 and I type in A12... the search does not return what I expect and takes a long time because Unidata thinks it is doing a Alphanumeric search. Is there a way to get the results I expect? If the primary key is indexed, that's pretty much a waste of time. Indexing PART of the primary key on the other hand would be useful. You might consider creating an I-Type dictionary item that's @ID[1,3], and then indexing that field. That would work rather quickly. --- 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] Indexing issue
Not necessarily so... An index on the primary key will not only allow you to sort or sselect the file by that key instantly, but also allow quick selects on partial keys (e.g. select myfile with key = 12345]). Admittedly esoteric, but on occasion handy. Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Friday, March 11, 2005 12:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexing issue If the primary key is indexed, that's pretty much a waste of time. Indexing PART of the primary key on the other hand would be useful. You might consider creating an I-Type dictionary item that's @ID[1,3], and then indexing that field. That would work rather quickly. --- 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] Indexing issue
Try quoting it as 'A12'... instead. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: 11 March 2005 20:08 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexing issue From: Dan Knutson [EMAIL PROTECTED] Sent: Friday, March 11, 2005 2:23 PM Subject: [U2] Indexing issue I have a file that has thousands of keys that start with an A. There is an index on the key. When I try and do a search for any items that start with say A12 and I type in A12... the search does not return what I expect and takes a long time because Unidata thinks it is doing a Alphanumeric search. Is there a way to get the results I expect? If the primary key is indexed, that's pretty much a waste of time. Indexing PART of the primary key on the other hand would be useful. You might consider creating an I-Type dictionary item that's @ID[1,3], and then indexing that field. That would work rather quickly. --- 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] [UV] Web Services for Dummies
Has anyone developed a web service for Universe ? I'm trying to gather as much info as I can about the technology used. I realize UV 10.1 has many of the tools that I'll need for the backend, but what is normally used on the frontend, what communications protocal is normally used ? I've read alot of theory about how it should work, but I haven't come across anything that gives me some concrete examples. Can someone direct me to some information or maybe explain to me in practical terms on how an xml request would come into UV then a response sent back to the requestor from UV using xml. If you've done web services using ASP.NET and UV I would appreciate hearing from you. thx. rudy Rudy Cooper Sage Publications I.T Development Thousand Oaks, California (805) 499-0721 #7724 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexing issue
My problem seems to be that Unidata see's the A and thinks I am doing a alphanumeric search on everything after the A. It takes the A as a command to do an alphanumeric search. I was told you could put quotes around the criteria to get it to work right but so far I have not been able to do that. Daniel Knutson OSTech Client Support www.epicor.com Tel.: (800) 347-2381 Fax: (800) 764-4539 E-Mail: [EMAIL PROTECTED] 600 South HWY 169 2000 Interchange Tower, Minneapolis, MN 55426 This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: Friday, March 11, 2005 2:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Indexing issue Not necessarily so... An index on the primary key will not only allow you to sort or sselect the file by that key instantly, but also allow quick selects on partial keys (e.g. select myfile with key = 12345]). Admittedly esoteric, but on occasion handy. Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Friday, March 11, 2005 12:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexing issue If the primary key is indexed, that's pretty much a waste of time. Indexing PART of the primary key on the other hand would be useful. You might consider creating an I-Type dictionary item that's @ID[1,3], and then indexing that field. That would work rather quickly. --- 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/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- 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] [UV] Web Services for Dummies
This one has come up again and again over the last few weeks. You'll find lots of posting about it on www.indexinfocus.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy Sent: 11 March 2005 21:00 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Web Services for Dummies Has anyone developed a web service for Universe ? I'm trying to gather as much info as I can about the technology used. I realize UV 10.1 has many of the tools that I'll need for the backend, but what is normally used on the frontend, what communications protocal is normally used ? I've read alot of theory about how it should work, but I haven't come across anything that gives me some concrete examples. Can someone direct me to some information or maybe explain to me in practical terms on how an xml request would come into UV then a response sent back to the requestor from UV using xml. If you've done web services using ASP.NET and UV I would appreciate hearing from you. thx. rudy Rudy Cooper Sage Publications I.T Development Thousand Oaks, California (805) 499-0721 #7724 --- 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] [OT] Wonky?
What is a Modertor ? And again, many people on this list will have no idea HOW to move it to community. If you simply put community in the reply to field you can be of great assistance to all and sundry. Will -Original Message- From: Moderator [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Fri, 11 Mar 2005 15:55:34 +1100 Subject: RE: [U2] [OT] Wonky? Let's move this thread to u2-Community. To subscribe please visit http://listserver.u2ug.org/ David Jordan, Modertor --- 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] Indexing issue
I use something like somestuff:' CODE = A12] ': otherstuff or as an alternate somestuff:' CODE = A12 AND A13 ':otherstuff Works with the index, i.e. fast. Will Johnson -Original Message- From: Dan Knutson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Fri, 11 Mar 2005 13:23:17 -0600 Subject: [U2] Indexing issue I have a file that has thousands of keys that start with an A. There is an index on the key. When I try and do a search for any items that start with say A12 and I type in A12... the search does not return what I expect and takes a long time because Unidata thinks it is doing a Alphanumeric search. Is there a way to get the results I expect? ** 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 email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- 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/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- 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?
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?
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] [UV] Web Services for Dummies
Please see my four articles on Web Services and .NET, originally printed in Spectrum Magazine from 2003-2004. Magazines are here: http://www.intl-spectrum.com/SPECTRUMMAG.HTML HTML versions here: http://../articles/ I also have an article there called SOAP for people who don't do protocols which is a follow-up to my What are Sockets? article. In particular, Universe doesn't really play a part in Web Services per-se, unless you use socket coding to make it into a socket client and/or server. I'd recommend against that approach. To make Universe a web service client: - Use mainstream tools like .NET, J2EE, or Perl to create a WS client to an external service of your choice. Web Service sources publish WSDL which identifies the API to their service. Mainstream tools easily create WS clients to conform to the server side. - Then create a pipe from your new WS client into U2, to function purely as a data transport. For this you can use UO, UO.NET, MV.NET, PDP.NET, RedBack, or other tools described in this forum recently. To publish U2 business rules as a web service, follow the same pattern: - Use mainstream tools to publish WSDL and accept inbound WS requests. - When requests come in, connect to U2 to run BASIC programs, run rules, and build a result set. - The data from U2 can be built into XML, ready to be passed out through the Web Service, or you can pass back simple data and let your Web Service wrap it properly prior to returning data back to the client. I've written Web Services to/from MV platforms using .NET and Perl (not together), and am prepared to develop end-to-end solutions for VARs or end-users. I hope that helps. Tony, Nebula RD [EMAIL PROTECTED] Cooper, Rudy Rudy.Cooper-at-sagepub.com |U2UG| wrote: Has anyone developed a web service for Universe ? I'm trying to gather as much info as I can about the technology used. I realize UV 10.1 has many of the tools that I'll need for the backend, but what is normally used on the frontend, what communications protocal is normally used ? I've read alot of theory about how it should work, but I haven't come across anything that gives me some concrete examples. Can someone direct me to some information or maybe explain to me in practical terms on how an xml request would come into UV then a response sent back to the requestor from UV using xml. If you've done web services using ASP.NET and UV I would appreciate hearing from you. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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 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 regulated by the Financial Services Authority and,
RE: [U2]: Epicor
Here Here -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, March 11, 2005 8:52 PM To: u2-users@listserver.u2ug.org Subject: [U2]: Epicor Is anyone on this list an Epicor user ? I have a client who is examining Epicor as a possible solution to part of what they need and would like some input. Thanks Will Johnson Fast Forward --- 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]: Epicor
Is anyone on this list an Epicor user ? Here's another one. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Web Services for Dummies
Here is a direct link to the last one of the four articles that Tony is referring to. This will open as a pdf inside your browser, takes about 20 seconds on a T1 connection to open it. http://www.intl-spectrum.com/publications/JulAug04.pdf Will -Original Message- From: Tony Gravagno [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Fri, 11 Mar 2005 14:59:42 -0800 Subject: RE: [U2] [UV] Web Services for Dummies Please see my four articles on Web Services and .NET, originally printed in Spectrum Magazine from 2003-2004. Magazines are here: http://www.intl-spectrum.com/SPECTRUMMAG.HTML HTML versions here: http://../articles/ I also have an article there called SOAP for people who don't do protocols which is a follow-up to my What are Sockets? article. In particular, Universe doesn't really play a part in Web Services per-se, unless you use socket coding to make it into a socket client and/or server. I'd recommend against that approach. To make Universe a web service client: - Use mainstream tools like .NET, J2EE, or Perl to create a WS client to an external service of your choice. Web Service sources publish WSDL which identifies the API to their service. Mainstream tools easily create WS clients to conform to the server side. - Then create a pipe from your new WS client into U2, to function purely as a data transport. For this you can use UO, UO.NET, MV.NET, PDP.NET, RedBack, or other tools described in this forum recently. To publish U2 business rules as a web service, follow the same pattern: - Use mainstream tools to publish WSDL and accept inbound WS requests. - When requests come in, connect to U2 to run BASIC programs, run rules, and build a result set. - The data from U2 can be built into XML, ready to be passed out through the Web Service, or you can pass back simple data and let your Web Service wrap it properly prior to returning data back to the client. I've written Web Services to/from MV platforms using .NET and Perl (not together), and am prepared to develop end-to-end solutions for VARs or end-users. I hope that helps. Tony, Nebula RD [EMAIL PROTECTED] Cooper, Rudy Rudy.Cooper-at-sagepub.com |U2UG| wrote: Has anyone developed a web service for Universe ? I'm trying to gather as much info as I can about the technology used. I realize UV 10.1 has many of the tools that I'll need for the backend, but what is normally used on the frontend, what communications protocal is normally used ? I've read alot of theory about how it should work, but I haven't come across anything that gives me some concrete examples. Can someone direct me to some information or maybe explain to me in practical terms on how an xml request would come into UV then a response sent back to the requestor from UV using xml. If you've done web services using ASP.NET and UV I would appreciate hearing from you. --- 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] [UD] Objectcall again -- Australia 432, New Zealand 433 and 0/9
Steven Frost wrote: Sent: Friday, 11 March 2005 2:10 PM Subject: [U2] [UD] Objectcall again -- Australia 48-2 I am still having a bit of an issue with the Objectcall API Objectcall ping works fine to both the live database and the test database ( different unix servers) When the uniapi.ini file is pointing to the live system , the connection via the web page is good. When we change the uniapi.ini to point to the test server, and refresh our login asp page,the connection fails . The web page uses a 3rd party pclogin.dll and I have no idea what is inside. I am assuming Objectcall. It should be opening a connection to unidata and reading a username-password record from a table. However , there must be something on ( or missing from) the unidata unix server itself that is causing the problem Unirpcd is running , and the unirpcservices file looks OK ( must be if Objectcall ping works). Is there anything else I should be looking at? ObjectCall doesn't go through unirpcd and has nothing to do with the unirpcservices file as far as I know. You'll find entries in /etc/services and /etc/inetd.conf on your live UniData box I think which relate to UNIAPI or something similar. You need to set up similar entries on your test box. The key component is uniapisvr IIRC. I think there is a server admin program for it too, but it has been such a long time since I played with ObjectCall and I don't have access to a box where it is running at the moment. Cheers, Ken PS. Well played New Zealand. Not many people expected the Black Caps to be competitive. For what was billed as the fastest deck in NZ, Christchurch has provided a pretty flat track. Do you think it will break up on the 4th and 5th days or is it just dead? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Objectcall again -- Australia 432, New Zealand 433 and 0/9
Hi Steven, What version of UniData are you running on the test box? My current experience is that on UniData 6.0 ObjectCall does work, however on UniData 6.1 hp/ux it ObjectCall is fatally broken! (if anyone has a workaround to get ObjectCall working on hp.ux/udt 6.1 I'd be interested.) In answer to Ken's failing memory, the unix admin program is uniapi_admin; on Windows (6.0 and above) we have resorted to registry hacks to administr ObjectCall. My advice to to rewrite your application as IBM are no longer supporting ObjectCall... I have been trying to get rid of ObjectCall for sume time; unfortunately it just quite refuses to die!!! (we use it as part of our DataStage solution). One good thing though, our experiences with 6.1 will finally deal the fatal blow to our use of ObjectCall... Martin N.B. If anyone does give me a solution to our UniData 6.1 ObjectCall problem then I promise not to tell our developers! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Friday, March 11, 2005 9:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Objectcall again -- Australia 432, New Zealand 433 and 0/9 Steven Frost wrote: Sent: Friday, 11 March 2005 2:10 PM Subject: [U2] [UD] Objectcall again -- Australia 48-2 I am still having a bit of an issue with the Objectcall API Objectcall ping works fine to both the live database and the test database ( different unix servers) When the uniapi.ini file is pointing to the live system , the connection via the web page is good. When we change the uniapi.ini to point to the test server, and refresh our login asp page,the connection fails . The web page uses a 3rd party pclogin.dll and I have no idea what is inside. I am assuming Objectcall. It should be opening a connection to unidata and reading a username-password record from a table. However , there must be something on ( or missing from) the unidata unix server itself that is causing the problem Unirpcd is running , and the unirpcservices file looks OK ( must be if Objectcall ping works). Is there anything else I should be looking at? ObjectCall doesn't go through unirpcd and has nothing to do with the unirpcservices file as far as I know. You'll find entries in /etc/services and /etc/inetd.conf on your live UniData box I think which relate to UNIAPI or something similar. You need to set up similar entries on your test box. The key component is uniapisvr IIRC. I think there is a server admin program for it too, but it has been such a long time since I played with ObjectCall and I don't have access to a box where it is running at the moment. Cheers, Ken PS. Well played New Zealand. Not many people expected the Black Caps to be competitive. For what was billed as the fastest deck in NZ, Christchurch has provided a pretty flat track. Do you think it will break up on the 4th and 5th days or is it just dead? --- 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?
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?
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/