Re: [U2] Web services at 11.x
Great! Thanks! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Wednesday, May 14, 2014 4:22 PM To: 'U2 Users List' Subject: Re: [U2] Web services at 11.x Found the sample code ... https://u2devzone.rocketsoftware.com/accelerate/articles/soap-api/soap-api Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 15 May 2014 08:59 To: 'U2 Users List' Subject: Re: [U2] Web services at 11.x We've been using soap requests (UV10.3.4) to read/write data to a number of web service front ends since about this time last year. I found some sample code somewhere (either Rocket dev zone or pick wiki) to get me started. As Symeon has just mentioned, the soap and other commands in the UV Basic extensions manual is where you need to look. It can be a steep learning curve if you have not done any of this before (it certainly was for me and I still don't understand some of it!). Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Wednesday, 14 May 2014 03:11 To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Web services at 11.x I have been telling my manager (an Oracle-centric guy) that with Universe 11+ (we have 10.2 now) the web services will truly allow us to do input and output interfacing with other web services. I need to make sure this is a correct understanding. It is clear from the Web Services manual that one can create a web service (a SOAP service) which will allow outside queries and return data. I write to this list to ask those of you who know that it is possible to do the other way, that from Universe you are able to connect to outside web services, send queries to them, and get back responses. Because I don't see this in the Web manual. If the latter is not possible via the Web services capabilities built into Universe, how are any of you doing it? Do you need a 3rd-party product? Here is the data need: We are to interface our Jail system to another system via an ESB (electronic services bus) via 'web services', passing XML. Thanks- Harold Oaks Clark County, WA -- This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus
[U2] Web services at 11.x
I have been telling my manager (an Oracle-centric guy) that with Universe 11+ (we have 10.2 now) the web services will truly allow us to do input and output interfacing with other web services. I need to make sure this is a correct understanding. It is clear from the Web Services manual that one can create a web service (a SOAP service) which will allow outside queries and return data. I write to this list to ask those of you who know that it is possible to do the other way, that from Universe you are able to connect to outside web services, send queries to them, and get back responses. Because I don't see this in the Web manual. If the latter is not possible via the Web services capabilities built into Universe, how are any of you doing it? Do you need a 3rd-party product? Here is the data need: We are to interface our Jail system to another system via an ESB (electronic services bus) via 'web services', passing XML. Thanks- Harold Oaks Clark County, WA -- This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Web services at 11.x
Nancy: Great! Is there any possibility of you sending me some sample code? I may not be able to make it work at 10.2, but it would be instructive to try. If there are security or proprietary issues, or just your time issues, I understand. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nancy Fisher Sent: Tuesday, May 13, 2014 10:33 AM To: 'U2 Users List' Subject: Re: [U2] Web services at 11.x We query outside services for information via soap. Universe 10.3. Nancy Fisher Federal Way, Washington -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 13, 2014 10:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Web services at 11.x https://en.wikipedia.org/wiki/Enterprise_service_bus -Original Message- From: Oaks, Harold harold.o...@clark.wa.gov To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Tue, May 13, 2014 10:11 am Subject: [U2] Web services at 11.x I have been telling my manager (an Oracle-centric guy) that with Universe 11+ (we have 10.2 now) the web services will truly allow us to do input 11+ and output interfacing with other web services. I need to make sure this is a correct understanding. It is clear from the Web Services manual that one can create a web service (a SOAP service) which will allow outside queries and return data. I write to this list to ask those of you who know that it is possible to do the other way, that from Universe you are able to connect to outside web services, send queries to them, and get back responses. Because I don't see this in the Web manual. If the latter is not possible via the Web services capabilities built into Universe, how are any of you doing it? Do you need a 3rd-party product? Here is the data need: We are to interface our Jail system to another system via an ESB (electronic services bus) via 'web services', passing XML. Thanks- Harold Oaks Clark County, WA -- This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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] Web services at 11.x
Right, Enterprise Service Bus. Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 13, 2014 10:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Web services at 11.x https://en.wikipedia.org/wiki/Enterprise_service_bus -Original Message- From: Oaks, Harold harold.o...@clark.wa.gov To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Tue, May 13, 2014 10:11 am Subject: [U2] Web services at 11.x I have been telling my manager (an Oracle-centric guy) that with Universe 11+ (we have 10.2 now) the web services will truly allow us to do input and output interfacing with other web services. I need to make sure this is a correct understanding. It is clear from the Web Services manual that one can create a web service (a SOAP service) which will allow outside queries and return data. I write to this list to ask those of you who know that it is possible to do the other way, that from Universe you are able to connect to outside web services, send queries to them, and get back responses. Because I don't see this in the Web manual. If the latter is not possible via the Web services capabilities built into Universe, how are any of you doing it? Do you need a 3rd-party product? Here is the data need: We are to interface our Jail system to another system via an ESB (electronic services bus) via 'web services', passing XML. Thanks- Harold Oaks Clark County, WA -- This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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] Web services at 11.x
Thanks Bill. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, May 13, 2014 1:37 PM To: U2 Users List Subject: Re: [U2] Web services at 11.x Harold: Maybe you'd be interested in: https://u2devzone.rocketsoftware.com/accelerate/resources/videos/rest HTH, Bill Untitled Page - Original Message - *From:* harold.o...@clark.wa.gov *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 5/13/2014 11:20 AM *Subject:* Re: [U2] Web services at 11.x Right, Enterprise Service Bus. Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 13, 2014 10:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Web services at 11.x https://en.wikipedia.org/wiki/Enterprise_service_bus -Original Message- From: Oaks, Harold harold.o...@clark.wa.gov To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Tue, May 13, 2014 10:11 am Subject: [U2] Web services at 11.x I have been telling my manager (an Oracle-centric guy) that with Universe 11+ (we have 10.2 now) the web services will truly allow us to do input and output interfacing with other web services. I need to make sure this is a correct understanding. It is clear from the Web Services manual that one can create a web service (a SOAP service) which will allow outside queries and return data. I write to this list to ask those of you who know that it is possible to do the other way, that from Universe you are able to connect to outside web services, send queries to them, and get back responses. Because I don't see this in the Web manual. If the latter is not possible via the Web services capabilities built into Universe, how are any of you doing it? Do you need a 3rd-party product? Here is the data need: We are to interface our Jail system to another system via an ESB (electronic services bus) via 'web services', passing XML. Thanks- Harold Oaks Clark County, WA -- This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ ___ 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] Ref: Web Services at Universe 11.n
This is using the SOAP commands from within BASIC? Or some other way? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Friday, November 01, 2013 7:46 AM To: 'U2 Users List' Subject: Re: [U2] Ref: Web Services at Universe 11.n Consuming web services from U2 is really not that difficult. I've done both SOAP and RESTful transactions via both secure (HTTPS) and insecure (HTTP) connections. Some examples of the web services I've consumed from within U2 are: 1) UPS and FedEx package tracking services 2) Credit card authorization 3) Address validation and correction 4) Address geocoding using the Google maps API Protocol logging is your friend. It will log the complete transaction in a text file that you can review to see specifically where your errors are. Also, don't forget that if you're going to do secure transactions via HTTPS, you need to create a Security Context. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Thursday, October 31, 2013 1:46 PM To: U2 Users List Subject: Re: [U2] Ref: Web Services at Universe 11.n Hi Rudy: We're not using any web services at present - but we'd like to. (Basically I'm a beginner at this and trying to learn what is possible.) We need to interface our current jail system with a new RMS that is coming in, and the vendors of it prefer web services interfaces. So that's why. Unlike you, our underlying O/S is a form of unix - hpux actually - not Windows. Unfortunately, I don't know anything about WSD on unix. You notice Richard used curl and was happy with it, but right now that is not available on our hpux system. There is a download available where we can get curl along with some other web tools, but my system admin is not particularly enthusiastic about that idea. Richard: When you use curl, are you running on windows or unix (or something else)? Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, October 31, 2013 1:25 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Ref: Web Services at Universe 11.n Could you give an example of web services you are actually using and why? -Original Message- From: Cooper, Rudy rudy.coo...@sagepub.com To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Sent: Thu, Oct 31, 2013 1:18 pm Subject: [U2] Ref: Web Services at Universe 11.n Harold, We’re on a windows platform and we’ve doing web services with UV since 10.2. Use the WSD for creating the soap server and and use soapui (free) for testing. We access external services from UV using the soap api that is documented in basicext.pdf of the uv documentation. The documentation from Rocket for your release, IBM U2 Web Services Developer, is very good. rudy Date: Wed, 30 Oct 2013 12:00:40 -0700 From: Oaks, Harold harold.o...@clark.wa.govmailto:harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org Subject: [U2] Web Services at Universe 11.n Message-ID: e9aeaa752e89734bb39e1c6bfcddcfb804f7f...@esxvm40.clark.root.localmailto:e9aeaa752e89734bb39e1c6bfcddcfb804f7f...@esxvm40.clark.root.local Content-Type: text/plain; charset=us-ascii I've been telling my boss that if we upgraded to Universe 11.23, we can implement web services. (We're currently on 10.2) But, finally looking in detail at the appropriate manual (Universe Web Services Developer) it seems that one can publish a web service easily enough so that Universe data can be gotten, but I don't see that the other side is implemented, where one accesses an external web service and brings back data into Universe. Am I missing the something? What are any of you using to fully implement web services with an underlying Universe environment? Thanks- Harold Oaks Sr. Analyst/Programmer Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. Rudy Cooper Lead Applications Developer Sage Publications Inc. 2455 Teller Road Thousand Oaks, Ca. 91320 USA T:805.410.7724 www.sagepub.com Los Angeles | London | New Delhi Singapore | Washington DC The natural home for authors, editors societies Please consider the environment before printing this email Are you a fan of SAGE? Show us at www.facebook.com/SAGEPublicationshttp://www.facebook.com/SAGEPublications. ___ 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] Ref: Web Services at Universe 11.n
Hi Rudy: We're not using any web services at present - but we'd like to. (Basically I'm a beginner at this and trying to learn what is possible.) We need to interface our current jail system with a new RMS that is coming in, and the vendors of it prefer web services interfaces. So that's why. Unlike you, our underlying O/S is a form of unix - hpux actually - not Windows. Unfortunately, I don't know anything about WSD on unix. You notice Richard used curl and was happy with it, but right now that is not available on our hpux system. There is a download available where we can get curl along with some other web tools, but my system admin is not particularly enthusiastic about that idea. Richard: When you use curl, are you running on windows or unix (or something else)? Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, October 31, 2013 1:25 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Ref: Web Services at Universe 11.n Could you give an example of web services you are actually using and why? -Original Message- From: Cooper, Rudy rudy.coo...@sagepub.com To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Sent: Thu, Oct 31, 2013 1:18 pm Subject: [U2] Ref: Web Services at Universe 11.n Harold, We’re on a windows platform and we’ve doing web services with UV since 10.2. Use the WSD for creating the soap server and and use soapui (free) for testing. We access external services from UV using the soap api that is documented in basicext.pdf of the uv documentation. The documentation from Rocket for your release, IBM U2 Web Services Developer, is very good. rudy Date: Wed, 30 Oct 2013 12:00:40 -0700 From: Oaks, Harold harold.o...@clark.wa.govmailto:harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org Subject: [U2] Web Services at Universe 11.n Message-ID: e9aeaa752e89734bb39e1c6bfcddcfb804f7f...@esxvm40.clark.root.localmailto:e9aeaa752e89734bb39e1c6bfcddcfb804f7f...@esxvm40.clark.root.local Content-Type: text/plain; charset=us-ascii I've been telling my boss that if we upgraded to Universe 11.23, we can implement web services. (We're currently on 10.2) But, finally looking in detail at the appropriate manual (Universe Web Services Developer) it seems that one can publish a web service easily enough so that Universe data can be gotten, but I don't see that the other side is implemented, where one accesses an external web service and brings back data into Universe. Am I missing the something? What are any of you using to fully implement web services with an underlying Universe environment? Thanks- Harold Oaks Sr. Analyst/Programmer Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. Rudy Cooper Lead Applications Developer Sage Publications Inc. 2455 Teller Road Thousand Oaks, Ca. 91320 USA T:805.410.7724 www.sagepub.com Los Angeles | London | New Delhi Singapore | Washington DC The natural home for authors, editors societies Please consider the environment before printing this email Are you a fan of SAGE? Show us at www.facebook.com/SAGEPublicationshttp://www.facebook.com/SAGEPublications. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Web Services at Universe 11.n
I've been telling my boss that if we upgraded to Universe 11.23, we can implement web services. (We're currently on 10.2) But, finally looking in detail at the appropriate manual (Universe Web Services Developer) it seems that one can publish a web service easily enough so that Universe data can be gotten, but I don't see that the other side is implemented, where one accesses an external web service and brings back data into Universe. Am I missing the something? What are any of you using to fully implement web services with an underlying Universe environment? Thanks- Harold Oaks Sr. Analyst/Programmer Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Web Services at Universe 11.n
Thanks Larry! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Wednesday, October 30, 2013 12:16 PM To: 'U2 Users List' Subject: Re: [U2] Web Services at Universe 11.n Look in the UniVerse Basic Extensions manual at the Simple Object Access Protocol (SOAP) chapter. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Wednesday, October 30, 2013 12:01 PM To: u2-users@listserver.u2ug.org Subject: [U2] Web Services at Universe 11.n I've been telling my boss that if we upgraded to Universe 11.23, we can implement web services. (We're currently on 10.2) But, finally looking in detail at the appropriate manual (Universe Web Services Developer) it seems that one can publish a web service easily enough so that Universe data can be gotten, but I don't see that the other side is implemented, where one accesses an external web service and brings back data into Universe. Am I missing the something? What are any of you using to fully implement web services with an underlying Universe environment? Thanks- Harold Oaks Sr. Analyst/Programmer Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Web Services at Universe 11.n
Thanks Dan. Will those SOAP calls (the unibasic extensions mentioned by Larry Hiscock) work from Basic work at 10.2 ? Thanks so much- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, October 30, 2013 2:25 PM To: U2 Users List Subject: Re: [U2] Web Services at Universe 11.n We haven't built 11.23 yet. 11.2 is the next one about to come out :) As others have mentioned, U2 Basic supports HTTP/HTTPS calls as well as SOAP. More recent improvements include the UDO functions, which makes handling REST/JSON web-services at lot easier. Regards, Dan McGrath Managing Director, U2 Servers Lab Rocket Software 4600 South Ulster Street · Suite 1100 · Denver, CO 80237 · USA -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Wednesday, October 30, 2013 1:01 PM To: u2-users@listserver.u2ug.org Subject: [U2] Web Services at Universe 11.n I've been telling my boss that if we upgraded to Universe 11.23, we can implement web services. (We're currently on 10.2) But, finally looking in detail at the appropriate manual (Universe Web Services Developer) it seems that one can publish a web service easily enough so that Universe data can be gotten, but I don't see that the other side is implemented, where one accesses an external web service and brings back data into Universe. Am I missing the something? What are any of you using to fully implement web services with an underlying Universe environment? Thanks- Harold Oaks Sr. Analyst/Programmer Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Record Sampling for File Sizing Diagnostics
Perry: In Universe the modifier SAMPLED nn selects every nn'th record. For example, SELECT MYFILE SAMPLED 50 selects every 50th record. That way you plow thru the entire file but come back with only 1/50 of the records. I don't know if this keyword exists in Unidata Harold Oaks Clark County, WA -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Tuesday, June 11, 2013 9:01 AM To: U2-Users List Subject: [U2] [UV] Record Sampling for File Sizing Diagnostics I have several *very* large files on which I need to perform some file sizing diagnostics. Rather than repeatedly running HASH.AID against these files is there a good way to sample say 2-3 million records to copy into a test file? SAMPLE will only grab the first n records in hash order and I'm thinking that would not necessarily be a good representative sample of the file's contents. Am I up in the night thinking this is the case? Is there a better way to get a good sample of records for this purpose? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Signature Capture and use
Jeff: Nice! I certainly might contact you later and ask for that code. (However - if you've put in the work, you do deserve some payment.) The shared Windows directory is what I often use for I/O of data, images, etc., so that's something I could probably understand and use quickly. Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, June 07, 2013 2:18 PM To: U2 Users List Subject: Re: [U2] Signature Capture and use I wrote a VB.net application which integrates with our Universe system via Uniobjects and store the signatures on a shared Windows server directory using the sample code which Topaz provides with their signature capture pads. We decided on the Topaz hardware because (Surprise!) it pretty cheap @ around $100 for their low end USB signature pad. http://www.topazsystems.com/ I'd be happy to share the source code if you're interested. Oaks, Harold wrote: I'm sure some of you are implementing signature pad capture to a Universe system. What are you using and doing? I'd like to look into adding that feature to our jail system. Thanks- Harold Oaks Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users . -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Signature Capture and use
I'm sure some of you are implementing signature pad capture to a Universe system. What are you using and doing? I'd like to look into adding that feature to our jail system. Thanks- Harold Oaks Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Signature Capture and use
Thanks Rex -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rex Gozar Sent: Thursday, June 06, 2013 1:38 PM To: U2 Users List Subject: Re: [U2] Signature Capture and use I'm guessing you are not running a .net GUI frontend application. We have signature pads connected to our telnet-based Universe system. (a) We use AccuTerm to fire an exe on the client PC. (b) The client exe is a .net program with manufacturer's dll's that communicate with the signature pad. (c) When the user OKs the signature, the client exe sends the signature bytes to the application server via sockets, then exits. We had tried to use network shares for (c) but they proved to be unreliable. In a future version, I want to create a client exe with a socket listener built-in and run it like a service. That way, the application server can use a socket connection directly with the exe (instead of firing off the exe via AccuTerm). Theoretically, such an exe could be used via javascript in a browser-based application too. rex On Thu, Jun 6, 2013 at 3:59 PM, Oaks, Harold harold.o...@clark.wa.gov wrote: I'm sure some of you are implementing signature pad capture to a Universe system. What are you using and doing? I'd like to look into adding that feature to our jail system. Thanks- Harold Oaks Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 11.x
Thanks Allen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Friday, December 14, 2012 6:26 PM To: U2 Users List Subject: Re: [U2] Universe 11.x On 12/14/2012 12:16 PM, Oaks, Harold wrote: Universe folks: Who has upgraded from Universe 10.x to Universe 11.x lately? Is it painless? Like - get the users out, install Universe 11.x in 5 minutes, then get the users back in. Then, as time permits, take advantage of the new features within Universe 11.x. Or - is it a big deal to install it? My manager is interested in data encryption in the underlying data. It is my understanding the Automatic Data Encryption (ADE) only exists in Universe 11.x. Is that right? If the install is simple enough, that would seem to be the way to go to obtain this feature for all fields. If you use indexes, check the release to make sure they'll be okay. -- allen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Universe 11.x
Universe folks: Who has upgraded from Universe 10.x to Universe 11.x lately? Is it painless? Like - get the users out, install Universe 11.x in 5 minutes, then get the users back in. Then, as time permits, take advantage of the new features within Universe 11.x. Or - is it a big deal to install it? My manager is interested in data encryption in the underlying data. It is my understanding the Automatic Data Encryption (ADE) only exists in Universe 11.x. Is that right? If the install is simple enough, that would seem to be the way to go to obtain this feature for all fields. Thanks- Harold Oaks Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Universe 10.2
We are running Universe 10.2. I know 11.x has been out quite a while. Does anyone know if there is a planned end-of-support for 10.2? Thanks- Harold Oaks County IT Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Sub-second delay?
In Universe Basic, the !SLEEP$ routine accepts milliseconds as a parameter. For example: CALL !SLEEP$(200) sleeps for 200 milliseconds (2/10 of a second). Of course it takes a little time for the routine to start up, so you won't sleep exactly 1 millisecond if you try !SLEEP$(1). But it works quite well in general. Sometimes I have a message where pausing on it for 1 second seems too fast, 2 seconds too slow, so I make the call CALL !SLEEP$(1500) to pause 1.5 seconds. Harold Oaks Clark County -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, August 27, 2012 10:10 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [ud] Sub-second delay? O talk about bringing a system to its knees :) -Original Message- From: Marco Antonio Rojas Castro marco_roja...@hotmail.com To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Aug 27, 2012 9:59 am Subject: Re: [U2] [ud] Sub-second delay? H = SYSTEM(12) ;* TIME IN MILISECONDS LOOP H2 = SYSTEM(12) IF H2 - H 500 THEN EXIT ;* 500 MS ELAPSED REPEAT Date: Mon, 27 Aug 2012 10:17:01 -0600 From: ke...@precisonline.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] [ud] Sub-second delay? Ah crap, this client is Unidata 6.1 and NAP is not supported. I'm not seeing it in the 7.1 or 7.2 docs either. Looks to be a UV thing, right? On Mon, Aug 27, 2012 at 9:41 AM, David L. Wasylenko d...@pickpro.com wrote: NAP 500 ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, August 27, 2012 10:46 AM To: U2 Users List Subject: [U2] [ud] Sub-second delay? Is there anything in Unidata (7.1, in particular) that can do a sub-second delay, like maybe a half second? ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Sub-second delay?
I was unaware of NAP before today! That's why I'm still using !SLEEP$ (yes, as we did in PI/OPEN). I like it - thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark Sent: Monday, August 27, 2012 2:35 PM To: U2 Users List Subject: Re: [U2] [ud] Sub-second delay? yep, it's there for compatibility with pr1me. the source is in APP.PROGS SLEEP: 0031 subroutine PR1ME(time.in.milliseconds) 0032 ;* if time.in.milliseconds 1000 then sleep 1 0033 ;* else sleep (time.in.milliseconds / 1000) 0034 0035NAP time.in.milliseconds 0036 return On Aug 27, 2012, at 4:48 PM, Wjhonson wjhon...@aol.com wrote: Oooo naughty This is *not* in our online HELP BASIC display, and yet it works. I guess it's a synonym for NAP in Universe -Original Message- From: Oaks, Harold harold.o...@clark.wa.gov To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Aug 27, 2012 1:34 pm Subject: Re: [U2] [ud] Sub-second delay? In Universe Basic, the !SLEEP$ routine accepts milliseconds as a parameter. For example: CALL !SLEEP$(200) sleeps for 200 milliseconds (2/10 of a second). Of course it takes a little time for the routine to start up, so you won't sleep exactly 1 millisecond if you try !SLEEP$(1). But it works quite well in general. Sometimes I have a message where pausing on it for 1 second seems too fast, 2 seconds too slow, so I make the call CALL !SLEEP$(1500) to pause 1.5 seconds. Harold Oaks Clark County -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, August 27, 2012 10:10 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [ud] Sub-second delay? O talk about bringing a system to its knees :) -Original Message- From: Marco Antonio Rojas Castro marco_roja...@hotmail.com To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Aug 27, 2012 9:59 am Subject: Re: [U2] [ud] Sub-second delay? H = SYSTEM(12) ;* TIME IN MILISECONDS LOOP H2 = SYSTEM(12) IF H2 - H 500 THEN EXIT ;* 500 MS ELAPSED REPEAT Date: Mon, 27 Aug 2012 10:17:01 -0600 From: ke...@precisonline.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] [ud] Sub-second delay? Ah crap, this client is Unidata 6.1 and NAP is not supported. I'm not seeing it in the 7.1 or 7.2 docs either. Looks to be a UV thing, right? On Mon, Aug 27, 2012 at 9:41 AM, David L. Wasylenko d...@pickpro.com wrote: NAP 500 ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, August 27, 2012 10:46 AM To: U2 Users List Subject: [U2] [ud] Sub-second delay? Is there anything in Unidata (7.1, in particular) that can do a sub-second delay, like maybe a half second? ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regarding: use of I - Descriptor
Hi Satya: An I-descriptor is the same as an I-type (or a V-type). It's like a little program in the DICT (dictionary) of a file. It can do very complex things, but quite often is used for very simple things, but those simple things can be quite helpful. Here is an example- In the DICT of the INMATE file there are D-types for last name, first name, and middle name, which are LNAME, FNAME, and MNAME. Now, one can see a listing of inmate names by typing: LIST INMATE LNAME FNAME MNAME and get this: INMATENAMEFIRST NAMEMIDDLE NAME 86144JOHNSON PHILLIP 779501THOMAS ERNESTROBERT 192814SMITHTHOMASDEAN 204251TOONSDALEPAUL JAMES However, this takes up a lot of space for each name with the three names combining for 45 characters. To save space, let's create an I-type to put the last, first, and middle names together as one field: ED DICT INMATE FULLNAME This is a Type I Descriptor last compiled on 02/08/12 at 15:38. 0001: I 0002: LNAME:', ':FNAME:' ':MNAME 0003: 0004: FULL NAME 0005: 25L 0006: S You see in field 2 is that the three parts of the name are concatenated together, with a comma after the last name. This makes the display much shorter and works well for most anyone's name: INMATEFULL NAME... 86144JOHNSON, PHILLIP 779501THOMAS, ERNEST ROBERT 192814SMITH, THOMAS DEAN 204251TOONSDALE, PAUL JAMES The field now is only 25 characters in display width, but only a few person's names will exceed 25 characters and need to wrap to the next line, so that saves a lot of space. The I-type was very simple to create and understand. Oh yes, after creating the I-type field in the DICT, one needs to compile it with: COMPILE.DICT INMATE FULLNAME As I said, it's actually a little program. These little programs - the I-types - are one of the real strengths of the multivalue development environment. Harold Oaks Clark County, WA -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: Monday, June 25, 2012 9:10 AM To: U2 Users List Subject: [U2] Regarding: use of I - Descriptor Hi, Could any one of you explain What is I - Descriptor and What is the use of it. Thank you, Satya ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Suspected Spam] Re: File Sizing using concurrent option AND FAREWELL
Will: Thanks very much for the link. My numbers by memory where a bit off, it's even worse than I had remembered! Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, June 20, 2012 12:22 PM To: u2-users@listserver.u2ug.org Subject: [Suspected Spam] Re: [U2] File Sizing using concurrent option AND FAREWELL http://www.pcworld.com/businesscenter/article/157058/sap_project_costs_c ited_in_jewelers_bankruptcy_filing.html -Original Message- From: Oaks, Harold harold.o...@clark.wa.gov To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 23, 2012 2:21 pm Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL It was a Company in Portland Oregon, here where I live. The Shane ompany, a jeweler. Used to run a lot of local radio ads, then the ads uddenly stopped. Turns out they went bankrupt. In bankruptcy roceedings they mainly blamed the costs incurred by the SAP system rought in to replace their in-house customized Universe-based system. he SAP implementation was supposed to cost $8 million, but costs were ear $19 million when the company went out of business. I the ankruptcy proceedings the company mainly blamed the SAP implementation. fter bankruptcy they resurfaced, which we know as the radio ads came ack on a few months ago after being off about a year. However - the ds have stopped again. Perhaps they are just saving advertising ollars for now? Or is it worse? But what really burns me up: I did a google search on this very thing 2 ays ago and came across a blogger who was defending SAP, his deal was hat the install failure was Shane Company's upper management's fault. !!! If any company agrees to pay $8 MILLION dollars for a system, he vendor had better provide all the help needed to get the system up nd running successfully or that vendor has failed. How about you MV providers, do you ever help the customers do an nstallation? Or do you take the money and let 'em do the best they an? And if they fail, it's their fault?? I'm just rehashing what I've read. I'd really like to hear from one of he programmers or analysts that worked for the Shane Company when all his happened. Are you out there? An even more damaging a story, if possible, is the implementation of SAP o serve the City of Portland (once again, my home city, but this time t involves my tax dollars). I don't know too many details except that t was supposed to unify 19 separate systems into one, and mplementation was to cost about $20 million (already outrageous), but ne attempt under an outside SAP implementation specialist failed, a econd implementer hired from way out of town also failed, finally SAP hemselves came in (where were they all this time?) and it seems finally ot the job done. Cost at this point: almost FIFTY MILLION DOLLARS actually about 48.6 million, but what's an extra 1.4 million dollars?) recently asked a high-up analyst in the police department how the SAP mplementation was doing, and they said, Oh - OK I guess - there are till some problems. Thanks for listening- arold Oaks r. PA lark County, WA -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Horacio ellegrino ent: Wednesday, May 23, 2012 12:16 PM o: U2 Users List ubject: Re: [U2] File Sizing using concurrent option AND FAREWELL I remember a company that went bankrupt because they spent so much in AP ( r was it Oracle? ) It was in the news. Anybody? HP On Wed, May 23, 2012 at 3:07 PM, Dawn Wolthuis dw...@tincat-group.comwrote: I have only seen SAP implementations from a bit of a distance and through reading stories, but in every case, my understanding was that those in charge of the project were gone before SAP went live. I have seen systems analysts and programmers survive the project, with plenty of stories once they do. It sounds like a really brutal ERP installation. I have not kept current on this front enough to know that people were still selecting it, although a whole lot of people are still maintaining it. Best wishes, Scott, and thanks for taking the time to write up your notes regarding some of those in the industry who have helped you. Cheers! --dawn On Wed, May 23, 2012 at 1:58 PM, Holt, Jake jh...@samsill.com wrote: I thought no one actually ever finished implementing SAP? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of ggch...@comcast.net Sent: Wednesday, May 23, 2012 1:31 PM To: U2 Users List Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL Don't worry, we're not going to implement anything that's going to o damage. Well, unless you call the outrageous cost a damage :) Any thoughts on the CONCURRENT option? - Original Message - From: Wjhonson
Re: [U2] File Sizing using concurrent option AND FAREWELL
It was a Company in Portland Oregon, here where I live. The Shane Company, a jeweler. Used to run a lot of local radio ads, then the ads suddenly stopped. Turns out they went bankrupt. In bankruptcy proceedings they mainly blamed the costs incurred by the SAP system brought in to replace their in-house customized Universe-based system. The SAP implementation was supposed to cost $8 million, but costs were near $19 million when the company went out of business. I the bankruptcy proceedings the company mainly blamed the SAP implementation. After bankruptcy they resurfaced, which we know as the radio ads came back on a few months ago after being off about a year. However - the ads have stopped again. Perhaps they are just saving advertising dollars for now? Or is it worse? But what really burns me up: I did a google search on this very thing 2 days ago and came across a blogger who was defending SAP, his deal was that the install failure was Shane Company's upper management's fault. G!!! If any company agrees to pay $8 MILLION dollars for a system, the vendor had better provide all the help needed to get the system up and running successfully or that vendor has failed. How about you MV providers, do you ever help the customers do an installation? Or do you take the money and let 'em do the best they can? And if they fail, it's their fault?? I'm just rehashing what I've read. I'd really like to hear from one of the programmers or analysts that worked for the Shane Company when all this happened. Are you out there? An even more damaging a story, if possible, is the implementation of SAP to serve the City of Portland (once again, my home city, but this time it involves my tax dollars). I don't know too many details except that it was supposed to unify 19 separate systems into one, and implementation was to cost about $20 million (already outrageous), but one attempt under an outside SAP implementation specialist failed, a second implementer hired from way out of town also failed, finally SAP themselves came in (where were they all this time?) and it seems finally got the job done. Cost at this point: almost FIFTY MILLION DOLLARS (actually about 48.6 million, but what's an extra 1.4 million dollars?) I recently asked a high-up analyst in the police department how the SAP implementation was doing, and they said, Oh - OK I guess - there are still some problems. Thanks for listening- Harold Oaks Sr. PA Clark County, WA -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Horacio Pellegrino Sent: Wednesday, May 23, 2012 12:16 PM To: U2 Users List Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL I remember a company that went bankrupt because they spent so much in SAP ( or was it Oracle? ) It was in the news. Anybody? HP On Wed, May 23, 2012 at 3:07 PM, Dawn Wolthuis dw...@tincat-group.comwrote: I have only seen SAP implementations from a bit of a distance and through reading stories, but in every case, my understanding was that those in charge of the project were gone before SAP went live. I have seen systems analysts and programmers survive the project, with plenty of stories once they do. It sounds like a really brutal ERP installation. I have not kept current on this front enough to know that people were still selecting it, although a whole lot of people are still maintaining it. Best wishes, Scott, and thanks for taking the time to write up your notes regarding some of those in the industry who have helped you. Cheers! --dawn On Wed, May 23, 2012 at 1:58 PM, Holt, Jake jh...@samsill.com wrote: I thought no one actually ever finished implementing SAP? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of iggch...@comcast.net Sent: Wednesday, May 23, 2012 1:31 PM To: U2 Users List Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL Don't worry, we're not going to implement anything that's going to do damage. Well, unless you call the outrageous cost a damage :) Any thoughts on the CONCURRENT option? - Original Message - From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Wednesday, May 23, 2012 2:14:19 PM Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL Well you used to be. After SAP sucks ten years out of the life of your company, we'll see I am being moved to our corporate office to join a eam of 10 who will be learning, configuring, and customizing SAP to meet the eeds of the best wine and spirits distribution company in the world. Ok, I'm little partial... -Original Message- From: iggchamp iggch...@comcast.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 23, 2012 11:11 am Subject: [U2] File Sizing using concurrent
[U2] Universe 10.2 to 11.1
All: Who has upgraded Universe 10.2 to 11.1? Difficult or not? Costs? Time? More generally, I'm addressing anyone using Universe 11.1 coming from any other place. On their website, Rocket states: UniVerse V11.1 adds powerful high availability, interoperability, administration and security capabilities to the solid extended relational database. EDA (Extended Data Architecture) sounds quite interesting (this is under interoperability): External Database Access (EDA) External database access (EDA) provides the flexibility to store some or all of your data in either UniVerse files or an external database such as Microsoft SQL Server, Oracle and IBM DB2. EDA provides the ability to transparently access and update data from an existing UniVerse application. Graphical tools ease schema mapping and configuration management. Has 11.1 been a happy choice for you? Thanks for any advice and opinions- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.2 to 11.1
Thanks Chris. The link you have is to a user (Tony Gravagno) updating the PE edition. My application is Universe running over hpux so it's a little different setting. I'm looking for anyone who has done 10.2 to 11.1 in that setting (or with o/s linux which would be quite similar). But I think doing the PE11 download is a nice idea and will try it. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Tuesday, March 06, 2012 12:05 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe 10.2 to 11.1 Here is the writeup from one user (who upgraded to 11.1): http://nebula-rnd.com/blog/tech/mv/2011/04/u2upgrade2.html Chris From: cjausti...@hotmail.com To: u2-users@listserver.u2ug.org Date: Tue, 6 Mar 2012 14:03:56 -0600 Subject: Re: [U2] Universe 10.2 to 11.1 Harold, I just did this upgrade about a week ago.. it was super easy. I actually went from 10.1.18 to 11.1.1 and the transition was smooth but there were a couple things to note: 1) Install Universe 11.x under the 'modify' setting. 2) The file paths are diff (c:\ibm\uv vs. c:\u2\uv), so agree to have the files MOVED from one to the other (during install). [make sure permissions allow this on the folder] 3) run UPDATE.ACCOUNT (UniVerse command) in each of the UniVerse accounts, then update the VOC when it asks you to. Cost = 1 day of my time Time = 2 hours (most of the time spent was getting the UniVerse license) 11.1.1 has been perfect for me so far and I have not had 1 hiccup as a result of the upgrade. Here is a writeup done by one user: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Here was my post from the other week: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Chris Date: Tue, 6 Mar 2012 11:34:31 -0800 From: harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10.2 to 11.1 All: Who has upgraded Universe 10.2 to 11.1? Difficult or not? Costs? Time? More generally, I'm addressing anyone using Universe 11.1 coming from any other place. On their website, Rocket states: UniVerse V11.1 adds powerful high availability, interoperability, administration and security capabilities to the solid extended relational database. EDA (Extended Data Architecture) sounds quite interesting (this is under interoperability): External Database Access (EDA) External database access (EDA) provides the flexibility to store some or all of your data in either UniVerse files or an external database such as Microsoft SQL Server, Oracle and IBM DB2. EDA provides the ability to transparently access and update data from an existing UniVerse application. Graphical tools ease schema mapping and configuration management. Has 11.1 been a happy choice for you? Thanks for any advice and opinions- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.2 to 11.1
Thanks - well written! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Tuesday, March 06, 2012 12:21 PM To: U2 Users List Subject: Re: [U2] Universe 10.2 to 11.1 I just went from 10.3.4 on AIX 5.3, to 11.1.4 on Red Hat 6.2 Most of the pain was the operating system conversion and new hardware. The actual Universe stuff was pretty painless. We've only been live for a few days, so I have not had time to play with any new stuff. We had to rebuild our globally cataloged stuff, but, we had the source code. We had to transfer over items from UV.ACCOUNTS file. We had to upgrade all the VOC's, but, they have command line utility that you can write a BASIC program to do that if you want. -The utility is called = /usr/uv/bin/updaccount -Someone on the list had a utility to run this in every account. -I think all you need to do is, loop through the UV.ACCOUNTS file and run this command on every account Oh yes, and then if you have a file called 'ORDER' (I mean, who would write a business application with a file called ORDER!!!- note the sarcasm), then you have to put those file pointers back, because the upgrade utility will wipe them out. Just look in TEMP of the account and you will find the VOC items replaced by the upgrade utility. Oh yeah and then we have to run format.conv on every file and object code to bit swap them from AIX to Linux, but, again, if you aren't changing OS's, you don't need to worry about that. Again, another BASIC program to write. Thats all I can remember, as I haven't slept much in the past week... On Tue, Mar 6, 2012 at 3:05 PM, Chris Austin cjausti...@hotmail.com wrote: Here is the writeup from one user (who upgraded to 11.1): http://nebula-rnd.com/blog/tech/mv/2011/04/u2upgrade2.html Chris From: cjausti...@hotmail.com To: u2-users@listserver.u2ug.org Date: Tue, 6 Mar 2012 14:03:56 -0600 Subject: Re: [U2] Universe 10.2 to 11.1 Harold, I just did this upgrade about a week ago.. it was super easy. I actually went from 10.1.18 to 11.1.1 and the transition was smooth but there were a couple things to note: 1) Install Universe 11.x under the 'modify' setting. 2) The file paths are diff (c:\ibm\uv vs. c:\u2\uv), so agree to have the files MOVED from one to the other (during install). [make sure permissions allow this on the folder] 3) run UPDATE.ACCOUNT (UniVerse command) in each of the UniVerse accounts, then update the VOC when it asks you to. Cost = 1 day of my time Time = 2 hours (most of the time spent was getting the UniVerse license) 11.1.1 has been perfect for me so far and I have not had 1 hiccup as a result of the upgrade. Here is a writeup done by one user: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Here was my post from the other week: http://comments.gmane.org/gmane.comp.db.u2.general/65456 Chris Date: Tue, 6 Mar 2012 11:34:31 -0800 From: harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10.2 to 11.1 All: Who has upgraded Universe 10.2 to 11.1? Difficult or not? Costs? Time? More generally, I'm addressing anyone using Universe 11.1 coming from any other place. On their website, Rocket states: UniVerse V11.1 adds powerful high availability, interoperability, administration and security capabilities to the solid extended relational database. EDA (Extended Data Architecture) sounds quite interesting (this is under interoperability): External Database Access (EDA) External database access (EDA) provides the flexibility to store some or all of your data in either UniVerse files or an external database such as Microsoft SQL Server, Oracle and IBM DB2. EDA provides the ability to transparently access and update data from an existing UniVerse application. Graphical tools ease schema mapping and configuration management. Has 11.1 been a happy choice for you? Thanks for any advice and opinions- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to
[U2] DesignBais Website
I am interested in showing my boss DesignBais and would like to download the trial copy. Unfortunately, when trying to open the website www.designbais.com I see nothing at all, except the message Done, but with errors on the page in a bottom bar. I don't even have a phone# to call because the webpage is blank. Can anyone help me out? At least to inform DesignBais that their web page has a problem. Thanks- Harold Oaks Clark County, WA, USA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DesignBais Website
Thanks to all. I am pretty much restricted to IE here. A co-worker was able to see it fine, so it's something with my particular PC - sorry to bother everyone. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, January 12, 2012 11:47 AM To: U2 Users List Subject: Re: [U2] DesignBais Website Hi Harold, I just tried it with Firefox and was able to get the site up - perhaps they just had a momentary glitch. I couldn't find a phone number anywhere, though, just a support contact form. Regards, Charlie Noah On 01-12-2012 1:38 PM, Oaks, Harold wrote: I am interested in showing my boss DesignBais and would like to download the trial copy. Unfortunately, when trying to open the website www.designbais.com I see nothing at all, except the message Done, but with errors on the page in a bottom bar. I don't even have a phone# to call because the webpage is blank. Can anyone help me out? At least to inform DesignBais that their web page has a problem. Thanks- Harold Oaks Clark County, WA, USA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DesignBais Website
Thanks Tony! I downloaded Chrome and had no problems. Something to do with IE on my PC... Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, January 12, 2012 3:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DesignBais Website I was just there last night to check out the v6 enhancements. The site is all run using DesignBais itself - very clean and lightning fast even overseas. If you're going to do a demo, don't bother installing unless you want to demo the designer. Just run the samples off the live site. BTW, if you click that Done, but with errors on the page message it should show the errors which DBI might want to see, and which might tip you off as to why the page didn't display for you. T From:Oaks, Harold I am interested in showing my boss DesignBais and would like to download the trial copy. Unfortunately, when trying to open the website www.designbais.com I see nothing at all, except the message Done, but with errors on the page in a bottom bar. I don't even have a phone# to call because the webpage is blank. Can anyone help me out? At least to inform DesignBais that their web page has a problem. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] The math just doesn't work.
Running Martin's code on a Universe system, got: (A+B) = C? YOU ROCK A = 4096.9, B = 106.19, (A+B) = 4203.09, C = 4203.09 Interesting - Universe does better than Unidata at this particular task. Harold Oaks Clark County -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, September 29, 2011 6:21 AM To: 'U2 Users List' Subject: Re: [U2] The math just doesn't work. And just to add to Martin's excellent answer - the normal workround for any computer system is to use integral values, scaling and descaling as required. In case you think this is a U2 specific limitation, here's the same in C# as a console app - namespace ConsoleApplication1 { class Program { static void Main(string[] args) { float A = 3176.79f; float B = 106.19f; float C = 3282.98f; float D = 920.11f; A = A + D; C = C + D ; if((A+B) != C ){ Console.WriteLine(You lie, A+B = {0}, C= {1},(A+B), C); } else{ Console.WriteLine(you rock); } pressAnyKey(); } static void pressAnyKey() { Console.Write(Press any key ...); Console.ReadLine(); } } } Result - You lie, A+B = 4203.09, C= 4203.09 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: 29 September 2011 13:46 To: U2 Users List Subject: Re: [U2] The math just doesn't work. Hi George, As a general rule in programming, comparison of floating point values for equality should be avoided. This is because, just as we cannot write the number one third accurately in decimal notation, so the IEEE floating point format used by computer systems cannot store numbers accurately. The example that I use when teaching training courses is 14.2 which actually ends up as something close to 14.197. UniVerse gets around this with a wonderful concept called wide zero that says, when testing for equality of floating point numbers, they must be within some specified value of being equal rather than strictly equal. The default wide zero error tolerance, set in IEEE format with the WIDEZERO configuration parameter, is 2.91 * 10^-11 (2^ 035) which is good for most business applications but occasionally needs adjusting. Unidata has a command, SET.WIDEZERO, to serve the same purpose but defaults to 0.0 for backward comaptibility. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 - Original Message - From: George Hammerle zhamme...@hubert.com To: u2-users@listserver.u2ug.org Sent: Thursday, September 29, 2011 1:30 PM Subject: [U2] The math just doesn't work. Can anybody please help? For some reason A + B does not equal C in the comparison below. Is there any trick to get the comparisons to work properly? Unidata 7.2 on Hp Unix 11+ Top of TEST.COMP in RMH.MAIN, 13 lines, 263 characters. *--: P 001: A = 3176.79 002: B = 106.19 003: C = 3282.98 004: D = 920.11 005: A = A + D 006: C = C + D 007: IF (A+B) # C THEN 008: CRT '(A+B) # C? YOU LIE' 009: CRT 'A = ':A:', B = ':B:', (A+B) = ':(A+B):', C = ':C 010: END ELSE 011: CRT '(A+B) = C? YOU ROCK' 012: CRT 'A = ':A:', B = ':B:', (A+B) = ':(A+B):', C = ':C 013: END Bottom. *--: FIBR Filed TEST.COMP in file RMH.MAIN unchanged. Compiling Unibasic: /db1/ud1/PGM/RMH.MAIN/TEST.COMP in mode 'u'. compilation finished (A+B) # C? YOU LIE A = 4096.9, B = 106.19, (A+B) = 4203.09, C = 4203.09 George Hammerle Programming Dude Hubert Company LLC. 9555 Dry Fork Road Harrison, Ohio 45030 513-367-8974 zhammerle@hubertREMOVE_THIS.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] The math just doesn't work.
Mecki: Oops, that's right - Martin pointed out it would work in Universe - it did. In our uvconfig file the variable setting is WIDE0 3dc0 which is the default value. In case anyone wishes to change the value, note that the WIDE0 variable has an entire appendix devoted to it in the Administering Universe guide. Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, September 29, 2011 8:53 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] The math just doesn't work. You didn't read Martin's answer, or did you? So to what value is WIDEZERO set on your UV system? On 29/09/2011 16:40, Oaks, Harold wrote: Running Martin's code on a Universe system, got: (A+B) = C? YOU ROCK A = 4096.9, B = 106.19, (A+B) = 4203.09, C = 4203.09 Interesting - Universe does better than Unidata at this particular task. Harold Oaks Clark County -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, September 29, 2011 6:21 AM To: 'U2 Users List' Subject: Re: [U2] The math just doesn't work. And just to add to Martin's excellent answer - the normal workround for any computer system is to use integral values, scaling and descaling as required. In case you think this is a U2 specific limitation, here's the same in C# as a console app - namespace ConsoleApplication1 { class Program { static void Main(string[] args) { float A = 3176.79f; float B = 106.19f; float C = 3282.98f; float D = 920.11f; A = A + D; C = C + D ; if((A+B) != C ){ Console.WriteLine(You lie, A+B = {0}, C= {1},(A+B), C); } else{ Console.WriteLine(you rock); } pressAnyKey(); } static void pressAnyKey() { Console.Write(Press any key ...); Console.ReadLine(); } } } Result - You lie, A+B = 4203.09, C= 4203.09 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: 29 September 2011 13:46 To: U2 Users List Subject: Re: [U2] The math just doesn't work. Hi George, As a general rule in programming, comparison of floating point values for equality should be avoided. This is because, just as we cannot write the number one third accurately in decimal notation, so the IEEE floating point format used by computer systems cannot store numbers accurately. The example that I use when teaching training courses is 14.2 which actually ends up as something close to 14.197. UniVerse gets around this with a wonderful concept called wide zero that says, when testing for equality of floating point numbers, they must be within some specified value of being equal rather than strictly equal. The default wide zero error tolerance, set in IEEE format with the WIDEZERO configuration parameter, is 2.91 * 10^-11 (2^ 035) which is good for most business applications but occasionally needs adjusting. Unidata has a command, SET.WIDEZERO, to serve the same purpose but defaults to 0.0 for backward comaptibility. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 - Original Message - From: George Hammerlezhamme...@hubert.com To:u2-users@listserver.u2ug.org Sent: Thursday, September 29, 2011 1:30 PM Subject: [U2] The math just doesn't work. Can anybody please help? For some reason A + B does not equal C in the comparison below. Is there any trick to get the comparisons to work properly? Unidata 7.2 on Hp Unix 11+ Top of TEST.COMP in RMH.MAIN, 13 lines, 263 characters. *--: P 001: A = 3176.79 002: B = 106.19 003: C = 3282.98 004: D = 920.11 005: A = A + D 006: C = C + D 007: IF (A+B) # C THEN 008: CRT '(A+B) # C? YOU LIE' 009: CRT 'A = ':A:', B = ':B:', (A+B) = ':(A+B):', C = ':C 010: END ELSE 011: CRT '(A+B) = C? YOU ROCK' 012: CRT 'A = ':A:', B = ':B:', (A+B) = ':(A+B):', C = ':C 013: END Bottom. *--: FIBR Filed TEST.COMP in file RMH.MAIN unchanged. Compiling Unibasic: /db1/ud1/PGM/RMH.MAIN/TEST.COMP in mode 'u'. compilation finished (A+B) # C? YOU LIE A = 4096.9, B = 106.19, (A+B) = 4203.09, C = 4203.09 George Hammerle Programming Dude Hubert Company LLC. 9555 Dry Fork Road Harrison, Ohio 45030 513-367-8974 zhammerle@hubertREMOVE_THIS.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Stuck getting started with DataVu
Anybody using DataVu? Rocket's free data viewer? I think this is a tool my users might like, if I can only get it to work! But I can't get past a seemingly beginning point... I have created a repository. I can now define a new U2 data source. After entering the server name, Universe login and password, testing that the connection is good, I am then able to pick an account as the data source (The list shown surely comes from the UV.ACCOUNT file). Fine. Seemingly the data source is now defined, call it MyDataSource. The 'repositories' view shows this tree: [-] MyRepository [-] U2 Data Sources [-] MyDataSource [+] Files Now, if I click on the [+] next to Files, I expect it to expand with the available files making use of the VOC file to know what these are. But it simply flashes 'pending' for about 1/2 a second and becomes 'Files' with no [-] or [+] next to it. What step am I missing? Does there need to be some special VOC record created in the account? I am thinking perhaps the JDBC drivers are not known to DataVu, and that is the problem. The documentation states that U2 DataVu does not include JDBC drivers, however it states that one can import the JDBC library settings file. To do this, it says, one clicks on File - Import - Connection and JDBC Library Settings, etc. However! After clicking on File, there is no Import selection available at all in the drop down. (I just hate it when the documentation doesn't match the product!). Has anyone gotten past these issues? Does anyone actually use this product? I might mention that I am also looking at the Web Services product from Rocket. After specifying an account and clicking on Database Files it instantly displays all the available files in the account. Which is good. Thanks- Harold Oaks Clark County IT Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Stuck getting started with DataVu
Jeff: I have one account set up for ODBC access which I know works for ODBC connectivity. Choosing that account makes no difference. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Wednesday, August 24, 2011 9:11 AM To: U2 Users List Subject: Re: [U2] Stuck getting started with DataVu Have you enabled the account you selected for ODBC access? Perry Taylor wrote: I had the very same problem when I last tried it a few weeks ago. Got discouraged and gave up :( Perry - Original Message - From: Oaks, Harold [mailto:harold.o...@clark.wa.gov] Sent: Wednesday, August 24, 2011 11:56 AM To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] Stuck getting started with DataVu Anybody using DataVu? Rocket's free data viewer? I think this is a tool my users might like, if I can only get it to work! But I can't get past a seemingly beginning point... I have created a repository. I can now define a new U2 data source. After entering the server name, Universe login and password, testing that the connection is good, I am then able to pick an account as the data source (The list shown surely comes from the UV.ACCOUNT file). Fine. Seemingly the data source is now defined, call it MyDataSource. The 'repositories' view shows this tree: [-] MyRepository [-] U2 Data Sources [-] MyDataSource [+] Files Now, if I click on the [+] next to Files, I expect it to expand with the available files making use of the VOC file to know what these are. But it simply flashes 'pending' for about 1/2 a second and becomes 'Files' with no [-] or [+] next to it. What step am I missing? Does there need to be some special VOC record created in the account? I am thinking perhaps the JDBC drivers are not known to DataVu, and that is the problem. The documentation states that U2 DataVu does not include JDBC drivers, however it states that one can import the JDBC library settings file. To do this, it says, one clicks on File - Import - Connection and JDBC Library Settings, etc. However! After clicking on File, there is no Import selection available at all in the drop down. (I just hate it when the documentation doesn't match the product!). Has anyone gotten past these issues? Does anyone actually use this product? I might mention that I am also looking at the Web Services product from Rocket. After specifying an account and clicking on Database Files it instantly displays all the available files in the account. Which is good. Thanks- Harold Oaks Clark County IT Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Stuck getting started with DataVu
Thanks Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, August 24, 2011 9:10 AM To: U2 Users List Subject: Re: [U2] Stuck getting started with DataVu Hi Harold, Glad to hear it might be useful to you. There are a bunch of videos available on the U2 DevZone (https://u2devzone.rocketsoftware.com/accelerate/) that could be useful to you; particularly under the 'U2 DataVu Query' section which is immediately under the DataVu 2.0 videos. Let me know if they did help. If not, we can work out what's missing and make sure it is covered! Cheers, Dan McGrath U2 Product Manager Rocket Software 4600 S. Ulster Street **Suite 1100 **Denver, CO 80237 * USA Tel: +1.720.475.8098 * Fax: +1.617.630.7392 Email: dmcgr...@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 Oaks, Harold Sent: Wednesday, August 24, 2011 9:56 AM To: U2 Users List Subject: [U2] Stuck getting started with DataVu Anybody using DataVu? Rocket's free data viewer? I think this is a tool my users might like, if I can only get it to work! But I can't get past a seemingly beginning point... I have created a repository. I can now define a new U2 data source. After entering the server name, Universe login and password, testing that the connection is good, I am then able to pick an account as the data source (The list shown surely comes from the UV.ACCOUNT file). Fine. Seemingly the data source is now defined, call it MyDataSource. The 'repositories' view shows this tree: [-] MyRepository [-] U2 Data Sources [-] MyDataSource [+] Files Now, if I click on the [+] next to Files, I expect it to expand with the available files making use of the VOC file to know what these are. But it simply flashes 'pending' for about 1/2 a second and becomes 'Files' with no [-] or [+] next to it. What step am I missing? Does there need to be some special VOC record created in the account? I am thinking perhaps the JDBC drivers are not known to DataVu, and that is the problem. The documentation states that U2 DataVu does not include JDBC drivers, however it states that one can import the JDBC library settings file. To do this, it says, one clicks on File - Import - Connection and JDBC Library Settings, etc. However! After clicking on File, there is no Import selection available at all in the drop down. (I just hate it when the documentation doesn't match the product!). Has anyone gotten past these issues? Does anyone actually use this product? I might mention that I am also looking at the Web Services product from Rocket. After specifying an account and clicking on Database Files it instantly displays all the available files in the account. Which is good. Thanks- Harold Oaks Clark County IT Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Stuck getting started with DataVu
I JUST found a pdf document which describes DataVu. At the very end it says Please note that a JDBC driver is required in order to access all relational data sources. Drivers are not required for UniData, Universe, and OLAP servers. So it seems the JDBC issue is moot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Wednesday, August 24, 2011 9:24 AM To: U2 Users List Subject: Re: [U2] Stuck getting started with DataVu Jeff: I have one account set up for ODBC access which I know works for ODBC connectivity. Choosing that account makes no difference. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Wednesday, August 24, 2011 9:11 AM To: U2 Users List Subject: Re: [U2] Stuck getting started with DataVu Have you enabled the account you selected for ODBC access? Perry Taylor wrote: I had the very same problem when I last tried it a few weeks ago. Got discouraged and gave up :( Perry - Original Message - From: Oaks, Harold [mailto:harold.o...@clark.wa.gov] Sent: Wednesday, August 24, 2011 11:56 AM To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] Stuck getting started with DataVu Anybody using DataVu? Rocket's free data viewer? I think this is a tool my users might like, if I can only get it to work! But I can't get past a seemingly beginning point... I have created a repository. I can now define a new U2 data source. After entering the server name, Universe login and password, testing that the connection is good, I am then able to pick an account as the data source (The list shown surely comes from the UV.ACCOUNT file). Fine. Seemingly the data source is now defined, call it MyDataSource. The 'repositories' view shows this tree: [-] MyRepository [-] U2 Data Sources [-] MyDataSource [+] Files Now, if I click on the [+] next to Files, I expect it to expand with the available files making use of the VOC file to know what these are. But it simply flashes 'pending' for about 1/2 a second and becomes 'Files' with no [-] or [+] next to it. What step am I missing? Does there need to be some special VOC record created in the account? I am thinking perhaps the JDBC drivers are not known to DataVu, and that is the problem. The documentation states that U2 DataVu does not include JDBC drivers, however it states that one can import the JDBC library settings file. To do this, it says, one clicks on File - Import - Connection and JDBC Library Settings, etc. However! After clicking on File, there is no Import selection available at all in the drop down. (I just hate it when the documentation doesn't match the product!). Has anyone gotten past these issues? Does anyone actually use this product? I might mention that I am also looking at the Web Services product from Rocket. After specifying an account and clicking on Database Files it instantly displays all the available files in the account. Which is good. Thanks- Harold Oaks Clark County IT Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public
Re: [U2] Adding capabilities in the sort term
Thanks to all who responded. This certainly gives me a start! Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Thursday, July 07, 2011 2:02 PM To: U2 Users List Subject: Re: [U2] Adding capabilities in the sort term Hi, We are using HostAccess as our terminal emulator and Verifone's MX870 for the PIN Pad device. We chose to use Verifone's IP Connect product to actually perform the communication with the device. HostAccess provides basic subroutines that will permit you to send the commands to either talk to the MX or their SIM dll. Either way, we receive the signature back and display it on the screen without a problem. The beauty of the way we are doing this is that credit cards never touch our server, and with Verifone's end-to-end encryption no usable credit card information touches the register, which takes both out of scope for PCI DSS, and PCI PA-DSS... depending on your auditor that is. Tom Whitmore, RATEX Business Solutions. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Wednesday, July 06, 2011 2:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] Adding capabilities in the sort term Has anyone done either of the following with a U2 system (we have Universe) and can give me some recommendations? (1) Added a signature pad so that captured signatures can be stored for future use. (We have Print Wizard, so can easily print graphical images if they can just be captured.) (2) Worked with Web Services from within your U2 application? Thanks- Harold Oaks This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Adding capabilities in the sort term
Has anyone done either of the following with a U2 system (we have Universe) and can give me some recommendations? (1) Added a signature pad so that captured signatures can be stored for future use. (We have Print Wizard, so can easily print graphical images if they can just be captured.) (2) Worked with Web Services from within your U2 application? Thanks- Harold Oaks This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ViaDuct problem
Tony, thanks for your insights. Thanks to others too. My end users are criminal justice folks, so indeed a pretty focused audience. Based on that and several other considerations, I'm going to take a hard look at AccuTerm. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, December 28, 2010 10:10 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ViaDuct problem It's sort of weird to see AccuTerm being investigated like it's a newcomer to be compared to SecureCRT. I hope this review will be helpful, by someone who has used them all. Back in the late 80's to early 90's I was a ViaDuct fan. Around 1994 I was introduced to wIntegrate and found it more capable. Around 1995 I was introduced to AccuTerm and I found a permanent home. AccuTerm is quite simply (IMHO) the best terminal emulator in the MV industry. It has a ton of features that every MV developer can appreciate. Just get it and start using it and you'll see what I mean. There is a helpful user forum, a lot of people who know it very well, excellent product support with rapid code changes if required, and you can get AccuTerm GUI training. No matter what you do, you're going to have to get away from ViaDuct, and if you go to anything else there is going to be a lot of conversion effort. This is the price that's paid for building so heavily into a specific product. For better or worse you'd do the same thing with AccuTerm but if you're going to get in deep with any product, this is a reasonable one. While I recommend AccuTerm GUI for a Pick developer who doesn't like to use mainstream tools, I personally don't think it's right business approach for a diverse end-user base. It's thick-client only and connects via Telnet or SSH. That is a fine solution for focused audiences. If you have any interest in an extranet or internet audience where a browser is used, then you may want to invest your time in mainstream tools. Personally I use AccuTerm all the time to get into all MV environments while I'm building browser GUI - these things are not in conflict. AccuTerm does have AccuTerm for Internet Explorer which is a plugin to allow browser users to access your system, but when people say they want a browser UI this isn't what they have in mind. Try it for yourself. I should also mention that the AnzioWin terminal emulator from Rasmussen Software (anzio.com) seems to be a more apples to apples competitor for SecureCRT. I wish I could take all the mainstream features of AnzioWin and mash them up with the MV-specific features of AccuTerm. I actually use both of these products, having used SecureCRT, Putty, and other mainstream options in the past. If you go to PickWiki you'll see other emulators documented, including Winnix which deserves a fair evaluation: http://www.pickwiki.com/cgi-bin/wiki.pl?TerminalEmulators HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno From: Harold.Oaks I've always considered AccuTerm the 'other' main player in the MV terminal emulator market, and thought about going to them but conversion of the programs to use their forms would be a lot of workwheras the code to run Viaduct forms is embedding subroutine calls in the Basic code. That is, they are quite different. Do others have an opinion of AccuTerm versus SecureCRT? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] ViaDuct problem
All: I wouldn't ask the list this question except Via Systems told me they no longer have a programmer on staff so can't answer this question. Does anyone besides me use Viaduct and make use of programming with Visual Data/Basic to manipulate Windows forms? I really like Viaduct and the forms capability, but there is one problem that's driven me crazy for years: after so many calls to the gui capability, a form will simply freeze when a control, for example a button, is clicked. After some sleuthing I know it's that the VTW.RESPONSE routine is looping thru code where it is waiting for End to be returned from the form. Normally this is returned, but when things go haywire it's not returned and the loop spins forever. All is fixed ONLY by rebooting the PC. Nothing else I've found works. This is obviously a real hinderance for the user community. Has anyone seen/solved this problem? Thanks- Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ViaDuct problem
Charlie- Wow - sorry to hear that. Thanks for the info! I've always considered AccuTerm the 'other' main player in the MV terminal emulator market, and thought about going to them but conversion of the programs to use their forms would be a lot of workwheras the code to run Viaduct forms is embedding subroutine calls in the Basic code. That is, they are quite different. Do others have an opinion of AccuTerm versus SecureCRT? Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Monday, December 27, 2010 3:46 PM To: U2 Users List Subject: Re: [U2] ViaDuct problem Harold, I just Googled Via Systems and got this: *Via Systems Inc. has ceased trading.* If you would like information or have enquiries relating to either the UniVision DBMS or ViaDuct Terminal Emulation software, please visit the EDP Website by clicking here http://www.edp.co.uk/index.html. It sounds like they are all but kaput. I suggest you bail ASAP. I know it will be a pain, but it appears inevitable. May I suggest you take a look at SecureCRT? It is a very robust, full-featured emulator, and the folks at VanDyke are extremely competent and helpful. Charlie Noah Charles W. Noah Associates cwn...@comcast.net The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 12-27-2010 5:26 PM, Oaks, Harold wrote: All: I wouldn't ask the list this question except Via Systems told me they no longer have a programmer on staff so can't answer this question. Does anyone besides me use Viaduct and make use of programming with Visual Data/Basic to manipulate Windows forms? I really like Viaduct and the forms capability, but there is one problem that's driven me crazy for years: after so many calls to the gui capability, a form will simply freeze when a control, for example a button, is clicked. After some sleuthing I know it's that the VTW.RESPONSE routine is looping thru code where it is waiting for End to be returned from the form. Normally this is returned, but when things go haywire it's not returned and the loop spins forever. All is fixed ONLY by rebooting the PC. Nothing else I've found works. This is obviously a real hinderance for the user community. Has anyone seen/solved this problem? Thanks- Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] PC setup for to use ODBC
A question for those who have done it- I want to set up ODBC access on user PCs to Universe files for several of my users. The Universe side is all set up. This, of course, requires the ODBC driver be installed on the user's PC when creating the ODBC data source. I have this driver on my personal PC from some time ago, gotten from the very large IBM download that includes UniDK, UniAdmin, and much more. Of course that download from IBM is no longer available. Anybody have simple steps to get the needed driver all loaded on a PC so that the Universe driver is available for setup? I know - this is the lowest form of communication to the Universe files, but I want to give users the option. It's a perception thing mostly, if they see ODBC they think good things. Thanks- Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Printing images
All: In Universe I am able to use PCL commands to customize printing, fonts, spacing, orientation, etc. I'm sure many of you do this. For example by issuing CHAR(27):'(10U':CHAR(27):'(s1p09v0s6b16602T' in front of text the printing is Arial 9 bold. However, I have been unable to figure out how to print images from within Universe. Something to do with 'bit map', but I can't seem to get it. I have a file containing JPG format images. I can copy a record from this file to a windows directory and easily display the image using windows tools. But, how to get the same binary sent to a printer and print that image? Has anyone been able to do this? Thanks! Harold Harold D. Oaks Sr. Analyst/Programmer Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SELECT Statement question
Charles: The select statement will have to be, once all substitutions are made, like this: SELECT X BY PART_NUM WITH PART_NUM LIKE '...G2A...' The inner quotes are required in order to get an exact match on the characters G2A anywhere in the part_num field. Try this on the second line: ECMD := \WITH PART_NUM LIKE '...\ : SELCRIT : \...'\ This makes use of the 3rd way to quote strings, the backslash. It practically exists just for this purpose: to manipulate substrings that themselves have single and double quotes in them. Incidently - Do NOT use SSELECT, use just SELECT. The 'BY' clause will make the sort happen. It's my understanding that using SSELECT pre-sorts the file on @ID which is not at all what you want - it simply wastes processing time. Harold Oaks Clark County IT -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, April 01, 2010 5:54 AM To: U2 Users List Subject: [U2] SELECT Statement question Here's an odd thing, I have an app that allows the user to pass in a select criteria string that is used to find a string containing the select criteria. Like this. ECMD = SSELECT :CP: BY PART_NUM IF SELCRIT '' THEN ECMD := WITH PART_NUM LIKE '...:SELCRIT:...' END EXECUTE ECMD This works fine most of the time, but we just noticed that when the select criteria is G2A, it takes that to mean a G followed with 2 alpha characters, so it matches many more items than desired. Is there a way to force the SELECT to take the criteria as a literal G2A and not as a matching pattern? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TOP/LIMIT Equivalent?
Adrian: Here's a dumb little solution that might work for you if you can run a VOC paragraph (I don't know how your interface to the web application is set up). We have Universe. I make use of the standard line editor ED which I think everybody has. In the VOC file create the two paragraphs PREGET and GETRECS: PREGET is these 3 lines: PA SELECT PRODUCTS BY A1 SAVE.LIST LIST1 GETRECS is these 9 lines: PA DELETE.LIST LIST2 EDIT.LIST LIST2 DATA LOAD LIST1 DATA I2,FROMLINE DATA I3,TOLINE DATA FILE GET.LIST LIST2 LIST PRODUCTS REQUIRE.SELECT First run PREGET. This selects all the records sorted as you wish and creates the saved list LIST1. You only run this once. Now, for each selection range of records desired, you run GETRECS with 2 parameters, fromline and toline. For example: GETRECS 1 100 will display the first 100 records GETRECS 700 725 will display the 700th thru 725th records Of course the final line LIST PRODUCTS REQUIRE.SELECT would display output on the terminal. You'll be doing something else to make the data you wish appear on the website, perhaps using LIST2 as your source for records IDs. Note that REQUIRE.SELECT is necessary in my LIST command to ensure we don't display the entire file if LIST2 is empty. I have a file with about 325000 records. Running PREGET took about 12 seconds. OK, that's a while. But after that, each run of GETRECS was very quick. Even this command: GETRECS 31 300100 took about 1/3 second to start displaying. Harold Oaks Sr. Analyst/Programmer Clark County WA -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Halid Sent: Thursday, February 18, 2010 5:45 PM To: U2 Users List Subject: Re: [U2] TOP/LIMIT Equivalent? If I have a file of 100,000 products and I want to page them in a list of 100 on my website sorted by product name in attribute 1. SELECT PRODUCTS BY A1 This would return me all 100,000 products. So what would be my query when the website loads and I only want the 1st 100 by product name. Then the user would click the Next button to display the 2nd 100 (101, 200). What would be my query then? Would I always have to perform the full select and return 100,000 records and then loop through and only show records 101 to 200. Isn't there a better way so that you only return the 100 records you want to view. Regards Adrian Halid Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P: (08) 9315 7000 F: (08) 9315 7088 E: adrian.ha...@itvision.com.au W: http://www.itvision.com.au ___ NOTICE : This e-mail and any attachments are intended for the addressee(s) only and may contain confidential or privileged material. Any unauthorised review, use, alteration, disclosure or distribution of this e-mail (including any attachments) by an unintended recipient is prohibited. If you are not the intended recipient please contact the sender as soon as possible by return e-mail and then delete both messages. ___ -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Friday, 19 February 2010 9:29 AM To: 'U2 Users List' Subject: Re: [U2] TOP/LIMIT Equivalent? You could save the list, and edit it. But, really, there will be no logical relationship between these records. The 1st hundred is just as random as the 2nd or 3rd hundred, unless your modulus is an extremely ill-advised one. Again, they are hashed records. What we mean by this is that UV will take your item id, extract a numeric equivalent from it (i.e., a238rs45 becomes 23845), then divides by the modulo (a simplification, but reasonably illustrative for our purposes). It takes the resulting remainder (if your modulus was 101, this will be 9), adds 1 (because you can have a remainder of 0), and puts that record into group #10. Unless you know your precise hashing algorithm (which was proprietary, last time I checked), you simply don't know where the record will land. (OK, if you have sequential numeric id's, and you use group.stat.detail to analyze the file, you might be able to predict it, but whatever algorithm you cook up goes out the window if you resize or change the file type, and that's a lot of unnecessary work, anyway). If you want a random sample, use SAMPLE. If you need a logically related group (the last 100 records added, for example), then you should apply selection criteria (SSELECT FILE WITH TIMESTAMP GE BY-DSND TIMESTAMP). The logic is in the data. -Original Message- From: u2-users-boun...@listserver.u2ug.org
Re: [U2] TOP/LIMIT Equivalent?
Andrew: Indeed, the word is 'sample'. The command: SELECT MYFILE SAMPLE 100 will select the first 100 records as they are laid out internally in the file, so this is somewhat a random selection. But many times it's all you want - just get 100 records. The command SELECT MYFILE SAMPLED 100 will select every 100th record to the end of the file, so how many you get back depends on the number of records in the file. This is a better way to get a sampling of data across the entire file. Harold Oaks Sr. Programmer/Analyst County IT Clark County, WA -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E. Tegenkamp Sent: Thursday, February 18, 2010 9:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] TOP/LIMIT Equivalent? In UniVerse, I can't seem to find the syntax like MSSQL's SELECT TOP 100 or MySQL's LIMIT 100 clause. Does UniVerse have this syntax somewhere I'm not seeing in the documentation? I'm just trying to pull out the last 100 records of a table and export them out as a sample. Thanks, Andrew ... Andrew E. Tegenkamp Director, Systems Integration G3 Systems, Inc. P:540.951.4300 F:540.951.4311 http://www.g3.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] hpux to linux
We have Rocket's Universe 10.2 over hpux 11.11 but are considering moving to a linux box. Has anyone ported a U2 app from hpux to linux? I am trying to estimate for management how long such a porting might take. Just an opinion would be helpful, like 'easy', 'medium', 'hard', 'really hard'. Thanks- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Worst Case/Best Case
Outstanding - thanks for the reference on Pickwiki. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthony W. Youngman Sent: Saturday, September 19, 2009 7:22 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Worst Case/Best Case In message d1be4de74846bd499929b632eaec736a0b7c9...@nt102.clark.root.local, Oaks, Harold harold.o...@clark.wa.gov writes Dawn: That wasn't Dawn, it was me, Wol. Where might we find the proof you speak of? Is there a nice, tidy paper somewhere? The Mathematician in me is quite interested. I would be overjoyed to show this to management. Let's start with sets. To a relational database, EVERYTHING is a set. So if your data happens to be a list, or a bag, you can't STORE it in a RDBMS, you have to MODEL it instead. So, instantly, you are mixing data and metadata. BAD MOVE. Now your applications need to know what stuff IN the database is data, and what is metadata. Relational theory says data is two-dimensional. We know it isn't :-) An RDBMS stores data in two-dimensional structures. An MV database stores data in n-dimensional structures. In Maths, the general always trumps the specific - n-dimensional trumps 2-dimensional. But being n-dimensional, we can pretend to be 2-dimensional. Relational can't pretend to be n-dimensional. Look on Pickwiki - http://www.pickwiki.com/cgi-bin/wiki.pl?MVDefinition - that was me - it was an attempt to demolish CD's twelve rules. Have a look and see what you think. I'm quite happy to carry on discussing this - either here, on community, or private email. And I suspect Dawn would like to discuss this to try and get a paper together. The basic problem is that relational *theory* is both *sound*, and *good*. So people assume that RDBMSs are sound and good too. But if you read my article on Pickwiki, it's obvious nothing could be further from the truth. Good maths does not necessarily make good engineering - and RDBMSs are an example of crap engineering. Thanks- Harold Oaks Clark County,WA Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthony W. Youngman Sent: Friday, September 18, 2009 2:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Worst Case/Best Case In message 002a01ca37d4$03bc58b0$0b350a...@com, Symeon Breen syme...@gmail.com writes Just to pick up on one point - I am a .net developer but we use u2 as the data store in a growing business with many new customers every year. It is more a problem with peoples mindset than a problem with u2 technology itself, lets home rocket can tackle this head on. As I KEEP banging on, it's EASY to prove that U2 (and MV in general) is a far better database engine than an RDBMS, we just need to show that to management. Efficiency and relational are NOT compatible, and the maths to prove it is simple. Einstein's corollary to Occam - make it as simple as possible, but no simpler - relational is OVER simplified. Cheers, Wol -- -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Worst Case/Best Case
Dawn: Where might we find the proof you speak of? Is there a nice, tidy paper somewhere? The Mathematician in me is quite interested. I would be overjoyed to show this to management. Thanks- Harold Oaks Clark County,WA -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthony W. Youngman Sent: Friday, September 18, 2009 2:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Worst Case/Best Case In message 002a01ca37d4$03bc58b0$0b350a...@com, Symeon Breen syme...@gmail.com writes Just to pick up on one point - I am a .net developer but we use u2 as the data store in a growing business with many new customers every year. It is more a problem with peoples mindset than a problem with u2 technology itself, lets home rocket can tackle this head on. As I KEEP banging on, it's EASY to prove that U2 (and MV in general) is a far better database engine than an RDBMS, we just need to show that to management. Efficiency and relational are NOT compatible, and the maths to prove it is simple. Einstein's corollary to Occam - make it as simple as possible, but no simpler - relational is OVER simplified. Cheers, Wol -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Universe just quits
David, Henry: In my original testiing it seemed ineffective, with the following occurring if running our menu program in my testing: Your program has aborted from the application Please contact your system administrator Enter Q to log out or any key to continue= Just hitting the Enter key puts you right back into the menu, no actual logout, so it didn't do what we wanted. But, perhaps I was too hasty. Putting AUTOLOGOUT 180 in the LOGIN record in the VOC would implement it each time a user logged in, but how do you set it up globally? Many thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, July 22, 2009 5:20 PM To: 'U2 Users List' Subject: Re: [U2] FW: Universe just quits Harold, Is there any reason you don't use the UV command AUTOLOGOUT to time out idle sessions? It does what you want already from within UV already (and can be setup individually or globally for all UV sessions) and doesn't have the problem of just looking at terminal keyboard input idle time like the UNIX who command does. Regards David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Thursday, 23 July 2009 7:01 AM To: U2 Users List Subject: Re: [U2] FW: Universe just quits Thanks to all who made suggestions. I'm definitely going to use some of them to improve processing. Good news: Universe is not at fault! So why did the process just end? Because a background process we run logs out processes idle for more than 3 hours. To determine idle time we check the 7th column of the output from the unix command who -HTR. Here was the surprise for me: even though the process was furiously performing I/O, as far as that unix command was concerned, it was idle. Oops! Easy to fix that, of course. The best parts of this were that UniVerse came through as more robust than I had worried it wasn't, and that contributors gave me some great advice. Thanks again to all. Harold Oaks ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe just quits
Ross: Interesting idea! I will try it both ways and see which is faster. Thanks so much- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Wednesday, July 22, 2009 6:42 PM To: U2 Users List Subject: Re: [U2] Universe just quits Real Indexing should win - compound key based on wo...@id, index on word and then traverse keys in Basic (or via a select) ... saves having to juggle your own key blocks for larger intersects/more popular words Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, 23 July 2009 1:44 AM To: 'U2 Users List' Subject: Re: [U2] Universe just quits Harold You might want to look at splitting out some of those index records, e.g. where you have 10,000 fields in an index for CRIME, split this into CRIME, CRIME-1, CRIME-2 etc. with a maximum number of entries per index. Otherwise you are not going to get efficient storage at those sizes: if they are in a directory file these can be slow scanning and clashing on the lock table, and of course in a hashed file they will be in out of line overflow - again, slowing access. You can also adopt a scheme where, for example, the first entry in the base record holds the last sequence number of the series, so you don't have to read the intermediate ones when appending.. I realize this will mean changing the search routines, but it might help in the long run. I would also definitely echo what the others have said about sequentially accessing the source descriptions. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 4:54 PM To: U2 Users List Subject: Re: [U2] Universe just quits Barry: Thanks for resonding. The main activity is running thru text files (narratives), identifying the next word then updating a file (DEXNAR) used to cross-reference all the words. For example, in record ABC123 in the narrative field the next identified word is DECOMPOSING. I read the record DECOMPOSING from the DEXNAR file. The record DECOMPOSING has 10 lines in it, because 10 other prior narratives had the word DECOMPOSING. The program seeks the current record key (ABC123) in the fields using the LOCATE command. If not found, the key ABC123 is appended to the end of the DECOMPOSING record and DECOMPOSING it is written out, now with 11 fields. Some of the records in DEXNAR get long as they are for fairly common words, like ALIAS. (The most common words I do not bother to cross-reference, of course, like the word THE). Thus, the LOCATE is looking thru an ever increasing number of fields as we go along. Some records currently have over 11000 fields. Is that the problem? Maybe the sytem tries to 'fit' the next very long record in memory to do the LOCATE and it overflows something? The dropping out, however, occurs normally after updating 25000+ records. Shorter runs seem to 'hold out'. What might be building up in memory space? These are also overnight runs, typically, so there are fewer users to contend with making it unlikely that it's exceeded limits for all users, I would think. The point of the cross-reference file is to allow users to quickly search thru all the 700,000 available (crime) narratives for the ones that match a set of entered search words. Searching that many narratives using brute force would probably take 5+ minutes for each search on our system, which would really stifle the crime analysts. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Tuesday, July 21, 2009 1:03 PM To: U2 Users List Subject: Re: [U2] Universe just quits Can you elaborate a little on these tasks Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 bro...@pny.com - We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner P Before printing please think about your environmental responsibility -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 2:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe just quits I am having a very disconcerting problem. A long job I have been running, processing a large text file and then loading a Universe file, is simply quitting sometimes. No error message of any kind, Universe just
Re: [U2] Universe just quits
Brian: I really like these suggestions and will give it a go. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, July 22, 2009 8:44 AM To: 'U2 Users List' Subject: Re: [U2] Universe just quits Harold You might want to look at splitting out some of those index records, e.g. where you have 10,000 fields in an index for CRIME, split this into CRIME, CRIME-1, CRIME-2 etc. with a maximum number of entries per index. Otherwise you are not going to get efficient storage at those sizes: if they are in a directory file these can be slow scanning and clashing on the lock table, and of course in a hashed file they will be in out of line overflow - again, slowing access. You can also adopt a scheme where, for example, the first entry in the base record holds the last sequence number of the series, so you don't have to read the intermediate ones when appending.. I realize this will mean changing the search routines, but it might help in the long run. I would also definitely echo what the others have said about sequentially accessing the source descriptions. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 4:54 PM To: U2 Users List Subject: Re: [U2] Universe just quits Barry: Thanks for resonding. The main activity is running thru text files (narratives), identifying the next word then updating a file (DEXNAR) used to cross-reference all the words. For example, in record ABC123 in the narrative field the next identified word is DECOMPOSING. I read the record DECOMPOSING from the DEXNAR file. The record DECOMPOSING has 10 lines in it, because 10 other prior narratives had the word DECOMPOSING. The program seeks the current record key (ABC123) in the fields using the LOCATE command. If not found, the key ABC123 is appended to the end of the DECOMPOSING record and DECOMPOSING it is written out, now with 11 fields. Some of the records in DEXNAR get long as they are for fairly common words, like ALIAS. (The most common words I do not bother to cross-reference, of course, like the word THE). Thus, the LOCATE is looking thru an ever increasing number of fields as we go along. Some records currently have over 11000 fields. Is that the problem? Maybe the sytem tries to 'fit' the next very long record in memory to do the LOCATE and it overflows something? The dropping out, however, occurs normally after updating 25000+ records. Shorter runs seem to 'hold out'. What might be building up in memory space? These are also overnight runs, typically, so there are fewer users to contend with making it unlikely that it's exceeded limits for all users, I would think. The point of the cross-reference file is to allow users to quickly search thru all the 700,000 available (crime) narratives for the ones that match a set of entered search words. Searching that many narratives using brute force would probably take 5+ minutes for each search on our system, which would really stifle the crime analysts. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Tuesday, July 21, 2009 1:03 PM To: U2 Users List Subject: Re: [U2] Universe just quits Can you elaborate a little on these tasks Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 bro...@pny.com - We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner P Before printing please think about your environmental responsibility -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 2:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe just quits I am having a very disconcerting problem. A long job I have been running, processing a large text file and then loading a Universe file, is simply quitting sometimes. No error message of any kind, Universe just quits, the session drops into unix. We have Universe 10.2 running over HPux 11.1. I have reduced the job to smaller pieces to get thru it and indicate data values so that I restart at about the dropout point. So I'll be able to finish but I would like to understand what's going on. Anybody seen this kind of thing before? Is there a Universe parameter I should look at? A unix kernal parameter? Any ideas appreciated. Thanks- Harold
Re: [U2] FW: Universe just quits
Thanks to all who made suggestions. I'm definitely going to use some of them to improve processing. Good news: Universe is not at fault! So why did the process just end? Because a background process we run logs out processes idle for more than 3 hours. To determine idle time we check the 7th column of the output from the unix command who -HTR. Here was the surprise for me: even though the process was furiously performing I/O, as far as that unix command was concerned, it was idle. Oops! Easy to fix that, of course. The best parts of this were that UniVerse came through as more robust than I had worried it wasn't, and that contributors gave me some great advice. Thanks again to all. Harold Oaks -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, July 22, 2009 8:14 AM To: U2 Users List Subject: Re: [U2] FW: Universe just quits I'm leaning towards the string too large theory. I'd definitely try this same thing with sequential I/O. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Universe just quits
I am having a very disconcerting problem. A long job I have been running, processing a large text file and then loading a Universe file, is simply quitting sometimes. No error message of any kind, Universe just quits, the session drops into unix. We have Universe 10.2 running over HPux 11.1. I have reduced the job to smaller pieces to get thru it and indicate data values so that I restart at about the dropout point. So I'll be able to finish but I would like to understand what's going on. Anybody seen this kind of thing before? Is there a Universe parameter I should look at? A unix kernal parameter? Any ideas appreciated. Thanks- Harold Oaks Sr. Analyst/Programmer Clark County Information Systems Clark County, Washington ph: (360) 397-6121 x4132 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe just quits
Hi Marc: Curretly I'm doing nothing special with the error handling. I note that errors when running a BASIC program print some error and drop to Universe (TCL) level. However in this situation there is no error displayed and we drop entirely out of Universe, to unix. I can certainly try the ON ERROR clause to see if something gets returned. Thanks--- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marc Hilbert Sent: Tuesday, July 21, 2009 1:16 PM To: U2 Users List Subject: Re: [U2] Universe just quits Are you handling all potential I/O errors in your Basic code (e.g. ON ERROR, ELSE, LOCKED clauses on CLEARFILE, WRITE, READSEQ)? UV will often just drop out of a program if the errors aren't handled. Regards, Marc - Original Message - From: Oaks, Harold harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.org Sent: Tuesday, July 21, 2009 3:41 PM Subject: [U2] Universe just quits I am having a very disconcerting problem. A long job I have been running, processing a large text file and then loading a Universe file, is simply quitting sometimes. No error message of any kind, Universe just quits, the session drops into unix. We have Universe 10.2 running over HPux 11.1. I have reduced the job to smaller pieces to get thru it and indicate data values so that I restart at about the dropout point. So I'll be able to finish but I would like to understand what's going on. Anybody seen this kind of thing before? Is there a Universe parameter I should look at? A unix kernal parameter? Any ideas appreciated. Thanks- Harold Oaks Sr. Analyst/Programmer Clark County Information Systems Clark County, Washington ph: (360) 397-6121 x4132 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe just quits
Barry: Thanks for resonding. The main activity is running thru text files (narratives), identifying the next word then updating a file (DEXNAR) used to cross-reference all the words. For example, in record ABC123 in the narrative field the next identified word is DECOMPOSING. I read the record DECOMPOSING from the DEXNAR file. The record DECOMPOSING has 10 lines in it, because 10 other prior narratives had the word DECOMPOSING. The program seeks the current record key (ABC123) in the fields using the LOCATE command. If not found, the key ABC123 is appended to the end of the DECOMPOSING record and DECOMPOSING it is written out, now with 11 fields. Some of the records in DEXNAR get long as they are for fairly common words, like ALIAS. (The most common words I do not bother to cross-reference, of course, like the word THE). Thus, the LOCATE is looking thru an ever increasing number of fields as we go along. Some records currently have over 11000 fields. Is that the problem? Maybe the sytem tries to 'fit' the next very long record in memory to do the LOCATE and it overflows something? The dropping out, however, occurs normally after updating 25000+ records. Shorter runs seem to 'hold out'. What might be building up in memory space? These are also overnight runs, typically, so there are fewer users to contend with making it unlikely that it's exceeded limits for all users, I would think. The point of the cross-reference file is to allow users to quickly search thru all the 700,000 available (crime) narratives for the ones that match a set of entered search words. Searching that many narratives using brute force would probably take 5+ minutes for each search on our system, which would really stifle the crime analysts. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Tuesday, July 21, 2009 1:03 PM To: U2 Users List Subject: Re: [U2] Universe just quits Can you elaborate a little on these tasks Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 bro...@pny.com - We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner P Before printing please think about your environmental responsibility -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 2:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe just quits I am having a very disconcerting problem. A long job I have been running, processing a large text file and then loading a Universe file, is simply quitting sometimes. No error message of any kind, Universe just quits, the session drops into unix. We have Universe 10.2 running over HPux 11.1. I have reduced the job to smaller pieces to get thru it and indicate data values so that I restart at about the dropout point. So I'll be able to finish but I would like to understand what's going on. Anybody seen this kind of thing before? Is there a Universe parameter I should look at? A unix kernal parameter? Any ideas appreciated. Thanks- Harold Oaks Sr. Analyst/Programmer Clark County Information Systems Clark County, Washington ph: (360) 397-6121 x4132 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 21/7/2009NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http
Re: [U2] Universe just quits
Thanks for the suggestions! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Tuesday, July 21, 2009 2:57 PM To: U2 Users List Subject: Re: [U2] Universe just quits Suggestions: 1. Turn COMO ON before starting the job. This may catch something helpful. 2. Look at the UV error log to try and locate something at the time of the failure 3. How large are your text files? There may be a memory fault above a certain size (we get around that by using OPENSEQ/READSEQ/WRITESEQ) Good luck! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 2:53 PM To: U2 Users List Subject: Re: [U2] Universe just quits Hi Marc: Curretly I'm doing nothing special with the error handling. I note that errors when running a BASIC program print some error and drop to Universe (TCL) level. However in this situation there is no error displayed and we drop entirely out of Universe, to unix. I can certainly try the ON ERROR clause to see if something gets returned. Thanks--- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marc Hilbert Sent: Tuesday, July 21, 2009 1:16 PM To: U2 Users List Subject: Re: [U2] Universe just quits Are you handling all potential I/O errors in your Basic code (e.g. ON ERROR, ELSE, LOCKED clauses on CLEARFILE, WRITE, READSEQ)? UV will often just drop out of a program if the errors aren't handled. Regards, Marc - Original Message - From: Oaks, Harold harold.o...@clark.wa.gov To: u2-users@listserver.u2ug.org Sent: Tuesday, July 21, 2009 3:41 PM Subject: [U2] Universe just quits I am having a very disconcerting problem. A long job I have been running, processing a large text file and then loading a Universe file, is simply quitting sometimes. No error message of any kind, Universe just quits, the session drops into unix. We have Universe 10.2 running over HPux 11.1. I have reduced the job to smaller pieces to get thru it and indicate data values so that I restart at about the dropout point. So I'll be able to finish but I would like to understand what's going on. Anybody seen this kind of thing before? Is there a Universe parameter I should look at? A unix kernal parameter? Any ideas appreciated. Thanks- Harold Oaks Sr. Analyst/Programmer Clark County Information Systems Clark County, Washington ph: (360) 397-6121 x4132 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] English phrases
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] multi-valued extraction
Brenda: One way to pick off only the first four characters in each value is to use !FMTS, one of the dynamic-array handling subroutines. You create an I-type like so in the DICT of first file: 0001: I 0002: SUBR(!FMTS,ONE,4L) 0003: 0004: PICK4 0005: 10L 0006: M If we now type the command LIST FILE_ONE FIELD_ONE PICK4 we get this (made up data of course): FILE_ONEFIELD_ONE.PICK4. BBB XXX YYY ZZZ AAA AAA BBB CCC 2 records listed. You see that the first 4 characters are selected from each value. You said that you wished to use those 4 characters to read another field. Assuming that the other field is the ID field of another file (FILE_TWO), then the I-type could be this: 0001: I 0002: TRANS(FILE_TWO,SUBR(!FMTS,FIELD_ONE,4L),FIELD_IN_FILE_TWO,'X') 0003: 0004: FIELD_IN_FILE_TWO 0005: 15L 0006: M Then each of the PICK4 values, , , etc, are used as IDs for the second file. With my test data, the result is this: FILE_ONEFIELD_ONE.PICK4.FIELD_IN_FILE_TWO. BBB XXX SOME FIELD IN YYY SOME FIELD IN ZZZ SOME FIELD IN AAA AAA SOME FIELD IN BBB SOME FIELD IN CCC SOME FIELD IN Hope this helps. Harold Oaks Clark County, WA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Monday, May 19, 2008 1:24 PM To: u2-users@listserver.u2ug.org Subject: [U2] multi-valued extraction I know I've done this before several times in fact but for some reason, today I just can't get my dict item to work correctly. Field 1 is multivalued with 10 digit ids, I want to extract only the first 4 digits of those ids, then read another field with each of those extracted ids. My dict item works fine until I add the [1,4], then only the first 4 digits of the first 10 digit Id is returned. My co-worker with 25 years plus experience is drawing a blank on this at the moment also. Rec1 = 1154960101:@vm:3456960201:@vm:4565982341 Dict item comes back with 1154 only, instead of 1154, 3456, and 4565. Brenda Price AAC --- 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] U2 - SQL Server ODBC Connection via Universe
Marc: I am just now in the process of evaluating an ODBC-ODBC bridge from the British company Easysoft. There is a 14-day free trial of their products, which is nice. Another product they have is a specific ODBC-SQL driver that might be more efficient for your specific need to connect to SQL Server 2005 than the generic ODBC-ODBC bridge, I don't know. I'll post my results from using the demo in the next week or so. Good luck. Harold Oaks Clark County, WA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caminiti, Marc Sent: Thursday, May 08, 2008 10:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 - SQL Server ODBC Connection via Universe Has anyone had success in setting up a ODBC connection from Universe to MS SQL Server 2005? We are needing to get data imported into SQL Server and I was hoping that there is an easy way for UniVerse to connect to the database and do the inserts on its own. Universe 10.0.9 running on Red Hat 7.3 Thanks in advance Marc Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax Obey gravity, It's the law! --- 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] ICONV(VAR,DB)
Irina: I don't think the B in 'DB' has any effect on internal conversion in Universe. I don't know about UniData - which are you using? We have Universe 10.2. I ran this little program to compare the result after an ICONV using the 'D' and 'DB' conversions: 0001: FOR I = 1000 TO 14731 0002:ODAT = OCONV(I,'D2/') 0003:INTERNAL.D = ICONV(ODAT,'D') 0004:INTERNAL.DB = ICONV(ODAT,'DB') 0005:IF INTERNAL.D # INTERNAL.DB THEN PRINT ODAT,INTERNAL.D,INTERNAL.DB 0006: NEXT I 0007: END If there had been differences after conversion, like your mentioned last day of February, then line 5 in the program would cause a line to display. However when I ran the program, no lines were displayed. That is, every conversion was identical on each date from 09/26/1970 thru 04/30/2008. It appears the first character D tells the compiler to perform a date conversion and the second character is disregarded. Indeed, I changed the 'DB' conversion code to 'DZ', then 'DK', then 'D+' and they all ran the same, no conversion differences were displayed. For OCONV, the output is quite different. For internal date 1, a 'D' conversion yields 18 MAY 1995, a 'DB' conversion yields 05B18B1995 (so the B character is simply used as the separator), and a 'DBW' conversion yields 4 - the day of the week (Thursday). If the first character is illegitimate, the compiler does not catch it, but the conversion fails. I set the conversion to 'ZZ', the compiler did not care, but on every date there was no conversion of the input date. Harold Oaks Clark County -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Irina Lissok Sent: Wednesday, May 07, 2008 1:16 PM To: u2-users@listserver.u2ug.org Subject: RE: [?? Probable Spam] RE: [U2]ICONV(VAR,DB) David, It is possibly valid because it passed the compilation. If it will not pass the compilation we would know it is not valid and just do not consider this conversion. The point is that is probably legitimate conversion because it still works for other date conversion except the last day of February. Irina Lissok -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Murray Sent: Wednesday, May 07, 2008 3:24 PM To: u2-users@listserver.u2ug.org Subject: [?? Probable Spam] RE: [U2]ICONV(VAR,DB) Irina, I do not think that a ICONV conversion code of 'DB' is actually valid. 'DMB', DWB' etc for short codes for month and day respectively are OK. Cheers, David Murray * Learn and do * Excel and share http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Irina Lissok Sent: Wednesday, May 07, 2008 2:21 PM To: u2-users@listserver.u2ug.org Subject: re:[U2]ICONV(VAR,DB) Hey all, We are using ICONV(VAR,'DB') and it works perfectly except one case when the date is the last day of February any year. For instance for VAR=31-MAR-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR=14335 For VAR=28-FEB-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR='' In case VAR=29-FEB-2008 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR='' We tested it with STATUS() and in both cases it returns 0 which is considered as successful conversion. If we are using ICONV(VAR,'D') there is no problem in conversion to internal representation. Is anybody familiar with 'DB' conversion and what the difference between 'DB' and 'D' except the one we've already known it doesn't convert the last day of February? Irina Lissok. --- 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/
[U2] EasySoft ODBC-ODBC bridge
Is anyone using EasySoft's ODBC-ODBC bridge? Do you recommend it or not? Thanks- Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Reading data from an SQL Server Database from Universe
David: Thanks for the info. Very, very nice blog. It seems a 3rd-party software to do the ODBC connection is probably necessary. On the internet I found a site for the company 'easysoft' which advertises such a product. Anyone have experience using it? Thanks- Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Murray Sent: Monday, April 14, 2008 7:37 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Reading data from an SQL Server Database from Universe Harold, I did a similar exercise accessing MySQL from UniVerse. There are a few tricks, see : http://u2blog.org/2007/10/08/universe-odbc-to-mysql/ Cheers, David Murray * Learn and do * Excel and share http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Monday, April 14, 2008 7:43 PM To: u2-users@listserver.u2ug.org Subject: [U2] Reading data from an SQL Server Database from Universe I am simply trying to read data from a SQL Server database into Universe. It's all supposed to be explained in the document BASIC SQL Client Interface Guide, but am missing one key point, it seems... One defines the ODBC data source in the uvodbc.config file. According to the documentation the only information one puts into this parameter file are data source name and dbms type. For example: mysqldb DBMSTYPE = ODBC are two lines in this file. This says the data source name is 'mysqldb' and it's an ODBC type of database. OKfine. That's it! For sources which are Universe databases, one also enters a service type and host. That makes sense. Well - the SQL Server database I am interested in reading is on another server. WHERE do I specify the name of the server and the database name? Is it even possible in Universe to connect to a SQL Server database on another server? Thanks for any help on this. Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- 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] Reading data from an SQL Server Database from Universe {unclassified}
Mike, Sorry I did not specify. We have Universe on unix (hpux to be specific). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Monday, April 14, 2008 6:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Reading data from an SQL Server Database from Universe {unclassified} Harold, If your UniVerse server is Windows, it's not too hard at all:- Install the UniVerse ODBC Client from the U2 Clients CD on your server On the server, do to Start Settings Control panel Administrative Tools Data Sources (ODBC) From the System DSN tab, select Add, choose 'SQL Server', follow the prompts The entry you make in the 'Name' box is the one you put in the uvodbc.config file (instead of mysqldb) If your UniVerse server is *ix, then I think you need a thing called an ODBC-ODBC Bridge which will cost you money and which will need configuring. But I'm on Windows, so ... HTH Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Tuesday, 15 April 2008 11:43 a.m. To: u2-users@listserver.u2ug.org Subject: [U2] Reading data from an SQL Server Database from Universe I am simply trying to read data from a SQL Server database into Universe. It's all supposed to be explained in the document BASIC SQL Client Interface Guide, but am missing one key point, it seems... One defines the ODBC data source in the uvodbc.config file. According to the documentation the only information one puts into this parameter file are data source name and dbms type. For example: mysqldb DBMSTYPE = ODBC are two lines in this file. This says the data source name is 'mysqldb' and it's an ODBC type of database. OKfine. That's it! For sources which are Universe databases, one also enters a service type and host. That makes sense. Well - the SQL Server database I am interested in reading is on another server. WHERE do I specify the name of the server and the database name? Is it even possible in Universe to connect to a SQL Server database on another server? Thanks for any help on this. Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- 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] Reading data from an SQL Server Database from Universe
David: Thanks for your response. We have Universe running on hp's version of unix, hpux. The MS SQL Server is running on a Windows NT-based server. Here is a simple test to see if one is connecting: From Universe TCL one is supposed to be able to issue the CONNECT command: CONNECT data.source [options] where data.source is the name of the source database, naturally. Can that data.source database be an SQL Server database on another server? If so, then there somewhere needs to be a way to say that it resides on the server 'NT99' or whatever, and the database name on that server is 'MySQLdbName'. Another response mentioned 3rd-party software. Perhaps that is required to make this all work... Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:31 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Reading data from an SQL Server Database from Universe Harold, Can you give your environments as this will make the replies easier and more to the point. What is your Universe running on? What is your sql server running on? For my clarification .. you said ... I am simply trying to read data from a SQL Server database into Universe... I am getting from this that you want to connect to a server (MS Sql so on windows?) and simply access data from the server. Not the other way around. I just want to be clear about this as some of the replys don't seem to go this way. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: [U2] Reading data from an SQL Server Database from Universe From: Oaks, Harold [EMAIL PROTECTED] Date: Mon, April 14, 2008 4:43 pm To: u2-users@listserver.u2ug.org I am simply trying to read data from a SQL Server database into Universe. It's all supposed to be explained in the document BASIC SQL Client Interface Guide, but am missing one key point, it seems... One defines the ODBC data source in the uvodbc.config file. According to the documentation the only information one puts into this parameter file are data source name and dbms type. For example: mysqldb DBMSTYPE = ODBC are two lines in this file. This says the data source name is 'mysqldb' and it's an ODBC type of database. OKfine. That's it! For sources which are Universe databases, one also enters a service type and host. That makes sense. Well - the SQL Server database I am interested in reading is on another server. WHERE do I specify the name of the server and the database name? Is it even possible in Universe to connect to a SQL Server database on another server? Thanks for any help on this. Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- 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] Reading data from an SQL Server Database from Universe
I am simply trying to read data from a SQL Server database into Universe. It's all supposed to be explained in the document BASIC SQL Client Interface Guide, but am missing one key point, it seems... One defines the ODBC data source in the uvodbc.config file. According to the documentation the only information one puts into this parameter file are data source name and dbms type. For example: mysqldb DBMSTYPE = ODBC are two lines in this file. This says the data source name is 'mysqldb' and it's an ODBC type of database. OKfine. That's it! For sources which are Universe databases, one also enters a service type and host. That makes sense. Well - the SQL Server database I am interested in reading is on another server. WHERE do I specify the name of the server and the database name? Is it even possible in Universe to connect to a SQL Server database on another server? Thanks for any help on this. Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe failure - why?
Thanks to all who helped. fixtool at unix level has worked very well. Harold Oaks Clark County -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lubin Sent: Tuesday, January 22, 2008 4:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe failure - why? This could be happening because there is an error on the file or on one of the associated indices. We had that error a couple of times. To fix, we either rebuilt the indices or ran fixtool (at unix) to check if the file needs to be fixed. We also had that error if there is something wrong with the key (eg control character or @VM, @SM) Rgds Bernard Lubin Development Department Reynolds and Reynolds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Wednesday, 23 January 2008 10:39 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe failure - why? Can anybody help determine what to do about this error? Hashdata = 490657843 Infohtype32=20, infosplit32=80, infomerge32=50 Infocurmod=80, infofilesp=66D80, infolargerec=651 Infonsplit=80, infobasemod=80 Contact Customer Support Immediately!!! CRITICAL ERROR! Notify the system administrator. Abnormal termination of Universe. Fault type is 10. Layer type is BASIC run machine. Fault occurred in BASIC program APPRISSP at address 121e. .profile[20]: 11947 Memory fault The offending instruction in the program APPRISSP is just a write of a record to a file. How does this make Universe blow up? Any help appreciated. Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- 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] Universe failure - why?
Can anybody help determine what to do about this error? Hashdata = 490657843 Infohtype32=20, infosplit32=80, infomerge32=50 Infocurmod=80, infofilesp=66D80, infolargerec=651 Infonsplit=80, infobasemod=80 Contact Customer Support Immediately!!! CRITICAL ERROR! Notify the system administrator. Abnormal termination of Universe. Fault type is 10. Layer type is BASIC run machine. Fault occurred in BASIC program APPRISSP at address 121e. .profile[20]: 11947 Memory fault The offending instruction in the program APPRISSP is just a write of a record to a file. How does this make Universe blow up? Any help appreciated. Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] A few simple questions
I am a fairly new Universe user. We are running on hpux 10.2 I have several questions, but only one here- I know the MASTER OFF command can be used to log out a user, i.e. MASTER OFF 132 logs off user 132. The on-line help says one must be a Universe Administrator to run this command, and be in the home account for Universe. However, in ...ibm/uv/bin the file 'master' which is executed by this command has owner root and permissions are set to rwx--. In other words, only root can execute this command on our system and logging in as uvadm is not good enough. Is this typical for you Universe users? Or did you change the permissions on this executable? Is there some other way uvadm can log out users? Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] user IDs
Is there a Universe command to show all those logged in with their user ID? I can run UniAdmin to find this out, of course, but the users can't. What simple unix or Universe command will return this information? Thanks! Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] select statement with single quotes
Charlie: One can always write a program to select the records, of course. It's just that there's not a convenient built in SELECT command that seems to work. Using an I-type tied to a subroutine will work (I am in Universe): Write the subroutine FSQ (Find Single Quote): SUBROUTINE FSQ(RESULT,X) IF INDEX(X,',1) THEN RESULT = 1 END ELSE RESULT = 0 END RETURN END Compile and catalog this. Now create an I-type in your CUSTFILE DICT, I will call it NQCNT: 0001: I 0002: SUBR('FSQ',@ID) 0003: 0004: 0005: 2R 0006: S 0007: Compile the I-type of course. Then, the command LIST CUSTFILE NAME NQCNT produces: CUSTFILENAMENQCNT 6 JOHN'S RESTAURANT 1 2 HOWARD JOHNSONS 0 3 LOU'S BAR 1 4 STANDARD PLACE 0 5 STARBUCKS 0 You can see that NQCNT is 1 if there is a single quote in the name, so you can select those records with the TCL command: SELECT CUSTFILE WITH NQCNT = 1. Harold Oaks Clark County, WA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Rubeor Sent: Friday, October 12, 2007 11:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] select statement with single quotes I didn't want to jump the gun and call it a bug, but it certainly looks like one to me. This was just the easiest example to document. If you have a customer with a name of Lou's Bar and Grill the following select statement will not select it: SELECT CUSTOMER WITH NAME = [Lou's] I tried all of the suggestions that have been posted, with no luck. My current work around is to replace the single quote with the single character wild card, like this: SELECT CUSTOMER WITH NAME = [Lou^s] Unfortunately, that also selects any customer with a name of Louis. -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- Bill Haskett [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/12/2007 01:40 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject RE: [U2] select statement with single quotes This bug also exists in UniData! Also, when you get the... Enter New line to continue... ...question at the end of a page of missing quote:...'... errors, you can't enter 'Q' to quit! You have to [Ctrl]+C to quit. I tried in both Pick and UniData modes with no success. This select statement works fine in D3. I couldn't check jBase or QM though. On a side note, it never ceases to amaze me that this anachronistic end of page comment is still around. Hasn't it been thirty years since a [New Line] key existed on any keyboard? :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Friday, October 12, 2007 8:30 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] select statement with single quotes Have you tried using the LIKE option? SELECT CUSTOMER WITH NAME LIKE ...'... -Original Message- From: Charlie Rubeor [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 10:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] select statement with single quotes Unidata 6.1, this statement fails. :SELECT CUSTOMER WITH NAME = ['] missing quote:...'''... . . . There are no indices on the file and it is not only related to the CUSTOMER file. Any filename and field will result in the same error message. For example, SELECT VENDOR WITH ADDRESS = ['] results in the same message. Is this a known issue? More importantly, is there an option or setting that I can change to fix it? -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: SAPUG Meeting September 20th (was: Re: [U2] User Groups)
Larry: Can I get authorization to attend this meeting? The afternoon session is at 3pm, so I would need to leave about noon driving to get there on time. Session cost is $35, plus mileage of course. I could take care of my dinner if needed. Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Morrissey Sent: Thursday, September 13, 2007 10:42 AM To: u2-users@listserver.u2ug.org Subject: SAPUG Meeting September 20th (was: Re: [U2] User Groups) Speaking of User Groups... If you're in the Northwest, you definitely want to attend the next SAPUG - Seattle Area Pick User Group meeting next Thursday September 20th. We're going to hear details about the most ambitious UV project I know of from Steve Ritchie of Market America: Join Steve Ritchie, VP of R/D and founding member of Market America to hear about how Universe is being in numerous unique ways to run their company as well as their growth financially and the steady buildup of their IT department. Steve will talk about challenges with rolling out a truly massive UniVerse project and about how the power of UniVerse has helped propel Market America to a billion dollar company in 5 countries. This is the project that elicited gasps at the U2UG Meeting at last year's Cincinnati Spectrum show. Our afternoon session will feature a technology preview from MITS looking at some of the technology underlying the advanced features in the next releases of MITS Discover and MITS Report. Special thanks to MITS for making their expertise available and underwriting this meeting. For details, see http://www.sapug.org and make sure to RSVP soon. Thanks, Ross VP Events - SAPUG --- 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] Binary data corruption on copy
Thanks to all who wrote about this problem. The simplest solution - that of simply copying the JPG files to one type 19 directory - is working, to my amazement. There are 171,000 mugshots in one directory and they are being handled correctly. As far as a solution goes, that's good enough. However, Craig's technical example regarding conversion was worth pursuing. I forgot to mention that there are two steps: storing the JPG record into the file, then copying it back out to a directory. Once it's out I can use it. Simply, the record has to go in and out of the Universe dynamic file intact. I mimicked the code Craig supplied then wrote a corresponding program to copy the record out. Since the code used OCONV before storing, I guessed ICONV would be the choice when reading form the universe dynamic file: ASSIGN 1 TO SYSTEM(1017) OPEN 'TARGETFILE' TO TFT ELSE STOP ;* open the uv dyn file of jpg recs OPEN 'MYDIR' TO MYDIR ELSE STOP ;* open a type 19 file READ JPGREC FROM TFT,'1234.JPG' ELSE STOP OUTREC = ICONV(JPGREC,MX0C) WRITE OUTREC TO MYDIR,'1234.JPG' END This works! So either solution will work. Harold Oaks Sr. Analyst/Programmer Clark County, WA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Tuesday, August 21, 2007 5:22 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Binary data corruption on copy Hi Harold, if I were doing this on UV I would do the following (inelegant error handling but its just an example :): If 1234.jpg is in a UV type 19 file: OPEN SOURCEFILE TO SFT ELSE STOP ASSIGN 1 TO SYSTEM(1017) ;* UV Specific - disables conversion of CRLF to @AM on reading which damages your binary data READ JPG FROM SFT, 1234.jpg ELSE STOP OPEN TARGETFILE TO TFT ELSE STOP * Choose one of the following options to encode your data before storing * 1: Hex Conversion - exactly doubles the size of the file TDAT = OCONV(JPG, MX0C) * 2: Base64 conversion - slower but more space (33% size increase). ERRCDE = ENCODE(Base64, 1, JPG, 1, TDAT, 1) WRITE TDAT ON TFT ELSE STOP hth, Craig Oaks, Harold wrote: Dave- Of course, unidata may be different than universe in its file structure. However, I would like to try what you do. How do you do that hex conversion? What is the next step? For example, I have 1234.jpg at unix level. What specifically do you do to get that into your unidata file? Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis Sent: Tuesday, August 21, 2007 10:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Binary data corruption on copy That $ trick is probably specific to pi/open. I normally convert this kind of file to hex before storing in unidata. If there's a better way, I would like to know about it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Tuesday, August 21, 2007 1:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Binary data corruption on copy A question for the group: I have JPG format records which I wish to copy from unix level into a Universe file but am having trouble with it getting 'corrupted' during the copy. We are converting from pi/open to universe. I can do this business in pi/open by changing the name of the source file, prepending it with a $, then copying at TCL level into the pi/open file. For example, if the record at unix level is named 1234.jpg and is in the directory SOURCE I run this command at unix level: mv 1234.jpg \$1234.jpg which changes the name. Now at TCL level in pi/open I can issue the command COPY FROM SOURCE TO IMAGE_FILE $1234.jpg After that, I can change the name back within the pi/open file: CNAME IMAGE_FILE $1234.jpg 1234.jpg and the copy is complete. Pi/open knows that if the record name starts with a dollar sign that it is binary and should not be changed. Once the copy from a unix directory into the pi/open dynamic file is done I can use it successfully. In Universe I attempt to do the same thing. The 1234.jpg name is changed to $1234.jpg and then copied into the Universe file UNIV_IMAGE_FILE, a dynamic (type 30) file. But it doesn't work very well - the image is corrupted, the binary file was messed with during the copy. I know the jpg record is intact before I start the copying. I wouldn't need to bother with a copy to a Universe file, in fact, except that we have over 130,000 images now and I can't believe a unix directory could successfully handle that many records. Any suggestions on copying so that the binary remains intact? Thanks- Harold Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please
[U2] Binary data corruption on copy
A question for the group: I have JPG format records which I wish to copy from unix level into a Universe file but am having trouble with it getting 'corrupted' during the copy. We are converting from pi/open to universe. I can do this business in pi/open by changing the name of the source file, prepending it with a $, then copying at TCL level into the pi/open file. For example, if the record at unix level is named 1234.jpg and is in the directory SOURCE I run this command at unix level: mv 1234.jpg \$1234.jpg which changes the name. Now at TCL level in pi/open I can issue the command COPY FROM SOURCE TO IMAGE_FILE $1234.jpg After that, I can change the name back within the pi/open file: CNAME IMAGE_FILE $1234.jpg 1234.jpg and the copy is complete. Pi/open knows that if the record name starts with a dollar sign that it is binary and should not be changed. Once the copy from a unix directory into the pi/open dynamic file is done I can use it successfully. In Universe I attempt to do the same thing. The 1234.jpg name is changed to $1234.jpg and then copied into the Universe file UNIV_IMAGE_FILE, a dynamic (type 30) file. But it doesn't work very well - the image is corrupted, the binary file was messed with during the copy. I know the jpg record is intact before I start the copying. I wouldn't need to bother with a copy to a Universe file, in fact, except that we have over 130,000 images now and I can't believe a unix directory could successfully handle that many records. Any suggestions on copying so that the binary remains intact? Thanks- Harold Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Binary data corruption on copy
Dave- Of course, unidata may be different than universe in its file structure. However, I would like to try what you do. How do you do that hex conversion? What is the next step? For example, I have 1234.jpg at unix level. What specifically do you do to get that into your unidata file? Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis Sent: Tuesday, August 21, 2007 10:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Binary data corruption on copy That $ trick is probably specific to pi/open. I normally convert this kind of file to hex before storing in unidata. If there's a better way, I would like to know about it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Tuesday, August 21, 2007 1:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Binary data corruption on copy A question for the group: I have JPG format records which I wish to copy from unix level into a Universe file but am having trouble with it getting 'corrupted' during the copy. We are converting from pi/open to universe. I can do this business in pi/open by changing the name of the source file, prepending it with a $, then copying at TCL level into the pi/open file. For example, if the record at unix level is named 1234.jpg and is in the directory SOURCE I run this command at unix level: mv 1234.jpg \$1234.jpg which changes the name. Now at TCL level in pi/open I can issue the command COPY FROM SOURCE TO IMAGE_FILE $1234.jpg After that, I can change the name back within the pi/open file: CNAME IMAGE_FILE $1234.jpg 1234.jpg and the copy is complete. Pi/open knows that if the record name starts with a dollar sign that it is binary and should not be changed. Once the copy from a unix directory into the pi/open dynamic file is done I can use it successfully. In Universe I attempt to do the same thing. The 1234.jpg name is changed to $1234.jpg and then copied into the Universe file UNIV_IMAGE_FILE, a dynamic (type 30) file. But it doesn't work very well - the image is corrupted, the binary file was messed with during the copy. I know the jpg record is intact before I start the copying. I wouldn't need to bother with a copy to a Universe file, in fact, except that we have over 130,000 images now and I can't believe a unix directory could successfully handle that many records. Any suggestions on copying so that the binary remains intact? Thanks- Harold Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- 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] Users of UniVerse
Clark County, Washington, Jail system and 911 system uses PI/open, but we are converting this summer to UniVerse (at last!). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Liesse, Dave Sent: Friday, April 27, 2007 6:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] Users of UniVerse Hi, all. My sales group has a need to convince some prospects that real companies do, indeed, use UniVerse. Naturally and logically, there are no references on the IBM web site. I've been tasked with coming up with the names of a few UniVerse users - no contacts, just companies. If any of you is willing to let it be known that your employer uses UV, please respond as soon as possible. Of course, this was a last-minute request, so I don't have time to go through the normal channels to get reference lists. Again, I emphasize that we're NOT looking for contact information, and it's doubtful anyone will even think of trying to get in touch with you; we're just facing the usual concern that UV is a minor product at which real companies turn up their noses and sniff haughtily before they go off and use a real system like SQL Server. Dave Liesse Quality Manager SSC Technologies, Inc. --- 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] Trying to run UniAdmin with PE`
Bill: Thanks for the hints! I can connect thru telnet localhost in DOS just fine. No other instances of U2 or other MV dbms. I have UniAdmin 1.2.0. Anyone know if that is current? No Zone alert. Did not consider #4 below when installing Universe 10.2. I can type netstat -an and see TCP and UDP stuff, but I don't know what it means. What am I looking for? Defining the connection in UniAdmin to be localhost (it works at DOS) I continue to get the dreaded No RPC connection active. Please, do you have the four services running? Or just 3 like I see: universe uvtelnet unirpc The older version I had of Universe had also this service: hsrexec I wonder if an older UniAdmin is looking for hsrexec and, of course, not finding it. Thanks to all who have sent in ideas. Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H Sent: Thursday, April 05, 2007 9:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Trying to run UniAdmin with PE` A couple of things I'd look at: 1) Are you on a domain? 2) Do you have another instance of U2 or other MV dbms running? 3) Do you have an older version of UniAdmn installed? 4) Did you install UV with your anti-virus and/or anti-spyware software disabled? 5) Are you using Zone Alarm? 6) When you telnet localhost from a DOS window what happens? 7) What does the results of netstat -an show? I've installed UV, UD, and UniAdmin on my laptop numerous times and rarely had problems. The last problem was when I had UV 10.1 installed and it expired, thus causing UniAdmin barf. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Thursday, April 05, 2007 7:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Trying to run UniAdmin with PE` Brenda Price wrote: snip I hadn't tried it use it for a while until last night. I am assuming something I installed (Earthlink Total Access, or updates to Norton security, or updates from Microsoft) after the last time I used UniVerse UniAdmin has screwed it up. I get an error saying port 23 is used by another program. This was the error that I was originally getting before the motherboard and hard drive were replaced. Windows telnet was disabled, just for grins I enabled it to see if that helped, it did not. snip You might want to check out Active Ports, a windows application that will help you figure out what process is using port 23. Here's a link: http://www.download.com/3000-2085-10062969.html -- Allen Egerton aegerton at pobox dot com --- 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] Trying to run UniAdmin with PE`
Bill: That did it. I de-installed everything, then re-downloaded the huge IBM download file (.44GB) and re-installed. The current UniAdmin is ver 1.3. I have learned quite a bit today. Thanks! Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H Sent: Thursday, April 05, 2007 11:37 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Trying to run UniAdmin with PE` Harold: First, you should probably uninstall UniAdmin and any other older U2 client software you have (unless you need it). Then reinstall the new version that comes with UV 10.2 (Try just installing UniAdmin first). Make sure you turn off your AV/Aspyware software first. I believe the most recent version of UniAdmin is 1.3. The reason you want to telnet to localhost is to verify UV is running, along with UV telnet on port 23 (the default port). I only have the same three services running on UV: + Resource Service + Telnet Service + UniRPC Service My netstat shows: C:\Documents and Settings\wphaskettnetstat -a | more Active Connections Proto Local Address Foreign AddressState TCPasibill:telnet asibill:0 LISTENING TCPasibill:31438 asibill:0 LISTENING TCPasibill:2940 localhost:31438ESTABLISHED C:\Documents and Settings\wphaskettnetstat -an | more Active Connections Proto Local Address Foreign AddressState TCP0.0.0.0:23 0.0.0.0:0 LISTENING TCP0.0.0.0:31438 0.0.0.0:0 LISTENING TCP127.0.0.1:31438127.0.0.1:2940 ESTABLISHED Port 31438 is the UniAdmin port. I've made a connection from my machine to UV on my machine via localhost. You should make sure UV is properly licensed as I've experienced the RPC service not responsive without proper licensing. The UV license I have is valid throuh 31 Mar 2008 (see UV control panel). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Thursday, April 05, 2007 10:32 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Trying to run UniAdmin with PE` Bill: Thanks for the hints! I can connect thru telnet localhost in DOS just fine. No other instances of U2 or other MV dbms. I have UniAdmin 1.2.0. Anyone know if that is current? No Zone alert. Did not consider #4 below when installing Universe 10.2. I can type netstat -an and see TCP and UDP stuff, but I don't know what it means. What am I looking for? Defining the connection in UniAdmin to be localhost (it works at DOS) I continue to get the dreaded No RPC connection active. Please, do you have the four services running? Or just 3 like I see: universe uvtelnet unirpc The older version I had of Universe had also this service: hsrexec I wonder if an older UniAdmin is looking for hsrexec and, of course, not finding it. Thanks to all who have sent in ideas. Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H Sent: Thursday, April 05, 2007 9:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Trying to run UniAdmin with PE` A couple of things I'd look at: 1) Are you on a domain? 2) Do you have another instance of U2 or other MV dbms running? 3) Do you have an older version of UniAdmn installed? 4) Did you install UV with your anti-virus and/or anti-spyware software disabled? 5) Are you using Zone Alarm? 6) When you telnet localhost from a DOS window what happens? 7) What does the results of netstat -an show? I've installed UV, UD, and UniAdmin on my laptop numerous times and rarely had problems. The last problem was when I had UV 10.1 installed and it expired, thus causing UniAdmin barf. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Thursday, April 05, 2007 7:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Trying to run UniAdmin with PE` Brenda Price wrote: snip I hadn't tried it use it for a while until last night. I am assuming something I installed (Earthlink Total Access, or updates to Norton security, or updates from Microsoft) after the last time I used UniVerse UniAdmin has screwed it up. I get an error saying port 23 is used by another program. This was the error that I was originally getting before the motherboard and hard drive were replaced. Windows telnet was disabled, just for grins I enabled it to see if that helped, it did not. snip You might want to check out Active Ports, a windows application that will help you figure out what process is using port 23. Here's a link: http://www.download.com/3000-2085-10062969.html -- Allen Egerton aegerton at pobox dot com --- 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
[U2] Trying to run UniAdmin with PE`
Looking for help - I have downloaded Universe PE 10.2, replacing an earlier version or PE. I am unable to get UniAdmin to connect despite many combinations of attempts. One thing I find curious is that, with the latest download, the number of services has dropped from four to three . and I wonder if this is somehow related. From release notes in readme.txt, one can start the services from DOS, like so: net start universe net start unirpc net start uvtelnet net start hsrexec The last one does not work, claiming no such service. Universe Control also shows only the first three. Perhaps at 10.2 the last service is dropped deliberately (even if the notes don't reflect that). I don't really care, but I do want to run UniAdmin against the installed PE database to practice using it. My PC is networked on an NT network. I believe we use LAN manager. To start, one must define a connection in UniAdmin. One must fill in boxes for (1) Server Name (2) Transport Type (of course I click the Universe Radio button) I have tried localhost() for Server Name, the default 127.0.0.1 IP address which should mean the current PC, and my network IP address as well, and the specific string localhost() For Transport Type I have tried them all - Default, TCP/IP, and LAN manager Then, clicking on the created connection, I attempt to log in. One must enter (1) Login ID (2) Password The only combination I know is my NT login and password. I get one of two error messages: If I specify localhost() the error is the host name is not valid, or the host is not responding. If I specify any one of the other connections, the error is No RPC connection active. Any suggestions from anyone who has successfully gotten UniAdmin running against Universe PE is much appreciated. Thanks- Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 [demime 1.01d removed an attachment of type image/gif which had a name of Citrus Punch Bkgrd.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Spam:RE: [U2] Trying to run UniAdmin with PE`
Brenda: I'll look forward to that, as will a few others! Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Wednesday, April 04, 2007 1:02 PM To: u2-users@listserver.u2ug.org Subject: RE: Spam:RE: [U2] Trying to run UniAdmin with PE` I have but I do not have my laptop with me. There was something strange I had to do with the server name. I've forwarded this to my home email and when I get home will look at the setting and reply with what I had to do. Hopefully, by then someone else will have given you the answer. Brenda Price Affiliated Acceptance Corporation -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 1:02 PM To: u2-users@listserver.u2ug.org Subject: Spam:RE: [U2] Trying to run UniAdmin with PE` Harold D. Oaks asked: Any suggestions from anyone who has successfully gotten UniAdmin running against Universe PE is much appreciated. Not only have I not gotten UniAdmin working against Universe PE (on the same box), once Universe PE is installed UniAdmin doesn't work for Unidata PE either. I'd love to know the fix for this one also. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- 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: Spam:Re: [U2] Trying to run UniAdmin with PE`
Joe: Any called subroutine needs to be cataloged. Also, the number of arguments in the call needs to match the number of parameters expected by the called subroutine or you will get an error. The way you have it below you are sending one parameter every time, using the variable RESPONSE, so the called subroutine must have only one parameter as well. Perhaps all the called programs could be changed to expect one parameter, but that parameter could have multiple values separated by something or other (e.g. value mark, comma, vertical bar, something that won't be in the data). Harold Oaks Clark County, WA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joseph Ruiz Sent: Wednesday, April 04, 2007 2:58 PM To: u2-users@listserver.u2ug.org Subject: RE: Spam:Re: [U2] Trying to run UniAdmin with PE` Does anyone know how to call a program with '@'? I received an error when testing the code below: 0001: OPEN JAR.BP TO JAR.BP.FILE ELSE ABORT JAR.BP 0002: DEBUG 0003: READV SUBS FROM JAR.BP.FILE, SUBS, 1 ELSE GOTO 999 0004: NO.OF.SUBS = DCOUNT(SUBS,@VM) 0005: FOR XXX = 1 TO NO.OF.SUBS 0006: SUB.TO.CALL = SUBS1,XXX 0007: CALL @SUB.TO.CALL(RESPONSE) 0008: CRT RESPONSE 0009: NEXT XXX 0010: 999: STOP 0011:END SUBS is a record that contains subroutine names that I would like to call. Also, do the programs that are used in these types of calls need to be cataloged? I am using universe. Thanks Joe --- 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] Calculate age from date of birth
Dom: Use my routine posted earlier, but insert the target date instead of date(): Suppose variable DOB holds the date of birth in internal format. Suppose TARGET is the 'as of' date in internal format also. DOBX = OCONV(DOB,'D4/') DOB.YR = DOBX[7,4] DOB.DA = DOBX[4,2] DOB.MO = DOBX[1,2] TARGETX = OCONV(DATE(),'D4/') TARGET.YR = TARGETX[7,4] TARGET.DA = TARGETX[4,2] TARGET.MO = TARGETX[1,2] AGE = TARGET.YR - DOB.YR * We will subtract 1 from age if the 'now' month day is earlier in the * year than the 'dob' month day, otherwise not IF TARGET.MO DOB.MO THEN AGE = AGE - 1 END ELSE IF TARGET.MO = DOB.MO AND TARGET.DA DOB.DA THEN AGE = AGE - 1 END END * The variable AGE now holds their age as of the target date. Harold Oaks Sr. Programmer/Analyst Clark County, WA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darren Macdonald Sent: Wednesday, January 17, 2007 4:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Calculate age from date of birth Perhaps a better way to do this would be to calculate a 'born before date'. This may save on processing time as well... So, everyone born before 17/01/1942 is 65 or older. HTH Darren -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dominion Sent: 16 January 2007 21:05 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Calculate age from date of birth Hi, Could anyone tell me how I can calculate someones age from their date of birth at a specific point in time? ie, age at 6 April 2006 if their date of birth is 12 October 1967. Thanks, Dom -- View this message in context: http://www.nabble.com/-UV--Calculate-age-from-date-of-birth-tf3023501.ht ml#a8398858 Sent from the U2 - Users mailing list archive at Nabble.com. --- 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] RE: [UV] Calculate age from date of birth
For age in whole years, this is pretty easy, just subtract the DOB year from the current year to get age, but if the current month and day are earlier in the year than the date of birth month and day, subtract 1 from the age. Suppose variable DOB holds the date of birth in internal format. This code will give you the age today: DOBX = OCONV(DOB,'D4/') DOB.YR = DOBX[7,4] DOB.DA = DOBX[4,2] DOB.MO = DOBX[1,2] NOWX = OCONV(DATE(),'D4/') NOW.YR = NOWX[7,4] NOW.DA = NOWX[4,2] NOW.MO = NOWX[1,2] AGE = NOW.YR - DOB.YR * We will subtract 1 from age if the 'now' month day is earlier in the * year than the 'dob' month day, otherwise not IF NOW.MO DOB.MO THEN AGE = AGE - 1 END ELSE IF NOW.MO = DOB.MO AND NOW.DA DOB.DA THEN AGE = AGE - 1 END END * The variable AGE now holds their age as of the current day. This even works if the DOB is 02/29 in some year, assuming that 02/28 in the current year is not a person's birthday, but 03/01 is considered to be their birthday. Harold Oaks Sr. Programmer/Analyst Clark County, WA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dominion Sent: Tuesday, January 16, 2007 3:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: [UV] Calculate age from date of birth Needs to be in whole years, ie, age 40 at 6 April 2006 - must be exactly correct as this is for pension calculations so can't get it wrong due to a rounding discrepancy! What units do you want it in? Days? Years and fractional parts of years? Years, months days? Larry Hiscock Western Computer Services -- View this message in context: http://www.nabble.com/-UV--Calculate-age-from-date-of-birth-tf3023501.ht ml#a8401316 Sent from the U2 - Users mailing list archive at Nabble.com. --- 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] Spell-checker?
Thanks for this idea! We are running PI/open over hpux 11.11. I will ask the sysadmin people if replacing vi is even thinkable. Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith W. Roberts Sent: Tuesday, October 18, 2005 3:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Spell-checker? In what environment/circumstances do you need it? I use the Vim editor (Vi IMproved) for just about everything. I can even use it for email (though I haven't yet loaded the Outlook plugin here at my new job). It's a free, open source Vi replacement that works on every major O/S, and it has more plugins than you can shake a stick at ... including a (did I mention free?) spell-checker. :) -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Monday, October 17, 2005 4:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] Spell-checker? Has anyone implemented a form of a spell-checker? Ideally, not by calling a Visual Basic or VB.NET application running on each user's PC - I would prefer on the main server. Doing a little web searching, I find mvWord from WordMark. Can anybody comment on this product? Thanks- Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 [demime 1.01d removed an attachment of type image/jpeg which had a name of Clear Day Bkgrd.JPG] --- 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] Spell-checker?
Has anyone implemented a form of a spell-checker? Ideally, not by calling a Visual Basic or VB.NET application running on each user's PC - I would prefer on the main server. Doing a little web searching, I find mvWord from WordMark. Can anybody comment on this product? Thanks- Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 [demime 1.01d removed an attachment of type image/jpeg which had a name of Clear Day Bkgrd.JPG] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Printing diff-
Thanks everybody, the answers were great. Harold --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/