Re: [U2] Web services at 11.x
We have been using a SOAP interface on 10.2 or 10.3 (I forget now which) and are now on 11.1. We have also successfully used curl to from within UV to interact with a web service on 11.1, on linux. Richard Lewis On Tue, May 13, 2014 at 11:10 AM, Oaks, Harold harold.o...@clark.wa.govwrote: 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] Read yourself
George, It's better illustrated by multiple call levels. A colleague here wrote these specifically to test this: STACK.1 SUBROUTINE STACK.1 CRT || CRT CHANGE(SYSTEM(9001), @AM, CHAR(13):CHAR(10)) CRT || RETURN STACK.2 SUBROUTINE STACK.2 CALL STACK.1 RETURN STACK.WRAP CRT @(-1) CALL STACK.2 And here's the results: || 3ý/(absolute path)/BP.O/STACK.1ý0x6 2ý/(absolute path)/BP.O/STACK.2ý0x0 1ý/(absolute path)/BP.O/STACK.WRAPý0xe || Best Regards, Richard Lewis On Tue, May 13, 2014 at 11:59 AM, George Gallen ggal...@wyanokegroup.comwrote: Unless I'm doing it wrongdidn't look it up. For me - on UV 10.0.2 PRINT SYSTEM(9001) STOP END Outputs RUN LIB TEST 0 George -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 1:55 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Read yourself I had posted an update, that I had tried it (it returns the program stack) Its System(9001), and it will return the subroutine names in the stack as well as the main program (on Universe 11 anyway) Someone has to try this on Unidata, and on D3 to make sure it also returns the subroutine name. What it returns is the absolute path, so you would still need a program to translate this into a LOCAL file name and program id, which is, to what, I'm trying to get. Like I mentioned, I'm sure there is a way to do it, it's just a question of whether someone has a routine which *does* this already, and the answer is apparently not, so if I have to roll my own. -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 13, 2014 10:40 am Subject: Re: [U2] Read yourself Does the 9001 call work for subroutines, or just the main program? Also, it's platform specific It all depends on what your trying to do, if the 9001 call works, great, if not figure something else out. -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 1:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Read yourself Well do you see any problem in just using the SYSTEM(9001) and ignoring embedding this information ? -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 13, 2014 10:27 am Subject: Re: [U2] Read yourself Then you would need to write another program that scans the programs and checks if the VERDATA element For the program name matches the @ID in the program file - if not email someone to fix it. Then have it run nightly - so if it did get cloned without changing, it wouldn't be that way For long. George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] BDT Sluggish
Bill, Most sluggish 'initial' connections that I hear about end up being a reverse-DNS issue. It's been awhile since I had to fix one myself, but I believe the solution involves updating the hosts file on either the workstation or the server or both, or modifying the rules for default domains to use/try, etc. Best Regards, Richard Lewis On Thu, Nov 21, 2013 at 2:17 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: 1. I just downloaded the latest Oct2013. 2. As with the earlier BDT release... each time I press a key... it takes two seconds to appear on the screen. 3. My PC that I am using BDT is Windows Pro 8.1... and the latest Symantec EndPoint Protect AntiVirus. 4. Suggestions would be appreciated. --Bill ___ 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 Universe 11.n
To be fair, I'm basing my my assumption of not getting all of the conversation on the following log entries: Assembled Request (body omitted,length=0): (the body of my request is empty, but apparently it isn't logged anyway.) Response message body(may be partial) length: 1769 (and I'm most definitely _not_ getting the entire response message body logged!) And yes, I have logging level set at 10. As the service deals with sensitive data, it would not be appropriate to discuss the security situation on a public list, but there is a 'Host' header present when using the uv functions as well as using curl. My point, in the end, is that I spent days trying to tweak my usage of uv functions to get the service I was hitting to recognize my request as valid, without success, whereas I spent less than a day setting up and using curl and achieving success. Then I was able to spend a little time making various invalid requests to see in detail what error conditions would look like, and document that as well. And the curl implementation took about 1/10 as many lines of code. Thanks for all the suggestions! Sincerely Best Regards, Richard Lewis IBM Certified Solutions Expert -- U2 Family Application Development IBM Certified Solutions Expert -- U2 UniVerse V10.1 Administration On Thu, Oct 31, 2013 at 2:37 AM, Symeon Breen syme...@gmail.com wrote: That is interesting Richard. I only have experience in udt with this, and if I set logging with protocolLogging(sym.log, ON, 10)I get the full http conversation. Maybe there is a difference in UV ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: 30 October 2013 22:43 To: U2 Users List Subject: Re: [U2] Web Services at Universe 11.n Yes, as I said, I've tested with curl and it works perfectly. The problem I have is not being able to clearly/cleanly see the raw text being sent by the uv functions, in order to determine the difference in what curl sends (success) and what the uv functions send (failure). There may be certain idiosyncratic parsing involved in the service I am trying to consume, but I have no control over that. With curl I can see the entire conversation if the logging is set correctly. With the uv functions, even with the highest logging level, it doesn't appear that the logging is actually that complete and exact. I have never had the impression that it was. I would love to be able to do it all in uv, but I only have control over half of the conversation, and with the uv functions, I seem to have a bit less than half. Richard On Wed, Oct 30, 2013 at 2:12 PM, Symeon Breen syme...@gmail.com wrote: That means you where probably missing a header. http is just a text conversation, if the same headers are passed as passed with curl it will work. You can test using curl, or even better with telnet. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: 30 October 2013 20:03 To: U2 Users List Subject: Re: [U2] Web Services at Universe 11.n I've recently been tasked with accessing a webservice, and couldn't get a valid response from the webservice. It kept not recognizing the headers that were sent, and with the maximum logging set on the uv side, it looked like everything was being sent just fine, but the webservice still failed it. I switched to using curl, and it all worked perfectly. Richard Lewis On Wed, Oct 30, 2013 at 1:00 PM, Oaks, Harold harold.o...@clark.wa.govwrote: 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 ___ 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
We're on linux. Richard Lewis On Thu, Oct 31, 2013 at 2:46 PM, Oaks, Harold harold.o...@clark.wa.govwrote: 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.local mailto: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/SAGEPublications http://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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Web Services at Universe 11.n
I've recently been tasked with accessing a webservice, and couldn't get a valid response from the webservice. It kept not recognizing the headers that were sent, and with the maximum logging set on the uv side, it looked like everything was being sent just fine, but the webservice still failed it. I switched to using curl, and it all worked perfectly. Richard Lewis On Wed, Oct 30, 2013 at 1:00 PM, Oaks, Harold harold.o...@clark.wa.govwrote: 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
Re: [U2] Web Services at Universe 11.n
Yes, as I said, I've tested with curl and it works perfectly. The problem I have is not being able to clearly/cleanly see the raw text being sent by the uv functions, in order to determine the difference in what curl sends (success) and what the uv functions send (failure). There may be certain idiosyncratic parsing involved in the service I am trying to consume, but I have no control over that. With curl I can see the entire conversation if the logging is set correctly. With the uv functions, even with the highest logging level, it doesn't appear that the logging is actually that complete and exact. I have never had the impression that it was. I would love to be able to do it all in uv, but I only have control over half of the conversation, and with the uv functions, I seem to have a bit less than half. Richard On Wed, Oct 30, 2013 at 2:12 PM, Symeon Breen syme...@gmail.com wrote: That means you where probably missing a header. http is just a text conversation, if the same headers are passed as passed with curl it will work. You can test using curl, or even better with telnet. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: 30 October 2013 20:03 To: U2 Users List Subject: Re: [U2] Web Services at Universe 11.n I've recently been tasked with accessing a webservice, and couldn't get a valid response from the webservice. It kept not recognizing the headers that were sent, and with the maximum logging set on the uv side, it looked like everything was being sent just fine, but the webservice still failed it. I switched to using curl, and it all worked perfectly. Richard Lewis On Wed, Oct 30, 2013 at 1:00 PM, Oaks, Harold harold.o...@clark.wa.govwrote: 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 ___ 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 Universe 11.n
Dan, Where would I find documentation on the 'UDO functions'? Thanks! Richard Lewis On Wed, Oct 30, 2013 at 3:24 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: 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 ___ 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
Tried that already, but thanks for the suggestion. By the way, the curl solution doesn't require that header to get a successful response. Richard Lewis On Wed, Oct 30, 2013 at 5:01 PM, Rick Nuckolls r...@lynden.com wrote: If you have not done so yet, try adding the header for Content-Type before making the request. ie. setRequestHeader(handle, 'Content-Type', 'text/html') Rick Nuckolls Lynden -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Wednesday, October 30, 2013 3:43 PM To: U2 Users List Subject: Re: [U2] Web Services at Universe 11.n Yes, as I said, I've tested with curl and it works perfectly. The problem I have is not being able to clearly/cleanly see the raw text being sent by the uv functions, in order to determine the difference in what curl sends (success) and what the uv functions send (failure). There may be certain idiosyncratic parsing involved in the service I am trying to consume, but I have no control over that. With curl I can see the entire conversation if the logging is set correctly. With the uv functions, even with the highest logging level, it doesn't appear that the logging is actually that complete and exact. I have never had the impression that it was. I would love to be able to do it all in uv, but I only have control over half of the conversation, and with the uv functions, I seem to have a bit less than half. Richard On Wed, Oct 30, 2013 at 2:12 PM, Symeon Breen syme...@gmail.com wrote: That means you where probably missing a header. http is just a text conversation, if the same headers are passed as passed with curl it will work. You can test using curl, or even better with telnet. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: 30 October 2013 20:03 To: U2 Users List Subject: Re: [U2] Web Services at Universe 11.n I've recently been tasked with accessing a webservice, and couldn't get a valid response from the webservice. It kept not recognizing the headers that were sent, and with the maximum logging set on the uv side, it looked like everything was being sent just fine, but the webservice still failed it. I switched to using curl, and it all worked perfectly. Richard Lewis On Wed, Oct 30, 2013 at 1:00 PM, Oaks, Harold harold.o...@clark.wa.govwrote: 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 ___ 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] [JOB] in Colorado ?
After glancing over the posting to which you linked, at the bottom I find: To be considered for this role, please visit our website by clicking here (Insert hyperlink to www.iqor.com under here), click the CAREERS tab at the top of the page à United States à Universe Software Developer (New York, NY). There, you will apply for the position by clicking the Apply Online button at the top of this page where you will submit a cover letter, including your salary requirements, plus your resume. Please submit as a PDF, if possible. Seems like perfect instructions to me. On Tue, Sep 17, 2013 at 11:46 AM, Wjhonson wjhon...@aol.com wrote: I'm sure it's just me, but really if *I* were to post a job ad, I would at least tell people how to respond to it http://www.intl-spectrum.com/Multivalue_jobs.aspx No phone number, no address, no email, no way to actually respond. Unless Spectrum is now taking and forwarding resumes ? ___ 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] Select from one file with save-list from another file
Yes, because (at least on UV) it actually writes a temporary record to the dictionary to perform the EVAL expression. On Tue, Aug 27, 2013 at 6:37 PM, Wjhonson wjhon...@aol.com wrote: Are you implying that it somehow reads the permissions of the dictionary before allowing the use of EVAL? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] History of Prime Information
I believe that was Informix rather than Informatics. Richard Lewis On Fri, Apr 26, 2013 at 7:12 PM, David Taylor da...@sysmarkinfo.com wrote: If I'm not mistaken, there was another company in between Vmark and IBM. I believe (and there may have been some smoke and mirrors in all this) that Informatics acquired Ardent and then assigned the CEO of Ardent as the President of Informatics, or something like that, to run both Ardent and Informatics. And then later, IBM acquired Informatics for their database and just inherited Vardent almost by accident. Then, I believe that IBM acquired Unidata and formed the U2 product group. ... Dave Taylor Sysmark Information Systems, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
How about: SELECT fname WITH MPAR.STATUS.DATE CONV = [/] Since you seem to know exactly the kind of erroneous data you want to find. On Tue, Jan 29, 2013 at 3:38 PM, Greg Coelho coe...@american.edu wrote: All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE .. ./... (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ 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] YYMMDD easy way?
Mine is on HP-UX B.11.31. Richard On Wed, Apr 25, 2012 at 8:07 AM, Rick Nuckolls r...@lynden.com wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ 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] YYMMDD easy way?
On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckolls r...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ 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 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 ___ 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] YYMMDD easy way?
Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckolls r...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckolls r...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ 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 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 ___ 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] Universe 10.2 to 11.1
Some time ago we upgraded our development server to 11.1.1 (hpux) and ran into a couple of bugs involving indexes. Our development server is currently on 11.1.3 with those bugs completely wiped out. We haven't yet been able (schedule-wise, etc.) to get our production server updated, so it is still running 10.3.2. Our sys admin isn't here at the moment, but didn't report any extra difficulties or delays compared to any previous upgrades. Best Regards, Richard Lewis On Tue, Mar 6, 2012 at 12:34 PM, Oaks, Harold harold.o...@clark.wa.govwrote: 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
Re: [U2] uppercase
I understand matrix operations well enough to use them frequently, and in light of this discussion, the following question popped into my mind: Is there any difference between: X = OCONV(X,'MCU') and: X = OCONVS(X,'MCU') Has anyone experienced the results being different? Thanks! Richard Lewis On Wed, Jun 22, 2011 at 9:08 AM, George Gallen ggal...@wyanokegroup.com wrote: UPCASE() will also function as OCONVS() If you put in a dynamic array into UPCASE(), it will upcase the entire string and leave the @VM, @AM... untouched. I use this on UV when reading items, especially for searching, I'll upcase the entire dynamic array, then proceed to do my indexes or locates. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Wednesday, June 22, 2011 6:32 AM To: U2 Users List Subject: Re: [U2] uppercase Hi Jeff, The difference is probably only one of performance. Using OCONV requires the conversion code to be decoded in order to work out what to do. Using UPCASE() can go straight off to do the real work without any additional decoding. I suspect not, but there may be some difference of interpretation if you have NLS installed. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 - Original Message - From: Jeff Butera jbut...@hampshire.edu To: u2-users@listserver.u2ug.org Sent: Wednesday, June 22, 2011 11:24 AM Subject: [U2] uppercase On unidata, can anyone shed light on the differences between UPCASE(...) and OCONV(...,'MCU')? I know OCONVS(...,'MCU') will preserve @VM and other unidata delimiters, but for single valued data is their any difference in the above? -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ 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] How to Clear Empty VM marks in Field
Garry, Since you described a simple situation, I'll provide a simple solution. FXI = 1ýý DCOUNT(TRIM(FXI,@VM),@VM) should return 1. Best Regards, Richard Lewis On Fri, Jan 28, 2011 at 5:29 PM, Garry Smith gar...@charlesmcmurray.comwrote: FXI = 1ýý DCount(FXI,VM) returns 3 Is there function to clear the blank value marks so that FXI = 1 and then DCOUNT would return 1 TIA Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 ___ 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] Data in Dict
At a previous employer, we used a single file similar to what Jeff suggests, and it was a very neat and tidy little file. The only problem we ran into was when we started getting larger sites, and had trouble with throughput. It turned out that with 20 or so next-item counters in one frame, the lock table became a bottleneck. We had to radically over-size the file to spread the items into more groups so that group update locks didn't hamper performance. So our neat and tidy modulo 7 or 11 file went to a modulo of around 101. Still relatively small with a separation of 1. With disk as cheap as it is these days, it's a very easy solution, once you know. Richard Lewis On Tue, Jan 25, 2011 at 10:49 AM, Allen Egerton aeger...@pobox.com wrote: Jeff, That's a nice simple solution, I'd just add don't forget to right justify the @ID Dict item in the file that's being selected by.dsnd ;) Allen On 1/25/2011 11:37 AM, Jeff Schasny wrote: My preference is to have a data file specifically for next key records with the item id being the filename and field 1 being the next available key. As far as restoring it should it become corrupted a fairly simple Uvbasic program which is fed a list of filenames, selects each file BY.DSND @ID, readnext, add 1 to the first key, write that as the next key for the file, next filename should be able to restore your next key file in a couple minutes if not less. George Gallen wrote: The one down side I can think of to not keeping 'next' values in the DICT and in a separate file, is if you have to restore the file, you will also have to restore the NEXT-FILE as well. It's not one neat package. But I have to admit, when I was setting up a MySQL structure and needed to implement a 'next' value, I went with a separate file and each row had two values, key and value, where the key was the filename and the value being the next value, and used this one file for all my 'next' placeholders, instead of writing it to the DICT, I used the filename as the key. Although, keeping all your nexts in one basket could be a problem if that file ever was corrupted, it would be difficult to reset them all to the correct values. Other than that, seems a bit of overhead to have a separate next file for each file you want to keep one on to avoid losing all your keys with one file issue. What other methods are people using to track next ID? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, January 24, 2011 7:55 PM To: U2 Users List Subject: Re: [U2] Data in Dict Kate: It seems to me that this is very tidy! :-) Bill --- - Kate Stanton said the following on 1/24/2011 1:27 PM: Hi David, The reason we use dictionaries for data entry, reports, queries and forms is so we can use the same dictionary item for all activities, thus using the dictionary as designed with a little more. So, if part ID is changed at a site to be 6 numbers, then changing the dict item in a file once means the same change applies to all other activities. We think this is very tidy, and the unused portion of dictionaries have been used like this for a long, long time (over 30 years to our knowledge). Cheers, Kate Kate Stanton Walstan Systems Ltd, 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: +64 9 360 5310 mobile: + 64 21 400 486 fax: + 64 9 367 0750 Email: k...@walstan.com On 25 January 2011 03:53, David A. Greendgr...@dagconsulting.com wrote: All this talk about using the Dictionary item to store extra data has prompted this post. I realize in the past when the limit to the number of Opened Files in a Basic program was a programming challenge, that doing creative data storage might have been an necessity. But I would like to suggest we leave the Dictionary alone, let the database use it the way it wants to and let us create our own storage device for dictionary related data. Thoughts? David A. Green (480) 813-1725 DAG Consulting ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV User Logout
Bill, It looks like it's trying to write out maryann's command stack. SAVEDLISTS is apparently setup as a Type 1 file, and since maryann's stack key is longer, it's trying to create a sub-directory and write into it. It looks like maryann doesn't have appropriate prviileges to create the sub-directory in the SAVEDLISTS directory. You could resize the SAVEDLISTS file as a Type 19, or fix the owner /or group of SAVEDLISTS, or just turn STACK.WRITE off. Without looking, that's what I would guess. Best Regards, Richard Lewis On Wed, Jan 12, 2011 at 2:15 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: When one user here logs out via Dynamic Connect on HP-Ux 11i v2 running UV 10.3.6, she gets the following screenful... mkpath: SAVEDLISTS/S.maryann.13 is not a directory mkpath: SAVEDLISTS/S.maryann.13 is not a directory . . mkpath: SAVEDLISTS/S.maryann.13 is not a directory MaryAnn is setup like most everybody else. Clarification on the significance of this message would be appreciated. --Bill ___ 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] UV 11.1 and HP Itanium
Our sysadmin would like me to ask: How many out there are running UV 11.1 on Itanium? Have any of you on UV 11.1 on Itanium had any issues with shared memory? Thanks! Richard Lewis IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV 11.1 and HP Itanium
Not a problem. Thanks for responding! On Tue, Jan 11, 2011 at 6:15 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: Two months ago, we upgraded to 10.3.6. In the original message, I dislexed Ux 11i and UV 11.1. I am considering upgrading to UV 11.1. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Tuesday, January 11, 2011 7:05 PM To: U2 Users List Subject: Re: [U2] UV 11.1 and HP Itanium And what version of UV are you running? Richard On Tue, Jan 11, 2011 at 4:49 PM, Bill Brutzman bi...@hkmetalcraft.com wrote: We are running HP-Ux 11i v2 Itanium. We have not had any memory issues at all. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Tuesday, January 11, 2011 6:10 PM To: U2 Users List Subject: [U2] UV 11.1 and HP Itanium Our sysadmin would like me to ask: How many out there are running UV 11.1 on Itanium? Have any of you on UV 11.1 on Itanium had any issues with shared memory? Thanks! Richard Lewis IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sparse array population in Pick
Will, I used the second model (originally about 20 years ago) with the initial empty value. Neither model is really very simple, but with the second model we created one or two I-descriptor subroutines that can allow dictionaries to be tailored to any tag you want to look for and select for all values associated with that tag quite nicely. Display routines are also not too daunting. There are certainly worse file structures to deal with than the second model. But maybe I'm biased, I 'invented' its use at a previous company, and I and the rest of the company worked with it for at least 15 years. Best Regards, Richard Lewis On Thu, Dec 9, 2010 at 3:09 PM, fft2...@aol.com wrote: Years ago I had written a system, far predating XML, where the element-tags were unpredictable. Essentially the user was allowed to create any tags they wished, and any number of tags they wished, attached to another item. Each tag had an associated value. So far example Zip Code = 95062 You could not however predict what tags a person would use, they were all free-form and user-supplied, but you still had to store the tag with their associated value. At the time I developed two ideas for how to do this in a Pick item TAGS1052 001 Make = Chrysler 002 Model = LeBaron 003 Age = 7 years and 3 days TAGS1052 001 Make]Model]Age 002 Chrysler 003 LeBaron 004 7 years and 3 days The first model is clear. Anyone with no programming background at all, can easily understand it, and also easily edit it. It suffers from requiring more elaborate programming than the second model, as you have to parse every element. The second model is not quite as clear. You determine the attibute position of the value by locate the tag in attribute 1 and then adding 1 to it. That gives you the attribute number where the value lives. Alternately you could simply pre-fill attribute 1 with an initial null to push everything forward 1 place, then you wouldn't have to add 1 after your locate. Comments? Critiques? Nasty cat-calls and grimaces? Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV index with duplicate nodes
into determining exactly how long a rebuild of this particular index will take, as that seems like the best work-around for us at the moment. We are in the process of formalizing the steps we use to identify the problem, and codifying that in a process that can be run on every index we have, so that we can at least identify the scope of our issues and, if rebuild is the only remedy, make plans to schedule them regularly. If you would like to check your indexes, here are the steps we have found to be reliable: 1.Create an F-pointer to the index directly, named indexfile, with the Dict pointing to the dict of the data/source file. 2.SSELECT indexfile 3.SAVE.LIST XX 4.Create a DICT fname DUP dictionary item like this: a.0001: I b.0002: @2;@ID;@1...@2 c.0003: d.0004: e.0005: 3R f.0006: S 5.GET.LIST XX 6.LIST indexfile WITH DUP # “0” DUP 7.Note the ID’s listed (dup_id1, dup_id2, etc.). Use them as listing criteria as follows: a.LIST indexfile WITH @ID = “dup_id1]””dup_id2]” (etc.) F1 F2 Building a program to perform these tasks will be one of our next immediate steps. Any further suggestions or comments are most welcome! Sincerely Best Regards, Richard On Fri, Oct 1, 2010 at 7:39 AM, David Wolverton dwolv...@flash.net wrote: This has been our issue in the past -- unless you look at that data with a HexEditor, it's not obvious. If you use the UniData AE Editor (now included with UniVerse) you can type a ^ (Shift 6 - Caret) and see non-printable characters. Once you know the culprit, you fix the source data and the index heals itself. David W. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Brown Sent: Friday, October 01, 2010 6:02 AM To: U2 Users List Subject: Re: [U2] UV index with duplicate nodes Look for a space or non printing character in the data. That would make it look the same but actually be unique. - Original Message - From: Richard Lewis rbl...@gmail.com To: U2-Users@listserver.u2ug.org Sent: Thursday, September 30, 2010 8:47 PM Subject: [U2] UV index with duplicate nodes We've just uncovered a rather unusual and unsettling situation. We have a file with a single index that has somehow gotten nodes with duplicate keys. A simple example would be having an index on ZIPCODE in a address database, and finding that there are _two_ nodes (records) in the index for ZIPCODE 12345, for example. The source records referred to in the nodes are not duplicated, but since most operations find the 'first' node, any source records referred to in the duplicate node appear to not exist in the index. LIST.INDEX fname ALL Alternate Key Index Summary for file fname File... fname Indices 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type BuildNulls In DICT S/M Just Unique Field num/I-type fieldnameANot Reqd YesYes ML N2 The file contains 6,539,233 records, with 574,547 unique values in fieldname (which is actually a single-valued field, and has been verified that each record's fieldname contains one and only one value). We found that 9 source records appear to have not been included in the index, but upon further research found the nodes with duplicate keys. We created an F-pointer to the index file itself (not normally recommended, but useful), then got the results like the following: LIST indexfile WITH @ID = 12345] F1 F2 fname. F1 F2 12345 987654 876543 12345-6789 765432 543219 12345 654321 We are having our UniVerse administrator ask our dealer for assistance, but were interested if any other users have had any recent similar experiences, or advice. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV index with duplicate nodes
Oh, I forgot to mention that we are on UV 10.3.2, HP-UX B.11.23 U. Thanks! Richard ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV index with duplicate nodes
We've just uncovered a rather unusual and unsettling situation. We have a file with a single index that has somehow gotten nodes with duplicate keys. A simple example would be having an index on ZIPCODE in a address database, and finding that there are _two_ nodes (records) in the index for ZIPCODE 12345, for example. The source records referred to in the nodes are not duplicated, but since most operations find the 'first' node, any source records referred to in the duplicate node appear to not exist in the index. LIST.INDEX fname ALL Alternate Key Index Summary for file fname File... fname Indices 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type BuildNulls In DICT S/M Just Unique Field num/I-type fieldnameANot Reqd YesYes ML N2 The file contains 6,539,233 records, with 574,547 unique values in fieldname (which is actually a single-valued field, and has been verified that each record's fieldname contains one and only one value). We found that 9 source records appear to have not been included in the index, but upon further research found the nodes with duplicate keys. We created an F-pointer to the index file itself (not normally recommended, but useful), then got the results like the following: LIST indexfile WITH @ID = 12345] F1 F2 fname. F1 F2 12345 987654 876543 12345-6789 765432 543219 12345 654321 We are having our UniVerse administrator ask our dealer for assistance, but were interested if any other users have had any recent similar experiences, or advice. Sincerely Best Regards, Richard Lewis IBM Certified Solutions Expert Nu Skin Enterprises ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TRANSLATING LAST VALUE FROM A SINGLE VALUE
Try: LIST FILE1 EVAL TRANS(FILE2,@RECORD1,DCOUNT(@RECORD1,@VM),'12','X') Richard Lewis On Fri, May 21, 2010 at 10:15 AM, James Patrick Volkman jamesvolk...@yahoo.com wrote: I'm attempting to do a translate and was wondering if anyone might have a suggestion. Attribute (or Field) 1 of File1 is a multi-valued foreign key to the Primary Key in File2. File2 contains a Date in Attribute 12. I want the latest date in Attribute 12 of File2 of all the values of Attribute 1 in File1. This is pulling 1 record from Attribute 1 of File1. How can I display the Date (Attribute 12 of File2)? LIST FILE1 1 EVAL @RECORD1,DCOUNT(TRANS(FILE2,@RECORD1,'12','X'),@VM) Jim Volkman http://www.linkedin.com/in/jamesvolkman ___ 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] The opposite of Export is.. sometimes not Import...
I would probably start by making an index on the Part Number, based on an I-descriptor with an expression like this: CONVERT(OCONV(OCONV(PartNumber,'MC/N'),'MC/A'),'',PartNumber) where PartNumber is a D-pointer to the raw data field that is the Part Number. This will strip out all the non-alphanumeric characters. You could then easily access by Part Number no matter how many dashes, dots, etc. were entered on either system, via the index. Best Regards, Richard Lewis Nu Skin Enterprises On Thu, Jan 21, 2010 at 1:33 PM, John J. Wahl jw...@joseph.com wrote: Off Topic but has anyone else noticed the Trend for the last three months is Help my boss, customer, friend wants to get ALL his columns, all his data or all his junk out of U2, and I'm not worried about getting it back in... I'm in the opposite boat, I want to leave it in there, and I'm VERY comfortable with SQL Server, I'd rather they work together than choose one technology over the other. My Question today is, if I'm writing a quick view in SQL Server I can write a nice little function to strip a field to just it's alpha numeric characters. Then I'll be using this on a webpage to strip the Input of it's non-alphanumeric characters as well, thus showing more matches when values are entered for (in this case) part numbers were entered in an odd fashion. Example: User enters 1-2-3-4 My data for a Part Number, might have 1-2-34 12-34 AND 123-4 My systems on the Intranet (Employees only) would say no matches found I'm not ok with this response. I think a direct match should be done first, but THEN additional searches are done, I even have a fuzzy one off Search using the SQL single Char replace (using _ based on the LEN of the input) and then a massive union query. However I want to do this in our UniVerse system instead, as that's where the data truly resides, and so I would hope would be the fastest place to run this type of search. I have no idea how to write an I type or Paragraph or Subroutine that will take a string in as the Variable and then pass back another string stripped to the AlphaNumeric only response so that I can search it. I'm assuming a Subroutine would do the trick and then I can use that Sub in an Dict Entry as an Type I, no? Where to begin? . Thanks for your time, - John J. Wahl Employee Owner Programmer / Analyst (Born in Microsoft, but now a U2 lover...) Tel: (330) 528-0091 Ext. 120 Fax: (330) 655-8458 Email: jw...@joseph.com Web: http://www.Joseph.com/ If the ship is not sinking why are you all jumping off? ___ 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] UD: Executing small part of subroutine code once from dictionary call
Bill, A little while ago there was a thread about running totals, and the same problem of initialization came up. It's apparently solved by using an additional named commons variable that saves the date and time last initialized compared to the current date and time of 'this' LIST/etc. statement. Here's a post that used that method: http://www.mail-archive.com/u2-users%40listserver.u2ug.org/msg30268.html Best Regards, Richard Lewis On Thu, Aug 20, 2009 at 3:28 PM, Bill Haskett wphask...@advantos.netwrote: I have a UD dictionary that calls a subroutine. The subroutine selects a small file and saves the data into a reformatted array, which is returned as a passed variable. I want to only execute this select code once in the subroutine then continue with the reset of the subroutines business rule(s) for subsequent items processed. When I create a named common variable for the built data array the array is set once and when I alter the data in the selected file (small) it never is updated when I run a subsequent selects or sorts. UniData doesn't seem to be able to inform me when the first item is processed, in order to initialize, read, and build the configuration array. How is this done? E.g. I want to know what accounts a user has access to (we run an ASP with 50-100 accounts on it and our users file is global). The dictionary builds an array of users on our system as follows: 001 mv'd list of user names 002 mv'd list of upper-cased user names 003 mv'd list of account paths each user has access to A user can have access to multiple account paths. When I do the following (in PICK mode): :sort SECUSERS BY USERID ID-SUPP USERID ACCTUSER AUTHACCTS ...I get the following list of users and account paths they have access to: UserId. C. AuthAccts. PUBLICUSER 1 E:\UDAccounts\AsiPublic E:\DataTrust\Dev E:\DataTrust\Demo DOTNETUSER 1 E:\DataTrust\Demo E:\Advantos\Intel E:\DataTrust\Dev MYUSER 1 E:\DataTrust\Dev E:\DataTrust\Demo E:\Advantos\Intel The dictionary of AUTHACCTS looks like: Top of AUTHACCTS in DICT SECUSERS, 6 lines, 113 characters. *--: P 001: I The authorized accounts this user has access to (a DBIUSERS value) 002: SUBR( D.AUTHACCTS, @ID ) 003: 004: AuthAccts 005: 30L 006: M Bottom. *--: ...and the subroutine looks like: * ** Initialize common program variables $INCLUDE DTABP,INCLUDES SET.COMMON * ** Initialize local common COMMON /dbUserc/ comDbiUserArray * ** Initialize null because we're calling from a dictionary and SET.INIT ** hasn't run yet (besides NULL$ isn't named common). NULL$ = '' * ** Initialize return value OutValue = NULL$ * ** Make sure we're dealing with a user record key IF UserID = NULL$ THEN GOTO END.OF.PROGRAM * ** Get the list of DB users IF comDbiUserArray = NULL$ OR comDbiUserArray = 0 THEN CALL GET.DBIUSERS ( DbiUserArray ) comDbiUserArray = DbiUserArray END * **---** ** ** ** R U N P R O G R A M ** ** ** **---** * ** Assign the names Id intialize variable to pass back UCDbiUserList = comDbiUserArray2 DbiUserPaths = comDbiUserArray3 UserID= OCONV(UserID, 'MCU') LOCATE(UserID, UCDbiUserList, 1; Pos) THEN OutValue = RAISE(DbiUserPaths1,Pos) END The problem is once I run the query the contents of the array comDbiUserArray will never change until I log off. How can I force the array to be initialized without logging off? Any help would be appreciated. Thanks, Bill Haskett Advantos Systems, Inc. ___ 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] Clearing a Sequential File:
If you do a WEOFSEQ after all your WRITESEQs, the file will be truncated at that point. Something like this: OPENSEQ 'path/filename' TO F.SEQ ... * pointer is at beginning of file LOOP WHILE STUFF.TO.WRITE DO WRITESEQ STUFF.TO.WRITE ON F.SEQ ELSE ... REPEAT WEOFSEQ F.SEQ ... This insures that even if what you're writing this time is fewer 'lines' than last time, the file will not contain any leftovers at the end. Richard B. Lewis Sr. Software Engineer Dynix r l e w i s at d y n I x dot c o m www.dynix.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Moore Sent: Tuesday, August 24, 2004 11:41 AM To: [EMAIL PROTECTED] Subject: [U2] Clearing a Sequential File: I am able to OPENSEQ and WRITESEQ for a sequential file, and need to clear the records or data before writing to this file. I have tried CLEAR and CLEARFILE, but may not have the correct syntax. How do I go about this? TIA, as always. Ron --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] EVAL formatting
Of course you can display a decimal. Try this: LIST CS.2004 H.HCG.AWARDED.ALL H.TOTAL.AWARD EVAL (H.HCG.AWARDED.ALL * 100)/H.TOTAL.AWARD) CONV MR2 Richard B. Lewis Sr. Software Engineer Dynix r-l-e-w-i-s-at-d-y-n-i-x-dot-c-o-m p 801-223-5392 f 801-223-5202 www.dynix.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Michaelsen Sent: Monday, August 16, 2004 3:02 PM To: [EMAIL PROTECTED] Subject: [U2] EVAL formatting I had one of my IT folks look at this one and I don't want to belive them. They said you cannot display a decimal when using the EVAL command. I think there is got to be a way. That's why I put this out. The current EVAL statement displays 1 or 0. Any ideas?? LIST CS.2004 H.HCG.AWARDED.ALL H.TOTAL.AWARD EVAL H.HCG.AWARDED.ALL/H.TOTAL.AWARD kevin --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MCU's an input within a PAragraph?
I learn so much lurking on this list (some of which I actually get to use in my work) that I humbly dare to respond: Glenn wrote: Well, according to the documentation you can specify a conversion code: A,PROCESS?,(MCU) which should apply the conversion code to the input value, but which appears not to work. My response: I'm on UV 10.0.13 at the moment and the 'HELP ...' says, in part, The conversion only verifies the format of the data entered. It does not convert the data. If the data does not match the conversion, the user is prompted to reenter it. So I would suggest that, while I agree that it may not be very useful, it does appear to work as the 'documentation' describes it should. Sincerely Best Regards, Richard B. Lewis Sr. Software Engineer Dynix rlewis at dynix dot com mailto:[EMAIL PROTECTED] p 801-223-5392 f 801-223-5202 www.dynix.com http://www.dynix.com/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MCU's an input within a PAragraph?
I didn't say nor mean to suggest that it was not _at all_ useful. I have used such an example before myself. I was just recognizing and agreeing with Glenn that there remain some, perhaps several, situations and conversion codes where it is not really too helpful, and could perhaps be enhanced. But also trying to point out that it was indeed not 'broken' per the documentation. Richard B. Lewis Sr. Software Engineer Dynix rlewis at dynix dot com p 801-223-5392 f 801-223-5202 www.dynix.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janke, Mark There's a very good reason why it works this way. Suppose you have the following LIST statement: LIST EMPLOYEE.FILE WITH HIRE.DATE Enter Hire Date,(D) Mark -Original Message- Glenn wrote: Well, according to the documentation you can specify a conversion code: A,PROCESS?,(MCU) which should apply the conversion code to the input value, but which appears not to work. Richard's response: I'm on UV 10.0.13 at the moment and the 'HELP ...' says, in part, The conversion only verifies the format of the data entered. It does not convert the data. If the data does not match the conversion, the user is prompted to reenter it. So I would suggest that, while I agree that it may not be very useful, it does appear to work as the 'documentation' describes it should. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Preventing Unix Login
Don't most flavors of unix support the /etc/nologin file? The contents of that file will be displayed instead of the usual 'Login please' prompt to telnet connections, as well as preventing logins, except from root. Try 'man login' from your unix shell prompt for more info. Just setup the file as /etc/nologin.bak or something, then rename it at the appropriate time, get everyone off, resize, rename the file back. Richard B. Lewis Sr. Software Engineer Dynix [EMAIL PROTECTED] p 801-223-5392 f 801-223-5202 www.dynix.com http://www.dynix.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Friday, May 21, 2004 10:39 AM To: '[EMAIL PROTECTED]' Subject: [U2] Preventing Unix Login We are getting file overflow error messages on our Sales Order files and I want to make sure that nobody can login as it is resizing. Maybe I am overly concerned. We are on UV 8.3.3 on HP-Unix v10. Suggestions are welcome. Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 .voice 973.471.9666 .fax www.hkMetalCraft.com [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] [UV] CATALOG verb
And if you add the T option to the S and N, you don't have to press return the extra time. i.e., COPYP BP PROGRAM (SNT rtn Richard B. Lewis Sr. Software Engineer Dynix [EMAIL PROTECTED] p 801-223-5392 f 801-223-5202 www.dynix.com http://www.dynix.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Ockenden Sent: Wednesday, May 19, 2004 4:20 PM To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] CATALOG verb Dianne wrote... Interesting idea, Trevor. I do prefer the INFORMATION verbs, probably because I'm more used to them. I'll definitely make a COPYI ! As you may have discovered by now, COPYI already exists and there is also a COPYP for those that prefer Pick style copies. In fact the Pick style copy (COPYP) has one very useful feature I haven't been able to reproduce using the COPYI verb namely the ability to list a program (or whatever) without the line numbers. The command is: COPYP BP PROGRAM (SN rtn TO: rtn Hope that helps! Cheers Trevor Ockenden OSP - Original Message - From: Dianne Ackerman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 11:30 PM Subject: Re: [U2] [UV] CATALOG verb Thanks, Dianne Trevor Ockenden wrote: Dianne wrote... I'm using PICK flavour in UV version 9.6.1.4. I want all programs to be catalogued with the COMPLETE keyword. Is there an option somewhere I can set to force that keyword? I have found the Pick flavour of verbs frustrating so whenever I am in a Pick flavoured account I create several Information flavoured verbs as follows: Create CREATE.FILEI and CATALOGI as follows... Copy these verbs from the NEWACC,INFORMATION file you will find in the UV account or copy the Pick flavoured verbs and change the PICK to INFORMATION in the new VOC entries. Now you can use these new verbs as though they were from a non Pick flavoured account. Cheers Trevor Ockenden OSP PS the above information applies to UV. Similar changes might work for UD but I'm not sure about this. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.687 / Virus Database: 448 - Release Date: 17/05/2004 --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
